Microsoft Access 2016 Beginners Courses in Cape Town
2KO offers this 2016 course in 3 levels.
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.
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