Employee Benefit Statements Procedures Document Collection Data Collection Tutorial for Doing-it-Yourself Samples & Examples An Employee Website + more Click here for the Index
Employee Communications A variety of Targeted Examples, ranging from an online Employee Budget Worksheet, to Retirement Communications, online Enrollment & much more. Click here for the Index
The Human Resources Collaborative Suite Why it's needed Tools we used Your Tools Overview and Introduction Movies and more Click here for the Index
HR Collaborative Suite
HR Suite Table of Contents
The HR IT Divide
Too many applications
Expensive Applications
Endless Loop
Our Design decision
Tools we used
Your Tools
Tables
Queries
Views
Functions
Templates
Actions
Applications
Charts
Images
Sites
Files
HTML
Datasources
PDFs
Gyre Modules
Composite Type
Bookmarks
Account
Access Control
Project Manager
Application Analyzer
Barcodes
Ytree
Chat
Cron
Packaged Solutions
Consulting
Movie Menu
Movie Create Role
Movie New User Assign
Movie Simple query
Movie Data Entry
Movie Bind Data
Movie New Template
Movie New Image
Movie Edit Query
Movie Import Data
Movie Pie Chart
Movie Dental Form
Movie Form Tools
DIY Demo
Employee Communications
Employee Communications TOC
Slide Shows
Remote Workplace
An Intro
HR CS
Group Presentation
Survey
Survey Questions
Employee Personal Page
Insurance Enrollment
Dental Claims Form
Budget Worksheet
Boost 401(k) Participation
Personalized retirement education
Multilingual Interface Design
DIY Demo
Employee Benefit Statements
Employee Benefit Statements TOC
Statements samples overview
Projects Require
Define Communication Goals
Delivery Methods
Styling and Images
Content Source Documents
Data
Access Control
Reports
Employee Feedback
Updateable
Cross Project Integration
DIY
Project Types
Other Vendors
Web Sample
Sample Web Page 1
Website Page 2
Website Page 3
Website Page 4
Website Page 5
Website Page 6
Website Page 7
Website Page 8
Website Page 9
Tutorial Benefit Statements 1
Tutorial Benefit Statements 2
Tutorial Benefit Statements 3
Tutorial Benefit Statements 4
Tutorial Benefit statements 5
Tutorial Benefit Statements 6
Tutorial Benefit Statements 7
Tutorial Benefit Statements 8
Tutorial Benefit Statements 9
Benefit statements 10
Statements samples 1
Statements Samples 2
Statements Samples 3
Statements Samples 4
Statements Samples 5
Statements Samples 6
New View
Step #1
Step #2
Step #3
A View is the visual result of a Query. Whenever you look at a View, the Query has been run -> then the View is presented, similar to a 'temporary Table'. A View can be useful because it can be Joined to other Tables and used as part of a New Query.
Creating a New View is very simple and does not require a lengthy discussion. A View is a special type of Query that creates a temporary Table of the Query results. Since it acts as a Table, you are allowed to Query a View, meaning that you can essentially Query multiple Queries + multiple Tables within a single query. This technique is used frequently within projects such as Employee Benefit Statements where recombining information is essential.
From your MENU , select NEW ... VIEW .
Give your View a name, a description, designate a Folder and most importantly, designate the 'base Query'
Click Create. That's it, you're done.
Have a Question?
Type of Q
Access Control
Account
Action
Application
Application Analyzer
Barcode
Bookmarks
Charts
Chat
CRON
Consulting - help!
Datasource
Files
Functions
GYRE Module
HTML
Images
Packaged Solutions
Pdfs
Project Manager
Query
Tables
Templates
Site
Type
View
YTree
Your email
Send Question
Employee Benefit Statements
An online Employee Budget Worksheet
Collaborate. Easily, productively
Please wait...