prospen.co.za

ProspenAfrica | Training and Consulting Services Provider

Intermediate Microsoft PowerPoint

2 Day Accredited Training

Unit standards: 116936, NQF Level 3, 3 Credits

Dates: 06 – 07 June | 12 – 13 August | 17 – 18 October 2024
Locations:
Johannesburg, South Africa
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

    Enquire Now

    Related Courses

    Advanced Excel and Dashboards Training
    Dates: 18 - 19 Jun | 22 - 23 Aug 2024

    A Complete Introduction To Power BI Desktop

    View Course
    Basic Microsoft Word
    Dates: 19 Jul 2024

    Microsoft Word Basic

    SAQA ID: 117924, NQF L2

    View Course
    Intermediate Microsoft Word: SAQA ID: 119078, NQF L3
    Dates: 22 - 23 Aug | 14 - 15 Oct 2024

    Microsoft Word Intermediate

    SAQA ID: 119078, NQF L3

    View Course
    Basic Microsoft Word
    Dates: 12 Jun | 19 Aug 2024

    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