using the format P- ### and then change the field size to 5 . Save the table .
9 Switch to Datasheet view , apply Best Fit to all of the
3 fields in the table , save the table , and then close the table .
10 Import the records from the downloaded Excel
7 filego _ a01 _ grader _ h3 _ Contractors . xlsx into the database as a new table named Contractors . Designate the first row as column headings and the ID field as the primary key .
11 Open the Contractors table in Datasheet view ( the table
3 has four records ). Apply Best Fit to all of the fields in the table , save the table , and then close the table .
12 8
Based on your Projects table , use the Query Wizard to create a simple query . Add the Site , Building Project ,