Workforce Training Consortium

Course Title: Microsoft Access (202.000)

Course Length:     8 hrs

Prerequisites:         Knowledge of Windows

Objective:

After completing this course, the participants will be able to design a database form and table, enter and retrieve information, design queries and build reports.

Day 1

        Creating a Database Form

                    Database Basics

                    Creating Database Datasheets and Forms

                    Entering Data

                    Enhancing Datasheets and Forms

        Editing and Printing a Database

                    Modifying Datasheets and Forms

                    Editing Data

                    Printing Datasheets and Forms

        Searching and Sorting a Database

                    Searching Datasheets and Forms

                    Sorting Data

                    Creating Subsets from Datasheets and Forms

        Queries

                    Query Basics

                    Enhancing and Printing a query

                    Creating a Query Using Data from Multiple Tables

        Reports

                    Changing and Enhancing a Report

                    Using a Wizard to Create a Report

                    Changing Item Properties

                    Adding New Fields to a Report

Equipment needed:

MS Office software, Lap Top Computers, Learning Microsoft Office Professional.