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 three 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.

 

SAQA Unit Standards
116936 Use a Graphical User Interface (GUI)-based database application to work with simple databases (3 Credits) Level 3

Pre-requisites
Mathematical literacy and communication skills at least at NQF level 2.
Use generic functions in a Graphical User Interface (GUI)-environment (ID 117902 - NQF level 1).
Use a Graphical User Interface (GUI)-based word processor to format documents (ID 117924 - NQF level 2).
Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem (ID 116940 - NQF level 2).

 

Level
Beginner Level

 

Duration
1 Day

 

Database Concepts

What is a Database
Database planning and concepts
Database objects
Understanding relationships

 

Starting with Databases

Starting the Access programme
The Getting Started screen
Opening an existing database
Understanding the security warning
Access screen terminology
Opening database objects
Closing a database
Working with Help
Starting a new blank database

 

Working in a database table

Opening an existing table
Adding records to a datasheet
Editing & deleting records in a datasheet
Sorting, searching and filtering records in a datasheet
Printing records from a datasheet

 

Creating & designing tables

Creating a new table in the datasheet
Changing data type and format
Understanding data types
Creating a new table in the design view
Primary Key
Field Properties
Deleting a database table
Modifying a database table

 

Database Relationships

Understanding relationships
Creating relationship using the Lookup Wizard
Display Relationships
Editing and creating relationships in the Relationships window

 

Working with Forms

Understanding forms
Creating forms instantly
Creating forms using the Form Wizard
Changing the form views
Understanding controls and layouts
Resizing and formatting controls
Understanding Property sheets
Sections in the Design view

 

Working with Queries

Understanding Queries
Creating a Select Query
Selecting fields for a query
Sorting the query results
Understanding the Datasheet and Design query views
Entering Criteria
Using the Expression Builder

 

Working with Reports

Understanding reports
Creating reports instantly
Creating a report using the Report Wizard
Modifying a Report Design
Print preview reports
Printing reports
Send the report as an e-mail message