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 offers a suite of IT services, IT consulting and training programs in business and IT. Our computer training is available to students worldwide either 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