Course not currently available

Microsoft Access Advanced

Short course

In Redbourn ()

Price on request

Description

  • Type

    Short course

  • Duration

    1 Day

To provide attendees with an understanding of the data analysis. Suitable for: Individuals who wish to create queries, build forms reports and macros.

Important information

Documents

  • Access Advanced

About this course

Attendees need to have attended the Access Foundation course or have equivalent knowledge.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Microsoft Access Advanced Course Outline

Relationships and Specialist Queries

  • Relational database design
  • Creating many to many relationships
  • Creating a query from related tables
  • Inner and outer joins
  • Parameter queries
  • Summary queries
  • Calculated queries

Action Queries

  • Make table queries
  • Delete queries
  • Append queries
  • Update queries
  • Cross tab queries

Form and Report Design

  • Features of forms & reports
  • Working with sections
  • Moving, resizing and deleting controls
  • Working with controls
  • Working with properties
  • Using unbound and bound controls
  • Creating subforms & subreports
  • Using command buttons

Introduction to Macros

  • Introducing Macros
  • Creating Macros for command buttons
  • Creating Macros for forms
  • Creating a switchboard
  • Switchboard display options
  • Using hyperlinks

Microsoft Access Advanced

Price on request