Access - Introduction

Course details

Lesson 1 Getting started
Topic A Database concepts
Topic B Exploring the Access environment
Topic C Getting help

Lesson 2 Databases and tables
Topic A Planning and designing databases
Topic B Exploring tables
Topic C Creating tables

Lesson 3 Fields and records
Topic A Changing the design of a table
Topic B Finding and editing records
Topic C Organizing records

Lesson 4 Data entry rules
Topic A Setting field properties
Topic B Working with input masks
Topic C Setting validation rules

Lesson 5 Basic queries
Topic A Creating and using queries
Topic B Modifying query results and queries
Topic C Performing operations in queries

Lesson 6 Using forms
Topic A Creating forms
Topic B Using Design view
Topic C Sorting and filtering records

Lesson 7 Working with reports
Topic A Creating reports
Topic B Modifying and printing reports