LESSON 1 – INTRODUCTION TO QUERY BUILDER
Launching Query Builder
Understanding Query Builder Screens
Performing Your First Query in Query Builder
Saving the Query
Closing and creating another query
Practice
LESSON 2 – DEFINING NEW COLUMNS
Adding a Literal Text Column or a Calculation Column to the Query
Selecting Defined Columns For the Query
Practice
LESSON 3 – LIMITING THE RECORDS SELECTED IN QUERY BUILDER
The Query Editor
Entering Conditions
To activate the condition box
To enter a condition
To accept the condition
To cancel or remove the conditions
Executing a Query to select the employees in the ‘POL’ department
Adding Multiple Conditions
Practice
LESSON 4 – RETRIEVING RECORDS FROM MULTIPLE TABLES USING QUERY BUILDER
Defining a Relationship
Practice
LESSON 5 – USING QUERY BUILDER TO COMPUTE GROUP VALUES
Creating and Executing a Group Function
Limiting the Records Based Upon the Group Function
Practice
LESSON 6 – ORDERING YOUR RECORDS
Setting the sort order using the Sort dialog box
Using the Toolbar tools to set the sort order
Practice
LESSON 7 – CHARACTER, NUMBER and DATE FUNCTIONS
The Paste Function dialog box
Practice
LESSON 8 – SUBSELECTS AND QUERY PARAMETERS
Performing a subselect
Correlated Queries
Parameter columns
Defining a query parameter
Using the query parameter
Practice
LESSON 9 – FORMATTING THE RESULTS
Using the Format dialog box
Toolbar formatting tools
Breaking the results
Printing the results with headers, footers, and margins
Removing gridlines and row counters
To Launch the Preferences Dialog box: Select the Edit/Preference menu option.
Practice
LESSON 10 – COLUMN TOTALS AND SUBTOTALS
Practice
LESSON 11 – MODIFYING DATA USING QUERY BUILDER
How to launch the Data Editor
Updating Records
Deleting Records
Inserting Records
Commiting and Rollback of the changes
Practice
Appendix A – EMPLOYEE TABLE RELATIONSHIP DIAGRAM
Practice Answers
Lesson 2
Lesson 3
Lesson 4
Lesson 5
Lesson 6
Lesson 7
Lesson 8
Lesson 9
Lesson 10
Lesson 11