Microsoft Access 2016 Beginners Courses in Cape Town
2KO offers this 2016 course in 3 levels.
Increasing effectiveness in developing and manipulating databases. 2KO Africa is a professional training company, delivering cutting edge programs in the IT space and in selected business applications. Our training is offered online, live online and also by instructor led classes. 2KO Africa's business courses are available world-wide, many of them leading to European Certification, 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