Microsoft Access 2007/2010: Advanced

Course Overview

This course shows attendees how to improve upon their existing level of Microsoft Access skills using 2007/10 releases of the application. This training teaches delegates to enhance their database by creating more sophisticated queries, forms and reports, and creating macros.

CourseMonster has vetted every training supplier to ensure that you receive the best quality Microsoft training available.

Related Courses

• Microsoft Access 2007: Introduction for Beginners (2 day)
• Microsoft Access 2007: Building Applications with microsoft Access
• Microsoft Access 2007: Introduction for Beginners (1 day)
• Microsoft Access 2007: Advanced (1 day)
• Microsoft Access 2007: Level 4 (1 day)
• Microsoft Access 2007: Intermediate (1 day)
• Microsoft Access 2007: Advanced
• Microsoft Access 2007: Introduction for Beginners
• Microsoft Access 2007: Intermediate
• Microsoft Access 2007: Introduction and Intermediate

Audience

Requirements before booking this course:

• Delegates enrolling in this course should understand table design and table relationships, and how to create basic queries, forms, and reports. All delegates attending this training must have attended and Access Foundation course or have equivalent knowledge

Skills Gained

Course Aims to enable delegates to:

• Learn to create advanced queries, create more efficient forms and reports, and understand and work with macros.

Course Outline

• Interface differences from earlier versions of Access
• Views and Options
• Overview of Advanced Capabilities of Access in recent versions
• Import, Export and Link data to and from other applications
• Create Data Access Pages
• Automate a database with macros
• Use Events to trigger a macro
• Set Form and Control properties through a macro
• Secure a database
• Set permissions for database objects
• Use the database utilities
• Control the start-up of a database
• Write VBA code using the Wizard