Microsoft Access 2019 (Basic to Intermediate)

In this 2-days hand-on course, you will learn how to migrate your existing data and manage them in Microsoft Access 2019. This course is also designed for new and inexperienced users to appreciate the concept of database design through the process of normalization.

An essential approach which is a step that is often not taught to help you to build an effective and suitable database.

Some Key Pointers to Consider:

• How to determine what fields are needed for the database/system?
• How to determine how many tables are need?
• How to determine which field goes into which table?

Failing to consider all these, your database would be inefficient and may not work properly. It would greatly hinder future enhancements to your database or even make it impossible for enhancements.

This course is designed with a workshop and many hands-on exercises to allow you to practice key lessons taught to help you create a proper working database.

Course Outline:

• Introduction to Database
• Working Through Normalisation Concept
• Working Through Table Design
• Understanding Field Properties
• Understanding Relationships
• Working with Datasheet View
• Importing/Exporting Data
• Working with Prefix
• Form Wizard
• Report Wizard