ACCESS TRAINING COURSES WARRINGTON
About Enable Technology Warrington Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). We provide every candidate with Access training materials which they keep after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Our primary method of delivery is instructor led training coupled with practical hands on activities. 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 training site in Warrington. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Total Telecommunications Limited, Barclays Bank PLC, DHL Express, National Power PLC, Fujistu PLC, Dollond & Aitchison Limited, Birmingham City University and Cadbury PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Warrington
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Understanding Errors
- See Training Course Details...
Using the Object Browser
Specifying a Recordset Cursor Location - Optional
Using Visual Basic Help
Working with the Code Editor
Why Program in Access?
Calling Procedures
Using Input Boxes
Understanding VBA's Error Trapping Options
Determining the Value of Expressions
Declaring Variables
Working with Inline Error Handling
Working with Recordsets
Setting Breakpoints
Understanding the Err Object
Working with Variable Lifetime
Using the Select Case...End Select Structure
Naming Procedures
Understanding the DoCmd Object
Microsoft Access
- 2 day course
- Location: Warrington
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Creating Queries
- See Training Course Details...
Navigation Pane Protection
Querying Techniques
Creating and Using Macros
Setting Table Relationships
Macros on Forms
Getting to Know Access
Modifying Forms
Macro Techniques
Action Queries
Creating and Using Forms
Creating a Lookup Database
Using a Navigation Form
Parameter Queries
Relational Database Design
Adding Records to a Table
Database Security
Creating a Relational Database
Data Validation
Designing a Lookup Database
Database Wellness
Email us about this courses
Other Warrington Enable Technology Training Courses
Excel 365 Basic Warrington Training Courses
Report Builder Warrington Training Courses
SSRS Warrington Training Courses
Excel 365 Advanced - Warrington Excel Training Courses
JavaScript - Warrington JavaScript Training Courses
VBA - Warrington Excel Training Courses