ACCESS TRAINING COURSES CARMARTHEN
About Enable Technology Carmarthen Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant is given Access courseware which they can refer to after the 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 Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We also offer the option of scheduling of Access course at a venue near you in Carmarthen. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Countrywide Homes Limited, Queen's Medical Centre Nottingham, Keele University, TalkTalk Direct Limited, South Staffordshire Water PLC, Loughborough University, Canadian High Commission and Birmingham City University.
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 ... Creating a Function Procedure
- See Training Course Details...
Using the Do...Loop Structure
Working with the Application Object
Understanding the Form Object
Specifying a Recordset Cursor Type
Specifying a Recordset Cursor Location - Optional
Understanding Classes and Objects
Creating a Sub Procedure
Guidelines for use of Branching Structures
Locking Records for Updating
Understanding Procedures
Understanding Objects
Using Expressions, Variables, and Intrinsic Functions
Understanding Error Handling
Working with Variable Scope
Understanding VBA's Error Trapping Options
Understanding Expressions and Statements
Understanding the Development Environment
Using the CacheSize Property - Optional
Understanding the Order of Events
Using Message Boxes
Microsoft Access
- 2 day course
- Location: Carmarthen
- 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...
Multi Table Queries
Querying Techniques
Adding Transactional Records
Database Security
Calculations in Queries
Database Wellness
DIY Forms
Importing and Exporting Records
Macro Techniques
An Introduction to VBA
Designing a Lookup Database
Understanding VBA
Creating a Lookup Database
Parameter Queries
Creating and Using Reports
Navigation Pane Protection
Using a Navigation Form
Action Queries
Macros on Forms
Getting to Know Access
Email us about this courses
Other Carmarthen Enable Technology Training Courses
SSRS - Carmarthen SQL Server Reporting Services Training Courses
Excel 365 Intermediate - Carmarthen Excel Training Courses
SSIS Carmarthen Training Courses
Excel 365 Advanced Carmarthen Training Courses
PL/SQL - Carmarthen SQL Training Courses
VBA Carmarthen Training Courses