New Perspectives Access 365 | Module 12: SAM Project A | Tech Builders

Описание: New Perspectives Access 365 | Module 12: SAM Project A | Tech Builders #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 data division of Tech Builders which sells computer and network system hardware to a variety of companies. For high level planning purposes, you have created an Access database to track new customers, the hardware modules they have purchased, and the lead representative for each installation. In this project, you will complete tasks that help an Access database become a complete and easy-to-use desktop application.

Create a linked table to the Support_AC365_12A_NewHires.xlsx Excel file located in the default folder using the following information:
a. The first row contains column headings.
b. Use NewHires for the linked table name.
2. Create a linked table to the Support_AC365_12A_Region.accdb Access file located in the default folder using the following information:
a. Link to the Region table.
3. Create a Navigation form using the following information:
a. Use a Horizontal Tabs format.
b. Add the CustomerEntry and RepresentativeSalary forms as the first and second tabs, then modify the captions so that they read as Customer Entry and Representative Salary.
c. Add the CustomerDetails and RepresentativeList reports as the third and fourth tabs, then modify the captions so that they read as Customer Details and Representative List.
d. Use the name Main to save the navigation form.
4. With the Main form still open in Form Layout View, reorder the tabs so that the Representative Salary tab is first as shown in Figure 1. Save and close the Main form.
Figure 1: Final Main Navigation Form



5. Change the Access options as follows:
a. Set the Main form as the opening Display Form for the database.
b. Use Tech Builders as the Application Title.
c. Do not close and reopen the database.
6. Use the Database Documenter as follows:
a. Document all of the tables in the database.
b. Export the report as a pdf file using the default name of doc_rptObjects.pdf to the default folder.
c. Save the export steps saving the export as Export Tables as PDF without a Description.
d. Close the Object Definition report.
7. Use the Performance Analyzer as follows:
a. Analyze all object types.
b. When it finishes, read the ideas. You will take steps to complete the following suggestion: "Table RepresentativeImport: Relate this table to the others in the database."
c. Close the Performance Analyzer dialog box.
d. Open the Relationships window, then drag the RepresentativeID field from the Representative field list to the RepresentativeID field in the Customer field list to create a one-to-many relationship between the tables.
e. In the Edit Relationships dialog box, Enforce Referential Integrity on the relationship.
f. Save and close the Relationships window.
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 website to submit your completed project.