Microsoft Access 2013 Beginners Courses in Cape Town
2KO offers this course in 3 levels.
Beginner (below) Intermediate (click to see)
Increasing effectiveness in developing and manipulating databases. 2KO is an IT consulting and training company, offering both business services and training across multiple platforms. 2KO Africa's various courses are available as full time classes, or as online e-learning, enabling 2KO students the opportunity to study courses online world-wide, to ensure students have access to the best training possible.
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
Prior knowledge and skills to:
Mathematical Literacy at NQF Level 3.
Communication at NQF Level 3.
Knowledge of GUI based database application.
What is a Database?
Definitions of Terms used
Planning a Database
Identify Reasons to Build a Relational Database
Overview of Access
Starting & Exiting Access
Access Screen Layout & Toolbars
Creating A New Database
Creating a Table
Customising Data Entry
Data Types and Formats
Setting Primary Keys
Setting Field Properties
Entering /Editing/Deleting Data
Understand Different Types of Relationships
Set Relationships between Tables
Entering Data in a Form
Modifying a Form
Create a Sub Form
Creating a Query
Sort Fields in a Query
Setting up Criteria
Used Expressions within the Query
Multi Table Queries
Concatenation and Calculation
Change Query Join Types