· Open the file SC_AC16_7b_FirstLastName_1.accdb, available for download from the SAM website.
· Save the file as SC_AC16_7b_FirstLastName_2.accdb by changing the “1” to a “2”.
o If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
· Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.
1. Create a new form in Design View using the following options:
a. Open the Property Sheet for the new form, and then set the record source for the form to the States and Properties query.
b. Add these fields to the form, in the order listed, in the approximate location shown in Figure 1 on the following page: Address, City, StateName, Services, ClientNumber.
c. Adjust the sizing and positioning of the controls to approximately match those shown in Figure 1.
d. Add the PropertyID field to the form, and then move the control and its label to the approximate location shown in Figure 1.
e. Save the form with the name Record Source Form. (Hint: Do not include the period.)Close the form.