Microsoft Access Basic

1. Explore an Access 2010 Database

Working in Access 2010

Understanding Database Concepts

Exploring Tables

Exploring Forms

Exploring queries

Exploring Reports

Previewing and Printing Access Objects

2. Create Database and Simple Tables

Creating Databases from Templates

Creating Databases and Tables manually

Manipulating Table Columns and Rows

Refining Table Structure

Creating Relationships Between Tables

3. Create Simple Forms

Creating Forms by Using the Form Tool

Changing the Look of Forms

Changing the Arrangement of Forms

4. Display Data

Sorting Information in Tables

Filtering Information in Tables

Filtering Information by Using Forms

Locating Information That Matches Multiple Criteria

5. Create Simple Reports

Creating Reports by Using a Wizard

Modifying Report Design

Previewing and Printing Reports