Microsoft Access Level 3

Course Code: AC16L3   Duration: 1 Day   Price: £345+VAT
Overview

During this course you create complex Access databases by structuring existing data, writing advanced queries, working with macros and performing database maintenance.

Audience

The course is designed for those people whose job responsibilities include working with heavily related tables, creating advanced queries, forms and reports, writing macros to automate common tasks and performing general database maintenance.

Learning Objectives

On completion of this course, you will be able to:

  • Obtain skills in advanced query, form and report design, and manage their databases.
  • Provide some levels of automation with the use of Macros. Create more complex queries looking at different query types.
  • Pull data in from other sources to use in your database.
Pre-Requisites

To ensure your success, knowledge of basic and intermediate features of Access tables, relationships, and queries, forms, and reports is recommended. The following or equivalent knowledge is recommended:

  • Microsoft Access Level 1
  • Microsoft Access Level 2
Course Contents
  • Trusted locations and default locations
  • Queries
  • Forms
  • Reports
  • Macros
  • Linking Data
  • Importing Data