New Perspectives Access 365 | Module 12: SAM Project A Tech Builders
Building Application Parts and Importing and Exporting Data
· Excel Projects Help
GETTING STARTED
1. Save the file NP_AC365_12A_FirstLastName_1.accdb as NP_AC365_12A_FirstLastName_2.accdb
a. Edit the file name by changing “1” to “2”.
b. If you do not see the .accdb file extension, do not type it. The file extension will be added for you automatically.
2. To complete this Project, you will also need the following files:
Support_AC365_12A_NewHires.xlsx
Support_AC365_12A_Region.accdb
3. With the file NP_AC365_12A_FirstLastName_2.accdb open, ensure that your first and last name is displayed as the first record in the _GradingInfoTable table.
a. If the table does not display your name, delete the file and download a new copy.
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.