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 - Planning a Database
Planning a Database
The Relational Database Design Process
Relational Database Design Process
Statement of Purpose
Existing Data
Group Fields into Tables
Group Fields into Tables - example
Data Normalization Guidelines
Data Normalization - examples
Blank Values
Data Denormalizaion
Designate Primary and Foreign Keys
Primary Key - example
Lesson 1 Review
Lesson 2 - Building the Structure of a Database
Building the Structure of a Database
Create a New Database
Create a Table Using a Wizard
Create Tables in Design Views
Demo - Create Database
Create Relationships Between Tables
Demo - Create Relationships Between Tables
Enforce Referential Integrity
How to Create Relationships Between Tables
Lesson 2 Review
Lesson 3 - Controlling Data Entry
Controlling Data Entry
Field Properties
Create an Input Mask
Demo - Validation
Create a Lookup Field
How to Create a Lookup Field
Lesson 3 Review
Lesson 4 - Finding and Joining Data
Finding and Joining Data
Find Data with Filters
Saving a Filter
How to Find Data with Filters
Using Criteria to Filter Records
Demo - Filters
Create Query Joins
Self Join
How to Create a Query Join
Query Types
Join Unrelated Tables
Lesson 4 Review
Lesson 5 - Creating Flexible Queries
Creating Flexible Queries
Set Select Query Properties
How to Set Select Query Properties
Create Parameter Queries
The Like Operator and Wildcards
Demo - Flexible
How to Create Parameter Queries
Demo - Parameter
Action Queries (1)
Action Queries (2)
Demo - Action
Action Queries (3)
How to Create Action Queries
Lesson 5 Review
Lesson 6 - Improving Your Forms
Improving Your Forms
Enhance the Appearance of a Form
Form Design View
The Form Design View Window
Formatting Palettes
How to Enhance the Appearance of a Form
Demo - Elements
Restrict Data Entry in Forms
Combo Box Control
List Box Control
Demo - Combo
Options Box Group
How to Restrict Data Entry in Forms
Command Button
How to Add Command Buttons
Subform
How to Create a Subform
Lesson 6 Review
Lesson 7 - Customizing Your Reports
Customizing Your Reports
Organize Report Information
Report Design Enhancements
Report Design View
How to Organize Report Information
Demo - Organize Report
Add a Report Grouping Section Manually
Display Properties
How to Set Report Control Properties
Export Data to a Text File
How to Merge Access Data with a Word Document
Lesson 7 Review
Lesson 8 - Expanding the Reach of Your Data
Expanding the Reach of Your Data
Publish Access Data as a Word Document
Demo - Publish Access Data as a Word Document
How to Analyze Access Data in Excel
How to Merge Access Data with a Word Document
How to Export Data to a Text File
Demo - Delimited
Lesson 8 Review
Course Closure
