MAC Microsoft Access Advanced 2011

Access

This comprehensive Access Advanced MAC 2011 Course builds on the grounding which was learnt in the Access MAC Essentials and Intermediate 2011 courses.

The Access Advanced 2011 MAC course covers some of the more advanced features and functions of Access MAC 2011. This is an intense one day course, 09h00 to 15h30, which will provide the delegate with sufficient MAC 2011 Access Advanced skills to create sophisticated analytical spreadsheets and master intricate advanced formula.

This course will prepare the delegate for more advanced Access MAC 2011 courses. The delegate receives an Access Advanced 2011 MAC manual and an electronic attendance certificate on completion of the Access Advanced 2011 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 This email address is being protected from spambots. You need JavaScript enabled to view it. for dates in your area?

ENQUIRY FORM

 

 

Topic-Level Outline
  • 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
 

Download the table of contents (TOC)

DOWNLOAD TOCENQUIRY FORM

 

This courses will prepare the delegate for more advanced Mac Access Courses. The delegate receives a Mac Access manual and an electronic attendance certificate on completion of the relevant Mac Access Advanced 2011 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 This email address is being protected from spambots. You need JavaScript enabled to view it. for dates in your area?

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

ENQUIRY FORM

 

Contact Arnold 083 778 4903 or email This email address is being protected from spambots. You need JavaScript enabled to view it.

 

Subscribe to our free tips newsletter

About college africa group

We, at College Africa Group offer training courses
which meet your needs and fit within your budget.

As a MICT Seta National Accredited Microsoft
Computer Training provider, College Africa Group
is the preferred choice for all computer related
training needs.

Contact Info

Mobile: Arnold Muscat + 27 (0)83 778 4903

Call Centre: +27 (0)11 881 5998

Email: sales@collegeafricagroup.com

Head Office:

Physical Address :2nd Floor, West Tower Maude

Street Nelson Mandela Square Sandton

South Africa 2196