Microsoft Access Advanced - In-company / Bespoke

Microsoft Office Training Limited

Course

Inhouse

£ 400 VAT inc.

The best Office Systems courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Inhouse

  • Duration

    2 Days

  • Start date

    Different dates available

At the end of this course you will be able to:
Do advance Table design
Do advance Query design and Action Querys
Do advance Form design with the use of macros and buttons
Export and import data to and from different sources.

Facilities

Location

Start date

Inhouse

Start date

Different dates availableEnrolment now open

About this course

The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros.

Questions & Answers

Add your question

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

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Microsoft Access
  • Database training
  • Access
  • Database
  • Design
  • Export
  • Import
  • Macros
  • Navigations
  • Import Data
  • Database Documenter
  • Regular Management

Course programme

Advanced Table Design

  • Advanced Field Properties
  • Table Properties

Advanced Query Design

  • Advanced Naming Conventions
  • Join Tables in Queries
  • Manage Query Joins
  • Use Self-Joins in Queries
  • Summarise Data in Queries
  • Parameter Queries
  • Action Queries
  • Crosstab Queries

Advanced Form Design

  • Create Subforms and Linked Forms
  • Form Controls
  • Command Buttons
  • Form Properties
  • Interface, Start-Up and Navigations Forms

Working with Macros

  • Create Single Macros
  • Run Macros
  • Work with Sub Macros
  • Use Conditional Macros
  • Run Macros from Buttons
  • Assign Macros to Events

Extending Data Reach

  • Import Data
  • Export Data
  • Work with Linked Tables

Managing Databases

  • Object Dependencies
  • Database Documenter
  • Performance Analyzers
  • Regular Management of a Database
  • Access Database Security

Additional information

£400 per day for one-to-one training £550 per day for groups of up to 8 people Course tailoring at no extra cost. Discounts for Nonprofits/Charities and Governmental Organizations

See related categories

Microsoft Access Advanced - In-company / Bespoke

£ 400 VAT inc.

The best Office Systems courses

See all

See all