Aims

This course is designed to extend your knowledge into some of the more specialised and advanced capabilities of Access. Effective database management calls for mastering the advanced administrative and collaborative features of Access. This course, you will exchange data with other applications and secure and share databases.

Objectives

On completion of this course, attendees will be able to create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports, and also by performing database maintenance. You will exchange data with other applications and share databases on a network.

Prerequisites

Attendees need to have attended our ‘Creating Databases with Access’ course or have equivalent knowledge.

Versions

Courses are delivered in 2010, 2013, 2016, 2019 & O365.

What will I learn?

Structuring Existing Data

  • Analyse tables
  • Create a junction table for many to many relationships
  • Improve the table structure

Action Queries

  • Make table queries
  • Delete queries
  • Append queries
  • Update queries

Creating Advanced Queries

  • Create Parameter queries
  • Inner and outer joins
  • Group and summarise records using criteria
  • Create Unmatched and Duplicate Queries
  • Calculated queries
  • Summarize data using a Crosstab query

Improving Forms

  • Working with properties
  • Using unbound and bound controls
  • Restrict Data Entry in Forms
  • Organize Information with Tab Pages
  • Add a Command Button to a Form
  • Create a Subform
  • Display a Summary of Data in a Form
  • Change the Display of Data Conditionally

Customising Reports

  • Organize Report Information
  • Format Reports
  • Control Report Pagination
  • Summarize Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report
  • Include a Chart in a Report
  • Publish Reports as PDF

Introduction to Macros

  • Create a Macro
  • Attach a Macro
  • Restrict Reports Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro

Maintaining an Access Database

  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyse the Performance of a Database

Integrating Access into your Business

  • Import XML Data into an Access Database
  • Export Access Data to the XML Format
  • Integrating Access with Email – broad concepts

Managing Switchboards

  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set the Startup Options

Distributing and Securing Databases

  • Split a Database
  • Locating Front and Back End components
  • Maintaining a Split Database
  • Implement Security

How we deliver

Training can be delivered at your offices in either of the following ways:

  • Online

    Online training is ideal if you have staff in different geographical locations who have the same Microsoft or Adobe training requirements.

    Our expert trainers can deliver Watch and Learn sessions to up to 100 people. Alternatively, they can produce an interactive session that allows delegates to complete practical exercises within the Microsoft or Adobe apps of your choosing.

  • Face to face

    Choose from one or half day training sessions or our popular 90-minute Sprint sessions, which can be delivered in your offices or at another location of your choice.

    All we need is a room with a table and chairs and we look after the rest. We can even provide laptops and a projector should you not have spare IT equipment to use.

Sprint learning

Short on time, but still want to boost staff performance?
Book a Sprint Session!

Each Sprint Session follows a 90-minute format for ultra-focused team learning.

Pick a topic, tell us what you want to achieve from your session, and we’ll put together a short, fun, entirely bespoke programme that meets the needs of your team.

Designed to cater for 10-15 delegates at a time

Developed by our team to cover the subject matter of your choice

Delivered online or face-to-face

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)