Course not currently available

Microsoft Access Advanced

Training U IT Ltd

Short course

In Redbourn ()

Price on request

The best Access courses

See all

See all

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

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

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

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

See related categories

Microsoft Access Advanced

Price on request

The best Access courses

See all

See all