Access 2007 Intermediate Courseware Materials

Microsoft Access 2007 Intermediate Training Materials for IT Trainers

Intermediate Level Computer Training Course Teaching Materials

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

ACCESS 2007 – TABLE DESIGN

  • 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.

ACCESS 2007 – IMPORTING, EXPORTING AND LINKING DATA

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

 

Rate this post