|
Access Basics
|
· Understanding Databases
· Using Database Templates
· Open an Existing Database
· The Access Environment
|
· Working with Database Objects
· Creating a Blank Database
· Setting Access Options
· Using Help
|
|
Working with Tables
|
· Using Table Templates
· 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
|
|
Working with Data
|
· 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/Unhiding Columns
· Freezing Columns
· Rearranging Columns
· Displaying Column Totals in a Datasheet
|
|
Working with Queries
|
· 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
· Using the Query Wizard
|
|
Working with Forms
|
· Using the Form Wizard
· Entering Data into a Form
· A Look at Design View
· Adding a Field to a Form
|
· Changing Control Properties
· Layout View
· Finding Records in a Form
|
|
Creating Reports
|
· Creating a Basic Report
· Autoformatting 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
|