O'Reilly logo

Microsoft® Office Access 2003 Inside Out by John L. Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Defining Fields

Now you’re ready to begin defining the fields for the Companies table as we designed it in Chapter 3. Be sure the insertion point is in the first row of the Field Name column, and then type the name of the first field, CompanyID. Press the Tab key once to move to the Data Type column. A button with a down arrow appears on the right side of the Data Type column. Here and elsewhere in Microsoft Access, this type of button signifies the presence of a drop-down list. Click the down arrow or press Alt+Down arrow to open the list of data types, shown in Figure 4-20. In the Data Type column, you can either type a valid value or select from the list of values in the drop-down list. Select AutoNumber as the data type for CompanyID.

Figure 4-20. The ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required