Access Advanced course content

Access Advanced 2010

Microsoft Office Access 2010 AdvancedInstructor-led Microsoft Access Advanced course outline

Duration:

Intended audience:

1 day

Anyone who is comfortable and familiar with using Access at intermediate level and wants to expand their knowledge

Aims:

To enlarge on an Intermediate level of Microsoft Access knowledge by the use of worked examples

Objectives:

By the end of the session delegates will be able to:·

  • Create user forms with advanced functionality
  • Use different types of joins between entities
  • Run various types of query
  • Run reports on multiple tables
  • Add calculated fields
  • Add summary fields
  • Record simple macros and assign them

Prerequisites:

A good knowledge of Access at Intermediate Level

This Microsoft Access Advanced Tutorial is intended to build upon the knowledge gained in the Access Intermediate course by adding additional expertise. The delegate will complete exercises designed to include creating more complex joins, running reports on multiple tables, adding summary and calculated fields and recording macros. Building advanced user forms is also included in this course, and this will include sub-forms where necessary.

Review of Basic Skills

Database design objectives

Creating a relation model

Creating tables

Forms

Creating a linked form

Calculated fields in forms

Expression builder

List boxes and combo boxes

Option fields & groups

Buttons

Check boxes

Querying the Database

Using different table join-types

Action queries

Find duplicate

Find unmatched

Reports

Multiple table reports

Controlling Grouped reports

Calculated fields

Summary fields

Macros

Using command button wizard

Using a macro to open a form

Microsoft Access Advanced Courses

We have versions for Microsoft Office 2007, Microsoft Office 2010 and Microsoft Office 2013

If you don’t have time to take one of our instructor-led courses, you might enjoy our Access online e Learning Microsoft Access Tutorials instead

Looking for an Access 2010 Intermediate course?

Or an Access 2010 Introduction course?