List of Sidebars

Conventions and Features Used in This Book

Sidebars

Chapter 1: What Is Microsoft Access?

Some Relational Database Terminology

Important Changes to User-Level Security

Reasons to Switch to a Database

Chapter 4: Creating Your Database and Tables

Choosing Field Names

Nulls and Zero-Length Strings

Chapter 5: Modifying Your Table Design

Comparing the Two Contacts Tables

How Do Multi-Value Lookup Fields Maintain Data Normalization Rules?

Chapter 6: Importing and Linking Data

Defining an Import Specification

Chapter 7: Creating and Working with Simple Queries

Understanding Field Names and Captions

Chapter 8: Building Complex Queries

Finding Records Across Date Spans

SQL-The Basic Clauses

Query Fields That Cannot Be Updated

Chapter 11: Building a Form

Some Key Form Design Terms

Chapter 12: Customizing a Form

How Format and Input Mask Work Together

Be Careful When Setting Control Validation Rules

Chapter 14: Using Reports

Checking Out Reports in the Sample Application

Chapter 16: Advanced Report Design

Understanding Grouping Options

Chapter 21: Publishing Data on the Web

What Is Unicode?