New Perspectives Access 365 | Module 5: SAM Project A Lighthouse Cybersecurity скачать в хорошем качестве

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

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/4B6N... Whatsapp Number: +919116641093 Gmail Id: singhal.agrawal.bharati@gmail.com 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. New Perspectives Access 365 | Module 5: SAM Project A Lighthouse Cybersecurity PROJECT STEPS You work as a project assistant for Lighthouse Cybersecurity, an information security consulting company in Tacoma, Washington. For high-level planning purposes, you have created an Access database to track new clients and their projects, services, and analysts. To provide accurate information to other employees, you will improve the tables and queries of the database. In Design View of the Client table, add three new fields with the following specifications to track additional client information: Add a field named Website with a Hyperlink data type. Add a field named Logo with an Attachment data type. Add a field named Comments with a Long Text data type. For the Comments field, use Yes as the value for the Append Only property value to track the changes to the field. Save the Client table. While still in Design View of the Client table, modify the following field properties to make the fields easier to use: Use 30 as the Field Size property for the ClientName field. Use Client as the Caption property for the ClientName field. Choose Medium Date as the Format property for the ProjectStart field. Save the Client table. If prompted that some data may be lost, click Yes to continue. (Hint: No data is lost because no values exceed 30 characters in the ClientName field.) While still in Design View of the Client table, modify the following field properties to increase the accuracy of data entry: Choose Yes as the Required property for the ServiceCode field. Enter =1/1/2029 as the Validation Rule property for the ProjectStart field. Enter Must be later than 1/1/2029 for the Validation Text property for the ProjectStart field. Save the Client table. If prompted to test data integrity rules, click Yes. While still in Design View of the Client table, add a new field immediately below the existing fields using the Lookup Wizard and the following information to store the geographical region for each client: Enter RegionCode as the field name. Get the values from the Region table. Select the RegionCode and RegionName fields. Sort the records in ascending order by the RegionName field. Do not hide the key column. Store the RegionCode value, use the other default options of the Lookup Wizard, and save the Client table as prompted. Use Yes for the Column Heads Lookup property for new RegionCode field. Save the Client table. Switch to Datasheet View of the Client table, and then select NE (Northeast) as the RegionCode value for the first record (ClientID 1, Astrum Logistics). Switch to Design View of the Client table and modify the following table properties to further increase accuracy in data entry: Add [ProjectStart]=[ContractSigned] as the Validation Rule for the table. Enter Contract must be signed before the project start date as the Validation Text property for the table. Save and close the Client table. Click Yes if prompted to test for data integrity. Open the Analyst table in Datasheet View and modify the datasheet as follows to summarize analyst data: Add a Total row to the datasheet. Sum the values in the Salary field. Resize the Salary field to display the new total. Save and close the Analyst table. In Design View of the ProjectsByClient query, modify the query as follows to make the datasheet easier to interpret and to summarize project data: Use Project as the Caption property for the Description field. Use Clients as the Caption property for the ClientName field. Use Total Fee as the Caption property for the MonthlyFee field. Add the Total row to the query grid, count the ClientName field, and sum the MonthlyFee field. Save and view the query in Datasheet View, add a Total row to the datasheet, and then sum the Clients and Total Fee columns. Resize the Total Fee column to its best fit as shown in Figure 1. Save and close the ProjectsByClient query. Create a new query in Query Design View based on the Analyst table as follows to select the top five records depending on a maximum salary amount: Add the FirstName, LastName, and Salary fields in that order. Sort the records in descen #samproject1a #samprojects #cengageassignments #NP_AC365_5a #NP_ACCESS #access_assignments #access_sam_projects #Module5SamProjecta #lighthouse_cybersecurity #new_perspectives_access #NP_AC365_5a_FirstLastName_1.accdb #NP_AC365_5a_FirstLastName_2.accdb