ACCESS TRAINING COURSES HALIFAX
About Enable Technology Halifax Access Training Courses
We are a company that provides short intensive Access training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can deliver at your premises. We can provide the equipment. Another way we could deliver the Access course is at a local training site. We are happy to modify the Access syllabus to match your teams training requirements.
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.
Our teaching team have over twenty years continuous technical training experience. Our clients include: GKN PLC, South Staffordshire Water PLC, Homeserve PLC, Norfolk Police Constabulary, Royal Air Force, Nationwide Building Society Limited, TalkTalk Direct Limited and Fujistu PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Halifax
- 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 ... Understanding Error Handling
- See Training Course Details...
Understanding Modules
Working with the Code Editor
Working with Variable Scope
Navigating the Access Object Hierarchy
Declaring Variables
Creating a Sub Procedure
Using the CacheSize Property - Optional
Using Visual Basic Help
Declaring and Creating Object Variables
Setting Breakpoints
Working with the ADODB Recordset Object
Calling Procedures
Working with Recordsets
Creating a Function Procedure
Understanding Expressions and Statements
Understanding the DoCmd Object
Understanding VBA's Error Trapping Options
Using the With Statement
Microsoft Access
- 2 day course
- Location: Halifax
- 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 ... Action Queries
- See Training Course Details...
Adding Transactional Records
Modifying Table Structures
Designing a Lookup Database
Creating Queries
Getting to Know Access
Creating a Relational Database
An Introduction to VBA
Understanding VBA
Macros on Forms
Aggregation Queries
Formatting Tables
Calculations in Queries
Using a Navigation Form
Creating and Using Forms
Setting Table Relationships
Database Wellness
Parameter Queries
Modifying Forms
Working With Records
Data Validation
Email us about this courses
Other Halifax Enable Technology Training Courses
DAX - Halifax Excel Training Courses
Excel Power Pivot - Halifax Excel Training Courses
VBA Halifax Training Courses
Excel 365 Advanced - Halifax Excel Training Courses
SQL - Halifax SQL Training Courses
Power BI - Halifax Microsoft Power BI Training Courses