Microsoft Access 2003: Advanced (2 day)

Course Overview

This course is designed to enable delegates to create fully automated applications using Access 2003, exchange data with other applications, secure a database and be able to use the database utilities that are supplied with the product.

Not sure whether this is the right Microsoft training course for you? Use our quick search bar to find the right Microsoft training course for you.

Related Courses

• Microsoft Access 2003: Introduction for Beginners (1 day)
• Microsoft Access 2003: Advanced (1 day)
• Microsoft Access 2003: Intermediate (2 day)
• Microsoft Access 2003: Introduction for Beginners (2 day)
• Microsoft Access 2003: Visual Basic Applications (VBA)
• Microsoft Access 2003: Visual Basic Applications (VBA)
• Microsoft Access 2003: Intermediate (1 day)
• Microsoft Access 2002 2003: Advanced Development in Microsoft Access
• Microsoft Access 2003: Programming with VBA

Audience

Advanced users who need to build secure databases for other users, and those wishing to automate and control the use of database objects.

Skills Gained

Delegates will learn to:

• 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.

Prerequisites

• Delegates should have attended Access Intermediate or have equivalent knowledge.

Course Outline

• Sharing data. Access and the Internet.
• Data Access Pages.
• Database utilities.
• Creating and running macros.
• Specialist macros.
• Events.
• Securing a database.
• Customising toolbars and menu bars.
• Introduction to VBA.