ACCESS TRAINING COURSES AMMANFORD
About Enable Technology Ammanford Access Training Courses
Enable Technology provides practical Access skills based technology training. 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. 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.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another way we could deliver the Access course is at a local socially distanced training site. All Access courses can be customised to meet your particular requirements.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Homeserve PLC, Carillion PLC, Loughborough University, Canadian High Commission, Norwich Union PLC, Lloyds TSB Bank PLC, Barclays Bank PLC and University of Birmingham.
Microsoft Access
- 2 day course
- Location: Ammanford
- 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 ... Data Validation
- See Training Course Details...
Modifying Forms
Creating and Using Macros
Getting to Know Access
Creating Queries
Database Wellness
An Introduction to VBA
Navigation Pane Protection
Importing and Exporting Records
Creating and Using Reports
Adding Records to a Table
Multi Table Queries
Parameter Queries
Understanding VBA
Modifying Table Structures
Designing a Lookup Database
Action Queries
Formatting Tables
Macro Techniques
Adding Transactional Records
Creating a Lookup Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: Ammanford
- 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 ... Working with Methods
- See Training Course Details...
Using Intrinsic Functions
Using the For Each...Next Structure
Understanding VBA's Error Trapping Options
Understanding Errors
Working with Inline Error Handling
Using the With Statement
Writing an Error-Handling Routine
Understanding Data Types
Creating a Standard Module
Naming Procedures
Calling Procedures
Understanding the Order of Events
Understanding Error Handling
Creating a Function Procedure
Using the Immediate Window to Call Procedures
Understanding Control-of-Flow Structures
Locking Records for Updating
Using the Object Browser
Email us about this courses
Other Ammanford Enable Technology Training Courses
Power BI - Ammanford Microsoft Power BI Training Courses
SSAS Ammanford Training Courses
SSAS Tabular - Ammanford SQL Server Analysis Services Training Courses
Oracle SQL Ammanford Training Courses
Data Warehouse Ammanford Training Courses
SQL Ammanford Training Courses