Course Description
What is the Microsoft Office Access 2019 course?
Microsoft Access is a widely embraced software application developed by Microsoft for creating and overseeing databases. Databases serve as vital tools for organising and overseeing customer details and survey findings. Their utility extends to various scenarios requiring the storage and analysis of substantial data sets with dependability and efficiency.
Modules Covered
What are the Microsoft Office Access 2019 online course modules?
- Microsoft Access 2019: Introduction
- Microsoft Access 2019: Intermediate
- Microsoft Access 2019: Advanced
What does the Microsoft Office Access 2019 course cover?
- Understanding the fundamentals of utilising the Access application
- Essential database terminology
- Diverse methods for creating tables and practising configuring their fields' properties
- Further analysing table data through select queries, including incorporating calculated fields
- Grasping the establishment of table relationships and ensuring their referential integrity
- Developing simple forms and reports
- Incorporating calculated fields into queries utilising functions
- Practising the creation of aggregate and parameter queries
- Understanding table join properties and exploring their impact on query outcomes
- Designing forms in the Design view and integrating calculated fields
- Editing reports and mastering various calculations within them
- Learning to insert controls into forms and reports, including subforms and subreports
- Executing action queries
- Exploring different query types in SQL view and becoming familiar with the essential language clauses
- Creating and utilising macros to automate database tasks
- Importing and exporting objects and their data
- Exploring detailed printing options for various objects
- Understanding the principles of data normalisation
- Navigational options within a database
Accreditation
Fully Accredited
This course is nationally accredited by Microsoft - Training and Certification Courses
To many of us, Microsoft is a company that requires no introduction! Microsoft has been in our lives for over four decades and during that time, Microsoft has consistently worked towards transforming the way we live, work, and connect using technology. Microsoft certifications are globally recognised qualifications, validating an individual’s competency and ability in technical knowledge of Microsoft technologies.
Benefits
- Assessment Included
- Course Access: 12 months
- Study anytime, anywhere24/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?
This Microsoft Office Access 2019 course is ideal for you if you want to quickly understand Microsoft Access 2019 and help towards a potential job, promotion, running your own business, or for personal use.
