Key Concepts

•  Create and run queries
•  Print query results
•  Include fields in design grid
•  Use text and numeric data in criteria
•  Create and use parameter queries
•  Save a query and use the saved query

•  Use compound criteria in queries
•  Sort data in queries
•  Join tables in queries
•  Perform calculations in queries
•  Use grouping in queries
•  Create cross tab queries

Videos

•  Page  66 - Creating Queries (13:21 - 2809KB)
•  Page  79 - Creating Parameter Queries (2:36 - 526KB)
•  Page  81 - Queries using Criteria & Compound Queries (12:05 - 2515KB)
•  Page  90 - Joining Tables (4:42 - 1010KB)
•  Page  96 - Calculated Fields (4:32 - 928KB)
•  Page  99 - Calculating Statistics Grouping (3:54 - 767KB)
•  Page 104 - Cross tab Query (3:23 - 700KB)

Create copies of the databases as follows:

Ashton James College.mdb  -->  Ashton James College 2.mdb

City Guide.mdb  -->  City Guide 2 .mdb

 Videos

o                                Copy a database using Windows Explorer - (1:48 - 378KB)

o                                Copy a database using Access Backup feature - (1:11 - 320KB)

 Requirements

 Client-Trainer

 Client-City Query part 1, Client-City Query part 2

 City-Trainer Crosstab query is correct

 Total possible for uploading Ashton James College 2.mdb

Points

 Name

2

 #1 Names which begin with C

2

 #2 Located on Main

Note:

 To create a query which contains the text Main you would enter
 Like "*Main" if Main is at the end of the field you are searching
or
 Like "Main*" if Main is at the beginning of the field.

2

 #3 Balance of 0

2

 #4 Balance greater than 150 and paid greater than 800

2

 #5 Highest 5 balances

2

 #6 Total for each advertiser

Points

 Name

1

 #1 Pending Commission

1

 #2 Pending Commission greater than 20

Points

 Name

2

 #1 Average balance for ad rep 26

2

 #2 Total paid of all advertisers

2

 #3 Total balance for each ad rep

20

 Total possible for uploading City Guide 2.mdb (all parts)