ACCESS TRAINING COURSES SKELMERSDALE
About Enable Technology Skelmersdale Access Training Courses
We offer intensive two and three days Access courses. The training will be delivered by a Microsoft professional with development experience. 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. If you prefer we can offer an offsite socially distanced training location in Skelmersdale. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are West Bromwich Building Society, GKN PLC, Vodafone Group Services, Nuclear Engineering Services, Birmingham Heartlands Hospital, Unipart Group, Cadbury PLC and Royal & Sun Alliance Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Skelmersdale
- 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 ... Understanding Errors
- See Training Course Details...
Understanding Error Handling
Working with Events
Understanding Classes and Objects
Understanding Constants
Understanding Collections
Understanding Data Types
Declaring and Creating Object Variables
Determining the Value of Expressions
Considering Variable Scope and Lifetime Together
Using Debugging Tools
Stepping through Code
Why Program in Access?
Using Expressions, Variables, and Intrinsic Functions
Setting Breakpoints
Working with the ADODB Recordset Object
Declaring Variables
Understanding Procedures
Using Intrinsic Functions
Introduction to Programming in Access
Microsoft Access
- 2 day course
- Location: Skelmersdale
- 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 ... Setting Table Relationships
- See Training Course Details...
Querying Techniques
Creating and Using Reports
Modifying Forms
Calculations in Queries
Creating a Lookup Database
Adding Transactional Records
Parameter Queries
Using a Navigation Form
Designing a Lookup Database
Relational Database Design
Sorting and Filtering
DIY Forms
An Introduction to VBA
Importing and Exporting Records
Modifying Table Structures
Macro Techniques
Creating and Using Forms
Macros on Forms
Database Security
Multi Table Queries
Email us about this courses
Other Skelmersdale Enable Technology Training Courses
JQuery Skelmersdale Training Courses
SSAS Skelmersdale Training Courses
Excel 365 Intermediate Skelmersdale Training Courses
Power Query - Skelmersdale Excel Training Courses
SSRS Skelmersdale Training Courses
SQL - Skelmersdale SQL Training Courses