Book your Access 2003 VBA Training Course
This two day course is being run six times between Monday 12th March 2012 and Thursday 13th September 2012 in Leeds, Manchester, London,
Book this course with us today from as little as £400.50 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.
See all courses provided by QAExpert Help
If you would like
advice, or to book, call
one of our experts on
Open: 9am - 5:30pm
Monday- Friday
Locations/dates for this course
| Date | Location | Rating | Price | ||
|---|---|---|---|---|---|
| Monday 12 March 2012 | Leeds |  | Save £44.50 | £400.50+VAT | |
| Monday 30 April 2012 | Manchester | | Save £44.50 | £400.50+VAT | |
| Monday 21 May 2012 | London | | Save £44.50 | £400.50+VAT | |
| Monday 25 June 2012 | Leeds | | Save £44.50 | £400.50+VAT | |
| Monday 13 August 2012 | Manchester | | Save £44.50 | £400.50+VAT | |
| Thursday 13 September 2012 | Leeds | | Save £44.50 | £400.50+VAT |
Book your course now with Coursebookers!
Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.
Remember:
- Not only are we great value, we can also boast no booking fees
- Human administrators make booking & coordination simple and painless
- Coursebookers is vendor neutral we can offer unbiased and independent advice
- If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
- We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Download Course OutlineSummary:
This two day course will teach delegates how to use Microsoft Access 2003. The course provides in-depth, hands on training with a focus on real-world application.
PreRequisites:
- Understand, create and modify table relationships
- Create left and right query joins
- Create and modify tables, forms, reports and queries
- Modify table, form, report and query properties
- Create advanced parameter queries
- Use the controls on the toolbox
- Write basic formulas
- Format forms and reports
- Sort and filter data
Module 1
- Getting Started
- Introduction to Programming in Access
- Why Program in Access?
- Understanding the Development Environment
- Using Visual Basic Help
Module 2
- Working with Procedures and Functions
- Understanding Modules
- Creating a Standard Module
- Understanding Procedures
- Creating a Sub Procedure
- Calling Procedures
- Using the Immediate Window to Call Procedures
- Creating a Function Procedure
- Naming Procedures
- Organizing Code and Procedures
- Working with the Code Editor
Module 3
- Understanding Objects
- Understanding Classes and Objects
- Navigating the Access Object Hierarchy
- Understanding Collections
- Using the Object Browser
- Working with the Application Object
- Understanding the Form Object
- Working with Properties
- Using the With Statement
- Working with Methods
- Understanding the DoCmd Object
- Working with Events
- Understanding the Order of Events
Module 4
- Using Expressions, Variables, and Intrinsic Functions
- Understanding Expressions and Statements
- Declaring Variables
- Understanding Data Types
- Working with Variable Scope
- Working with Variable Lifetime
- Considering Variable Scope and Lifetime Together
- Using Intrinsic Functions
- Understanding Constants
- Using Intrinsic Constants
- Using Message Boxes
- Using Input Boxes
Module 5
- Controlling Program Execution
- Understanding Control-of-Flow Structures
- Working with Boolean Expressions
- Using the If…End If Decision Structures
- Using the Select Case…End Select Structure
- Using the For…Next Structure
- Using the For Each…Next Structure
- Using the Do…Loop Structure
- Guidelines for use of Branching Structures
Module 6
- Working with Recordsets
- Declaring and Creating Object Variables
- Working with the ADODB Recordset Object
- Specifying a Recordset Cursor Type
- Locking Records for Updating
- Specifying a Recordset Cursor Location - Optional
- Using the CacheSize Property - Optional
- Understanding Recordset Cursor Properties - Optional
Module 7
- Debugging Code
- Understanding Errors
- Using Debugging Tools
- Setting Breakpoints
- Setting Break Expressions
- Using Break Mode during Run Mode
- Stepping through Code
- Determining the Value of Expressions
Module 8
- Handling Errors
- Understanding Error Handling
- Understanding VBA\\\'s Error Trapping Options
- Trapping Errors with the On Error Statement
- Understanding the Err Object
- Writing an Error-Handling Routine
- Working with Inline Error Handling
Description:
This two day course will teach delegates how to use Microsoft Access 2003. The course provides in-depth, hands on training with a focus on real-world application.
QA
QA training has over 25 years of experience of supplying high standard training courses in many Business, Management and IT Technical areas. Since 1983 the company has grown to have 25 training centres across the UK offering businesses routes to advance on a local and national level.
QA have a dedicated team of permanent instructors and teaching consultants who constantly improve the courses to ensure the highest possible standard of training is available.
Want to leave your own testimonial? click Here
No Testimonials have been left for this course.