Skip to Content
Office 365 All-in-One For Dummies, 2nd Edition
book

Office 365 All-in-One For Dummies, 2nd Edition

by Peter Weverka, Matt Wade
January 2022
Beginner
960 pages
23h 25m
English
For Dummies
Content preview from Office 365 All-in-One For Dummies, 2nd Edition

Chapter 2

Building Your Database Tables

IN THIS CHAPTER

check Creating database tables

check Using field properties to make data entries more accurate

check Indexing fields in a table

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

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Office 365 For Dummies, 3rd Edition

Office 365 For Dummies, 3rd Edition

Rosemarie Withee, Ken Withee, Jennifer Reed
Office 365 All-in-One For Dummies

Office 365 All-in-One For Dummies

Peter Weverka, Timothy L. Warner
Outlook For Dummies

Outlook For Dummies

Faithe Wempen

Publisher Resources

ISBN: 9781119830702Purchase Link