Erin Olsen - MCAS
Erin Olsen has been involved in the computer training industry for over 15 years. Erin has helped
thousands of students worldwide receive quality computer training in a wide range of software titles and subject
matter. Erin is a Microsoft Office Specialist Master Instructor and is MCAS certified. As a frequent Microsoft
Office user as well as a trainer, Erin utilizes a practical approach in her instruction.
Explore our Training Features
Click on a Feature for more information! (popups must be enabled)
Course Introduction
Course Introduction
Lesson 1 - Structuring Existing Data
Structuring Existing Data
Import Data
Procedure Reference: Import Data
Demo - Import Data
First Normal Form
Second Normal Form
Second Normal Form Example
Third Normal Form
Third Normal Form Example
Transitive Dependency
Analyze Tables
Demo - Analyze Tables
Many-to-Many Relationships
Create a Junction Table
Junction Table
How to Create a Junction Table
Improve Table Structure
Demo - Junction
Demo - Table Structure
Lesson 1 Review
Lesson 2 - Writing Advanced Queries
Writing Advanced Queries
Create Unmatched and Duplicates Queries
Create an Unmatched Query
Create a Duplicates Query
Demo - Duplicate Query
The Criteria Field
How to Group and Summarize Records
Demo - Summarize
Crosstab Query
How to Summarize Data with a Crosstab Query
Demo - Crosstab Pivot
Create a PivotTable and a PivotChart
How to Create a PivotTable and a PivotChart
Display a Graphical Summary on a Form
Lesson 2 Review
Lesson 3 - Simplifying Tasks with Macros
Simplifying Tasks with Macros
Create a Macro
The Macro Window
How to Create a Macro
Attach a Macro to a Command Button
Object Event Categories
How to Attach a Macro to a Command Button
Demo - Macro
The Where Condition
How to Restrict Records Using a Where Condition
Demo - Macro Expressions
Lesson 3 Review
Lesson 4 - Adding Interaction and Automation with Macros
Adding Interaction and Automation with Macros
Require Data Entry with a Macro
Common Event Properties
Validating Data with Macros
Plan a Macro
Display a Message Box with a Macro
Demo - Data Entry
Automate Data Entry
Events and Actions for Automating Data Entry
Demo - Conditions
Lesson 4 Review
Lesson 5 - Making Forms More Effective
Making Forms More Effective
Conditionally
How to Change the Display of Data Conditionally
How to Display a Calendar on a Form
Form Properties
BorderStyle Settings
Organize Information with Tab Pages
How to Organize Information with Tab Pages
Demo - Conditional Calendar
Lesson 5 Review
Lesson 6 - Making Reports More Effective
Making Reports More Effective
How to Cancel Printing of a Blank Report
Report Events
How to Include a Chart in a Report
Demo - Blank report
How to Arrange Data in Columns
Report Snapshot
How to Create a Report Snapshot
Lesson 6 Review
Lesson 7 - Maintaining an Access Database
Maintaining an Access Database
Link Tables to External Data Sources
Demo - Link Tables
How to Back Up a Database
How to Compact and Repair a Database
How to Protect a Database with a Password
Object Dependency Task Pane
Database Documenter
Performance Analyzer
Demo - Database Utilities
Lesson 7 Review
Course Closure
