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.
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
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.
This course is suited to database administrators or prospective database administrators who have experience working with Microsoft Access and need to learn advanced skills.
To maximise your success in this course, you should have already completed Microsoft Access - Creating Relational Databases or possess equivalent knowledge and skills.
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.
