Warning: Declaration of ET_Theme_Builder_Woocommerce_Product_Variable_Placeholder::get_available_variations() should be compatible with WC_Product_Variable::get_available_variations($return = 'array') in /home/customer/www/cheltenhamcourseware.com/public_html/wp-content/themes/Divi/includes/builder/frontend-builder/theme-builder/WoocommerceProductVariablePlaceholder.php on line 8
Access 2007 Intermediate courseware training materials for IT Trainers

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.