ACCESS TRAINING COURSES LANCASTER
About Enable Technology Lancaster Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The tutor delivering the course will be a Microsoft certified expert. All course participants are issued Access training manuals they can refer to after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a course at a local socially distanced venue in Lancaster. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Shell UK Oil Products Ltd, Norfolk Police Constabulary, Royal Air Force, Countrywide Homes Limited, Lloyds TSB Bank PLC, Fujistu PLC, Birmingham City Council and University of Birmingham.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Lancaster
- 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 ... Locking Records for Updating
- See Training Course Details...
Understanding Collections
Declaring Variables
Understanding Data Types
Working with Inline Error Handling
Using Break Mode during Run Mode
Understanding VBA's Error Trapping Options
Understanding the Form Object
Working with the Code Editor
Understanding Recordset Cursor Properties - Optional
Using the Immediate Window to Call Procedures
Writing an Error-Handling Routine
Understanding the Development Environment
Understanding Procedures
Using the Do...Loop Structure
Organizing Code and Procedures
Using Intrinsic Constants
Working with Procedures and Functions
Understanding Control-of-Flow Structures
Trapping Errors with the On Error Statement
Setting Breakpoints
Microsoft Access
- 2 day course
- Location: Lancaster
- 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 ... Creating a Relational Database
- See Training Course Details...
Setting Table Relationships
Adding Records to a Table
Creating a Lookup Database
DIY Forms
Querying Techniques
Data Validation
Relational Database Design
Understanding VBA
Macros on Forms
Aggregation Queries
Multi Table Queries
Importing and Exporting Records
Creating and Using Forms
Macro Techniques
Creating and Using Macros
Creating and Using Reports
Database Security
Creating Queries
Navigation Pane Protection
Getting to Know Access
Email us about this courses
Other Lancaster Enable Technology Training Courses
Excel 365 Intermediate Lancaster Training Courses
Oracle SQL - Lancaster SQL Training Courses
SSRS - Lancaster SQL Server Reporting Services Training Courses
SSAS Tabular Lancaster Training Courses
Report Builder Lancaster Training Courses
SSAS Lancaster Training Courses