ACCESS TRAINING COURSES LANCASHIRE
About Enable Technology Lancashire Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The tutor delivering the course will be a Microsoft certified expert. We will issue each Access training participant with learning resources which they can refer to post training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Enable Technology training courses are delivered as instructor led courses. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another option is we can organise a local socially distanced training site in Lancashire. 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 course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: National Power PLC, Nationwide Building Society Limited, GKN PLC, Canadian High Commission, Queen's Medical Centre Nottingham, Barclays Bank PLC, Boots UK Limited and Vodafone Group Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Lancashire
- 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 ... Creating a Standard Module
- See Training Course Details...
Using Visual Basic Help
Understanding the DoCmd Object
Understanding Control-of-Flow Structures
Understanding Modules
Working with Procedures and Functions
Naming Procedures
Working with the Application Object
Using the Immediate Window to Call Procedures
Declaring and Creating Object Variables
Understanding Constants
Understanding the Err Object
Using Debugging Tools
Working with Events
Trapping Errors with the On Error Statement
Controlling Program Execution
Using the Object Browser
Using the For...Next Structure
Understanding Expressions and Statements
Calling Procedures
Microsoft Access
- 2 day course
- Location: Lancashire
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... An Introduction to VBA
- See Training Course Details...
Sorting and Filtering
Creating and Using Forms
Using a Navigation Form
Database Wellness
Importing and Exporting Records
Querying Techniques
Setting Table Relationships
Macros on Forms
Designing a Lookup Database
Action Queries
Data Validation
Calculations in Queries
Navigation Pane Protection
Aggregation Queries
Macro Techniques
Creating Queries
Database Security
DIY Forms
Multi Table Queries
Understanding VBA
Email us about this courses
Other Lancashire Enable Technology Training Courses
Oracle SQL Lancashire Training Courses
Excel 365 Advanced - Lancashire Excel Training Courses
SSRS Lancashire Training Courses
Excel Power Pivot - Lancashire Excel Training Courses
SQL - Lancashire SQL Training Courses
Report Builder Lancashire Training Courses