Realdolmen Education

Details

Access Module 4 - Automating Databases without Programming

This course is currently not scheduled on the open calendar, but can be organized on request.

Request Course

Duration

1 day(s)

MS Access: Module 4 – Automating databases without programming

Duration

1 day

Audience

The course is intended for all users who want to automate tasks in an existing database without having to write VBA code.

Prerequisites

Having followed the course " MS Access: Creating and using databases" or having the experience of using MS Access. Being able to create tables, relationships, queries, forms and reports. A good knowledge of working in a Windows environment and file management is necessary.

Objectives

Explore wizards, properties, conditional formatting and macros to automate tasks in an Access database.

Methods

Instructor-led classroom training, where to automate tasks in an existing database is the common thread throughout the course. Thanks to specific problems, the theory will be directly linked to practice.

Description

The students start by consulting an existing database with tables, relationships, queries forms and reports. First, wizards are used in various database objects. The properties of forms, reports and controls are also discussed in detail. Using Conditional Formatting, we apply automatic formatting in forms and reports. The database is further automated through the different types of macros and different types of macro actions.

Contents

  • Introduction
    • Tools to automate tasks
    • Preparation (analysis of tasks to be automated)
  • Use available Wizards
  • Properties of forms, reports and controls
  • Apply conditional formatting to forms and reports
  • Macros
    • Create independent macros
    • Create embedded macros
    • Add and manage macro actions
    • Run independent and embedded macros
      • Debug a macro
    • Program flow in macros
      • Add comment
      • Conditions in macros
      • Submacros
      • Group macro actions
      • Add error handling to a macro
  • Data macros
    • Introduction
    • Create an event-driven data macro
    • Create a named data macro