Home /
Training Courses /
Microsoft Access VBA (2 days)
Microsoft Access VBA (2 days)
Training Description
The skills and knowledge acquired in Microsoft Access VBA are sufficient to be able to use and operate the software at an efficient level.The Course Suits
Microsoft Access VBA is designed for users who are keen to extend their understanding and knowledge of the software.Training Benefits
At the completion of Microsoft Access VBA Introduction you should be able to:
- work with objects
- use the Object Browser
- identify collection objects
- use the Controls collection.
- manipulate data by declaring variables
- combine data by using expressions
- get user input
- create Sub and Function procedures, and call one procedure from another.
- use decision structures and loop structures.
- identify ActiveX Data Objects (ADO) architecture and collections, connect to a database, work with a Recordset, and create a parameter query.
- identify compile-time, run-time, and logical errors
- use the debugging tools
- write error-handling code
Course Timetable
The course focuses on practical work within the product giving delegates ample opportunity to use their PC skills through a series of graded exercisesTopics covered include:Create powerful applications
Objects, Properties and MethodsSynchronising FormsStoring Return Values
Learn basic programming structures
Working with ModulesCreating Sub ProceduresCalling Sub Procedures
Work with conditional statements and loops
The If StatementThe Do CommandLooping
Create custom message boxes
Evaluating a Message boxResponding to User SelectionsCreate Custom functionsUsing Built-in FunctionsCreating Custom FunctionsCalling Function Procedures
Interact with Excel or Word
Opening Other ApplicationsDestroying Object VariablesAdding Data
Write error-handling code
Stepping Through CodeUsing the Intermediate WindowSetting a Watch on a Variable
Validating User Input
Checking for Null ValuesOffering Choices
© PTP/AVBA
Please Choose from the list below:
Microsoft Access VBA (2 days) training course available to book:
Related Items:
There's no related items for that course.
Quick Training Search
-
- Training Courses
- Customer Care Training
- Assertiveness & Building Personal Confidence
- Body Language - The Hidden Secret of Communicating Successfully
- Brand Building with the Public
- Call Centre - Achieving Best Practice
- Customer Care
- Customer Excellence for Finance Staff
- Customer Satisfaction as a Selling Tool
- Dealing with Difficult People
- Dealing with Incoming Calls Positively
- Enhancing the Visitors Experience
- Excellent Customer Care - Incoming Calls
- How to say 'No' and retain Customer Satisfaction
- Introduction to Account Management
- Outstanding Customer Service Skills
- Professional Writing Skills
- Relationship Marketing
- Through the Customers' Eyes
- Finance and Planning Training
- Finance and Planning Training
- Business Skills for Administrators
- Credit Control
- Customer Excellence for Finance Staff
- Cutting Costs and Waste in Your Office
- Finance for Marketing and Sales People
- Finance For Non-Finance Managers
- Interpreting Financial Statements
- Investor and Entrepreneur Skills
- Managing Budgets
- Successfully Setting and Achieving Business Objectives
- Sustaining Effective Financial Control
- Finance Management
- Finance and Planning Training
- IT Courses
- Microsoft Access Courses
- Microsoft Access 2000 Fundamentals (2 days)
- Microsoft Access 2000 Specialised (2 days)
- Microsoft Access 2003 Fundamentals (2 days)
- Microsoft Access 2003 Specialised (2 days)
- Microsoft Access 2007 Fundamentals (2 days)
- Microsoft Access 2007 Specialised (2 days)
- Microsoft Access VBA (2 days)
- Microsoft Access XP Fundamentals (2 days)
- Microsoft Access XP Specialised (2 days)
- Microsoft Excel Courses
- Microsoft Excel 2000 Advanced
- Microsoft Excel 2000 Fundamentals
- Microsoft Excel 2000 Intermediate (2 days)
- Microsoft Excel 2003 Advanced
- Microsoft Excel 2003 Fundamentals
- Microsoft Excel 2003 Intermediate (2 days)
- Microsoft Excel 2003 Upgrade
- Microsoft Excel 2007 Advanced
- Microsoft Excel 2007 Fundamentals
- Microsoft Excel 2007 Intermediate (2 days)
- Microsoft Excel 2007 Upgrade
- Microsoft Excel VBA (2 days)
- Microsoft Excel XP Advanced
- Microsoft Excel XP Fundamentals
- Microsoft Excel XP Intermediate (2 days)
- Microsoft Outlook Courses
- Microsoft Outlook 2000 Fundamentals
- Microsoft Outlook 2000 Specialised
- Microsoft Outlook 2003 Fundamentals
- Microsoft Outlook 2003 Specialised
- Microsoft Outlook 2003 Upgrade
- Microsoft Outlook 2007 Fundamentals
- Microsoft Outlook 2007 Upgrade
- Microsoft Outlook XP Fundamentals
- Microsoft Outlook XP Specialised
- Microsoft PowerPoint Courses
- Microsoft PowerPoint 2000 Fundamentals
- Microsoft PowerPoint 2000 Specialised
- Microsoft PowerPoint 2003 Fundamentals
- Microsoft PowerPoint 2003 Specialised
- Microsoft PowerPoint 2003 Upgrade
- Microsoft PowerPoint 2007 Fundamentals
- Microsoft PowerPoint 2007 Specialised
- Microsoft PowerPoint 2007 Upgrade
- Microsoft PowerPoint XP Fundamentals
- Microsoft PowerPoint XP Specialised
- Microsoft Word Courses
- Microsoft Word 2000 Advanced
- Microsoft Word 2000 Fundamentals
- Microsoft Word 2000 Intermediate
- Microsoft Word 2003 Advanced
- Microsoft Word 2003 Fundamentals
- Microsoft Word 2003 Intermediate
- Microsoft Word 2003 Upgrade
- Microsoft Word 2007 Advanced
- Microsoft Word 2007 Fundamentals
- Microsoft Word 2007 Intermediate
- Microsoft Word 2007 Upgrade
- Microsoft Word VBA (2 days)
- Microsoft Word XP Advanced
- Microsoft Word XP Fundamentals
- Microsoft Word XP Intermediate
- Miscellaneous Microsoft Courses
- Microsoft FrontPage 2000 Fundamentals
- Microsoft Project 2000 FastPath
- Microsoft Project 2000 Level 1 (2 days)
- Microsoft Project 2000 Level 2 (2 days)
- Microsoft Project 2003 FastPath
- Microsoft Project 2003 Level 1 (2 days)
- Microsoft Project 2003 Level 2 (2 days)
- Microsoft Project 2007 FastPath
- Microsoft Project 2007 Level 1 (2 days)
- Microsoft Project 2007 Level 2 (2 days)
- Microsoft Project XP FastPath
- Microsoft Project XP Level 1 (2 days)
- Microsoft Publisher 2003 Fundamentals
- Microsoft Visio 2000 Fundamentals
- Microsoft Visio 2000 Specialised
- Microsoft Visio 2003 Fundamentals
- Microsoft Visio 2003 Specialised
- Microsoft Visio 2007 Fundamentals
- Microsoft Visio 2007 Specialised
- Microsoft Visio XP Fundamentals
- Microsoft Visio XP Specialised
- Microsoft Windows Vista New Features
- Non-Microsoft Courses
- Microsoft Access Courses
- Management Training
- Green Management
- HR and Recruitment Training
- Appraisee Training
- Appraising Performance Effectively
- Developing Your PA Potential to Ensure Success
- Influencing Skills
- Managing Appraisals
- Managing Difficult Staffing Situations
- Managing Sickness And Absences
- Recruiting the Best People
- Stress Management
- Successful Interviewing
- Understanding Discipline and Grievance
- Walk, Talk, Stance for Maximum Impact
- Interview Training
- Introductory Skills
- Developing Your PA Potential to Ensure Success
- Essential Management Skills (2 Days)
- Introduction to Facilitation Skills
- Introduction to Green Office Management
- Introduction to Management and Supervisory Skills
- Introduction to NLP
- Introduction to Quality Management
- Managing Budgets
- Successfully Setting and Achieving Business Objectives
- Leadership Skills
- Creative Problem Solving
- Introduction to Management and Supervisory Skills
- Leadership & Management Skills
- Management by Coaching
- Senior Management Skills
- Successful International Joint Venture Teamworking
- Successfully Setting and Achieving Business Objectives
- Team Building
- The Roles and Responsibilities of a Director
- Walk, Talk, Stance for Maximum Impact
- Management and People Skills
- Advanced Facilitation Skills (1 Day)
- Advanced Listening Skills
- Assertiveness & Building Personal Confidence
- Body Language - The Hidden Secret of Communicating Successfully
- Building Excellent Working Relationships
- Communication Skills
- Dealing with Difficult People
- Effective Management of Your Team
- Essential Management Skills (2 Days)
- First Line Manager Skills
- Getting Results
- Introduction to Facilitation Skills
- Introduction to Management and Supervisory Skills
- Management by Coaching
- Management Skills - How to Survive and Thrive
- Managing Change
- Managing Conflict
- Managing Effective Meetings
- Managing People on Projects
- Maximising Performance by Influencing and Persuading
- Motivation Skills
- People Management
- Performance Management
- Re-Energising a Stalled Change Campaign
- Senior Management Skills
- The Internal Consultant
- The Practical MBA - Managing By Your Actions (2 day course)
- Walk, Talk, Stance for Maximum Impact
- Work-Life Balance
- Working Globally Inter-Cultural Communications
- Management Finance
- Networking & Sales Skills for Managers
- Presentation
- Project Management
- Sales Management
- Strategy and Risk Management
- Time Management Skills
- Training and Coaching Skills
- Advanced Facilitation Skills (1 Day)
- Coaching and Mentoring
- Coaching Skills
- Introduction to Facilitation Skills
- Introduction to Management and Supervisory Skills
- Management by Coaching
- Managing the Training Function
- The Creative Trainer
- Train the Trainer (2 day course)
- Train the Trainer (one day course)
- Walk, Talk, Stance for Maximum Impact
- Personal Development
- Appraisee Training
- Assertiveness & Building Personal Confidence
- Body Language - The Hidden Secret of Communicating Successfully
- Building Excellent Working Relationships
- Building Personal & Professional Confidence
- Business Skills for Administrators
- Communication Skills
- Creative Problem Solving
- Creativity and Innovation (1 day course)
- Creativity and Innovation (2 Day Course)
- Cutting Costs and Waste in Your Office
- CV Writing and Interview Confidence Building
- Developing Your PA Potential to Ensure Success
- How to Learn Anything Quicker
- Influencing Skills
- Maximising Performance by Influencing and Persuading
- People Management Skills for Secretaries & Pas
- Personal Development for Professionals
- Personal Effectiveness
- Personal Organisation Skills for Secretaries & PAs
- Preparing Yourself for Interview
- Professional Writing Skills
- Self-Discipline and Emotional Control in the Workplace
- Speed Reading & Information Management
- The Green Worker
- Work-Life Balance
- Write to the Top! - Professional Report Writing
- Sales Training
- Face to Face Selling Skills
- Advanced Closing Skills
- Body Language - The Hidden Secret of Communicating Successfully
- Closing The Sale & Dealing With Objections
- Confidence in Making Face to Face Cold Calls
- Successful Sales Presentations
- The Client Meeting - Face to Face Selling
- Walk, Talk, Stance for Maximum Impact
- Winning More Business in the Final Meeting (2 day course)
- General Sales Skills
- Advanced Closing Skills
- Advanced Listening Skills
- Advanced Sales Strategies
- Advanced Selling Skills (2 day course)
- Closing The Sale & Dealing With Objections
- Consultative Selling
- Customer Satisfaction as a Selling Tool
- Developing Major Accounts
- How to Learn Anything Quicker
- Introduction to Account Management
- Introduction to NLP
- Key Selling Skills
- Managing Major Accounts (2 day course)
- More Advanced Selling Skills
- Planning Sales Activity to Help Meet & Exceed Targets
- Selling for Non-Sales Professionals
- Successful Sales Presentations
- The Art of Retail Selling
- The Secrets of Low Cost Advertising
- Through the Customers' Eyes
- Marketing Skills
- Marketing Training
- Negotiation, Objection Handling and Closing Skills
- Presentation Skills
- Sales Management and Coaching Skills
- Sales Writing Skills
- Telemarketing Training
- Telephone Sales Skills
- Advanced Telephone Prospecting
- Closing Incoming Calls Effectively
- Gaining Commitment on the Telephone
- Generating New Business by Telephone
- Maximising Appointments on the Telephone
- Outgoing Calls - Maximising Effectiveness
- Telephone Techniques - Incoming & Outgoing Calls
- Winning More Business on the Telephone
- Face to Face Selling Skills
- Customer Care Training
- Training Courses
To perform a free text search for courses enter your chosen keyword/s below:
Special offers
Click here to find training related special offers in your area special offers
Open course schedule
One day open course schedule for the next month more info
U-Choose
Can't find the right date?
Can't find the right venue?
With U-Choose you can build the training package of your specification more info
Download our brochure
To download our brochure please click
here
To download our 2009 Open Schedule click
here
Special Offers Subscription
Subscribe to receive our special offers.