O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

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

How Access Stores Your Data

In Access, the first thing you do is create a database file. That file holds everything you create for that database—not only all the data, but also the customized forms, reports, and indexes. If you have two or more businesses, you may want to create two or more separate databases (one for each business).

Tables

The heart of each database is its tables. A table is a lot like a spreadsheet. A data table (or just "table" for short) is shown in Figure 1.1.

Figure 1.1. A typical table in Access.

Access stores each database entry (for example, each client or each inventory item) in its own row; this is a record. ...

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