Microsoft Access 2013 for Beginners

Microsoft Access 2013 Beginners Courses in Cape Town

 

2KO offers this course in 3 levels.

 

Beginner (below)      Intermediate (click to see)   

 

Unit Standards
258875 - Design forms and reports using a Graphic User Interface (GUI) based database (Level 4) Credits 4 258881 - Design complex tables and queries using a graphical user interface (GUI) based database to solve a given problem (Level 4) Credits 5

Pre-requisites
Prior knowledge and skills to:
Mathematical Literacy at NQF Level 3.
Communication at NQF Level 3.
Knowledge of GUI based database application.

Level
Beginner

 

Duration
1 Day


Course Content

Introduction

What is a Database?

Relational Databases

Definitions of Terms used

Planning a Database

Identify Reasons to Build a Relational Database

 

Overview of Access

Starting & Exiting Access

Access Screen Layout & Toolbars

Accessing Help

 

Creating A New Database

Creating a Table

Customising Data Entry

Data Types and Formats

Setting Primary Keys

Setting Field Properties

Add/Edit Fields

Saving Tables

Entering /Editing/Deleting Data

Understand Different Types of Relationships

Set Relationships between Tables

 

Creating Forms

Autoform

Form Wizard

Columnar Form

Tabular Form

Entering Data in a Form

Modifying a Form

Create a Sub Form

 

Queries

Creating a Query

Sort Fields in a Query

Setting up Criteria

Used Expressions within the Query

Multi Table Queries

Concatenation and Calculation

Parameter Queries

Change Query Join Types

 

Reports

Create Reports