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
- Access Components Overview
- Creating Databases
- Module II: Creating Tables
- Design View and Data Types
- Field Properties
- Establishing Relationships
- Creating Lookup Fields
- Module III: Creating Queries
- Basic Queries
- Filtering with Criteria
- Expressions, Totals, and Concatenating
- Action Queries
- Special Select Queries with Wizard
- Module IV: Creating Forms and Reports
- Forms Wizard
- Reports Wizard
- Customizing Report Controls
- More Database Features
- Importing and Exporting Data
- Linking Data to an Access Table
- Linked Table Manager