Files Submitted

3

2. Complete Apply Your Knowledge 1: Changing Data, Creating Queries and Creating Reports: on pages AC 54–55 of Microsoft Access 2003. Download Begon Pest Control database here. Save each query and title it with a description of the query (e.g., Customers-Technician Query).

7

1. Complete Apply Your Knowledge 1: Querying the Begon Pest Control Database: on page AC. 109 of Microsoft Access 2003. Save each query and title it with a description of the query (e.g., Customers living on Fletcher).

4

3. Complete Apply Your Knowledge 1: Maintaining the Begon Pest Control Database: on page AC. 167 of Microsoft Access 2003. Save each query and title it with a description of the query (e.g., Customers table in descending order by balance).

1 attachment with 14 files saved in the Begon Pest Control.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 8, Your Name" in the Subject.

Database to be submitted as attachment:

Begon Pest Control.mdb with the following files saved in the database:

1. Customer Table
2. Customer Amount Report
3. Customer-Technician Query with Technician number 210
4. Query Results  (Customers living on Fletcher)
5. Query Results  (Customer Number, Name, City, Balance)
6. Query Results  (Customer-City Query for Kady)
7. Query Results  (Customer-City Query for Carlton (top 2 records))
8. Query Results  (Technician-Customer joined and sorted)
9. Query Results  (Technician-Customer joined and sorted, balance > $350)
10. Query Results  (City-Technician Crosstab)
11. Modified Customer Table
12. Customer Table with record removed
13. Customer Table in descending order by balance
14. Customer/Technician table relationship