Microsoft Access - Up to Speed

About Microsoft Access - Up to Speed

Introduction

Before You Begin

Understanding Databases

Using Database Templates

Opening an Existing Database

The Access Environment

A Look at Tables

A Look at Forms

A Look at Queries

A Look at Reports

Creating a Blank Database

Setting Access Options

Getting Help

Creating a Table using Application Parts

Entering Data into a Table

Adding New Fields to a Table

Creating a table from scratch

Setting a Primary Key

Changing Column Width and Row Height

Rearranging Fields

Inserting and Deleting Fields

Changing Field Properties

Designing in Datasheet View

Editing Data

Formatting Table Data

Importing Excel Data into an Existing Table

Importing a Text File into a New Table

Selecting and Deleting Records

Sorting Records

Finding and Replacing Data

Filtering Data by Selection

Filtering Data by Form

Using Common Filters

Hiding and Unhiding Columns

Freezing Columns

Rearranging Columns

Displaying Column Totals in a Datasheet

Setting Validation Rules

Formatting Fields

Indexing Fields

Requring Data Entry

Creating an Input Mask

Creating a Lookup Field

Creating a Value List

Modifying a Value List

Creating Calculated Fields

Creating Multiple Primary Keys

Creating Multiple Field Values

Working in Query Design View

Creating a Query in Design View

Adding Fields to a Query

Removing Fields from a Query

Saving a Query

Running a Query

Adding Criteria to a Query

Specifying Multiple Criteria

Sorting Data in a Query

Moving Columns in a Query

A Look at Relationships

Creating a One to One Relationship

Creating a One to Many Relationship

Creating a Many to Many Relationship

Enforcing Referential Integrity

Cascade Update Related Fields

Cascade Delete Related Records

Creating and Printing a Relationship Report

Creating Multi Table Queries

Using Calculations in Queries

Changing Query Properties

Working with the Expression Builder

Creating a Totals Query

Creating a Parameter Query

Creating a Find Duplicates Query

Creating a Find Unmatched Records Query

Modifying Query Joins

About Action Queries

Creating a Make Table Query

Creating an Append Query

Creating an Update Query

Creating a Delete Query

Creating a SQL Query

Using the Form Wizard

Entering Data into a Form

A Look at Design View

Adding a Field to a Form

Changing Control Properties

Using Layout View

Finding Records in a Form

Adding Headers and Footers

Adding Controls to a Form

Moving and Sizing Controls

Creating a Calculated Control

Changing Control Properties

Changing Form Properties

Changing the Tab Order

Adding a Lookup Control

Inserting Graphics

Creating a Subform

Creating a Basic Report

Applying a Theme to a Report

Using the Report Wizard

Report View and Layout View

A Look at Design View

Modifying Report Setup

Printing Reports

Using the Label Wizard

Working with Report Sections

Adding Controls to a Report

Changing Control Properties

Creating a Calculated Control

Changing a Control's Data Source

Changing a Report's Data Source

Sorting and Grouping Data

Changing Report Section Properties

Inserting Graphics

Applying a Theme to a Report

Applying Conditional Formatting

Adding A Subform Using the Subform & Subreport Tool

Modifying a Subform

Aligning Controls to each other

Creating an Option Group

Edit Sorting and Grouping Levels in a Report

Inserting Total Fields in a Report

Using Rectangles Lines and Borders

Importing Data from a Text File

Importing Data from Excel

Importing Data from another Access Database

Linking Data

Exporting Data to Other Formats

Exporting Data to a PDF File

Exporting Data to another Access Database

Exporting Data to Excel

Exporting Data to Microsoft Word

Exporting Data to a Microsoft Word Mail Merge

Creating a Macro

Adding Additional Macro Actions

Running a Macro Step by Step

Assigning a Macro to a Command Button

Creating a Macro Group

Using a Macro Group

Using Macro Conditions

The AutoExec Macro

Creating an AutoKeys Macro

Creating a Data Macro

Adding a Macro to the Quick Access Toolbar

Creating a Switchboard

Adding Switchboard Items

Using the Switchboard

Editing a Switchboard

Creating a Navigation Form

Setting Startup Options

Using Compact and Repair

Changing Database Properties

Documenting a Database

Analyzing a Database

Viewing Object Dependencies

Backing Up a Database

Splitting a Database

Setting a Database Password

Thank You!