Mastering Microsoft Access 2013 - Online Training Course - CPDUK Certified
The Mandatory Training Group
Delivery Method: eLearning
Mastering Microsoft Access 2013 - Online Training Course - CPDUK Certified.
Welcome to The Mandatory Training Group's online Mastering Microsoft Access 2013 training course. All our online training courses, programmes and qualifications are accredited by the CPD Certification Service (CPDUK).
Mastering Microsoft Access 2013
Teacher- Peggy Ward
Learner- Christina Tankersley
This online Mastering Microsoft Access 2013 training course, with the help of Peggy Ward, will help you gain invaluable skills to develop powerful apps customised for your business needs.
Course content
This online Mastering Microsoft Access 2013 training course includes the following:
Unit 1: Getting started
Unit 2: Database objects
Unit 3: Creating a database
Unit 4: Creating tables
Unit 5: Importing external data
Unit 6: Creating linked tables
Unit 7: Creating tables from templates
Unit 8: Working with records in a table
Unit 9: Tables and forms
Unit 10: Planning tables and forms
Unit 11: Creating a table in design view
Unit 12: Managing table relationships - Part 1
Unit 13: Managing table relationships - Part 2
Unit 14: Controlling data entry - Part 1
Unit 15: Controlling data entry - Part 2
Unit 16: Controlling data entry - Part 3
Unit 17: Working with tables
Unit 18: Importing data from other sources
Unit 19: Import and link data from other sources
Unit 20: Import and link data from excel
Unit 21: Creating a select query
Unit 22: Working with criteria
Unit 23: Doing more with queries
Unit 24: Group and summarise data in a query
Unit 25: Creating flexible queries
Unit 26: Creating action queries - Part 1
Unit 27: Creating action queries - Part 2
Unit 28: Creating and modifying forms
Unit 29: Modify forms in design view - Part 1
Unit 30: Modify forms in design view - Part 2
Unit 31: Add controls to forms
Unit 32: Tab pages and form control properties
Unit 33: Create and modify reports wizard
Unit 34: Modify reports in design view
Unit 35: Formatting reports
Unit 36: Adding calculations to a report
Unit 37: Putting finishing touches on a report
Unit 38: Modify startup options
Unit 39: Maintaining a database - Part 1
Unit 40: Maintaining a database - Part 2
Unit 41: Merging databases
Unit 42: Exporting to external locations
Unit 43: Saving databases
Unit 44: Creating a web app from a template
Unit 45: Creating a custom web app.
Who is the course for?
This online Mastering Microsoft Access 2013 training course is suitable for anyone who wants to enhance one’s knowledge to develop powerful apps customised for their business needs.
Course aims
The aims of this Mastering Microsoft Access 2013 e-learning course aims to :
Help learners realise that they can create database apps to suit their business needs
Assist the learner to know how to create a Microsoft Access desktop/web app.
Learning objectives
On completion of this Mastering Microsoft Access 2013 eLearning course, the learner will be able to:
Demonstrate navigating around the Access Interface
Explain the relationship between tables, records, and forms in Access
Describe how Access can be used to create web-based applications.
Learning outcomes
Once you have completed this online Mastering Microsoft Access 2013 training course, the learner will be able to:
Discuss the advantages of knowing how to create one’s own Custom Database Apps
Outline how to build and modify queries
Create a web app for use in one’s business environment.