End User Applications Category Banner Image

Microsoft Access - Creating Complex Databases (ACSL3)

  • Length 1 day
Course overview
View dates &
book now
Course locations >>

Why study this course

Experienced Microsoft Access users will learn about creating and managing complex databases in this course.

You'll learn how to improve data entry using forms, structure data using tables and dependencies, write advanced queries, use macros and VBA, secure and share a database, and perform database maintenance.

Request Course Information


What you’ll learn

After completing this course, students will be able to:

  • Customise a form layout in Microsoft Access to improve usability and efficiency of data entry

  • Share Access data across applications

  • Use macros to improve user interface design

  • Use VBA to enhance tasks

  • Organise data into appropriate tables to ensure data dependency and minimise redundancy

  • Lock down and prepare a database for distribution to multiple users

  • Create and modify a database switchboard and set the startup options


Microsoft Solutions Partner - Cloud - Training Services Logo

Microsoft Apps at Lumify Work

Lumify Work has been delivering effective training across all Microsoft products for over 30 years. We are proud to be both Australia's and New Zealand’s first Microsoft Gold Learning Solutions Partner and the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers (MCTs) in ANZ. Join more than 5,000 students who attend our quality Microsoft courses every year.


Who is the course for?

This course is suited to database administrators or prospective database administrators who have experience working with Microsoft Access and need to learn advanced skills.


Course subjects

Implementing Advanced Form Design

  • Add Controls to Forms

  • Enhance Navigation and Organisation of Forms

  • Apply Conditional Formatting

Sharing Data Across Applications

  • Import Data into Access

  • Export Access Data

  • Link Tables to External Data Sources

  • Create a Mail Merge

Using Macros to Improve User Interface Design

  • Create a Macro

  • Restrict Records Using a Condition

  • Validate Data Using a Macro

  • Automate Data Entry Using a Macro

Using VBA

  • Getting Started with VBA

  • Enhance Access Using VBA

Using Advanced Database Management

  • Manage a Database

  • Determine Object Dependency

  • Document a Database

Distributing and Securing a Database

  • Splitting a Database for Multiple User Access

  • Implement Security

  • Convert an Access Database to an ACCDE File

  • Package a Database with a Digital Signature

Managing Switchboards

  • Create a Database Switchboard

  • Modify a Database Switchboard

  • Set Startup Options


Prerequisites

To maximise your success in this course, you should have already completed Microsoft Access - Creating Relational Databases or possess equivalent knowledge and skills.


Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.


Request Course Information

Awaiting course schedule

If you would like to receive a notification when this course becomes available, enter your details below.

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.



Loading