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. ...
Get Ten Minute Guide to Access 97 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
