ACCESS TRAINING COURSES WEYMOUTH
About Enable Technology Weymouth Access Training Courses
We are a company that provides short intensive Access training courses. We guarantee the training will be delivered by a Microsoft certified expert. All course participants are issued Access training manuals they can refer to after the course. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. The Access course could also be scheduled at a socially distanced site near you in Weymouth. 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 course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Birmingham City Council, West Bromwich Building Society, Homeserve PLC, Halfords Group PLC, Cadbury PLC, Capita Group PLC, National Power PLC and Lloyds TSB Bank PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Weymouth
- 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 ... Understanding Collections
- See Training Course Details...
Working with Properties
Declaring and Creating Object Variables
Specifying a Recordset Cursor Type
Navigating the Access Object Hierarchy
Trapping Errors with the On Error Statement
Determining the Value of Expressions
Working with Procedures and Functions
Working with Recordsets
Using the Select Case...End Select Structure
Understanding Recordset Cursor Properties - Optional
Using the CacheSize Property - Optional
Understanding VBA's Error Trapping Options
Using the Immediate Window to Call Procedures
Understanding Constants
Using Debugging Tools
Naming Procedures
Introduction to Programming in Access
Microsoft Access
- 2 day course
- Location: Weymouth
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Macros on Forms
- See Training Course Details...
Modifying Table Structures
Creating and Using Macros
Getting to Know Access
Action Queries
Relational Database Design
DIY Forms
Aggregation Queries
Designing a Lookup Database
Creating a Relational Database
Calculations in Queries
Creating and Using Reports
Database Wellness
Database Security
Creating a Lookup Database
Setting Table Relationships
Creating Queries
Adding Records to a Table
Data Validation
Working With Records
Parameter Queries
Email us about this courses
Other Weymouth Enable Technology Training Courses
VBA - Weymouth Excel Training Courses
Excel Power Pivot Weymouth Training Courses
Power BI - Weymouth Microsoft Power BI Training Courses
Excel 365 Advanced - Weymouth Excel Training Courses
JavaScript - Weymouth JavaScript Training Courses
Power Query Weymouth Training Courses