ACCESS TRAINING COURSES DURHAM
About Enable Technology Durham Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every person attending a Access course will be provided with training materials and practice files to retain after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Enable Technology training courses are delivered as instructor led courses. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. The Access course could also be scheduled at a socially distanced site near you in Durham. Every Access course can be modified to meet your bespoke 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.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are South Staffordshire Water PLC, Dollond & Aitchison Limited, Yell Group PLC, Royal & Sun Alliance Group PLC, University of Birmingham, Countrywide Homes Limited, GKN PLC and Unipart Group.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Durham
- 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 ... Considering Variable Scope and Lifetime Together
- See Training Course Details...
Debugging Code
Understanding Data Types
Controlling Program Execution
Working with the ADODB Recordset Object
Using the For Each...Next Structure
Understanding the Order of Events
Setting Breakpoints
Working with Inline Error Handling
Understanding VBA's Error Trapping Options
Using the For...Next Structure
Understanding the Development Environment
Using Break Mode during Run Mode
Introduction to Programming in Access
Naming Procedures
Working with Properties
Understanding Collections
Declaring and Creating Object Variables
Using Input Boxes
Understanding the Err Object
Microsoft Access
- 2 day course
- Location: Durham
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Adding Records to a Table
- See Training Course Details...
Creating a Lookup Database
Setting Table Relationships
Modifying Table Structures
Querying Techniques
Calculations in Queries
Creating Queries
Designing a Lookup Database
Creating and Using Macros
DIY Forms
Creating and Using Reports
Database Security
Getting to Know Access
Multi Table Queries
Parameter Queries
Sorting and Filtering
An Introduction to VBA
Macros on Forms
Aggregation Queries
Importing and Exporting Records
Modifying Forms
Email us about this courses
Other Durham Enable Technology Training Courses
TSQL - Durham SQL Training Courses
Report Builder Durham Training Courses
VBA - Durham Excel Training Courses
SSAS Durham Training Courses
SQL - Durham SQL Training Courses
Data Warehouse Durham Training Courses