go_a01_grader_a3_Open_Houses.accdb (solution) Homework | Seite 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