Microsoft Access 2016 Beginners Course

Microsoft Access 2016 Database Training in Cape Town - Beginner Level (Office 2016)

 

2KO offers Microsoft Access courses in Cape Town for two levels of difficulty. If you are not sure which level you ought to begin with, click here for the content of the MS Access 2016 Intermediate Course.

 

Beginner Level

 

SAQA Unit Standards
258875 - Design forms and reports using a Graphic User Interface (GUI) based database (Level 4) Credits 4 258881 - Design complex tables and queries using a graphical user interface (GUI) based database to solve a given problem (Level 4) Credits 5

Pre-requisites
Prior knowledge and skills to:
Mathematical Literacy at NQF Level 3.
Communication at NQF Level 3.
Knowledge of GUI based database application.

Level
Beginner Level

 

Duration
1 Day


Typical Course Content Covers

Introduction to Access
Create a Database
Create a Table
Create a Table in Design View
Create an Input Mask
Add Data to Table
Import Data from a CSV File
Create a Relationship
Create a Lookup Table
Create a Query
Create a Query with User Input
How to use the Expression Builder
Export Data to Excel (and XML)
Create a Form
Add a Combo Box to a Form
Create a Report
Create a Macro
Backup a Database
Split a Database
Make an Executable Database