• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Access Advanced - In-company / Bespoke

Microsoft Access Advanced - In-company / Bespoke

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • Delivered Online or In-Person

  • You travel to organiser or they travel to you

  • London

  • Two days

  • All levels

Description

Course Objectives

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.

1 year email support service

Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk

With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.

Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.

  • Our competitive rates start from £550.00 per day of training

Tailored training courses:

You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.

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

Who is this course for? Who is this course for?

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.

Career path Career path

Microsoft Office know-how can instantly increase your job prospects as well as your salary.

80 percent of job openings require spreadsheet and word-processing software skills

About The Provider

Microsoft Office Training Ltd has been delivering training solutions for several years offering a variety of courses that cover all the apps of the Microsoft Office ranging fr...

Read more about Microsoft Office Training

Tags

Reviews