Microsoft Access 2013 Advanced Class

Microsoft Access 2013 Advanced Courses in Cape Town

 

2KO offers this course in 3 levels

 

Beginner (click to see)        Intermediate (click to see)       Advanced  (below)

 

Subject
Increasing effectiveness in developing and manipulating databases.
2KO Africa is a network of companies that offers a substantial series of computer courses across the entire African region, and is a leading provider of internationally recognised online IT training, online, IT training, enabling 2KO students the opportunity to study courses online world-wide, to ensure the best training possible.

 



Unit Standards
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

Pre-requisites
Prior knowledge and skills to:
Mathematical Literacy at NQF Level 3.
Communication at NQF Level 3.
Knowledge of GUI based database application.

Level
Advanced

Duration
1 Day

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
Macros
Creating a macro
Running a macro

Expert Database Tools
Importing Data
Linking Data
Linked table manager
Compact and Repair
Database Options
Printing relationships
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
Trusted Locations

Database design
Database Normalization
Relational Database structure
Understanding relationships

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
Append Queries
Delete Queries
Update Queries
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