ACCESS TRAINING COURSES PYLE
About Enable Technology Pyle Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The training will be delivered by a Microsoft professional with development experience. Each course participant will be issued with training Access resources which they can continue to use after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can bring the equipment necessary to deliver Access courses at your site. If you prefer we can offer an offsite socially distanced training location in Pyle. We are happy to modify the Access syllabus to match your teams training 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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are DHL Express, Wolverhampton City Council, Capita Group PLC, Homeserve PLC, EDF Energy PLC, Birmingham City Council, Loughborough University and Dollond & Aitchison Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Pyle
- 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 ... Working with the Code Editor
- See Training Course Details...
Working with Procedures and Functions
Working with Methods
Working with Recordsets
Understanding the Form Object
Using Message Boxes
Working with Boolean Expressions
Using Expressions, Variables, and Intrinsic Functions
Understanding Error Handling
Understanding Objects
Working with Inline Error Handling
Setting Break Expressions
Using the Select Case...End Select Structure
Declaring Variables
Why Program in Access?
Locking Records for Updating
Understanding Constants
Determining the Value of Expressions
Understanding the Err Object
Microsoft Access
- 2 day course
- Location: Pyle
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Sorting and Filtering
- See Training Course Details...
Using a Navigation Form
Action Queries
Creating a Relational Database
Aggregation Queries
Getting to Know Access
Database Wellness
Creating a Lookup Database
Creating and Using Macros
Adding Records to a Table
Calculations in Queries
Modifying Table Structures
Modifying Forms
DIY Forms
Macro Techniques
Setting Table Relationships
Macros on Forms
Creating and Using Forms
Relational Database Design
Navigation Pane Protection
Creating Queries
Email us about this courses
Other Pyle Enable Technology Training Courses
Oracle SQL Pyle Training Courses
SSRS - Pyle SQL Server Reporting Services Training Courses
Excel Power Pivot Pyle Training Courses
JQuery Pyle Training Courses
JavaScript - Pyle JavaScript Training Courses
Excel 365 Intermediate Pyle Training Courses