Mastering MS Access 2016 - Basics - Online Training Course - CPDUK Certified
The Mandatory Training Group
Delivery Method: eLearning
Mastering MS Access 2016 - Basics – Online Training Course - CPDUK Accredited
Welcome to The Mandatory Training Group's online Mastering MS Access 2016 basic training course. All our online training courses, programmes and qualifications are accredited by the CPD Certification Service (CPDUK).
Mastering MS Access 2016 - Basics
Teacher: Kathy Jones
Learner: Elizabeth Barrier
This online Mastering MS Access 2016 basic training course will teach everything you need to know about Microsoft Access. Kathy Jones will walk you through building your first Microsoft Access database, including creating tables, using queries, and implementing forms and reports in this course.
Course content
This online Mastering MS Access 2016 basic training course includes the following:
Unit 1: Introduction
Unit 2: Database objects
Unit 3: Creating a simple access database
Unit 4: Getting help and configuring options
Unit 5: Modifying table date
Unit 6: Sorting and filtering records
Unit 7: Creating basic access forms
Unit 8: Filtering data in a query
Unit 9: Sorting data in a query
Unit 10: Performing calculations in a query
Unit 11: Creating basic access forms
Unit 12: Working with data on access forms
Unit 13: Lookup fields on a form
Unit 14: Creating a report
Unit 15: Adding controls to a report
Unit 16: Adding logos and colours
Unit 17: Preparing a report for print
Unit 18: Organising report information
Unit 19: Formatting reports.
Who is the course for?
This online Mastering MS Access 2016 basic training course is suitable for anyone who wants to learn data management and Microsoft Access, including creating tables, using queries and implementing forms and reports.
Course aims
The aims of this Mastering MS Access 2016 basic e-learning course are to:
Provide you with the skills to create an effective database for any information at home or work.
Teach you how to organise and assemble an effective database for any kind of information you need to store, document, and manage.
Learning objectives
On completion of this online Mastering MS Access 2016 basic eLearning course, the learner will be able to:
Navigate within Microsoft Access
Create an Access database
Use Access help and set configuration options
Efficiently locate and change data
Sort and filter records in a table
Create a query
Sort and filter data through a query
Perform calculations through a query
Create a form
Effectively work with data in a form
Create a report
Add a control to a report
Apply themes, fonts, and layout options to a report
Prepare a report to be printed
Organise report information
Format a report
Quickly Search For And F.
Learning outcomes
Once you have completed this online Mastering MS Access 2016 basic training course, the learner will be able to: