Скачать или смотреть New Perspectives Access 2019 | Module 9: SAM Critical Thinking Project 1c

New Perspectives Access 2019 | Module 9: SAM Critical Thinking Project 1c #newperspectives

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,

Whatsapp Contact Link:
https://api.whatsapp.com/message/4B6NMKKBK...

Whatsapp Number:
+919116641093
+918005564456

Gmail Id:
[email protected]

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English.

PROJECT STEPS
1. You work in the software division of Global Human Resources Consultants (GHRC), which sells modular human resources (HR) software to large international companies.For high-level planning purposes, you havecreated 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, paste both the structure and the data into the database as a table, and use ClientBackup as the table name.
2. Create a new Make Table query as follows:
a. Select all of the fields from the Consultant table.
b. Add criteria to select only those records with salaries greater than or equal to $80,000.
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.
3. Create a new Append query as follows:
a. Select all of the fields from the Consultant table.
b. Add criteria to select only those records with salaries greater than or equal to $70,000 and less than $80,000.
c. Append the records to the HighSalaries table.
d. Run the query, which should add 13 records to the HighSalaries table. Save the query with the name AppendHighSalaries and then close it.
The HighSalaries table should contain 16 records, as shown in Figure 1.
Figure 1: HighSalaries table in Datasheet View



4. Create a new Delete query as follows:
a. Select all of the fields from the Client table.
b. Add criteria so only those records containing a date prior to 7/1/2021 in the ContractSigned field are selected.
c. Run the query, which should delete three records from the Client table. Save the query with the name DeleteOldContracts and then close it.
5. Create a new Update query as follows:
a. Select the ComponentName, InstallationFee, and MonthlyFee fields from the SoftwareComponent table.
b. Add criteria so only those records with an InstallationFee value greater than or equal to 2000 are selected.
c. Update the InstallationFee and MonthlyFee fields to increase them by 10% of their current values.
d. Run the query to update eight records, save it using UpdateFees as the query name, and then close it.
6. Open the UnsoldComponents query and complete the following tasks:
a. Delete the criteria row that contains criteria in the InstallationFee field.
b. Add the ClientID field from the ClientSoftware table to the query grid in the fourth column.
c. Set the query to select all records from the SoftwareComponent table.
d. Select only those records from the SoftwareComponent table with no matching records in the ClientSoftware table.

Save and close the UnsoldComponents query. The query should match Figure 2 when in Datasheet view.
Figure 2: UnsoldComponents Query in Datasheet View



7. Change the Navigation Options to show hidden objects and unhide the Revenue query.
8. Hide the ConsultantSalaries query in the Navigation Pane, and then change the Navigation Options to hide hidden objects.
Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project.