ACCESS TRAINING COURSES STROUD
About Enable Technology Stroud Access Training Courses
Enable Technology specialise in succinct skills based Access training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant is given Access courseware which they can refer to after the training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Enable Technology offers instructor led training taught by technology specialists. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. We are also more than happy to organise a local course at a training location in Stroud. Every Access course can be modified to meet your bespoke requirements.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are GKN PLC, Loughborough University, Royal Air Force, Norwich Union PLC, Boots UK Limited, Birmingham City Council, Homeserve PLC and Vodafone Group Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Stroud
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Using the If...End If Decision Structures
- See Training Course Details...
Working with Procedures and Functions
Using the Object Browser
Using Debugging Tools
Working with the Code Editor
Understanding Recordset Cursor Properties - Optional
Working with Variable Lifetime
Using the For...Next Structure
Understanding VBA's Error Trapping Options
Working with Recordsets
Guidelines for use of Branching Structures
Using the Immediate Window to Call Procedures
Why Program in Access?
Declaring Variables
Understanding the Err Object
Navigating the Access Object Hierarchy
Understanding the Form Object
Setting Breakpoints
Setting Break Expressions
Understanding the Order of Events
Microsoft Access
- 2 day course
- Location: Stroud
- 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 ... Macro Techniques
- See Training Course Details...
Modifying Forms
Creating and Using Macros
Adding Records to a Table
Setting Table Relationships
Understanding VBA
Modifying Table Structures
Data Validation
Database Wellness
Database Security
Creating and Using Reports
Creating Queries
Aggregation Queries
Importing and Exporting Records
Action Queries
Querying Techniques
Designing a Lookup Database
Adding Transactional Records
Macros on Forms
Creating a Lookup Database
Creating and Using Forms
Email us about this courses
Other Stroud Enable Technology Training Courses
SSAS - Stroud SQL Server Analysis Services Training Courses
Oracle SQL - Stroud SQL Training Courses
Excel 365 Advanced - Stroud Excel Training Courses
Power Query Stroud Training Courses
VBA Stroud Training Courses
Report Builder Stroud Training Courses