Microsoft Access Basic

R695.65 Excl VAT

This course is designed for those who wish to gain the necessary skills to start using MS Access.

 

Delegates who enroll in this course will learn:

  • Use and purpose of MS Access
  • About Databases
  • Creating and editing databases
  • Using Tables in a database

Description

Unit Standard: 116936

Course Schedule

 

Introduction to Access

What is a Database, and why use it

Properties of a database

Forms, Queries, and Reports

Opening and saving a database

Working with Your Access Environment

Creating a database

Adding Records and Entering Data to an existing table

Closing database

Producing and editing database table

Saving a table

Changing the Width of a Column

Moving a Column

Deleting a table

Saving and closing the table

Entering data in a table

Adding Records and Entering Data

Editing Records

Deleting data from a table

Modifying tables

To Open an Existing Table

Adding and Rearranging Fields

To Change the Data Type for Existing Fields

Field Character Limits

Deleting a fields

Sorting and searching for records in a table

Filtering Records