Access

This comprehensive MAC Access Advanced Course builds on the grounding which was learned in the Access MAC Essentials and Intermediate courses. The Access Advanced MAC course covers some of the more advanced features and functions of Access MAC. This is an intense one-day course, 09h00 to 15h30, which will provide the delegate with sufficient MAC Access Advanced skills to create sophisticated analytical spreadsheets and master intricate advanced formulae in MAC Access Advanced.

This course will prepare the delegate for more advanced Access MAC courses. The delegate receives an Access Advanced MAC manual and an electronic attendance certificate on completion of the Access Advanced MAC Course.

We almost run on demand as we try to accommodate the client’s work schedule when possible. Contact Arnold 083 778 4903 or email [email protected] for dates in your area?

What This Course Covers

Table of contents
How to use this manual
Indexing a table
Creating an index
Modifying an index
Multiple-field indexes
Parameter queries
Specifying data type
Creating multiple parameter prompts
Crosstab queries
Editing the crosstab
Designing forms
Using the form wizard
Customising the form
Displaying the field list
Selecting controls
Re-sizing controls
Copying a control
Deleting controls
Undoing your actions
Aligning controls
Applying attributes
Changing fonts & point size
Changing the colour of the font
Adjusting line style and colour
Adding special effects
Changing fill/back colour
Customizing properties
Using the drawing tools
Adding a chart to your form
Saving/opening a form
Saving the form
Closing a form
Opening a form
Advanced form features
Bound & unbound objects
Adding a bound object
Adding unbound objects
Adding a combo/list box
Creating an option gr
Adding command buttons to the form
Adding control tips to the form
Adding background pictures to the form
Creating reports
Using the report wizard
Printing options
Changing margins
Changing paper size
Changing the column layout
Previewing the report
Printing the report
Customizing the report
Displaying the field list
Selecting controls
Re-sizing controls
Copying a control
Deleting controls
Undoing your actions
Aligning controls
Adding a calculated control
Formatting the report
Changing the type of report
Displaying/hiding report items
Applying attributes
Changing fonts & point size
Changing the colour of the font
Adjusting line style and colour
Adding special effects
Changing fill/back colour
Customizing properties
Using the drawing tools
Displaying choices with option groups
Adding background pictures to the report
Saving/closing a report
Saving the report
Opening a report
Closing a report
Practice exercise
Backing up/restoring your database
Using database utilities
Working with an older database
Saving a database as a previous version
Compacting a database
Backing up your database
Linked table manager
The switchboard manager
Database startup options

This courses will prepare the delegate for more advanced Mac Access Courses. The delegate receives a manual and an electronic attendance certificate on completion of the relevant Mac Access Advanced Course.

We almost run on demand as we try to accommodate the client’s work schedule when possible. Contact Arnold + 27 083 778 4903 or email [email protected] for dates in your area?

ON and OFFSITE training are offered. See our Specials for Gauteng & KZN, other areas call Arnold 083 7784903. Offsite includes teas, light lunch, and an electronic attendance certificate. Group discounts apply. ONSITE, YOUR VENUE, minimum of three delegates attending simultaneously. Prices on request.

We provide training throughout Southern Africa and have offices in all the major cities.

Johannesburg, Pretoria, Sandton, Midrand, Centurion, Roodepoort, Edenvale, Durban, Umhlanga, Cape Town. "Other Areas on Request"

You May Also Like

MS Excel

Excel

MS Excel software package has different levels which cover many courses.
MS Excel

Excel Guru

Excel Guru software package has different levels which cover many courses.
MS Excel

MS Office

MS Office software package has different levels which cover many courses.
MS Excel

Soft Skills

Soft Skills software package has different levels which cover many courses.
Skip to content