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