Microsoft Office Tutorials and References
In Depth Information
Chapter 2: Building Your Database Tables
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 between tables.
Fasten your seatbelts. In this chapter, you find numerous tips and tricks for
making sure that data is entered accurately in your database tables.
Creating a Database Table
Raw data is stored in database tables (or in a single table if you decide to
keep all the data in one place). The first and most important part of setting
up a database is creating the tables and entering the data. After you enter
the data, you can harass your database for information about the things and
people your database keeps track of. If you haven’t done so already, read
the sections in Chapter 1 of this mini-book that pertain to storing
information and designing a database before you create a database table. Chapter 1
of this mini-book explains what database tables are and how to fashion a
splendid one.
Search JabSto ::




Custom Search