|
Advanced Access Course - Level 3 Access Course
Our Access advanced course will provide you with the tools to automate your database tasks using macros and build a better user interface or switchboard. This is the last step to ensure your database is easy to use, navigate and perform actions easily for non-access users. We will also provide a sample VBA routine and function.
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
Audience - This course is aimed at experienced Access users with a solid understanding of all building blocks and tools.
Course Duration - This is a 1 day Access advanced course
Course Dates - This course can run on any date you request
Course Versions - All versions from 97 to 2007
|
|
|
 Advanced Access Course Content
Understanding and Creating Macros
- A discussion on Macros, their purpose and benifit
- Creating new macros, running macros, macro actions
Attaching Macros
- Understanding events
- Attaching Macros to an event, either fom or report
Names Macros and AutoKeys
- Creating names macro groups
- Creating toolbars from names macros
- Assigning macros to key combinations
Conditional Macros
- Creating macro conditions
- Creating option, toggle and check groups
- Message boxes
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 VBA Sub and Function
- Sample subroutine
- Sample function
|
|
|
More Access Courses
Training Formats and Locations
- Onsite Training - We come to you
- Our London city based training center
- One to One - Dedicated to your needs
- Classroom - for groups up to 8
- All our courses are instructor led, and closed to you.
read more
Course Cost
- This course is charged at £595 per group of 8 per day
- One to One is charged at £450 per day
- All prices exxclude VAT
- No travel cost except outside M25
Why choose us?
- Experienced trainers
- Best rates for groups and One to One courses
- Most flexible cancellation terms
- Easy payment terms
- Simple pricing structure
- After course support by your trainer
- Free Training Needs Analysis
read more |
