Course Description
Microsoft Access, a favoured database management system for small to medium databases, seamlessly integrates with Microsoft Excel.
Whether you're aiming to handle extensive data or to track personal performance through recording and reporting, this MS Access training course will equip you with essential skills for leveraging the 2021 software.
If you're new to Microsoft Access or have some experience already, there's valuable learning for everyone in this comprehensive training course.
Modules Covered
Course 1: MS Access 2021: Introduction
This beginner-level Microsoft Access course introduces you to the fundamentals of the MS Access software. It consists of 21 online lessons, amounting to approximately 7-11 hours of study time.
Learning objectives include:
- Introduction
- Tables
- Data types and input
- Referential integrity
- Searching and editing records
- Sorting and filtering data
- Queries
- Lookup columns
- Automatic creation of forms
- Report creation
Course 2: MS Access 2021: Intermediate
The Intermediate Microsoft Access course builds on foundational knowledge, covering calculated fields, advanced queries, and other sophisticated features of MS Access. This online course comprises 26 lessons, with an estimated study duration of 9-13 hours.
Learning objectives include:
- Copying and importing external data into tables
- Use of queries in Access
- Complex functions
- Advanced tables
- Totals
- Advanced sorting and filtering data
- Design View
- Creating and editing forms
- Creating subforms
- Restricting data editing
- Grouping and summarising data
- Advanced reports
Course 3: MS Access 2021: Advanced
In the Advanced Microsoft Access 2021 course, you'll master macros, automate workflows, and delve into sophisticated data management techniques. This course consists of 19 lessons, with an approximate study time of 6-10 hours.
Learning objectives include:
- Updating queries
- SQL language
- Queries in SQL
- Form creation
- Macro basics
- Macro functions
- Splitting a database
- Advanced data import and export
- Object dependencies and properties inheritance
- Navigation
- Data normalisation
- Printing
- Privacy and security
Accreditation
Fully Accredited
This course is nationally accredited by Microsoft - Training and Certification Courses
Microsoft is a globally renowned company that needs little introduction. With a presence spanning over four decades, Microsoft has continuously innovated to redefine how we live, work, and connect through technology. Microsoft certifications are internationally recognised credentials that attest to an individual’s proficiency and technical expertise in Microsoft technologies.
Benefits
Upon successful completion, achieve proficiency in the latest version of Microsoft Access.
- Enhance your career prospects and earning potential through personal development of Microsoft skills. Expand your knowledge with additional Microsoft Office courses such as Microsoft Excel, PowerPoint, and Word.
- Effortlessly manage small to medium databases.
- Effectively manipulate data and generate reports with MS Access software.
- Create versatile and adaptable database systems.
- Utilise a user-friendly system that allows for easy creation and management of databases using drag-and-drop functionality.
- Assessment Included
- Course Access: 12 months
- Study anytime, anywhere 24/7 access
- Join a community of over 615,000
Eligibility
Please note this is a paid qualification, therefore you will have to pay the course fee in order to start studying.
Is the Microsoft Office Access 2019 right for me?
If you need a tool to manage your business database, support your professional role, or handle small to medium datasets effectively, MS Access 2021 is an excellent solution.
