SYSTEMETRICS

HANDS-ON, PERSONAL COMPUTER SEMINAR

 Upgrading to Microsoft Access 2007

Duration: 1 day (6 hours)

Prerequisite(s): Familiarity with earlier versions of Microsoft Access and with other Office 2007 applications.

Environment: Microsoft Windows

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

Who Should Take This Seminar: Upgrading to Microsoft Access 2007 is designed to show students the differences between Microsoft Access 2007 and the earlier versions of Microsoft Access. Students should already be familiar with the ribbons and other aspects of the Fluent User Interface used in all Office 2007 applications. Those not familiar with the ribbons should attend Systemetrics’ Upgrading to Microsoft Office 2007 seminar before attending this seminar. Those uncertain whether this seminar is appropriate for them should call Systemetrics at (401) 275 2200, extension 121.

Seminar Outline
  1. General Changes to Access
    1. Access 2007 screens, ribbons and toolbars
    2. Managing security
    3. Working in the Navigation Pane
    4. Accessing object windows with tabs
    5. Using the Date Picker
    6. Saving data to PDF files

  2. Changes to Datasheets
    1. Alternating background colors for rows
    2. Including datasheet totals
    3. Finding and filtering data

  3. Changes to Tables
    1. Creating and modifying tables
    2. Understanding the Attachment data type
    3. Propagating field properties
    4. Using Multivalue fields
    5. Formatting and maintaining history in memo fields
    6. Working with external data

  4. Changes to Queries
    1. Creating and modifying queries
    2. Understanding Union, Pass-Through and Data Definition Queries

  5. Changes to Forms and Reports
    1. Creating and modifying forms and reports
    2. Understanding Layout View
    3. Using the enhanced Field List Pane
    4. Using Embedded Macros
    5. Using the Split Form default view
    6. Understanding Report View
    7. Finding, filtering, copying and drilling report data
    8. Adding summary fields to a report
    9. Hiding detail records on a report
    10. Grouping and sorting on a report
    11. Including command buttons on reports

  6. Changes to Macros
    1. Using the Arguments column
    2. Understanding Trusted Actions and Untrusted Actions
    3. Using Macro Variables
    4. Using error handling

  7. New Features
    1. Collecting data via e-mail