MS Access 2010 Advanced Training Course

This third and final course in the Access 2010 series really helps tie the previous two courses up and elevate Access skills to an expert level.

Topics covered in this course include, SQL statements, crosstab queries, macros, data validation, importing and database maintenance.

This dynamic training course is available now throughout the US, including Atlanta, Baltimore, Boston, Charlotte, Chicago, Dallas, Los Angeles, Manhattan, Miami, Orlando, Philadelphia, and Seattle.

Learning Outcomes - MS Access 2010 Advanced Training Course

By the end of this training course, participants will:

• Write SQL statements
• Create aliases for fields
• Attach a SQL query to a control in a form
• View a crosstab query and use the Crosstab Query Wizard
• Create single-criterion & multiple-criteria parameter queries
• Use action queries to append, delete & modify records
• Create and run macros
• Attach macros to events and command buttons in forms
• Create data validation, data entry, & user-input macros
• Use the Query Wizard & Design view to create joins
• Export & import XML documents
• Link database objects
• Analyze database performance
• Split a database
• Compact, repair & backup a database
• Assign & remove passwords & encryption
• Open a database in exclusive mode
• Configure Access options
• Populate database file properties

Times

Public classes start at 9:00am and finish around 4:30pm.

Class Size

Public classes will be a small relaxed group of between 4 and 12 people.

The small group helps ensure that everyone will gets a chance to ask questions and learn at their own pace.

What is provided?

All participants will be provided with morning tea, afternoon tea, printed bound courseware to keep and a MS Access 2010 Advanced Training Course Certificate of Completion.

Certificates of Completion are issued to each participant