MS Access 2000 Advanced Training Course
Our MS Access 2000 Advanced course will provide users that have existing Intermediate level skills in Access to build on their knowledge. The Advanced course will focus on automating repetitive tasks in Access using Macros. We will also be focusing on creating a user interface for your Access database.
To maximize the gain you receive from our MS Access 2000 Advanced training course, it is recommended that you have attended our MS Access Intermediate course or that you are at a simi liar level.
Unlike training companies offering scheduled courses, we offer the alternative of your Microsoft Access Training Course delivered in central London on a date of your choice, either onsite or at our offices near Moorgate, Bank or Liverpool Street either 1 to 1 or as part of a group.
Microsoft Access 2000 Advanced
Audience: This course is designed for existing Access users whom need to start automating database tasks or simply complex database sequences.
Access 2000 Advanced Course Objectives: After the course, you will be able to:
- Create and Apply Macros
- Understand Events
- Create Conditional and Named Macros
- Create Custom Toolbars and Menu's
- Use Startup Options
Requirements: You must have sound Access skills and understand key concepts of a database, equivalent to our intermediate course contents
Course Duration :This is a 1 day Access 2000 Advanced course. The course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This Access 2000 Advanced course can be run Onsite, at our Access training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.
Access 2000 Advanced Training Course Contents
- An Overview
- Creating Macros and Running Macros
- Various Macro Actions
- Using ^ + letter
- Using ^ + Number
- Function keys
- Set value
- Using functions
- On open/close
- On got/lost focus
Creating a Switchboard (User Interface)
- Designing a switchboard
- Using Macros associated with Command Buttons
- Using Macros associated with Code
- Formatting switchboard forms
- Creating a Splash Screen
- Using autoexec
- Custom toolbar
- Custom menu
- Start-up Menu
- Sample subroutine
- Sample function