PROJECT 1

To identify the number of employees at the New Book Sales Corporation, you view the records in the Sales Department table. You decide to

add a parameter query where you can enter a title for a group of employees and have all employees in that group displayed in the query results.

1. Open the New Book Sales file from the drive and folder where your Data Files are stored. Save the database as New Book Sales

Database, followed by your initials.

2. Create a parameter query for the Sales Department table. In the Design window, add the Employee ID, Last Name, First Name, and Title

fields to the query grid. Since each field in the table will be included in the query, think of a quick way to put each field in the query grid.

3. Enter a prompt in the Title field that will prompt the user to enter a title for a group of employees.

4. Sort the query in ascending order by the Last Name field, and then add another sort in ascending order to the First Name field.

5. Save the query as Qry-Employees by Title.

6. Run the parameter query using Sales Rep as the criterion. Adjust the column widths if necessary. Print the query results.

7. Run the query using the Sales Assistant and the Sales Manager parameters. Print the results of each query.

8. Close the query and the database file.