Basic Access Course


The basic aspects of Microsoft Office Access. You will understand how a database work and which components it comprises of. At the end of the day you will be able to set up a basic database, with forms and reports, and you will be able to set up basic queries to extract data for the reports.


One full day.


This course is aimed at anyone who wishes to perfect their Microsoft Access skills.

The following people will find this course helpful:
 Anyone who wish to create a basic database
 Anyone who has basic knowledge of Access and wish to improve their skills on the program
 Sales staff, marketing managers
 Data captures
 Business Analysts


We do not have workshops currently, but only provide on site training customized to your needs.


Unit 1: Introduction to Access

Topic A: The Access Window Components

Topic B: Exploring Access Databases

Topic C: Database components

Topic D: What is an Access Database?

Topic E: Create a Access Database

Topic F: Help

Unit 2: Tables

Topic A: Field, Control and Object Names

Topic B: Create a Data Table

Topic C: Set Field Properties

Topic D: Manipulate the Table Design

Topic E: Manipulate Table Data

Topic F: Delete a Table

Unit 3: Relationships

Topic A: Set Primary and Foreign keys

Topic B: Create Table Relationships

Topic C: Edit Relationships

Topic D: Explore Sub-data sheets

Unit 4: Queries

Topic A: Create Select Queries

Topic B: Run a Query

Topic C: Extend Queries with Criteria

Topic D: Use calculated fields in Queries

Topic E: Apply Record Grouping and Calculations

Unit 5: Forms

Topic A: Use Auto Form

Topic B: Use Form Wizards

Topic C: Create a Form Manually

Topic D: Modify a Form

Topic E: Set Print Options

Topic F: Print a Form

Unit 6: Reports

Topic A: Explore Auto Reports

Topic B: Use the Report Wizard

Topic C: Add calculated fields to a Report

Topic D: Format a Report

Topic E: Set Print Options

Topic F: Print a Report


Empower Yourself - BOOK NOW!

Basic Access course
For Learnership Interviews (On appointment only)
1st Floor - SpecCon Holdings (above Huge PC),
1294 Heuwel Ave
Centurion, 0046
South Africa

For Corporate Appointments
4th Floor, Block 2
Anew Hotel Centurion (Conference Centre)
Cnr Gordon Hood and Hendrik Verwoerd Drive
Centurion 0046
South Africa

Contact Details:

Tel: 012 667 4928
Email: [email protected]

VAT No: 4410263224


Everyone can rise above their circumstances and achieve success
if they are dedicated to and passionate about what they do
Nelson Mandela