Microsoft Access

Duration

This programme is run over 2 days.

Delivery Method

Training times can be arranged according to your date and times requirements, delivered virtually or on-site at your premises by one of our professional facilitators.

Prerequisites

The learner must be competent in Communication and Mathematical Literacy at NQF Level 2.

Unit Standards

Use a Graphical User Interface (GUI)-Based Database Application to Work with Simple Databases NQF3 (3 credits)
(116936)

Learning outcomes:

• Understand the principles of databases
• Open and save a simple existing database.
• Produce and edit a simple database table from given specifications.
• Data is entered into a simple database table from given specifications.
• Modify the design of a database table.
• Sort and search for records in a database table.

Use a Graphical User Interface (GUI)-Based Database Application to Solve a Given Problem NQF4 (6 credits)
(117927)

Learning outcomes:

• Prepare a database to provide a solution to a given problem.
• Create database tables and data entry forms to solve the given problem.
• Retrieve information from a database by applying a filter.
• Sort data in a database query.
• Create a report for a database table.
• Perform advanced print options for a database.

Design Forms and Reports using a Graphic User Interface (GUI) based database NQF4 (4 credits)
(258875)

Learning outcomes:

• Analyse the use of advanced forms and reports.
• Design a form with all the necessary controls for ease of use in an end user environment.
• Create a report for meaningful interpretation of data.