Microsoft Access : Intermediate

Am:Pm Services

Price on request
Compare this course with other similar courses
See all

Important information

  • Training
  • Intermediate
  • Brighton
  • Duration:
    1 Day
Description

To give a deeper understanding of the concepts behind and methods of using and designing Access Tables, Forms, Queries and Macros

Important information
Venues

Where and when

Starts Location
On request
Brighton
Tower Point, 44 North Rd., BN1 1YR, East Sussex, England

Course programme

Microsoft Access : Intermediate

Course duration:

1 Day

Course Objectives

To give a deeper understanding of the concepts behind and methods of using and designing Access Tables, Forms, Queries and Macros. The course will cover the following features:

Further Queries

  • Using Totals queries for Summarising data
  • Using Crosstab queries for Cross tabulating and Summarising data
  • Using Action queries
  • Make table queries
  • Update queries
  • Append queries
  • Delete queries

Further Macros Design

  • Collection macros into groups
  • Naming macros
  • Referring to a macro in a group
  • Using the expression builder
  • Controlling the properties of objects trough macros

Further Forms Design

  • Main/Sub forms
  • Linking main forms to sub forms
  • Creating forms which contain charts
  • Using the Pivot Table Wizard
  • More advanced controls
  • List boxes and combo boxes to lookup data in other tables/queries
  • Option groups
  • Calendar controls
  • Tab Controls

Further Report DesignMain/Sub reports

  • Linking main reports to sub reports
  • Working with calculated controls and summary groups
  • Referring to control values in a report
  • Using conditional statements in a report
  • Creating reports which contain charts


Compare this course with other similar courses
See all