Custom Search
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Access 2003 Queries (2 Days)
Provided by: Last Minute Training

Access 2003 Queries (2 Days)

Access

 Last Minute Training
Training Provided by Last Minute Training 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.
This is primarily ilt training
Contact Last Minute Training for more information
Course Level:advanced
Duration:2 days
Training Presented in:English
Click here for more information or to take this course
Access 2003 Queries (2 Days) 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
Dates
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
Sorting
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
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
Click here for more information or to take this course
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Access 2003 Queries (2 Days)
Advertise With Us
Do you teach access 2003 ?
tcw11-gfc-v396M-11/06/09-22:02:03-()[A]-[B]-[A] -10:33:35