Microsoft Access 2000: Advanced Course (2 day) UK Classes & Lessons (Microsoft)

About this class

Microsoft Access provides powerful yet easy to use database tools facilitating the sharing of information and building of faster solutions. Access 2000 provides a number of enhancements to optimise the productivity of end users, power users and developers.

When a business must be sure that steps are taken to prevent accidental or deliberate loss, damage or misuse of data, a customised approach is often preferred. Our Specialised course covers these topics and teaches how to integrate and automate applications, yet still finds time to touch on simple programming in Visual Basic for Applications.

By the end of this course you will be able to produce advanced form interfaces, understand hyperlinked and data access pages, create and use macros, design advanced data queries and implement Access security features.

Who will the lesson benefit?

Advanced users who need to build secure databases for other users, and those wishing to automate and control the use of database objects. Delegates will be shown Internet tools, such as Data Access Pages, hyperlinks, how to create Web pages, and integrate with other Office products. Delegates will also be shown how to secure a database effectively and be given a brief overview of VBA programming.

What delegates will learn

This course will enable delegates to:

Create Data Access Pages.
Automate a database with macros.
Secure a database.
Use the database utilities.
Control the start-up of a database.
Write VBA code using the Wizard.

What prerequisites are required

This course is designed for students who have completed the Access 2000 Fundamentals course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.

Contents of this class

Using Advanced Query Features
Creating Advanced Queries
Enhancing Forms
Using Advanced Report Features
Creating Charts
Advanced forms
Macros
Advanced macros
Exploring Access SQL
Internet integration
Security fundamentals
Designing an application
Automating forms and Splash Screen forms

Optional follow-on classes

Access VBA Overview [AVBA]