O'Reilly logo

Office 2016 All-In-One For Dummies by Peter Weverka

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

Chapter 2

Building Your Database Tables

In This Chapter

arrow Creating database tables

arrow Creating fields for a database table

arrow Choosing a primary key field

arrow Using field properties to make data entries more accurate

arrow Indexing fields in a table

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

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