Audience Profile This MS Access course in
Cape Town is developed for students who have a thorough
understanding of the basic and advanced user features of
the Microsoft® Office Access™ 2007 application, and are
interested in learning introductory level administrator
skill sets. The course is also for the student who may
be working in a web-based environment and may require to
adapt Access applications to the environment.
2KO presents Microsoft courses in Cape Town by means of
full time instructor-led training; as well as
internet-accessible online training, which are aimed at
International IT Certification exams. 2KO Africa runs accredited computer courses in various African territories, and also supplies authorised online computer training, enabling 2KO students the opportunity to study courses online world-wide, to ensure the best training
possible. Please note: To achieve the MCITP: Enterprise
Messaging Administrator certification, you must
successfully complete two exams. One Microsoft Certified
Technology Specialist (TS) on Microsoft Exchange Server
2010 prerequisite exam and one Professional Series (PRO)
exam. (70-662 & 70-663 | Both these courses can be done
over 2 Weeks Full Time).
Course Accreditation: MS Access Advanced
Unit Standard: 258881
This course is currently accredited by MICT SETA and is Unit Standard is intended for people who need to plan, produce and use small scale databases using a GUI based database application.
People credited with this unit standard are able to:
Demonstrating an understanding of relational database theory.
Analysing unstructured data not populated to a relational database model.
Creating queries using specific functions.
Creating different types of queries.
Creating parameter queries and adding calculated fields.
Creating basic select queries using simple SQL syntax.
In this course, students will design complex Access
databases by structuring existing data, writing advanced
queries, working with macros, and performing database
Duration: 1 Day
Read, write, communicate and comprehend at least at GET level
Competent in mathematical fundamentals at least at NQF level 2
Use a Graphical User Interface (GUI)-based database application to work with simple databases
Use a Graphical User Interface (GUI)-based database application to solve a given problem
Mastering Access to create and modify an Access database
At Course Completion:
Upon successful completion of this course, students will
be able to:
Restructure data into appropriate tables to ensure data
dependency and minimize redundancy
Write advanced queries to analyze and summarize data
Create and revise Microsoft® Office Access® 2013 macros
Customize reports by using various Microsoft® Office
Access® 2007 features
Maintain their databases using Microsoft® Office Access®
Module Outline: Module 1: Structuring
Restructure the Data in a Table
Create a Junction Table
Improve the Table Structure
Module 2: Writing Advanced Queries
Create Unmatched and Duplicate Queries
Group and Summarize Records Using Criteria
Summarize Data Using a Crosstab Query
Create a PivotTable and a PivotChart
Module 3: Simplifying Tasks with
Create a Macro
Attach a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Module 4: Creating Effective
Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Publish Reports as PDF
Module 5: Maintaining an Access
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database