ACCESS TRAINING COURSES RUGELEY
About Enable Technology Rugeley Access Training Courses
We are a company that provides short intensive Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). 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.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a Access course at an alternative training site in Rugeley. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Boots UK Limited, Halfords Group PLC, Canadian High Commission, Wolverhampton City Council, Carillion PLC, Fujistu PLC, Queen's Medical Centre Nottingham and Nationwide Building Society Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Rugeley
- 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 ... Handling Errors
- See Training Course Details...
Understanding Modules
Using the Do...Loop Structure
Organizing Code and Procedures
Setting Break Expressions
Understanding Constants
Working with Methods
Stepping through Code
Understanding Procedures
Using the For...Next Structure
Specifying a Recordset Cursor Type
Understanding Error Handling
Understanding the Order of Events
Trapping Errors with the On Error Statement
Working with the Application Object
Using Intrinsic Constants
Creating a Function Procedure
Understanding the Form Object
Why Program in Access?
Microsoft Access
- 2 day course
- Location: Rugeley
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Getting to Know Access
- See Training Course Details...
Creating Queries
Database Wellness
Understanding VBA
Aggregation Queries
Database Security
Parameter Queries
Sorting and Filtering
Multi Table Queries
Setting Table Relationships
Data Validation
Formatting Tables
Navigation Pane Protection
Action Queries
Calculations in Queries
Creating and Using Reports
Creating a Lookup Database
Adding Records to a Table
Working With Records
Modifying Table Structures
Macro Techniques
Email us about this courses
Other Rugeley Enable Technology Training Courses
SSAS Tabular - Rugeley SQL Server Analysis Services Training Courses
Excel 365 Advanced - Rugeley Excel Training Courses
Data Warehouse - Rugeley SQL Training Courses
Excel 365 Basic Rugeley Training Courses
Excel 365 Intermediate - Rugeley Excel Training Courses
Report Builder - Rugeley SQL Server Reporting Services Training Courses