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.