Course Duration

8 hours, 1-day training workshop

Delivery

Face to face training or online training

Course Inclusive

Training materials & certificate of completion

Description

After maximizing the functionality of MS Excel, you may want to explore MS Access as your database

Course Content

Module I: Understanding Databases

1. Access Components Overview
2. Creating Databases

Module II: Creating Tables

1. Design View and Data Types
2. Field Properties
3. Establishing Relationships
4. Creating Lookup Fields

Module III: Creating Queries

1. Basic Queries
2. Filtering with Criteria
3. Expressions, Totals, and Concatenating
4. Action Queries
5. Special Select Queries with Wizard

Module IV: Creating Forms and Reports

1. Forms Wizard
2. Reports Wizard
3. Customizing Report Controls

More Database Features

1. Importing and Exporting Data
2. Linking Data to an Access Table
3. Linked Table Manager