ACCESS TRAINING COURSES SUNDERLAND
About Enable Technology Sunderland Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The tutor delivering the course will be a Microsoft certified expert. 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.
Courses are instructor led and groups sizes small. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If you prefer we can offer an offsite socially distanced training location in Sunderland. The Access syllabus can be modified to accommodate your specific training needs.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Carillion PLC, Yell Group PLC, Nationwide Building Society Limited, DHL Express, Royal Air Force, Keele University, Birmingham City Council and Dollond & Aitchison Limited.
Microsoft Access
- 2 day course
- Location: Sunderland
- 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 ... Understanding VBA
- See Training Course Details...
Calculations in Queries
Macros on Forms
Getting to Know Access
Creating a Relational Database
Setting Table Relationships
Creating and Using Reports
Modifying Table Structures
Importing and Exporting Records
Creating Queries
Navigation Pane Protection
Working With Records
Adding Records to a Table
DIY Forms
An Introduction to VBA
Multi Table Queries
Parameter Queries
Creating and Using Forms
Adding Transactional Records
Creating and Using Macros
Modifying Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Sunderland
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Understanding the Err Object
- See Training Course Details...
Working with Recordsets
Working with Methods
Understanding the Form Object
Using the Do...Loop Structure
Using the CacheSize Property - Optional
Working with Variable Scope
Using Expressions, Variables, and Intrinsic Functions
Understanding Control-of-Flow Structures
Using Debugging Tools
Handling Errors
Understanding Error Handling
Using the Select Case...End Select Structure
Introduction to Programming in Access
Organizing Code and Procedures
Specifying a Recordset Cursor Type
Navigating the Access Object Hierarchy
Understanding Objects
Email us about this courses
Other Sunderland Enable Technology Training Courses
JavaScript - Sunderland JavaScript Training Courses
Report Builder Sunderland Training Courses
Oracle SQL - Sunderland SQL Training Courses
JQuery - Sunderland JavaScript Training Courses
Power Query Sunderland Training Courses
SSAS Tabular Sunderland Training Courses