Expand your knowledge of Microsoft Access and learn about relational database design, write advanced queries, structure existing data, validate data entered into a database, and customise reports.
Expand your knowledge of Microsoft Access and learn about relational database design, write advanced queries, structure existing data, validate data entered into a database, and customise reports.
After completing this course, students will be able to:
Design a relational database in Microsoft Access
Join tables to retrieve data from unrelated tables
Validate data entered into a database
Use advanced queries to manipulate your data
Organise a database for efficiency and performance, and to maintain data integrity
Customise reports to organise the displayed information and produce specific print layouts
As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level. We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ.
This course is suitable for users wishing to build on their basic Microsoft Access knowledge and work with more complex databases, queries, and reports.
To maximise your success in this course, you should have already completed Microsoft Access - The Essentials 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.