What is Basic Microsoft Access ?

This course explains how a database works and which components it is comprised of. Microsoft Access is an easy-to-use information management tool used to create customisable database applications. It assists with the storage of information for reference, reporting and analysis. It can help manage related data more efficiently than Microsoft Excel or other spreadsheet applications. 

The course covers how to create table relationships and set primary and foreign keys, create queries and apply record groupings.

Basic Microsoft Access

Manish Rajoo

This course was a gift from my mother and I am so grateful for the opportunity. I loved every minute of it.

Caleb Henning

Rewarding course. It made a difference to my life. Thank you. 

What are the prerequisites?

  • Computer/Laptop
  • Email for notifications and communication
  • Internet connection
  • PDF viewer (e.g ADOBE Acrobat)
  • Microsoft Access
  • A web browser

What other related courses are offered?

We provide a variety of courses, from computer studies to leadership and softskills courses.

The following are our most popular courses:

Although this class was a challenge, I really enjoyed it. I also enjoyed the fact that everything was online.

Course Content

Job Market Prospects

Software developers, data architects and power users all use Microsoft Access to develop application software. 

What other people are saying:

How long does it take to complete?

How much does it cost?

Unit 1 - Introduction

1.1 Identifying the elements of the Access interface

1.2 The different types of databases in Access

1.3 Exploring the database components

1.4 Exploring different databases

1.5 How to create an Access database

1.6 Using the Help function

Unit 2 - Tables

2.1 Database fields, records and columns

2.2 Creating tables

2.3 Set field properties

2.4 Manipulate the table design

2.5 Manipulate the table data

2.6 Delete a table

Unit 3 - Relationships

3.1 Set primary and foreign keys

3.2 Create table relationships

3.3 Edit relationships

3.4 Explore sub data sheets

Unit 5 - Forms

5.1 Use auto form wizard, create a form manually, and modifying a form

Unit 6 - Reports

6.1 Create an auto report, use report wizard, imitations on reports and how to print

Unit 4 - Queries

4.1 Create select queries

4.2 Extend queries with criteria and run a query

4.3 Use calculated fields in a query

4.4 Apply record groupings

It takes between 4 days and 2 weeks, depending on your speed.

only R 50 (incl VAT)

Or

Microsoft Word Basic

Microsoft Excel Basics

Microsoft PowerPoint Beginner

Microsoft Word Intermediate

Microsoft Excel Intermediate

Microsoft PowerPoint Advanced

Charles Nkomo