Access 2007 Intermediate Courseware

Microsoft Access 2007 Intermediate Training Materials

Intermediate Level Training Course

Training Course Outline

WHAT’S NEW in ACCESS 2007

  •     New features in Access 2007
  •     Database Templates
  •     Local templates
  •     Downloading templates
  •     Enhanced Datasheet View
  •     New Layout View
  •     Improved Interface

TABLE DESIGN IN ACCESS 2007

  •     Modifying Fields
  •     Lookup Fields
  •     Validation Rules
  •     Input Masks
  •     Default Values
  •     Mandatory Fields

ACCESS 2007 & RELATIONSHIPS

  •     Basics of Relationships
  •     What are relationships?
  •     Understanding the basis for creating relationships
  •     Types of joins in a relationship
  •     Creating and modifying one-to-one, or one-to-many relationships
  •     Applying inner, outer, and self joins
  •     Applying and using referential integrity
  •     Applying automatic deletion of related records

ACCESS 2007 QUERY TYPES

  •     Creating and using a query to update data in a table
  •     Creating and using a query to delete data in a table
  •     Creating and using a query to save the selected information as a table
  •     Appending records to a table using query

ACCESS 2007 QUERY FORMULAS

  •     Grouping information in a query
  •     Using functions in a query
  •     Using Aggregate Functions
  •     COUNT function
  •     SUM function
  •     AVG function
  •     MIN function
  •     MAX function
  •     Using a crosstab query

ACCESS 2007 FORMS

  •     What are bound and unbound controls?
  •     Creating bound and unbound controls.
  •     Creating and editing a combo box, list box, check box and option groups.
  •     Creating arithmetic and logical expression controls on a form.
  •     Setting sequential order of controls on a form.
  •     Inserting data fields to appear within form header or footers
  •     What are sub forms?
  •     Creating a sub form and linking to parent.
  •     Modifying the sub form to change records.

ACCESS 2007 REPORTS

  •     Creating arithmetic and logical calculation controls within a report.
  •     Calculating percentage calculation control within a report.
  •     Using formulas and expressions within a report.
  •     Creating running summaries within a report.
  •     Inserting a data field to appear within report header or footers
  •     Forcing page breaks for groups on reports.

ACCESS 2007 MACROS

  •     Recording & assigning macros
  •     Running macros.
  •     Assigning macros to a form, report or control.

IMPORTING, EXPORTING AND LINKING DATA WITH ACCESS 2007

  •     Importing files into a database.
  •     Exporting data as different formats.
  •     Linking external data to a database.