ACCESS TRAINING COURSES CHIPPENHAM
About Enable Technology Chippenham Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Each course participant will be issued with training Access resources which they can continue to use after the training. 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 deliver at your premises. We can provide the equipment. We also offer the option of scheduling of Access course at a venue near you in Chippenham. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Total Telecommunications Limited, Yell Group PLC, EDF Energy PLC, Royal Air Force, Birmingham City University, Norfolk Police Constabulary, Shell UK Oil Products Ltd and Fujistu PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Chippenham
- 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 ... Using the CacheSize Property - Optional
- See Training Course Details...
Introduction to Programming in Access
Understanding the Form Object
Understanding Recordset Cursor Properties - Optional
Setting Breakpoints
Using Debugging Tools
Specifying a Recordset Cursor Location - Optional
Working with the ADODB Recordset Object
Understanding Error Handling
Using the Do...Loop Structure
Working with the Code Editor
Understanding VBA's Error Trapping Options
Creating a Standard Module
Creating a Sub Procedure
Working with the Application Object
Handling Errors
Using Visual Basic Help
Understanding Classes and Objects
Using Intrinsic Constants
Understanding the Err Object
Microsoft Access
- 2 day course
- Location: Chippenham
- 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...
Parameter Queries
Modifying Forms
DIY Forms
Database Security
Creating and Using Forms
Data Validation
Importing and Exporting Records
Adding Transactional Records
Macro Techniques
Creating a Relational Database
Database Wellness
Aggregation Queries
Creating and Using Reports
Using a Navigation Form
Relational Database Design
Calculations in Queries
Working With Records
Formatting Tables
Designing a Lookup Database
Getting to Know Access
Email us about this courses
Other Chippenham Enable Technology Training Courses
PL/SQL - Chippenham SQL Training Courses
VBA - Chippenham Excel Training Courses
Excel 365 Advanced Chippenham Training Courses
Data Warehouse - Chippenham SQL Training Courses
Report Builder - Chippenham SQL Server Reporting Services Training Courses
TSQL - Chippenham SQL Training Courses