ACCESS TRAINING COURSES GLOUCESTER
About Enable Technology Gloucester Access Training Courses
Enable Technology specialise in succinct skills based Access training. All of our tutors are Microsoft Certified Professionals. We provide every candidate with Access training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver Access courses onsite at your site. We also offer the option of scheduling of Access course at a venue near you in Gloucester. 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 instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Fujistu PLC, Birmingham Heartlands Hospital, Halfords Group PLC, Lloyds TSB Bank PLC, Birmingham City Council, Norwich Union PLC, West Bromwich Building Society and Loughborough University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Gloucester
- 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 ... Using the CacheSize Property - Optional
- See Training Course Details...
Declaring and Creating Object Variables
Locking Records for Updating
Using Visual Basic Help
Understanding Procedures
Understanding Expressions and Statements
Using Intrinsic Constants
Understanding Error Handling
Understanding the Development Environment
Understanding the Form Object
Understanding Data Types
Working with Variable Scope
Working with Variable Lifetime
Understanding Objects
Debugging Code
Trapping Errors with the On Error Statement
Using the With Statement
Understanding the DoCmd Object
Working with the Application Object
Understanding VBA's Error Trapping Options
Microsoft Access
- 2 day course
- Location: Gloucester
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Calculations in Queries
- See Training Course Details...
Adding Records to a Table
Creating a Relational Database
An Introduction to VBA
Creating and Using Forms
Sorting and Filtering
Designing a Lookup Database
Modifying Forms
Parameter Queries
Aggregation Queries
Macro Techniques
Formatting Tables
Action Queries
Database Wellness
Getting to Know Access
Importing and Exporting Records
Querying Techniques
Creating and Using Macros
Modifying Table Structures
Creating and Using Reports
Understanding VBA
Email us about this courses
Other Gloucester Enable Technology Training Courses
SSIS - Gloucester SQL Server Integration Services Training Courses
JQuery Mobile - Gloucester JavaScript Training Courses
PL/SQL Gloucester Training Courses
SSAS Tabular Gloucester Training Courses
Excel Power Pivot Gloucester Training Courses
SQL Gloucester Training Courses