K212 - Access Project 2, Part 1

Querying the Repair Shop Database

Purpose: To demonstate the ability to create and use queries.

Problem: Query an auto repair shop database in a variety of ways.

Instructions: Use the auto repair shop database you created in class (Project 1) for this assignment. If you don't have it with you, copy the database from someone sitting next to you. Execute the following tasks on the computer.

Part I

1. Open the Repair Shop database and, using the Jobs table, create a new query for each of the following tasks.

2. Display all fields for all the records in the Jobs table.

3. Display the Job ID, Customer ID, and Job Status for all records in the Jobs table.

4. Display the Job ID, Customer ID, Job Status, and Quote for all jobs with a Job Status of C.

5. Display the Job ID, Customer ID, Job Status, and Completion Date for all jobs with a Completion Date after June 1, 1998.

6. Display the Job ID, Customer ID, Job Status, and Quote for all jobs with a Job Status of I and a Quote of more than $1000.

7. Display the Job ID, Customer ID, Job Status, and Completion Date for all jobs with a Job ID that begins with P.

8. Display the Job ID, Customer ID, Completion Date, and Quote for all jobs with a Completion Date before March 30, 1998 or a Quote of less than $500. Print.

9. Display the Job ID, Customer ID, Job Description, and Quote for all jobs with a Quote greater than $500 and less than $1000.
(Hint: enter a criteria of “>500 And <1000” for Quote.) Print.

10. Display the Job ID, Customer ID, Job Status, and Completion Date of all records in the Jobs table sorted in ascending sequence by Customer ID.

11. Using all the fields, display all the records in the Jobs table sorted in ascending sequence by Job ID within Customer ID (Customer ID is the primary sort; Job ID is the secondary sort). Print.