Open the file SC_AC16_7b_FirstLastName_1.accdb, available for download from the SAM website.
computer science
Description
GETTING STARTED
·
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.
PROJECT STEPS
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.)
