SYSTEMETRICS

HANDS-ON, PERSONAL COMPUTER SEMINAR

 Introduction to Microsoft Access 2007

Duration: 1 day (6 hours)

Prerequisite(s): Familiarity with the Windows environment and at least one other Microsoft Office 2007 application.

Environment: Microsoft Windows.

Version(s): Access 2007. Not applicable to earlier versions of Access.

Support: Upon completion of this seminar, the student will be entitled to unlimited, free telephone support in Access.

Who Should Take This Seminar: Introduction to Microsoft Access 2007 is designed to introduce the student to Microsoft Access, the popular database product. Upon completion of this seminar the student will be able to design and use database tables, forms, queries, and reports. The student should be familiar with Windows basics and at least one other Microsoft Office 2007 application before taking this seminar. This seminar is not appropriate for students using earlier versions of Microsoft Access. Those uncertain whether this seminar is appropriate for them should call Systemetrics at (401) 275-2200, ext. 121.

Seminar Outline

  1. Understanding Database and Access Basics
    2.
    1. Understanding database terminology
    2. Understanding Access screens
    3. Understanding Access objects
    4. Using the Navigation Pane

  2. Working With an Existing Database
    3.
    1. Working with datasheets and forms
      1. Navigating among fields and records
      2. Adding, editing, deleting and sorting records
      3. Finding and filtering records
    2. Printing database objects

  3. Creating a New Database and Database Objects
    4.
    1. Creating and using tables
      1. Establishing fields
      2. Defining field properties
      3. Defining a primary key field
    2. Creating and using forms
      1. Establishing and changing form layout
      2. Creating controls of different types
      3. Defining control properties
    3. Creating and using Select Queries
      1. Defining query design
      2. Viewing query results
      3. Establishing query criteria, including wildcards
      4. Referencing multiple tables in a query
      5. Creating calculated fields
    4. Creating and using reports
      1. Establishing and changing report layout
      2. Grouping and summarizing data
      3. Printing a report
      4. Creating mailing labels

SYSTEMETRICS, INC.
95 Sockanosset Crossroad
Cranston, RI 02920

Telephone: (401) 275-2200
Home Page: www.systemetricsinc.com
Email: training@systemetricsinc.com

All rights reserved.