New Perspectives Access 365 | Module 4: SAM Project A Lighthouse Cybersecurity
New Perspectives Access 365 | Module 4: SAM Project A Lighthouse Cybersecurity
If you directly want to get the project from us then contact us on our Whatsapp. Link is given below,
https://wa.me/message/PPXGSJS2TLWUA1
Whatsapp Contact Number:
+91 8114420233
Email ID:
[email protected]
New Perspectives Access 365 | Module 4: SAM Project A Lighthouse Cybersecurity
PROJECT STEPS
As project assistant at Lighthouse Cybersecurity, you need to view records for all analysts, clients, and projects and prepare reports for company departments.
Open the ClientEntry form in Design View and complete the following tasks to improve the appearance and usefulness of the form:
Resize the Paid text box to be the same size as the ClientName text box above it.
Move the Close command button so that the left edge of the command button is at the 6" mark on the horizontal ruler.
Add a label with the caption Accounting Department to the Form Header at the 3" mark on the horizontal ruler.
Save the ClientEntry form, switch to Form View as shown in Figure 1, then close the form.
Open the AnalystEntry form in Design View and then modify it as follows to add a missing field:
Add the Salary field to the right of the AnalystID field.
Delete the Salary label.
Align the bottom edge of the Salary text box with the bottom edge of the AnalystID text box.
Save the changes to the AnalystEntry form and then close it.
Use the Form Wizard to create a new form based on the Client table with the following options:
Include all fields from the Client table in the form.
Select the Columnar layout for the form.
Enter ClientStatus as the form title.
With the ClientStatus form open in Layout View, right-align and bold the text in the five labels.
Save the ClientStatus form.
Open the ClientStatus form in Form View, and then navigate to the record with the ClientID field value of 8. Change the Balance field value of this record to $35,000.
Use the ClientStatus form to add a new record to the Client table with the field values shown in Table 1. (Hint: The Total field is a calculated field.) Save and close the form.
Table 1: New Record for ClientStatus Form
Open the AnalystSalary form in Design View and then modify it as follows to add a missing field and make the form more accurate:
Delete the Human Resources Department label in the Form Header.
Add the StartDate field to the form and then position it just below the Salary label and text box.
Align the left edge of the StartDate label with the left edge of the labels above it.
Align the left edge of the StartDate text box with the left edge of the text boxes above it.
Change the StartDate label to display Start Date as the text.
Save and close the AnalystSalary form.
Use the Report button to create a report based on the Region table. Save the report using RegionList as the name. (Hint: Do not use the Report Wizard.)
Modify the RegionList report in Layout View as follows to improve its appearance:
Change the orientation to Landscape.
Change the label in the Report Header section to use Region Descriptions as the text.
Delete the text boxes displaying the current date and time.
Delete the text box displaying the page number since this is a one-page report.
Resize the height of the text box that counts the number of records to clearly display 8 as the count, as shown in Figure 2.
Save and close the RegionList report.
Use the Report Wizard to create a report based on the Project and Analyst tables with the following options:
Include the Description field from the Project table and the LastName, StartDate, and ServiceCode fields from the Analyst table in the report.
View the data by Analyst.
Use Description as the grouping field.
Sort the records in alphabetic order by LastName.
Select Stepped as the layout and Landscape as the orientation.
Use ProjectsAndAnalysts as the report title, and then preview the report.
Close the ProjectsAndAnalysts report.
Open the AnalystsByProject form in Design View and then modify it as follows to add visual appeal:
Apply a Transparent border to the Description label.
Change the background color of the Form Header section to Maroon 1 (6th column, 2nd row of the Standard Colors palette).
Change the font size of the Lighthouse Cybersecurity Analysts label in the Form Header to 24.
Change the width of the Lighthouse Cybersecurity Analysts label so the right edge aligns with the 6" mark on the horizontal ruler.
Insert the picture
#samproject1a #samprojects #cengageassignments #NP_AC365_4a #NP_ACCESS #access_assignments #access_sam_projects #Module4SamProjecta #lighthouse_cybersecurity #new_perspectives_access #NP_AC365_4a_FirstLastName_1.accdb #NP_AC365_4a_FirstLastName_2.accdb