ACCESS TRAINING COURSES MONMOUTH
About Enable Technology Monmouth Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can bring the equipment necessary to deliver Access courses at your site. Alternatively we could schedule a course at a local socially distanced venue in Monmouth. Every Access course can be modified to meet your bespoke requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Royal & Sun Alliance Group PLC, Homeserve PLC, Wolverhampton City Council, Aston University, Birmingham City Council, Norfolk Police Constabulary, GKN PLC and Royal Air Force.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Monmouth
- 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 ... Declaring and Creating Object Variables
- See Training Course Details...
Understanding Error Handling
Trapping Errors with the On Error Statement
Creating a Standard Module
Understanding Procedures
Using Intrinsic Functions
Understanding Expressions and Statements
Calling Procedures
Working with Methods
Understanding the Order of Events
Understanding the Form Object
Understanding Constants
Using the Select Case...End Select Structure
Stepping through Code
Why Program in Access?
Using Input Boxes
Determining the Value of Expressions
Using the Object Browser
Understanding Classes and Objects
Understanding Errors
Microsoft Access
- 2 day course
- Location: Monmouth
- 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 ... Setting Table Relationships
- See Training Course Details...
Modifying Forms
Working With Records
Database Security
Adding Transactional Records
Using a Navigation Form
Importing and Exporting Records
Understanding VBA
Creating and Using Forms
Querying Techniques
Aggregation Queries
Parameter Queries
Sorting and Filtering
An Introduction to VBA
Creating and Using Macros
Creating Queries
Adding Records to a Table
Navigation Pane Protection
Formatting Tables
Modifying Table Structures
Calculations in Queries
Email us about this courses
Other Monmouth Enable Technology Training Courses
Excel 365 Advanced Monmouth Training Courses
SSIS - Monmouth SQL Server Integration Services Training Courses
Excel Power Pivot Monmouth Training Courses
DAX - Monmouth Excel Training Courses
TSQL - Monmouth SQL Training Courses
Excel 365 Intermediate - Monmouth Excel Training Courses