ACCESS TRAINING COURSES MID GLAMORGAN
About Enable Technology Mid Glamorgan Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Professionals. All candidates receive comprehensive Access training materials and practice files which are theirs to 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. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We are also more than happy to organise a local course at a socially distanced training location in Mid Glamorgan. We are happy to discuss customising the course content should you have particular Access training 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.
Our teaching team have over twenty years continuous technical training experience. Our clients include: University of Birmingham, Norfolk Police Constabulary, DHL Express, Shell UK Oil Products Ltd, Halfords Group PLC, Capita Group PLC, GKN PLC and Lloyds TSB Bank PLC.
Microsoft Access
- 2 day course
- Location: Mid Glamorgan
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Sorting and Filtering
- See Training Course Details...
Setting Table Relationships
Creating a Relational Database
Creating and Using Reports
Creating and Using Macros
Adding Transactional Records
Understanding VBA
Importing and Exporting Records
Designing a Lookup Database
Navigation Pane Protection
Aggregation Queries
Data Validation
Creating and Using Forms
Adding Records to a Table
Using a Navigation Form
Creating a Lookup Database
Querying Techniques
Parameter Queries
Macro Techniques
Calculations in Queries
An Introduction to VBA
Microsoft Access Programming Using VBA
- 3 day course
- Location: Mid Glamorgan
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Using Message Boxes
- See Training Course Details...
Understanding Classes and Objects
Understanding the Order of Events
Using Expressions, Variables, and Intrinsic Functions
Working with the ADODB Recordset Object
Working with Boolean Expressions
Working with Methods
Using Debugging Tools
Navigating the Access Object Hierarchy
Setting Break Expressions
Setting Breakpoints
Using the CacheSize Property - Optional
Working with Properties
Using Intrinsic Functions
Using the Object Browser
Understanding the Development Environment
Using the For Each...Next Structure
Determining the Value of Expressions
Declaring Variables
Organizing Code and Procedures
Email us about this courses
Other Mid Glamorgan Enable Technology Training Courses
Excel 365 Advanced Mid Glamorgan Training Courses
Data Warehouse - Mid Glamorgan SQL Training Courses
Excel 365 Intermediate Mid Glamorgan Training Courses
Excel Power Pivot Mid Glamorgan Training Courses
VBA - Mid Glamorgan Excel Training Courses
JQuery Mobile Mid Glamorgan Training Courses