Increasing effectiveness in developing and manipulating databases.
2KO International runs computer courses across the African continent, and is a top provider of internationally certified online IT training, enabling 2KO students the opportunity to
study courses online world-wide, to ensure 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.
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
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
Expert Queries Query types
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.