Microsoft Access 2010 Bible

Part I: Access Building Blocks

44

FIGURE 2.15

A new table added in Design view

Field Name Data Type

Field Properties

For this exercise, you create the Customers table for the Collectible Mini Cars application. The

basic design of this table is outlined in Table 2.1. I cover the details of this table’s design in the

“Creating tblCustomers” section, later in this chapter.

TABLE 2.1

The Collectible Mini Cars Customers Table

Field Name Data Type Description

CustomerID AutoNumber Primary key

Company Text 50 Contact’s employer or other affiliation

Address Text 50 Contact’s address

City Text 50 Contact’s city

State Text 50 Contact’s state

ZipCode Text 50 Contact’s zip code

Phone Text 50 Contact’s phone

Fax Text 50 Contact’s fax

Email Text 100 Contact’s e-mail address

WebSite Text 100 Contact’s Web address