Course Outline
Pre-Requisites
Microsoft Access 2013 Level 1 or equivalent experience
Lessons
Make more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.
Objectives- Understanding relational databases
- Understanding Different Join types to combine table information
- Advanced queries
- Implementing many-to-many relationships
- Import/export data
- Advanced reporting
- Lesson 1: Designing a Relational Database
- Topic A: Relational Database Design
- Topic B: Create a Table
- Topic C: Create Table Relationships
- Lesson 2: Joining Tables
- Topic A: Create Query Joins
- Topic B: Join Tables That Have No Common Fields
- Topic C: Relate Data within a Table
- Topic D: Work with Subdatasheets
- Lesson 3: Creating Advanced Queries
- Topic A: Create Parameter Queries
- Topic B: Create Action Queries
- Topic C: Create Unmatched and Duplicate Queries
- Topic D: Summarize Data
- Lesson 4: Organizing a Database for Efficiency
- Topic A: Data Normalization
- Topic B: Create a Junction Table
- Topic C: Improve Table Structure
- Lesson 5: Sharing Data Across Applications
- Topic A: Import Data into Access
- Topic B: Export Data to Text File Formats
- Topic C: Export Access Data to Excel
- Topic D: Create a Mail Merge
- Lesson 6: Advanced Reporting
- Topic A: Organize Report Information
- Topic B: Format Reports
- Topic C: Include Control Formatting in a Report
- Topic D: Add a Calculated Field to a Report
- Topic E: Add a Subreport to an Existing Report
Cancellation Policy
Should you postpone or cancel your course you must give 5 business days notice.
Training Location
On Track New Location
609 Granville Street
6th Floor
Vancouver,
BC
Canada