ACCESS TRAINING COURSES POOLE
About Enable Technology Poole Access Training Courses
We offer intensive two and three days Access courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We are set up to deliver Access training courses onsite at your premises. We also offer the option of scheduling of Access course at a venue near you in Poole. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: DHL Express, Cadbury PLC, Fujistu PLC, Royal & Sun Alliance Group PLC, Nationwide Building Society Limited, Unipart Group, Nuclear Engineering Services and Birmingham City University.
Microsoft Access
- 2 day course
- Location: Poole
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Database Security
- See Training Course Details...
Relational Database Design
Database Wellness
Creating and Using Macros
Action Queries
Macros on Forms
Aggregation Queries
Understanding VBA
Creating and Using Reports
Designing a Lookup Database
Creating a Relational Database
An Introduction to VBA
Modifying Table Structures
Modifying Forms
Getting to Know Access
Querying Techniques
Macro Techniques
Data Validation
Working With Records
Setting Table Relationships
DIY Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Poole
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Understanding the Order of Events
- See Training Course Details...
Using Debugging Tools
Using the For Each...Next Structure
Understanding the Err Object
Understanding Data Types
Declaring and Creating Object Variables
Stepping through Code
Understanding the Form Object
Using the For...Next Structure
Creating a Function Procedure
Working with the Code Editor
Understanding Recordset Cursor Properties - Optional
Using the Object Browser
Specifying a Recordset Cursor Type
Using the Immediate Window to Call Procedures
Guidelines for use of Branching Structures
Introduction to Programming in Access
Working with Boolean Expressions
Understanding Procedures
Email us about this courses
Other Poole Enable Technology Training Courses
Power BI Poole Training Courses
Excel 365 Basic Poole Training Courses
VBA Poole Training Courses
TSQL - Poole SQL Training Courses
SSAS Tabular - Poole SQL Server Analysis Services Training Courses
Excel 365 Intermediate Poole Training Courses