ACCESS TRAINING COURSES POOLE
About Enable Technology Poole Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The training will be delivered by a Microsoft professional with development experience. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Courses are instructor led and groups sizes small. We can bring the equipment necessary to deliver Access courses at your site. We also offer the option of scheduling of Access course at a venue near you in Poole. Every Access course can be modified to meet your bespoke requirements.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Wolverhampton City Council, EDF Energy PLC, Royal Air Force, Yell Group PLC, Nationwide Building Society Limited, Aston University, Carillion PLC and Keele University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Poole
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Using the With Statement
- See Training Course Details...
Calling Procedures
Understanding Expressions and Statements
Specifying a Recordset Cursor Location - Optional
Understanding Classes and Objects
Determining the Value of Expressions
Understanding Procedures
Understanding Control-of-Flow Structures
Creating a Standard Module
Understanding the Err Object
Understanding Recordset Cursor Properties - Optional
Using Intrinsic Constants
Using Expressions, Variables, and Intrinsic Functions
Declaring and Creating Object Variables
Understanding Objects
Stepping through Code
Why Program in Access?
Understanding Error Handling
Debugging Code
Using the For...Next Structure
Microsoft Access
- 2 day course
- Location: Poole
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Parameter Queries
- See Training Course Details...
Relational Database Design
Getting to Know Access
Sorting and Filtering
Querying Techniques
Importing and Exporting Records
Calculations in Queries
Creating and Using Forms
Action Queries
Creating a Lookup Database
Creating Queries
Aggregation Queries
Setting Table Relationships
Creating and Using Macros
Macros on Forms
Understanding VBA
Adding Records to a Table
Adding Transactional Records
Database Wellness
Multi Table Queries
Macro Techniques
Email us about this courses
Other Poole Enable Technology Training Courses
JavaScript - Poole JavaScript Training Courses
PL/SQL - Poole SQL Training Courses
VBA - Poole Excel Training Courses
SSIS Poole Training Courses
SSAS Poole Training Courses
Excel Power Pivot - Poole Excel Training Courses