Microsoft Access

 LENGTH OF COURSE:
3 Days

DESCRIPTION: This course provides students with the foundation needed to design and develop relational database applications using Microsoft Access. The students will learn to create relational databases manually, as well as using the form, table, report, and query wizards. They will also learn to import data from other sources.

PREREQUISITES: Some knowledge of Windows or Macintosh is necessary and a basic understanding of relational databases is helpful.

INSTRUCTION TECHNIQUES: Lecture and Hands-On Labs (when/where available).

AUDIENCE

This course is designed for students that need to organize, find, and present information using the interactive relational database management system, Microsoft Access.
KEY HIGHLIGHTS:
  • Introduction to Access
  • Overview of Database Design
    • Tables, Records, and File
    • Indexes and Keys
    • Table Wizards
  • Database Queries
    • Query by Example (QBE)
    • Query by Form (QBF)
    • Query Wizards and Conditions
  • Interface Controls
    • Form Design and Usage
    • Report Design and Printing
    • Menus, Toolbars, and Macros
  • Multi-User Applications
  • Client-Server Applications
  • Object Linking and Embedding (OLE)
    • Linking vs. Embedding
    • Sharing Data with other Windows Applications
  • Error Handling and Debugging
  • The Jet Database Engine


  • More Wizards
    • Import
    • Table Analyzer
    • Report
    • Answer
    • MS Word Mail Merge
    • Query
    • Security
    • Performance Wizard


FROM OUR STUDENT EVALUATIONS...
"One of the best-taught computer courses I have ever taken."

Michael Begley

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.