ACCESS TRAINING COURSES WIGAN
About Enable Technology Wigan Access Training Courses
Enable Technology specialise in succinct skills based Access training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We provide every candidate with Access training materials which they keep after the course. 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 offers instructor led training taught by technology specialists. We are set up to deliver Access training courses onsite at your premises. Alternatively we could schedule a course at a local venue in Wigan. We are happy to discuss customising the course content should you have particular Access training 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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Birmingham City Council, Shell UK Oil Products Ltd, Canadian High Commission, Cadbury PLC, Lloyds TSB Bank PLC, TalkTalk Direct Limited, Keele University and National Power PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wigan
- 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 ... Using Break Mode during Run Mode
- See Training Course Details...
Working with Recordsets
Using the CacheSize Property - Optional
Navigating the Access Object Hierarchy
Working with Events
Working with the Application Object
Understanding the Err Object
Using the Select Case...End Select Structure
Using the Do...Loop Structure
Using Expressions, Variables, and Intrinsic Functions
Using Debugging Tools
Understanding VBA's Error Trapping Options
Understanding Expressions and Statements
Understanding Data Types
Creating a Sub Procedure
Declaring and Creating Object Variables
Working with the ADODB Recordset Object
Understanding Modules
Locking Records for Updating
Working with Boolean Expressions
Microsoft Access
- 2 day course
- Location: Wigan
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Creating Queries
- See Training Course Details...
Understanding VBA
Creating a Lookup Database
Modifying Table Structures
DIY Forms
Querying Techniques
Using a Navigation Form
Database Wellness
Importing and Exporting Records
Getting to Know Access
Setting Table Relationships
Aggregation Queries
Formatting Tables
Data Validation
Modifying Forms
Relational Database Design
An Introduction to VBA
Working With Records
Designing a Lookup Database
Navigation Pane Protection
Multi Table Queries
Email us about this courses
Other Wigan Enable Technology Training Courses
Data Warehouse - Wigan SQL Training Courses
Excel 365 Advanced - Wigan Excel Training Courses
VBA Wigan Training Courses
Oracle SQL Wigan Training Courses
Report Builder Wigan Training Courses
SQL Wigan Training Courses