Chapter 2: Building Your Database Tables

In This Chapter

arrow.png Creating database tables

arrow.png Creating fields for a database table

arrow.png Choosing a primary key field

arrow.png Using field properties to make data entries more accurate

arrow.png Indexing fields in a table

arrow.png 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 ...

Get Office 2013 All-In-One For Dummies now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.