Microsoft Office Professional 2010 Step by Step eBook

(Ben Green) #1

Creating Forms by Using the Form Tool 823


SET UP You need the GardenCompany03_start database located in your Chapter27
practice file folder to complete this exercise. Open the GardenCompany03_start
database, and save it as GardenCompany03. Then follow the steps.

Important The practice file for this exercise contains tables that look similar to those in the
practice file for Chapter 25. However, to simplify the steps, we have removed the relationships
between the tables. Be sure to use the practice database for each chapter rather than continuing
on with the database from an earlier chapter.


  1. In the Navigation pane, display All Access Objects, and then in the Tables group,
    double-click Customers.
    The Customers table opens in Datasheet view.


The record navigation bar shows that there are 108 records in this table.

Notice the CustomerID field, which contains a unique identifier for each customer and
is the primary key field. In this case, the unique identifier is not an auto-generated
number, but the first three letters of the customer’s last name combined with the first
two letters of his or her first name.


  1. On the Create tab, in the Forms group, click the Form button.

Free download pdf