ACCESS TRAINING COURSES YSTRAD MYNACH
About Enable Technology Ystrad Mynach Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). 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.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Another option is we can organise a local socially distanced training site in Ystrad Mynach. The Access syllabus can be modified to accommodate your specific training needs.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to 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 Keele University, Barclays Bank PLC, Vodafone Group Services, Canadian High Commission, GKN PLC, Fujistu PLC, Nuclear Engineering Services and Halfords Group PLC.
Microsoft Access
- 2 day course
- Location: Ystrad Mynach
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Relational Database Design
- See Training Course Details...
Using a Navigation Form
Sorting and Filtering
Database Security
Aggregation Queries
Formatting Tables
Navigation Pane Protection
Parameter Queries
Creating and Using Reports
Modifying Forms
Importing and Exporting Records
Creating and Using Macros
Adding Records to a Table
Adding Transactional Records
DIY Forms
Designing a Lookup Database
Macro Techniques
Data Validation
Working With Records
Creating a Relational Database
Multi Table Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Ystrad Mynach
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Understanding Modules
- See Training Course Details...
Understanding VBA's Error Trapping Options
Working with Methods
Working with Procedures and Functions
Understanding Recordset Cursor Properties - Optional
Creating a Function Procedure
Working with Events
Debugging Code
Declaring Variables
Understanding Errors
Working with Variable Lifetime
Locking Records for Updating
Using the For...Next Structure
Understanding Expressions and Statements
Understanding the Form Object
Guidelines for use of Branching Structures
Writing an Error-Handling Routine
Understanding the Err Object
Understanding Constants
Working with the Application Object
Declaring and Creating Object Variables
Email us about this courses
Other Ystrad Mynach Enable Technology Training Courses
Power BI - Ystrad Mynach Microsoft Power BI Training Courses
Data Warehouse Ystrad Mynach Training Courses
Oracle SQL - Ystrad Mynach SQL Training Courses
JQuery Ystrad Mynach Training Courses
Excel Power Pivot - Ystrad Mynach Excel Training Courses
VBA Ystrad Mynach Training Courses