Intermediate Microsoft Access 2003
(ZCMP-479)
Course Description
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.
Prerequisite
ZCMP-454 How To Use Microsoft Access 2003 or Equivalent Knowledge
Industry Certification
To earn the Microsoft Office Specialist (MOS) certification for Microsoft Office, you must pass one or more certification exams. MOS exams provide a valid and reliable measure of technical proficiency and expertise by evaluating your overall comprehension of Microsoft Office or Office Project programs, your ability to use advanced features, and your ability to integrate the Office programs with other software programs. For more information visit: Prepare for Microsoft Office Specialist Certification
