ACCESS TRAINING COURSES LLANELLI
About Enable Technology Llanelli Access Training Courses
We offer intensive two and three days Access 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. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Access courses are taught by a Microsoft Certified Solutions Expert. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If you prefer we can offer an offsite training location in Llanelli. The Access syllabus can be adjusted and additional topics incorporated if helpful.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Birmingham City University, Queen's Medical Centre Nottingham, Lloyds TSB Bank PLC, Wolverhampton City Council, Birmingham Heartlands Hospital, GKN PLC, Countrywide Homes Limited and Nuclear Engineering Services.
Microsoft Access
- 2 day course
- Location: Llanelli
- 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 ... Relational Database Design
- See Training Course Details...
Creating a Relational Database
Database Wellness
Creating and Using Reports
Understanding VBA
Modifying Table Structures
Parameter Queries
Working With Records
Creating Queries
Importing and Exporting Records
Multi Table Queries
Formatting Tables
Creating and Using Macros
Calculations in Queries
Sorting and Filtering
Action Queries
Macros on Forms
Designing a Lookup Database
An Introduction to VBA
Database Security
DIY Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Llanelli
- 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 the Do...Loop Structure
- See Training Course Details...
Creating a Standard Module
Declaring Variables
Why Program in Access?
Working with Boolean Expressions
Understanding Control-of-Flow Structures
Working with Recordsets
Understanding Modules
Understanding Error Handling
Controlling Program Execution
Understanding the Order of Events
Understanding Classes and Objects
Using Input Boxes
Using the For...Next Structure
Understanding Expressions and Statements
Handling Errors
Using the For Each...Next Structure
Specifying a Recordset Cursor Type
Considering Variable Scope and Lifetime Together
Email us about this courses
Other Llanelli Enable Technology Training Courses
JQuery - Llanelli JavaScript Training Courses
DAX - Llanelli Excel Training Courses
Report Builder - Llanelli SQL Server Reporting Services Training Courses
SSAS - Llanelli SQL Server Analysis Services Training Courses
Excel 365 Advanced - Llanelli Excel Training Courses
SSIS - Llanelli SQL Server Integration Services Training Courses