ACCESS TRAINING COURSES ABERTILLERY
About Enable Technology Abertillery Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each course participant will be issued with training Access resources which they can continue to use after the training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
We provide instructor led training coupled with hands on training. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. If you prefer we can offer an offsite training location in Abertillery. We are happy to modify the Access syllabus to match your teams training 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 Queen's Medical Centre Nottingham, Dollond & Aitchison Limited, Unipart Group, Royal & Sun Alliance Group PLC, Yell Group PLC, Shell UK Oil Products Ltd, Carillion PLC and Fujistu PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Abertillery
- 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 ... Understanding Error Handling
- See Training Course Details...
Debugging Code
Working with Variable Scope
Using Expressions, Variables, and Intrinsic Functions
Using Visual Basic Help
Using the Immediate Window to Call Procedures
Using the CacheSize Property - Optional
Using Intrinsic Constants
Understanding Procedures
Using Message Boxes
Introduction to Programming in Access
Working with the ADODB Recordset Object
Navigating the Access Object Hierarchy
Understanding Constants
Understanding the Order of Events
Understanding VBA's Error Trapping Options
Determining the Value of Expressions
Microsoft Access
- 2 day course
- Location: Abertillery
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Understanding VBA
- See Training Course Details...
Navigation Pane Protection
Importing and Exporting Records
Calculations in Queries
Creating and Using Forms
Setting Table Relationships
Working With Records
Multi Table Queries
Macro Techniques
Creating a Relational Database
Aggregation Queries
Creating Queries
Creating and Using Reports
Creating and Using Macros
Adding Records to a Table
Action Queries
Creating a Lookup Database
Macros on Forms
Database Wellness
Getting to Know Access
Using a Navigation Form
Email us about this courses
Other Abertillery Enable Technology Training Courses
TSQL - Abertillery SQL Training Courses
Excel 365 Advanced - Abertillery Excel Training Courses
Excel 365 Basic - Abertillery Excel Training Courses
Data Warehouse - Abertillery SQL Training Courses
VBA Abertillery Training Courses
JQuery Mobile Abertillery Training Courses