Prerequisites

With knowledge of Windows is required with the following pre-requisites:

Able to maneuver with the mouse – Point, Click, Drag and Double Click.

Able to change/customized the desktop items

Able to use the Control Panel

Able to switch between task applications

Able to maneuver with Microsoft Office or current user of Microsoft Office (MS-Excel and MS-Word).

Able to surf the Net will be an added advantage

Course Objectives

At the end of the course, users will be able to create and maintain databases; generate common office solutions like mailing labels; extract information from databases; and generating reports. This course is meant for end users as there will not be any programming involve.

Module 1: Introduction to Database

What is a Database?

Database Terms

Problems with Bad Database Design

Database Design Steps

:: Course ACS03B ::

Module 2: Using Microsoft Access

Starting Microsoft Access

Quick Tour through Microsoft Access

Viewing Objects in the Database Window

Using Database Wizard

Module 3: Planning and Creating Tables

Introduction to Tables

Creating a New Database

Creating a Table using the Table Wizard

Creating Tables by Entering Data

Getting Data from other Access Tables

Creating Tables in Design View

Working with Fields and Data Type

Field Properties

Manipulating Tables in the Database Window

Establish Table Relationships

Understanding Referential Integrity

Module 4: Working with Tables

Navigating Inside a Database

Importing Tables

Exporting Tables

Linking Tables

Linking to Excel

Linking to another Access database table

Programme scope, delivery arrangements and suitability are confirmed during enquiry.