ACCESS TRAINING COURSES ABERGAVENNY
About Enable Technology Abergavenny Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every person attending a Access course will be provided with training materials and practice files to retain after the course. 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.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can set up a training lab at your premises and deliver Access courses onsite at your site. We can also deliver the Access course at a socially distanced local training venue in Abergavenny. We are happy to discuss customising the course content should you have particular Access 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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: University of Birmingham, Vodafone Group Services, Capita Group PLC, DHL Express, Shell UK Oil Products Ltd, Norfolk Police Constabulary, Keele University and Royal Air Force.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Abergavenny
- 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 ... Working with the ADODB Recordset Object
- See Training Course Details...
Using the If...End If Decision Structures
Working with Boolean Expressions
Using the For Each...Next Structure
Organizing Code and Procedures
Controlling Program Execution
Understanding Recordset Cursor Properties - Optional
Understanding Objects
Specifying a Recordset Cursor Location - Optional
Creating a Function Procedure
Understanding Procedures
Stepping through Code
Working with the Code Editor
Working with Methods
Using the Select Case...End Select Structure
Specifying a Recordset Cursor Type
Understanding Collections
Understanding Modules
Locking Records for Updating
Microsoft Access
- 2 day course
- Location: Abergavenny
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Adding Transactional Records
- See Training Course Details...
Creating and Using Forms
Querying Techniques
Multi Table Queries
Sorting and Filtering
Adding Records to a Table
Formatting Tables
An Introduction to VBA
Modifying Table Structures
Creating Queries
Aggregation Queries
Getting to Know Access
Macros on Forms
Parameter Queries
Creating a Relational Database
Relational Database Design
Modifying Forms
Setting Table Relationships
Calculations in Queries
Designing a Lookup Database
Understanding VBA
Email us about this courses
Other Abergavenny Enable Technology Training Courses
Oracle SQL - Abergavenny SQL Training Courses
SQL Abergavenny Training Courses
Excel Power Pivot - Abergavenny Excel Training Courses
JavaScript - Abergavenny JavaScript Training Courses
VBA Abergavenny Training Courses
SSIS Abergavenny Training Courses