a new table named Rooms . Designate the first row as column headings and the Room ID field as the primary key .
11 Open the Rooms table in Datasheet view ( the table has
2
10 records ). Apply Best Fit to all of the fields in the table , save the table , and then close the table .
12 12
Based on your Departments table , use the Query Wizard to create a simple query . Add the Department Name , Department Email , Phone , Contact Last Name , and Contact First Name fields ( in that order ). Keep the default name of Departments Query , click Finish to display the query results , and then close the query .
13 Based on your Rooms table , use the Form tool to create
10 a form for the table . Save the form as Room Form , display the form in Form view , and then close the form .