<<= Back Intermediate Databases - Basic Classes Next =>>

In this lesson you will learn:

Reports and Forms
Enhanced Forms with OLE
Switchboards, Pivot Tables and Pivot Charts

Use the Shelley Cashman Book for Microsoft Access, Comprehensive Concepts and Techniques to complete this section. It is in the Black file cabinet in the front of the room.

NOTE: Textbooks for older versions work fine for these lessons.

Creating Reports and Forms

Complete Project 4, which includes;

Create a Report Using Design View
Sorting and Grouping
Changing Properties
Changing Labels
Multiple Tables - Removing Unwanted Controls
Custom Forms
Modifying Designs
Calculated Fields

When completed return to this page and continue.

Enhancing Forms with OLE, Hyperlinks and Sub Forms

Complete Project 5, which includes;

Input Masks - the Wizard
Date and Memo Fields
OLE Fields
Updating Fields
Advanced Form Techniques
Date and Memo Fields in Queries

When completed return to this page and continue.

Switchboards, Pivot Tables and Pivot Charts

Complete Project 6, which includes;

Creating and Using Macros
Modifying a Macro
Creating a Switchboard
Additional Tables - Importing Data
Pivot Tables and Pivot Charts
Changing Properties
Assigning Axis Titles

Congratulations! You have completed the Intermediate Databases course.

Turn in your assignments to the Computer Lab instructor for your certificate.

NOTE: These are posted for student and staff educational & class use.