ACCESS TRAINING COURSES AMMANFORD
About Enable Technology Ammanford Access Training Courses
Enable Technology specialise in succinct skills based Access training. All Enable Technology tutors are Microsoft certified experts. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can bring the equipment necessary to deliver Access courses at your site. Alternatively we could schedule a Access course at an alternative training site in Ammanford. We are happy to discuss customising the course content should you have particular Access training requirements.
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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Cadbury PLC, Yell Group PLC, TalkTalk Direct Limited, Norwich Union PLC, Nationwide Building Society Limited, Total Telecommunications Limited, West Bromwich Building Society and Keele University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Ammanford
- 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 ... Determining the Value of Expressions
- See Training Course Details...
Guidelines for use of Branching Structures
Understanding Objects
Declaring and Creating Object Variables
Creating a Function Procedure
Using the CacheSize Property - Optional
Working with the ADODB Recordset Object
Understanding Recordset Cursor Properties - Optional
Using the Select Case...End Select Structure
Working with Procedures and Functions
Working with the Application Object
Understanding Data Types
Specifying a Recordset Cursor Location - Optional
Working with the Code Editor
Working with Inline Error Handling
Introduction to Programming in Access
Why Program in Access?
Understanding the Err Object
Using Visual Basic Help
Understanding Expressions and Statements
Trapping Errors with the On Error Statement
Microsoft Access
- 2 day course
- Location: Ammanford
- 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 ... Adding Records to a Table
- See Training Course Details...
Creating a Lookup Database
Data Validation
Macros on Forms
Creating and Using Forms
Formatting Tables
Action Queries
Sorting and Filtering
Setting Table Relationships
Understanding VBA
DIY Forms
Parameter Queries
Using a Navigation Form
Aggregation Queries
Calculations in Queries
Relational Database Design
Database Wellness
Creating and Using Macros
Macro Techniques
Adding Transactional Records
Querying Techniques
Email us about this courses
Other Ammanford Enable Technology Training Courses
TSQL - Ammanford SQL Training Courses
JQuery Mobile Ammanford Training Courses
JQuery Ammanford Training Courses
DAX Ammanford Training Courses
Excel 365 Basic Ammanford Training Courses
SSIS - Ammanford SQL Server Integration Services Training Courses