Mastering MS Access 2016 - Basics - Online Training Course - CPDUK Certified

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:

• Sort information and run queries
• Create tables and relationships
• Navigate the Access 2016 interface
• Design forms and generate reports
• Supercharge your database projects
• Create and print reports
• Compact, repair and backup your database
• Create a linked table.

Download Full Course Description (PDF)

Mastering MS Access 2016 - Basics - Online Training Course - CPDUK Accredited.