O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

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

Creating and Customizing Tables

A table is the basic unit for storing and organizing information in an Access database. One database can contain any number of tables, as well as links to tables stored in other locations and other formats. Data within a table is arranged in a basic grid: Each row contains all the data fields in a single record, and each column represents a field, where similar information (first name and last name, for instance) is stored in all the records. In turn, tables directly or indirectly form the basis for all other objects within an Access database, including queries, forms, and reports.

As a general rule, however, each field definition has four elements, all of them visible when you open a table in Design view and select ...

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