ACCESS TRAINING COURSES MERSEYSIDE
About Enable Technology Merseyside Access Training Courses
Enable Technology specialise in succinct skills based Access training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We provide every candidate with Access training materials which they keep after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Courses are instructor led and groups sizes small. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a course at a local venue in Merseyside. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your 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 been delivering technical training in the Midlands for twenty years. Our clients include: DHL Express, Dollond & Aitchison Limited, TalkTalk Direct Limited, Fujistu PLC, Queen's Medical Centre Nottingham, Keele University, Wolverhampton City Council and Yell Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Merseyside
- 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 ... Trapping Errors with the On Error Statement
- See Training Course Details...
Using Visual Basic Help
Considering Variable Scope and Lifetime Together
Understanding Control-of-Flow Structures
Using the For...Next Structure
Understanding Procedures
Understanding Recordset Cursor Properties - Optional
Debugging Code
Using the Select Case...End Select Structure
Calling Procedures
Understanding the DoCmd Object
Understanding Constants
Working with the ADODB Recordset Object
Using Expressions, Variables, and Intrinsic Functions
Working with Boolean Expressions
Setting Break Expressions
Using Input Boxes
Why Program in Access?
Introduction to Programming in Access
Locking Records for Updating
Microsoft Access
- 2 day course
- Location: Merseyside
- 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 and Using Forms
- See Training Course Details...
Designing a Lookup Database
Creating a Relational Database
Aggregation Queries
Importing and Exporting Records
Action Queries
Calculations in Queries
Relational Database Design
An Introduction to VBA
Working With Records
Data Validation
Macros on Forms
Formatting Tables
Creating and Using Macros
Understanding VBA
Navigation Pane Protection
Setting Table Relationships
Parameter Queries
Database Security
Macro Techniques
Creating and Using Reports
Email us about this courses
Other Merseyside Enable Technology Training Courses
JQuery - Merseyside JavaScript Training Courses
SSIS Merseyside Training Courses
SSAS Merseyside Training Courses
VBA Merseyside Training Courses
Excel 365 Advanced - Merseyside Excel Training Courses
Excel 365 Basic Merseyside Training Courses