You work in the software division of Global Human Resources Consultants (GHRC) which sells modular Human Resource (HR) software to large international companies. For high level planning purposes you have created an Access database to track new clients, the HR software modules they have purchased, and the lead consultant for each installation. In this project you will build action and advanced queries. You will also modify the options that affect the Navigation Pane. Copy the Client table and paste both the structure and data as a table using the name ClientBackup into the database. Create a new Make Table query in Design View with the following instructions: b. C. d. Select all of the fields from the from the Consultant table. Add criteria to select only those records greater than or equal to $80,000 in the Salary field. Use HighSalaries as the new table name. Run the query which should add three records to the HighSalaries table. Save the query using MakeHighSalaries as the query name and then close it.

You work in the software division of Global Human Resources Consultants (GHRC) which sells modular Human Resource (HR) software to large international companies. For high level planning purposes you have created an Access database to track new clients, the HR software modules they have purchased, and the lead consultant for each installation. In this project you will build action and advanced queries. You will also modify the options that affect the Navigation Pane. Copy the Client table and paste both the structure and data as a table using the name ClientBackup into the database. Create a new Make Table query in Design View with the following instructions: a. Select all of the fields from the from the consultant table. b. Add criteria to select only those records greater than or equal to $80,000 in the Salary field. c. Use HighSalaries as the new table name. d. Run the query which should add three records to the HighSalaries table. Save the query using MakeHighSalaries as the query name and then close it