Chapter 1. Getting Started

This short introductory chapter has limited but important objectives.

First, it presents basic database terminology, which lays the groundwork for the detailed discussion on database design in Chapters 2, “Database Design”; 3, “Understanding Relationships”; and 4, “Establishing Relationships.” The most important of these terms are table, field, record, value, and relational database.

Second, the chapter offers a brief overview of data types, which gives you some idea of the kinds of items—names, numbers, dates, pictures, hyperlinks, and so on—you can enter in an Access database.

Third, it explores two important areas—primary keys and null values—that often give new users trouble. Ideally, I'd like to delay discussing ...

Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.