Database Reference
In-Depth Information
In this exercise, you'll use the Form tool to create a form based on a table. You will then
enter a couple of records by using the new form and refresh the table to reflect the new
entries.
SET UP
You need the GardenCompany03 database located in the Chapter03 practice
file folder to complete this exercise. The practice file for this exercise contains tables that
look similar to those in the practice file for Chapter 1. However, to simplify the steps, we
have removed the relationships between the tables. Be sure to use the practice database
for this chapter rather than continuing on with the database from an earlier chapter.
Open the database, and if you want, save your own version to avoid overwriting the
original. Then follow the steps.
3
1
With
All Access Objects
displayed in the
Navigation
pane, in the
Tables
group,
double-click
Customers
to open the
Customers
table in
Datasheet
view.
The record navigation bar shows that there are 108 records in this table.
TIP
The CustomerID field contains a unique identifier for each customer and is the
table's primary key field. In this case, the unique identifier is not an autogenerated
number, but the first three letters of the customer's last name combined with the first
two letters of his or her first name. For more information about this type of primary
key, see “Allowing only values in other tables” in Chapter 6, “Maintain data integrity.”
2
On the
Create
tab, in the
Forms
group, click the
Form
button to create a simple form
based on the active table and display the form in
Layout
view.
