ACCESS TRAINING COURSES HEREFORDSHIRE
About Enable Technology Herefordshire Access Training Courses
We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Professionals. Each person attending a course takes away Access courseware which can be used as reference materials 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 training courses are delivered as instructor led courses. 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. The Access course could also be scheduled at a socially distanced site near you in Herefordshire. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
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.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Capita Group PLC, South Staffordshire Water PLC, GKN PLC, Boots UK Limited, Cadbury PLC, Dollond & Aitchison Limited, Shell UK Oil Products Ltd and Norwich Union PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Herefordshire
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Using the Object Browser
- See Training Course Details...
Working with Methods
Creating a Function Procedure
Navigating the Access Object Hierarchy
Understanding Expressions and Statements
Understanding Control-of-Flow Structures
Understanding Classes and Objects
Understanding Procedures
Using Expressions, Variables, and Intrinsic Functions
Controlling Program Execution
Declaring Variables
Using the For...Next Structure
Understanding the DoCmd Object
Understanding Objects
Why Program in Access?
Working with Recordsets
Understanding Modules
Using the Select Case...End Select Structure
Working with Variable Scope
Microsoft Access
- 2 day course
- Location: Herefordshire
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Navigation Pane Protection
- See Training Course Details...
Calculations in Queries
Setting Table Relationships
Adding Transactional Records
Getting to Know Access
Creating a Lookup Database
Querying Techniques
Creating and Using Forms
Action Queries
Understanding VBA
Adding Records to a Table
Modifying Forms
Macros on Forms
Creating a Relational Database
Multi Table Queries
Designing a Lookup Database
Macro Techniques
Database Security
Modifying Table Structures
Database Wellness
Creating Queries
Email us about this courses
Other Herefordshire Enable Technology Training Courses
Power BI Herefordshire Training Courses
Excel 365 Intermediate Herefordshire Training Courses
SSAS Herefordshire Training Courses
JQuery Herefordshire Training Courses
Excel Power Pivot - Herefordshire Excel Training Courses
SSRS - Herefordshire SQL Server Reporting Services Training Courses