ACCESS TRAINING COURSES ABERYSTWYTH
About Enable Technology Aberystwyth Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite socially distanced training location in Aberystwyth. We are happy to discuss customising the course content should you have particular Access training requirements.
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. Our clients include: Royal Air Force, Wolverhampton City Council, Shell UK Oil Products Ltd, GKN PLC, Birmingham Heartlands Hospital, Norfolk Police Constabulary, EDF Energy PLC and Dollond & Aitchison Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Aberystwyth
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Understanding the Order of Events
- See Training Course Details...
Using Debugging Tools
Understanding VBA's Error Trapping Options
Setting Breakpoints
Creating a Sub Procedure
Using Intrinsic Functions
Understanding Constants
Locking Records for Updating
Working with the ADODB Recordset Object
Understanding the Err Object
Using Break Mode during Run Mode
Specifying a Recordset Cursor Type
Using the Object Browser
Using Expressions, Variables, and Intrinsic Functions
Working with Recordsets
Controlling Program Execution
Using the For Each...Next Structure
Considering Variable Scope and Lifetime Together
Understanding Errors
Microsoft Access
- 2 day course
- Location: Aberystwyth
- 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 ... Working With Records
- See Training Course Details...
Parameter Queries
Setting Table Relationships
DIY Forms
Understanding VBA
Creating and Using Reports
Macros on Forms
Modifying Forms
Formatting Tables
Action Queries
Creating a Lookup Database
Getting to Know Access
Creating a Relational Database
Relational Database Design
Aggregation Queries
Querying Techniques
Calculations in Queries
Creating Queries
Designing a Lookup Database
Database Security
Sorting and Filtering
Email us about this courses
Other Aberystwyth Enable Technology Training Courses
VBA Aberystwyth Training Courses
Excel 365 Basic Aberystwyth Training Courses
Excel 365 Intermediate Aberystwyth Training Courses
SSIS - Aberystwyth SQL Server Integration Services Training Courses
Report Builder - Aberystwyth SQL Server Reporting Services Training Courses
Power BI - Aberystwyth Microsoft Power BI Training Courses