Microsoft Access 2016 for Beginners

Microsoft Access 2016 Beginners Courses in Cape Town

2KO offers this 2016 course in 3 levels.

Beginner (below) Intermediate (click to see) Advanced (Click to see)

Subject
Increasing effectiveness in developing and manipulating databases. 2KO is an IT consulting and training company, offering both business services and multi-platform training. 2KO Africa's wide range of computer courses are available as full time classes, or as online learning, enabling 2KO students the opportunity to study courses online world-wide, to ensure students have access to the best training possible.

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