Book 6

Access 365

Contents at a Glance

  1. Chapter 1: Introducing Access
    1. What Is a Database, Anyway?
    2. Tables, Queries, Forms, and Other Objects
    3. Creating a Database File
    4. Finding Your Way around the Navigation Pane
    5. Designing a Database
  2. Chapter 2: Building Your Database Tables
    1. Creating a Database Table
    2. Opening and Viewing Tables
    3. Entering and Altering Table Fields
    4. Field Properties for Making Sure That Data Entries Are Accurate
    5. Indexing for Faster Sorts, Searches, and Queries
    6. Establishing Relationships among Database Tables
  3. Chapter 3: Entering the Data
    1. The Two Ways to Enter Data
    2. Entering the Data in Datasheet View
    3. Entering the Data in a Form
    4. Finding a Missing Record
    5. Finding and Replacing Data
  4. Chapter 4: Sorting, Querying, and Filtering for Data
    1. Sorting Records in a Database Table
    2. Filtering to Find Information
    3. Querying: The Basics
    4. Six Kinds of Queries
  5. Chapter 5: Presenting Data in a Report
    1. Creating a Report
    2. Opening and Viewing Reports
    3. Tweaking a Report