O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

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

Building an Access 2002 Table

The following steps lead you through building this table from scratch using different quality checks and data types:

1.
Open the Claims.mdb database from your AccessByExample folder.
2.
Under Objects, click Tables; then click New to open the New Table dialog box.
3.
Click the second option, Design View, when the next window appears, and then click OK to open table Design view.
4.
After typing ClaimNumber, tab to the Data Type column. Notice that a down arrow automatically appears. You can choose any of the data types after clicking the down arrow. In this case, accept the default.
5.
Click the Primary Key button to make it a primary key and then click on Field Size in the lower part of the window (or press ...

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