New Perspectives Access 365 | Module 3: SAM Project A | Lighthouse Cybersecurity

Описание: New Perspectives Access 365 | Module 3: SAM Project A | Lighthouse Cybersecurity #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 are a project assistant for Lighthouse Cybersecurity, a consulting firm that provides information security services throughout the United States. You need to query the database to help make decisions and answer questions from company managers.

Start by creating a query in Design View that lists analysts by their last name and includes the following options:
a. Add the Analyst table to the query window.
b. Add the AnalystID, LastName, and FirstName fields to the design grid in that order.
c. Sort the records in ascending order by LastName to list the analysts alphabetically by their last name.
d. Save the query using LastNameSorted as the query name.

Open the query in Datasheet View and then close it.
2. Open the RegionCriteria query in Design View and make the following changes to select records only for analysts in the northwest:
a. Delete the AnalystID column from the design grid.
b. Add criteria to select only those records where NW is the Region field value.
c. Save the changes to the RegionCriteria query.

Open the query in Datasheet View and then close it.
3. Open the PaidOrBalance query in Design View and make the following changes to select records only for clients who have not made a payment or whose balance is $0.00:
a. Add criteria to select only those records where the Paid field value equals 0 or the Balance field value equals 0.
b. Save the changes to the PaidOrBalance query.

Open the query in Datasheet View, confirm that four records appear in the PaidOrBalance query results, and then close the query.
4. Open the SalaryComparison query in Design View and make the following changes to use the analysts' full names, select records for analysts with salaries over $70,000, and correct an error:
a. Add the FirstName field to the query design grid. The FirstName field should immediately follow the AnalystID field.
b. Add criteria to select only those records where the Salary field value is greater than 70,000.
c. Sort the records by Salary in descending order.
d. Run the query.
e. With the query open in Datasheet View, edit the first record by changing the FirstName value to Mariana from Maria.

Confirm that the query results match Figure 1. Save the query again and close it.
Figure 1: SalaryComparison Query Results



5. Open the RegionLastName query in Design View and make the following changes to display different fields and sort them first by region and then last name:
a. Delete the AnalystID field from the query grid.
b. Move the Region field to the beginning of the design grid.
c. Add the LastName field to the design grid so that the order of the fields in the grid is Region, LastName, FirstName, StartDate.
d. Sort the records in ascending order by the Region field and in ascending order by the LastName field.

Save the changes to the query. Open the query in Datasheet View and confirm that it matches Figure 2. Close the query.
Figure 2: RegionLastName Query Results



6. Open the PaidAndBalance query in Design View and make the following changes to select records for clients who have not made a payment and have a balance of $0.00:
a. Add criteria to select only those records where the Paid field value equals 0 and the Balance field value equals 0.
b. Save the changes to the query.

Open the PaidAndBalance query in Datasheet View, confirm that one record appears in the query results, and then close the query.
7. Open the StartDates query in Design View and make the following changes to select records only for analysts who started working after January 1, 2028:
a. Add criteria to select only those records where the StartDate field value is greater than 1/1/2028.
b. Save the changes to the query.

Open the query in Datasheet View, confirm that 15 records appear in the query results, and then close the query.
8. Create a query in Design View that lists analysts and their region by name and includes the following options:
a. Add the Analyst table and the Region table to the design window.
b. Add the FirstName and LastName fields from the Analyst table to the design grid.
c. Add the RegionName field from the Region table to the design grid.