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 delivers cutting-edge IT products in the consulting and business services space, as well as offering top-rated training for various IT vendors. Our internationally recognised courses can be offered either as hands-on 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