ACCESS TRAINING COURSES CARMARTHEN
About Enable Technology Carmarthen Access Training Courses
Enable Technology specialise in succinct skills based Access training. The training will be delivered by a Microsoft professional with development experience. We will issue each Access training participant with learning resources which they can refer to post training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Enable Technology training courses are delivered as instructor led courses. We are set up to deliver Access training courses onsite at your premises. If you prefer we can offer an offsite socially distanced training location in Carmarthen. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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 operated primarily in the West Midlands for twenty years. Our clients include: Norwich Union PLC, Countrywide Homes Limited, Homeserve PLC, Vodafone Group Services, Nationwide Building Society Limited, Birmingham City University, Unipart Group and Canadian High Commission.
Microsoft Access
- 2 day course
- Location: Carmarthen
- 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 ... Getting to Know Access
- See Training Course Details...
Macros on Forms
Using a Navigation Form
Action Queries
Creating a Relational Database
Navigation Pane Protection
Querying Techniques
Creating and Using Reports
Working With Records
Modifying Forms
An Introduction to VBA
Sorting and Filtering
Parameter Queries
Data Validation
Aggregation Queries
Adding Transactional Records
Importing and Exporting Records
Calculations in Queries
Creating a Lookup Database
Modifying Table Structures
Database Wellness
Microsoft Access Programming Using VBA
- 3 day course
- Location: Carmarthen
- 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 ... Trapping Errors with the On Error Statement
- See Training Course Details...
Understanding Procedures
Using the Do...Loop Structure
Understanding the DoCmd Object
Considering Variable Scope and Lifetime Together
Understanding the Development Environment
Working with Recordsets
Using the CacheSize Property - Optional
Using the With Statement
Using the If...End If Decision Structures
Using the Select Case...End Select Structure
Specifying a Recordset Cursor Type
Locking Records for Updating
Declaring Variables
Using the For Each...Next Structure
Specifying a Recordset Cursor Location - Optional
Navigating the Access Object Hierarchy
Why Program in Access?
Debugging Code
Email us about this courses
Other Carmarthen Enable Technology Training Courses
JQuery Mobile - Carmarthen JavaScript Training Courses
Excel 365 Basic Carmarthen Training Courses
DAX Carmarthen Training Courses
Data Warehouse - Carmarthen SQL Training Courses
JavaScript - Carmarthen JavaScript Training Courses
Report Builder - Carmarthen SQL Server Reporting Services Training Courses