New Perspectives Access 2019 | Module 12: SAM Project 1b BUILDING APPLICATION PARTS AND IMPORTING AND EXPORTING DATA GETTING STARTED Open the file NP_AC19_12b_FirstLastName_1

Subject:MS AccessPrice: Bought3

Share With

New Perspectives Access 2019 | Module 12: SAM Project 1b

BUILDING APPLICATION PARTS AND IMPORTING AND EXPORTING DATA

GETTING STARTED

• Open the file NP_AC19_12b_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as NP_AC19_12b_FirstLastName_2.accdb by changing the “1” to a “2”.
  • If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:
  • Support_AC19_12b_ComputerLabs.xlsx
  • Support_AC19_12b_Majors.accdb
• Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.

• 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:
    
   1. The first row contains column headings.
   2. Use ComputerLabs for the linked table name.
   3. Open the ComputerLabs table to view the data. It should look like Figure 1.
      
      Close the 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:
   1. Link to the Majors table.
   2. Open the Majors table to view the data. It should look like Figure 2.
      
      Close the Majors table.

3. Create a Navigation form using the following information:
   1. Use a Vertical Tabs, Left format.
   2. 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.
   3. Add the ClassMasterList report as the fourth tab, then modify the caption so that it reads as Class Master List.
   4. 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.

5. Change the Access options as follows:
   1. Set the Navigation form as the opening Display Form for the database.
   2. Use Ridgedale College as the Application Title.
   3. Do not close and reopen the database.
6. Use the Database Documenter as follows:
   1. Document the relationships in the Current Database category.
   2. Export the report as a pdf file using the default name of doc_rptObjects.pdf to the default folder.
   3. Do not open the file after publishing.
   4. Save the export steps saving the export as Export Relationships as PDF without a Description.
   5. Close the Object Definition report.
7. Use the Performance Analyzer as follows:
   1. Analyze all objects in the All Object Types category.
   2. 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."
   3. Close the Performance Analyzer dialog box.
   4. 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.
   5. In the Edit Relationships dialog box, Enforce Referential Integrity on the relationship.
   6. 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.