Chapter 2: Building Your Database Tables
In This Chapter
Creating database tables
Creating fields for a database table
Choosing a primary key field
Using field properties to make data entries more accurate
Indexing fields in a table
Forming relationships between tables
Database tables are the building blocks of a database. They hold the raw data. Relationships between the tables permit you to query and generate reports from several different tables. How well your database tables are put together and how accurately data is entered in the tables determine whether your database is a thing of beauty or a wilted flower.
This chapter explains how to create database tables and fields for the tables. It explains what primary key fields are and how primary key fields and indexed fields make it easier for Access to sort, search, and query a database. This chapter describes how to forge relationships ...