Files Submitted

Email the files created from the following sections as attachments to your instructor at llemley@pjc.edu:

5

1. Complete Project 1, on pp AC 4 - AC 52 of the Microsoft Access 2003 book. Save each query and title it with a description of the query (e.g. Client-Trainer Query).          

2

2. Complete Project 2 on page AC 66 - AC 106. Save each query and title it with a description of the query (e.g. Client-City Query).           

2

3. Complete Project 3 on pp AC 114 - AC 164. Save each query and title it with a description of the query (e.g. Client Table multiple field sort)..

1 attachment with 9 files saved in the Ashton James College.mdb database

Note:

• Save all the files on your disk first before you email your instructor.
• Browse the files on your disk and select/attach 1 file to your email.
• Type "Your section #, Assignment 7, Your Name" in the Subject.

Database to be submitted as attachment:

Ashton James College.mdb with the following files saved in the database:

1. Client Table (Figure 1-43)
2. Trainer Table (Figure 1-47)
3. Client-Trainer Query (Figure 1-53)
4. Client Form (Figure 1-64)
5. Client Amount Report (Figure 1-67)
6. Client-City Query (Figure 2-26)
7. City-Trainer Crosstab Query (Figure 2-71)
8. Client-Trainer Relationship (Figure 3-71)
9. Client Table multiple field sort (Figure 3-79)