Microsoft Access 2013 (Expert) Training in Cape Town
Increasing effectiveness in developing and manipulating databases
2KO Africa runs accredited computer courses in various African territories, and also supplies authorised online computer training.
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.
Modules Expert Reports
Creating a report with sub reports
Create a calculated control
Add Charts to Reports (or Forms)
E-mailing a report
Save the object using a different format
Working with Macro
Creating a macro
Running a macro
Expert Database Tools
Linked table manager
Compact and Repair
Printing from the Documenter
Analyse a Table
Analyse Database Performance
Improving the performance of an Access database
Editing data in a shared database
Database password security
Expert Form Design
Size and position of a Form
Modifying the record source for a form
Setting or changing the tab order on Forms
Creating an Option group using a wizard
Creating a form with sub forms using a wizard
Creating a sub form by adding a form to another form
Forms with a tab control
Forms with page breaks
Pivot Table Forms
Command buttons on a form
Make Table Queries
Query Joins and Join Properties
Types of joins
Cross tab Queries
Unmatched and Duplicates Queries
Included in your course fees:
• Tuition fees
• Breakfast daily at the training centre (where applicable)
• Teas and coffees
• Lunches daily
• Attendance certificate
Frequently Asked Questions Where do you train?
At our Cape Town offices in Bo-Kaap
What books do I get with this course?
You will receive a course manual which you can take away with you to keep after the course.