Microsoft Access - Creating Complex Databases (ACSL3)
Length 1 day
Price
NZD 495 exc GST
Course overview
View dates &
book now
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 Apps at Lumify Work
Lumify Work is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia's and New Zealand’s first and largest Microsoft Gold Learning Solutions Partner. 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.
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
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.