Access 2010 Basic Skills

Lessons

Concepts – Activities

1. Getting started

• Topic A: Database concepts
• Topic B: Exploring the Access environment
• Topic C: Getting help

2. Databases and tables

• Topic A: Planning and designing databases
• Topic B: Exploring tables
• Topic C: Creating tables

3. Fields and records

• Topic A: Changing the design of a table
• Topic B: Finding and editing records
• Topic C: Organizing records

4. Data entry rules

• Topic A: Setting field properties
• Topic B: Working with input masks
• Topic C: Setting validation rules

5. Basic queries

• Topic A: Creating and using queries
• Topic B: Modifying query results and queries
• Topic C: Performing operations in queries

6. Using forms

• Topic A: Creating forms
• Topic B: Using Design view
• Topic C: Sorting and filtering records

7. Working with reports

• Topic A: Creating reports
• Topic B: Modifying and printing reports