Introduction to Microsoft Access

Day or Evening Class

 

Overview

The Introduction to Microsoft Access class will teach students how to design databases, work with Access objects, work with queries, reports and forms. It is now easier than ever to turn your work into the answers you need quickly.

 

Prerequisite

Proficiency with Windows required. Students should of completed the Introduction to Excel or possess equivalent knowledge.

 

Outline

 

            1. Getting Started

    1. Understanding a relational database

    2. Menu commands

    3. Object Types

            2. Tables

    1. Designing and Maintaining Tables

    2. Fields and Records

            3. Finding and Filtering Data

    1. Sorting Records

    2. Filtering

            4. Printing Data

  • Query Wizard

  • Adding a Table to a Query

  • Running a Query

    •             6. Modifying Query Results

      1. Sorting

      2. Printing

                7. Operators in Queries

      1. Comparison Queries

      2. Between And Operator

                8. Designing Advanced Queries

      1. Setting Values

      2. Calculated Fields

      3. Concatenation Query

      4. Multiple Tables in a Query

                9. Basic Forms

      1. Using Forms and Form Wizard

      2. Printing Records in a Form

      3. AutoForm

                10. Basic Reports

      1. Report Wizard

      2. Printing Reports

      3. AutoReport