Database Reference
In-Depth Information
SET UP
You need the GardenCompany11 database and the Logo graphic located in the
Chapter11 practice file folder to complete this exercise. Be sure to use the practice data-
base for this chapter rather than continuing on with the database from an earlier chap-
ter. Open the database, and if you want, save your own version to avoid overwriting the
original. Then with All Access Objects displayed in the Navigation pane, follow the steps.
1
In the
Tables
group in the
Navigation
pane, click
Customers
. Then on the
Create
tab, in the
Forms
group, click
More Forms
, and in the list, click
Datasheet
to create a
datasheet form that looks like the
Customers
table.
2
Save the form as
Customer List
. Then open the
Property Sheet
pane, and on the
Data
page, set the
Allow Additions
,
Allow Deletions
, and
Allow Edits
properties
to
No
.
3
Close the
Property Sheet
pane, and then close the form, saving your changes.
4
In the
Forms
group in the
Navigation
pane, right-click
Customer Records
, and click
Copy
. Then right-click anywhere in the
Forms
group, and click
Paste
. In the
Paste As
dialog box, enter
New Customer
as the name of the form, and click
OK
.
5
Open the
New Customer
form in
Layout
view, right-click the form's title, and click
Form Properties
to open the
Property Sheet
pane for the form. On the
Data
page,
set the
Data Entry
,
Allow Additions
,
Allow Deletions
, and
Allow Edits
properties
to
Yes
.
6
Close the
Property Sheet
pane, and then close the form, saving your changes.
We've now created two new forms, one exclusively for data lookup and the other
exclusively for data entry. Now let's create a navigation form so that the new forms
are easy to identify and access.
7
On the
Create
tab, in the
Forms
group, click the
Navigation
button, and then click
Horizontal Tabs, 2 Levels
. If Access opens the
Field List
pane, close it.