Basic Access Course

INTRODUCTION

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.

DURATION OF THIS BASIC ACCESS COURSE

One full day.

WHO SHOULD ATTEND THIS COURSE?

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

COURSE DATES

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

PRICING

The cost for on-site training is R10,000 per day. Maximum 15 delegates for computer training and 30 delegates for soft skills training. For individual course, see our elearning platform.

OUTLINE

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

Address:

Unit 11, Block 2
Falcon Crest Office Park
142 South Street
Die Hoewes
Centurion
South Africa

Contact Details:

Basic Access course



*


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