MS Access 2010 Advanced Training Course in London
Our MS Access 2010 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 2010 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 2010 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 2010 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 2010 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 2010 Advanced course. The course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This Access 2010 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 2010 Advanced Training Course Contents
Macros
- An Overview
- Creating and Running Macros
- Various Macro Actions
- Applying Macros
Names Macros
- Using ^ + letter
- Using ^ + Number
- Function keys
Conditional Macros
- Msgbox
- Set value
- Using functions
Event Procedures
- On open/close
- On got/lost focus
Database Utilties
- Compact and repair
- Save as alternate formats
- Split database
- Package and distribute
- Password protect
- Application options (created database application)
- Compile code
- Make accde file
- Backup database
- Database Templates
Creating a Switchboard (User Interface)
- Design a switchboard
- Use Macros with Command Buttons
- Use Macros with Code
- Format switchboard forms
- Create a Splash Screen
- Use an autoexec Macro
- Customise a ribbon
- Customise the Quick access toolbar
- Start-up Menu
VBA
- Convert macro’s to code
- Sample subroutine
- Sample function
- Libraries
- Navigate the vba window
- Compiling
More 2010 Courses
