ACCESS TRAINING COURSES DEVON
About Enable Technology Devon Access Training Courses
Enable Technology provides practical Access skills based technology training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant will receives course practice files and Access course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We are set up to deliver Access training courses onsite at your premises. Another way we could deliver the Access course is at a local training site. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Countrywide Homes Limited, Fujistu PLC, Birmingham City University, Boots UK Limited, Norwich Union PLC, South Staffordshire Water PLC, University of Birmingham and Loughborough University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Devon
- 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 ... Working with Variable Lifetime
- See Training Course Details...
Debugging Code
Understanding Control-of-Flow Structures
Working with Events
Understanding Data Types
Understanding Collections
Setting Break Expressions
Working with the ADODB Recordset Object
Using Break Mode during Run Mode
Using Intrinsic Functions
Specifying a Recordset Cursor Location - Optional
Trapping Errors with the On Error Statement
Working with Boolean Expressions
Working with the Application Object
Understanding the Development Environment
Using the Object Browser
Determining the Value of Expressions
Understanding Procedures
Creating a Standard Module
Understanding the Err Object
Understanding Constants
Microsoft Access
- 2 day course
- Location: Devon
- 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 ... Creating Queries
- See Training Course Details...
Data Validation
Database Security
Working With Records
Adding Records to a Table
Sorting and Filtering
Creating and Using Reports
Creating a Lookup Database
Creating and Using Forms
Modifying Table Structures
Action Queries
Modifying Forms
Querying Techniques
Creating and Using Macros
Adding Transactional Records
Creating a Relational Database
An Introduction to VBA
Aggregation Queries
Macro Techniques
Database Wellness
Macros on Forms
Email us about this courses
Other Devon Enable Technology Training Courses
Oracle SQL Devon Training Courses
SQL - Devon SQL Training Courses
Power BI Devon Training Courses
Excel 365 Advanced - Devon Excel Training Courses
TSQL Devon Training Courses
SSRS Devon Training Courses