Intermediate Microsoft Access 2007

(ZCMP-045)


Participants in this course will enjoy a step-by-step approach for learning advanced database skills that will help them to become more productive in creating multiple table queries, using calculated fields, and crosstab and action queries. Participants will create a form, subform, and use the property sheet and toolbox options.

Complex reports will be created using controls, graphics, special effects, and embedded charts. Access data will be shared with Excel and Word for importing and exporting. Simple menu switchboards will be created to manage the database objects. Macros will be introduced to automate repetitive routines.

This course helps prepare you for the Microsoft Certified Application Specialist (MCAS) Office 2007 Certification. For more information on MCAS certification visit CBT's Microsoft Business Certifications Page

Blended Educational Experience

Students enrolling in this course will also receive access to Microsoft IT Academy online courses to help master the skills necessary to be successful with the software.  Have access to online lectures and labs delivered by Microsoft Experts

Prerequisite: How To Use Microsoft Access or significant experience with Access


Go To Top of Page