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.

Tailored in company 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

Course Images

Microsoft Access Advanced (live online classes)

By Microsoft Office Training

Booking options

Highlights

Description

About The Provider

Tags

Reviews