go_a01_grader_a3_Open_Houses.accdb (solution) Homework | Page 4

6 Append the records from the downloaded Excel

5 file​go _ a01 _ grader _ a3 _ Departments. xlsx to the Departments table.

7 In the Navigation Pane, organize the objects by Tables

2 and Related Views. Open the Departments table( the table has 14 records). Close the Navigation Pane.

8 Switch the Departments table to Design view. Delete the

4

Campus field. For the Department ID field, enter a description of ​Enter one to five characters for the Department ID​ and then change the field size to ​5​. Enter a description of​Payment for each open house event​ for the Special Pay field. Save the table.

9 Switch to Datasheet view, apply Best Fit to all of the

2 fields in the table, save the table, and then close the table.

10 Import the records from the downloaded Excel 7 file​go _ a01 _ grader _ h3 _ Rooms. xlsx into the database as