ACCESS TRAINING COURSES BIRKENHEAD
About Enable Technology Birkenhead Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Professionals. Each course participant will be issued with training Access resources which they can continue to use after the training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the Access course at a local training venue in Birkenhead. The Access syllabus can be modified to accommodate your specific 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. Our clients include: Nuclear Engineering Services, TalkTalk Direct Limited, Dollond & Aitchison Limited, Queen's Medical Centre Nottingham, Birmingham Heartlands Hospital, Vodafone Group Services, Yell Group PLC and Barclays Bank PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Birkenhead
- 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 ... Working with Inline Error Handling
- See Training Course Details...
Working with Events
Locking Records for Updating
Using Input Boxes
Specifying a Recordset Cursor Type
Trapping Errors with the On Error Statement
Understanding VBA's Error Trapping Options
Writing an Error-Handling Routine
Organizing Code and Procedures
Understanding Procedures
Why Program in Access?
Working with the Application Object
Debugging Code
Understanding Objects
Understanding the Development Environment
Understanding the Form Object
Creating a Sub Procedure
Working with the Code Editor
Considering Variable Scope and Lifetime Together
Microsoft Access
- 2 day course
- Location: Birkenhead
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Relational Database Design
- See Training Course Details...
Multi Table Queries
An Introduction to VBA
Creating Queries
Creating a Lookup Database
Setting Table Relationships
Querying Techniques
Macros on Forms
Calculations in Queries
Aggregation Queries
Modifying Table Structures
Modifying Forms
Using a Navigation Form
Data Validation
Macro Techniques
DIY Forms
Formatting Tables
Navigation Pane Protection
Action Queries
Working With Records
Sorting and Filtering
Email us about this courses
Other Birkenhead Enable Technology Training Courses
VBA Birkenhead Training Courses
SQL Birkenhead Training Courses
SSAS Tabular Birkenhead Training Courses
Excel 365 Intermediate - Birkenhead Excel Training Courses
SSAS - Birkenhead SQL Server Analysis Services Training Courses
Oracle SQL Birkenhead Training Courses