MS Access 2007 Advanced Training Course in London
Our MS Access 2007 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 repetive 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 2007 Advanced training course, it is recommended that you have attended our MS Access Intermediate course or that you are at a similar level.
Unlike training companies offering scheduled courses, we offer the alternative of your Microsoft Access 2007 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.
Access 2007 Advanced Training Course
Audience: This course is designed for existing Access users whom need to start automating database tasks or simply complex database sequences.
Access 2007 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 2007 Advanced course. The course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This Access 2007 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 2007 Advanced Training Course Contents
Macros
- An Overview
- Creating Macros and Running Macros
- Various Macro Actions
Names Macros
- Using ^ + letter
- Using ^ + Number
- Function keys
Conditional Macros
- Msgbox
- Set value
- Using functions
Event Procedures
- 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
VBA
- Sample subroutine
- Sample function
More 2007 Courses
