Access Fundamentals

Understand the Screen
Understand the Access Screen

Open and Save a Database
How to Open a Database in Access

Work with Database Objects
How to Work with Database Objects in Access

Tour of Tables
Tour of Tables in Access

Tour of Queries
Tour of Queries in Access

Tour of Forms
How to Add a Record in Access

Tour of Reports
Tour of Reports in Access

Help
How to Get Help in Access

Close and Exit Access
How to Close and Exit Access

Create and Work with a Database

Plan a Database
How to Plan a Database in Access

Create a Database
How to Create a Database in Access

Add, Edit, and Delete Records
How to Add, Edit, and Delete Records in Access

Select Data
How to Select Data in Access

Cut, Copy, and Paste Data
How to Cut, Copy, and Paste Data in Access

Use Undo and Redo
How to Use Undo and Redo in Access

Check Spelling
How to Check your Spelling in Access

Use the Zoom Box
How to Use the Zoom Box in Access

Preview and Print
How to Preview and Print in Access

Find, Filter, and Format Data

Find and Replace Data
How to Find and Replace Data in Access

Sort Records
How to Sort Records in Access

Use Common Filters
How to Use Common Filters in Access

Filter by Selection
How to Filter by Selection in Access

Filter by Form
How to Filter by Form in Access

Create an Advanced Filter
How to Create an Advanced Filter in Access

Adjust Rows and Columns
How to Adjust Rows and Columns in Access

Change Gridlines and Cell Effects
How to Change Gridlines and Cell Effects in Access

Freeze a Column
How to Freeze a Column in Access

Hide a Column
How to Hide a Column in Access

Tables

Create a Table
How to Create a Table in Access

Understand Field Types and Properties
How to Understand Field Types and Properties in Access

Index a Field
How to Index a Field in Access

Add a Primary Key and Auto-Increment Fields
How to Add a Primary Key and Auto-Increment Fields in Access

Insert, Reorder, and Delete Fields
How to Insert, Reorder, and Delete Fields in Access

Add Field Descriptions and Captions
How to Add Field Descriptions and Captions in Access

Change the Field Size
How to Change the Field Size in Access

Format Number, Currency, and Date/Time Fields
How to Format Number, Currency, and Date/Time Fields in Access

Format Text Fields
How to Format Text Fields in Access

Set a Default Value
How to Set a Default Value in Access

Require Data Entry
How to Require Data Entry in Access

Validate Data
How to Validate Data in Access

Create an Input Mask
How to Create an Input Mask in Access

Create a Lookup Field
How to Create a Lookup Field in Access

Create a Value List
How to Create a Value List in Access

Modify a Lookup List
How to Modify a Lookup List in Access

Add Total Rows
How to Add Total Rows in Access

Create Relational Databases

Table Relationships and Relationship Types
Understand Table Relationships and Relationship Types in Access

Create Relationships Between Tables
How to Create Relationships Between Tables in Access

Enforce Referential Integrity
How to Enforce Referential Integrity in Access

Print and Delete Relationships
How to Print and Delete Relationships in Access

Work with Queries

Create a Query
How to Create a Query in Access

Hide, Remove, and Sort Fields
How to Hide, Remove, and Sort Fields in Access

Use AND and OR Operators in a Query
How to Use AND and OR Operators in a Query in Access

Create a Multiple Table Query
How to Create a Multiple Table Query in Access

Create a Calculated Field
How to Create a Calculated Field in Access

Work with Expressions and the Expression Builder
How to Work with Expressions and the Expression Builder in Access

Format Fields within Queries
How to Format Fields within Queries in Access

Use an IIF Function
How to Use an IIF Function in Access

Summarize Groups of Records
How to Summarize Groups of Records in Access

Display Top or Bottom Values
How to Display Top or Bottom Values in Access

Parameter Queries
How to Create Parameter Queries in Access

Find Duplicate Records
How to Find Duplicate Records in Access

Find Unmatched Records
How to Find Unmatched Records in Access

Crosstab Queries
How to Create Crosstab Queries in Access

Delete Queries
How to Create Delete Queries in Access

Append Queries
How to Create Append Queries in Access

Make-Table Queries
How to Create Make Table Queries in Access

Update Queries
How to Create Update Queries in Access

Work with Forms

Create a Form with the Form Wizard
Create a Form Using the Form Wizard in Access

Create and Use a Form
How to Create and Use a Form in Access

Modify a Form in Layout View
How to Modify a Form in Layout View in Access

Form Design View Basics
How to Use Form Design View in Access

Change the Tab Order
How to Change the Tab Order in Access

Work with Control Properties
How to Work with Control Properties in Access

Work with Form Properties
How to Work with Form Properties in Access

Change a Controls Data Source
How to Change a Controls Data Source in Access

Create a Calculated Control
How to Create a Calculated Control in Access

Change a Controls Default Value
How to Change a Controls Default Value in Access

Create a Subform
How to Create a Subform in Access

Work with and Modify Subforms
How to Work with and Modify Subforms in Access

Create and Modify a Navigation Form
How to Create and Modify a Navigation Form in Access

Work with Reports

Create a Report
How to Create a Report in Access

Use the Report Wizard
How to Use the Report Wizard in Access

Use the Label Wizard
How to Use the Label Wizard in Access

Work in Layout View
How to Work in Layout View in Access

Format Fonts
How to Format Fonts in Access

Copy Formatting
How to Copy Formatting in Access

Change Text Alignment
How to Change Text Alignment in Access

Insert a Logo and Background Image
How to Insert a Logo and Background Image in Access

Adjust Page Margin and Orientation
How to the Adjust Page Margin and Orientation in Access

Add Page Numbers and Dates
How to Add Page Numbers and Dates in Access

Group and Sort
How to Group and Sort in Access

Summarize Data using Totals
How to Summarize Data using Totals in Access

Understand Report Sections
How to Understand Report Sections in Access

Advanced Topics

Use Conditional Formatting
How to Use Conditional Formatting in Access

Work with Number Formatting
How to Work with Number Formatting in Access

Use Themes
How to Use Themes in Access

Import Information
How to Import Information in Access

Export Information
How to Export Information from Access

Link External Information
How to Link External Information in Access

Mail Merge Records to Word
How to Create a Word Merge with Access Data

Use Hyperlink Fields
How to Use Hyperlink Fields in Access

Database Object Dependencies
How to Database Object Dependencies in Access

Compact and Repair a Database
How to Compact and Repair a Database in Access

Convert an Access Database
How to Convert an Access Database

Back Up and Restore a Database
How to Back Up and Restore a Database in Access

Password Protect a Database
How to Password Protect a Database in Access

Split a Database
How to Split a Database in Access