Skip to Main Content
Office 2021 All-in-One For Dummies
book

Office 2021 All-in-One For Dummies

by Peter Weverka
February 2022
Beginner content levelBeginner
800 pages
19h 1m
English
For Dummies
Content preview from Office 2021 All-in-One For Dummies

Chapter 2

Building Your Database Tables

IN THIS CHAPTER

Bullet Creating database tables

Bullet Using field properties to make data entries more accurate

Bullet Indexing fields in a table

Bullet Forming relationships among tables

Database tables are the building blocks of a database. They hold the raw data. Relationships among 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 among 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Office 2021 for Macs For Dummies

Office 2021 for Macs For Dummies

Bob LeVitus, Dwight Spivey
Microsoft Office 2021 – Das Handbuch

Microsoft Office 2021 – Das Handbuch

Rainer G. Haselier, Klaus Fahnenstich
The Frictionless Organization

The Frictionless Organization

Bill Price, David Jaffe

Publisher Resources

ISBN: 9781119831419Purchase Link