Microsoft Access Intermediate

Versions Available: 2007, 2010 and 2013

Course Overview:

This course is designed for those users who wish to step their current knowledge of Access to take advantage of the more complex features. On completion delegates will understand relational databases and be able to work with related tables. They will learn how to generate much more complicated queries and create more advanced forms and reports before tackling PivotCharts and PivotTables.

Course Content:

Creating relational databases

  • Database normalising
  • Introducing relating tables
  • Adding referential integrity

Working with related tables

  • The lookup wizard
  • Changing lookup fields
  • Inputting data to related tables

Defining data entry rules

  • Using input masks
  • Setting a property
  • Setting a validation rule

Using advanced query features

  • How to join a table in queries
  • Creating a calculated field
  • Using an action query

Creating advanced queries

  • Summarise and group values
  • Create a crosstab query
  • Using a parameter query

Creating advanced form design

  • Working with graphics
  • Working with calculations
  • Working with combo boxes
  • Working with unbound controls

Using advanced report features

  • Create customized headers and footers
  • Add a calculated value
  • Work with sub-reports

Duration: One Day

Availability: Course only available on Customer Premises

WS Training is affiliated and associated with the following organisations: