Inserting a Column in a Table

Changing a Column Name

Deleting a Column

Inserting a Lookup Column

Inserting a Hyperlink Column

Creating a Many-to-Many Relationship

Modifying Tables

Using Field Properties

Limiting Field Size

Setting Number Formats

Setting Date/Time Formats

Setting Yes/No Formats

Setting Default Values

Setting Validation Rules

Creating an Input Mask

Setting Field Properties

Using Comparison Operators

Using an And Condition

Using an Or Condition

Using the Between And Operator

Using a Wildcard Character

Using Operators in Queries

Setting Top Values in a Query

Creating a Calculated Field

Creating a Function Query

Creating a Parameter Query

Creating a Concatenation in a Query

Using Multiple Tables in a Query

Filtering a Query

Designing Advanced Queries

Creating a Make-table Query

Creating an Update Query

Creating an Append Query

Creating a Delete Query

Creating Action Queries

Using the Crosstab Query Wizard

Using the Find Duplicates Query Wizard

Using the Find Unmatched Query Wizard

Using Advanced Query Wizards

Printing a Relationship Document

Linking Data to an Access Table

Importing Data

Setting a Database Password

Compacting a Database

Backing Up a Database

Using Advanced Database Features

Using Controls

Selecting Non-adjacent Controls

Deleting Controls

Sizing a Control by Dragging

Selecting Adjacent Controls

Moving Selected Controls

Sizing Controls Automatically

Manipulating Controls

Hiding the Ruler

Disabling the Snap to Grid Feature

Displaying the Field List

Adding a Field

Moving Part of a Paired Control

Aligning Controls

Spacing Controls

Using the Toolbox

Adding a Label

Adding an Image

Adding a Rectangle

Adding a Line

Editing an Unbound Control

Using Design View

Using Forms in Design View

Creating a Combo Box

Creating a List Box

Creating an Option Group

Setting the Tab Order Automatically

Setting the Tab Order Manually

Adding a Form Header and Footer

Creating a Blank Form

Using Advanced Form Design

Using Reports in Design View

Creating a Calculated Control

Grouping Data in a Report

Creating a Header for Each Group

Creating a Running Summary

Inserting a Date/Time Control

Inserting a Page Break

Changing the Report Margins

Using the Label Wizard

Creating a Blank Report

Using Advanced Report Design

Selecting a Font Name

Selecting a Font Size

Selecting a Font Style

Using the Format Painter

Selecting Objects with the Toolbar

Using AutoFormat

Running the Spelling Checker

Setting AutoCorrect Options

Adding AutoCorrect Entries

Deleting AutoCorrect Entries

Using Editing Tools

Return to Table of Contents