Prospen Africa

ProspenAfrica | Training and Consulting Services Provider

Intermediate Microsoft PowerPoint

2 Day Accredited Training

Unit standards: 116936, NQF Level 3, 3 Credits

Dates: 09 – 10 December 2024 | 27 – 28 January | 24 – 25 March 2025
Locations:
Grayston Ridge Office Park, Sandton
Platform:
Available In class, In house & Online

Price: Available on Request

mictseta logo

Course Introduction

PURPOSE OF THE UNIT STANDARD

This unit standard is intended for people who need to create and edit simple databases using a Graphical User Interface (GUI)-based database application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry.

Course Objectives

Upon completion of this Intermediate Microsoft PowerPoint course, participants will be able to:

  • Understand the principles of databases.

  • Open and save a simple existing database.

  • Produce and edit a simple database 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.

Who should attend?

  • Business professionals

  • Educators/Facilitators

  • Students

  • Marketing professionals

  • Consultant

Microsoft office courses

Training Methodology

Our diverse instructional approaches ensure effective learning:

– Lectures & Presentations: Engage with expert-driven, stimulating content.
– Course Material: Access well-crafted supporting resources.
– Group Work: Collaborate on discussions and case studies for practical insights.
– Workshops & Role-Play: Participate in immersive, scenario-based activities.
– Practical Application: Focus on applying theoretical knowledge in real situations.
– Post-Training Support: Receive extensive support after training for skill implementation.

Training Outline

Module 1: Understand the principles of databases.

  • A database management system is defined in terms of its purpose and use.

  • Examples of uses of databases are provided.

  • Properties of databases are described in terms of their purpose and relation to the database as a whole

Module 2: Open and save a simple existing database

  • The database application is opened or started

  • The parts of the database application window are described in terms of their features and use

  • An existing database is opened

  • Data is entered into an existing database table

  • Saving a database giving it a descriptive name related to its purpose and use

  • The database is closed

  • The database application program is closed

Module 3: Produce and edit a simple database table from given specifications

  • A database table is created with the required format bases on a given specification

  • The database table is saved with a descriptive name, as per the given specification

  • A column is moved within the database table

  • Column widths of columns in the database table are changed

  • A database table is deleted

  • The database table is saved and closed

Module 4: Data is entered into a simple database table from given specifications

  • A new record is added to the database table

  • Data in the database table is modified

  • Data in the database table is deleted

  • A record is deleted from the database table

Module 5: Modify the design of a database table

  • An existing database table is opened in design view

  • The consequences of changing a field size are discussed

  • Field formats are modified

  • A field is moved in the database table

  • A new field is added to the database table

  • A field is deleted from the database table

  • The consequences of the changes made are explained and corrected if necessary

Module 6: Sort and search for records in a database table

  • A record in a database table is sorted according to one field

  • A record is in a database table, by searching for specific data within the table

Related Courses

Advanced Excel and Dashboards Training
Dates: 03 - 04 Feb | 23 - 24 Apr 2025

A Complete Introduction To Power BI Desktop

View Course
Basic Microsoft Word
Dates: 04 Nov 2024 | 20 Jan 2025

Microsoft Word Basic

SAQA ID: 117924, NQF L2

View Course
Intermediate Microsoft Word: SAQA ID: 119078, NQF L3
Dates: 06 - 07 Nov 2024 | 21 - 22 Jan 2025

Microsoft Word Intermediate

SAQA ID: 119078, NQF L3

View Course
Basic Microsoft Word
Dates: 08 Nov 2024 | 23 Jan 2025

Microsoft Word Advanced

SAQA ID: 116942, NQF L3

View Course

Open chat
Need Help? Chat with Us
Scan the code
Powered by Prospen Africa
Welcome to Prospen Africa!
Check out our 15% Off sale when you purchase QCTO Training Material