ACCESS TRAINING COURSES MACCLESFIELD
About Enable Technology Macclesfield Access Training Courses
Enable Technology specialise in succinct skills based Access training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). 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.
Courses are instructor led and groups sizes small. 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. Alternatively we could schedule a course at a local socially distanced venue in Macclesfield. 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.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Halfords Group PLC, Loughborough University, Keele University, Dollond & Aitchison Limited, Norwich Union PLC, Nuclear Engineering Services, Shell UK Oil Products Ltd and Total Telecommunications Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Macclesfield
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Understanding Classes and Objects
- See Training Course Details...
Setting Break Expressions
Working with Inline Error Handling
Declaring and Creating Object Variables
Understanding Control-of-Flow Structures
Trapping Errors with the On Error Statement
Understanding Error Handling
Declaring Variables
Understanding Collections
Understanding the Development Environment
Debugging Code
Handling Errors
Understanding the Order of Events
Understanding VBA's Error Trapping Options
Using the Do...Loop Structure
Understanding Recordset Cursor Properties - Optional
Guidelines for use of Branching Structures
Understanding Expressions and Statements
Using the Select Case...End Select Structure
Microsoft Access
- 2 day course
- Location: Macclesfield
- 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 ... Adding Records to a Table
- See Training Course Details...
Navigation Pane Protection
Data Validation
Multi Table Queries
Setting Table Relationships
Sorting and Filtering
Creating Queries
Creating and Using Macros
Calculations in Queries
Relational Database Design
Adding Transactional Records
Importing and Exporting Records
Macros on Forms
Modifying Forms
Creating a Lookup Database
Creating and Using Forms
DIY Forms
Understanding VBA
Parameter Queries
Database Wellness
Formatting Tables
Email us about this courses
Other Macclesfield Enable Technology Training Courses
SSAS Macclesfield Training Courses
Power BI Macclesfield Training Courses
SSRS - Macclesfield SQL Server Reporting Services Training Courses
SQL Macclesfield Training Courses
SSAS Tabular Macclesfield Training Courses
Oracle SQL Macclesfield Training Courses