MicrosoftВ® Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out)

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?

Категории