Book a course

Duration: 1-day

Location: inhouse, online or at our UK locations

What you will learn

This course looks at the advanced features within Microsoft Access by creating functional, powerful and highly customised database systems. After this course, you will be able to create a secured multi-user database system with a fully customised interface.

You will learn advanced numerical query calculations and date calculations, as well as how to present complex data in a precise and compact manner using calculated grouped reports.

Prerequisite

Attendees are required to be familiar with the Access Intermediate content before attending this course.

Course outline

Advanced Forms

  • Organising information into tab pages
  • Adding calendars to forms
  • Form control properties
  • Creating a pop-up dialogue form
  • Adding a sub form
  • Adding calculated fields to forms and sub forms
  • Creating and linking calculations with the expression builder
  • Working with expression (formulas) properties

Advanced Reports

  • Adding calculated fields to a report
  • Advanced use of calculated groups
  • Report field parameters
  • Advanced report properties

Advanced Queries

  • Running cross tab queries
  • Creating advanced numerical calculations
  • Creating advanced date calculations
  • Creating a union query using SQL view
  • Using the find duplicates wizard
  • Using the unmatched wizard

Sharing Data

  • Merging tables into Word
  • Exporting tables to Excel
  • Exporting data to other databases
  • Creating PDF documents
  • Creating a report snapshot
  • Importing Outlook contacts
  • Collecting data with email forms

Running Macros

  • Creating Command buttons for macros
  • Creating an embedded macro
  • Using the macro designer
  • Using conditions in macros
  • Validating data with an event driven macro
  • Adding a where condition to filter reports
  • Using macros to run queries
  • Creating an autoexec macro

Automating Access

  • Building a switchboard interface
  • Adding controls to a switchboard

Securing a Database

  • Overview of security
  • Securing a database with a password
  • Documenting database security
  • Securing a database using user-level security
  • Distributing a secured database

Access VBA (visual basic for applications)

  • Introducing object-oriented language
  • The visual basic editor
  • Converting macros to visual basic
  • Adding user-defined functions to a Lesson