Course Overview

Module Introduction

How to Use this Course

Course Information

Creating a Strong Foundation for Your Database

Module Introduction

Relational Modeling in Access

Lesson Introduction

What Is a Relational Database?

Creating Tables and Using the Relationship Window

Self Test

Using Relationships and Referential Integrity

Lesson Introduction

Taking Control from the Start

Using Tools for Data in Tables

Guarding Against Bad Data

Using the Cascade Features

Self Test

Importing and Linking Data into Access

Lesson Introduction

Importing vs. Linking

Types of Files Commonly Imported/Linked

Best Practices for Creating Tables and Utilizing Outside Data

Self Test

Lab: Importing Excel Data and Text Files

Lesson Introduction

Scenario

Exercises

Lab Review

Module Summary

Creating an Effective User Interface

Module Introduction

Designing Effective and Easy-to-Use Forms

Lesson Introduction

Good Form Design

Selecting Form Types

Creating a Switchboard

Best Practices for Creating User Interfaces

Self Test

Lab A: Creating the Necessary Input Forms

Lesson Introduction

Scenario

Exercises

Lab Review

Lab B: Creating the Main Switchboard

Lesson Introduction

Scenario

Exercises

Lab Review

Module Summary

Organizing Data Through Queries

Module Introduction

Using Various Types of Queries

Lesson Introduction

Using the Query Command

Choosing the Right Type of Query for a Task

Self Test

Lab A: Creating Various Types of Queries

Lesson Introduction

Scenario

Exercises

Lab Review

Retrieving Only the Information You Want

Lesson Introduction

Adding Criteria to Queries

Differentiating Between Simple and Complex Criteria

Using Parameter Queries

Best Practices for Using Queries

Self Test

Lab B: Adding Criteria to Queries

Lesson Introduction

Scenario

Exercises

Lab Review

Lab C: Using Forms and Controls for Criteria

Lesson Introduction

Scenario

Exercises

Lab Review

Module Summary

Reporting Strategic Information with Access

Module Introduction

Using Reports in Access

Lesson Introduction

Displaying Strategic Information Using Reports

Touring the Report Design View

Self Test

Lab A: Generate the Base Report

Lesson Introduction

Scenario

Exercises

Lab Review

Lab B: Using Macros to Display or Hide Sections of a Report

Lesson Introduction

Scenario

Exercises

Lab Review

Module Summary

Integrating Access with Other Office Applications

Module Introduction

Integration with Other Office Applications

Lesson Introduction

Producing Integrated Information

Presenting Integrated Information

Best Practices When Using Integration

Self Test