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 Columns

First, let’s build the Companies table that we designed in Chapter 3. With the table in Design view, click in the first row under Column Name, type the name of the first column, CompanyID, and press Tab. Notice that Access fills in a default data type and length. You’ll learn how to change this default later in this chapter. Click the down arrow in the Data Type cell or press Alt+Down Arrow to open the list of data type options, as shown in Figure 17-12.

Selecting from the drop-down list of data type options.

Figure 17-12. Selecting from the drop-down list of data type options.

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