New Perspectives Access 2019 | Module 12 SAM Project 1b | Ridgedale College

Описание: 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]

PROJECT STEPS
1. You work in the Admissions Office at Ridgedale College to help track grants awarded to professors as well as teaching assistant assignments by class. You have created an Access database to organize these details. 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_AC19_12b_ComputerLabs.xlsx Excel file located in the default folder using the following information:

a. The first row contains column headings.
b. Use ComputerLabs for the linked table name.
c. Open the ComputerLabs table to view the data. It should look like Figure 1.

Close the ComputerLabs table.
Figure 1: Linked ComputerLabs Table
2. Create a linked table to the Support_AC19_12b_Majors.accdb Access file located in the default folder using the following information:
a. Link to the Majors table.
b. Open the Majors table to view the data. It should look like Figure 2.

Close the Majors table.
Figure 2: Linked Majors Table
3. Create a Navigation form using the following information:
a. Use a Vertical Tabs, Left format.
b. Add the ClassEntry, DepartmentEntry, and ProfessorEntry forms as the first, second, and third tabs, then modify the captions so that they read as Class Entry, Department Entry, Professor Entry.
c. Add the ClassMasterList report as the fourth tab, then modify the caption so that it reads as Class Master List.
d. Use the name Navigation to save the Navigation form.
4. With the Navigation form still open in Layout View, reorder the tabs so that the Class Master List tab is first as shown in Figure 3.
Save and close the Navigation form.
Figure 3: Final Navigation Form
5. Change the Access options as follows:
a. Set the Navigation form as the opening Display Form for the database.
b. Use Ridgedale College as the Application Title.
c. Do not close and reopen the database.
6. Use the Database Documenter as follows:
a. Document the relationships in the Current Database category.
b. Export the report as a pdf file using the default name of doc_rptObjects.pdf to the default folder.
c. Do not open the file after publishing.
d. Save the export steps saving the export as Export Relationships as PDF without a Description.
e. Close the Object Definition report.
7. Use the Performance Analyzer as follows:
a. Analyze all objects in the All Object Types category.
b. When it finishes, read the ideas. You will take steps to complete the following suggestion: "Table 'Departments': Relate this table to others in the database."
c. Close the Performance Analyzer dialog box.
d. Open the Relationships window, then drag the DepartmentID field from the Departments field list to the Department field in the Professors 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 SAM website to submit your completed project.

#samproject1b #samprojects #cengageassignments #NP_AC19_12b #NP_ACCESS #access_assignments #access_sam_projects #Module12SamProjectb #ridgedale_college #new_perspectives_access #NP_AC19_12b_FirstLastName_1.accdb #NP_AC19_12b_FirstLastName_2.accdb