Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0

Topics covered: query types (select, append, update, delete, make-table and crosstab), basic and advanced criteria, totals, union & parameter queries, referencing forms, properties, expression columns, and writing simple SQL statements.

Course Outline

This course takes a close look at Access Query building.    We start with basic query concepts (review from Introduction), then look at some of the more advanced query features.

This course is classroom style instruction: Instructor-led, hands-on training.

Basic Query Design
Creating a Query
Adding Fields
 One at a Time
 In Sequence
 At Random
 All Fields
 All Fields Except 1 or 2
 Using the *
 Output All Fields
Clearing the Grid
Running a Query
Return to Design View
Sorting and Rearranging Columns
Preventing Data Changes
The Show Row
Entering Criteria
 Number/Currency Fields
 And vs. Or
 Multi-line Criteria
 In() and Not In()
 Using Wildcards
 Text Ranges
 Yes/No Fields
 Null and Not Null
 Adding Parameters
 Using Like in a Parameter
Adding Columns
 Concatenating Fields
 Adding Numeric Formulas
 Calculating Time Durations
 Formatting Formulas
Creating Totals Queries
Creating Update Queries
Creating Delete Queries

Other Query Types
Crosstab Queries
 Why a Crosstab?
 Setting Column, Row & Value
 Grouping Options
 Entering Criteria
Make Table Queries
Append Queries

Relationships in Queries
Join Types in Queries
Query Level Relationships

Union Queries
What is a Union Query?
Writing Basic SQL
Creating the Union Column
Column Names
Setting Criteria
Using Parameters
Showing Duplicates

Forms & Reports Based
on Queries
Determing Sort Order
Adding Parameters
Based on an SQL Statement
Saving SQL as a Query

Creating Criteria Dialog Box
Creating the Form
Adding Unbound Controls
SQL in Combo Boxes
DMin & DMax
Pop Up/Dialog
Adding Command Buttons
Creating the Query
Adding Referencing Criteria
Testing the Dialog Box

Synchronizing Combo Boxes
Using Customer/Contact Combo
Manual Synchronizing
Automatic Synchronizing



Prerequisites & Certificates

Course Prerequisite: Required: Solid understanding of all Access Introduction & Intermediate Level I topics.

Certificates offered

Participants receive with this course: * courseware (notes on all topics covered, along with exercises used during course). * a certificate of completion

Cancellation Policy

Map & Reviews
Computer Help
[ View Provider's Profile ]


This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 482 times.