ACCESS TRAINING COURSES ASHTON-UNDER-LYNE
About Enable Technology Ashton-under-lyne Access Training Courses
We have a twenty year history of providing skills based Access industry training. The tutor delivering the course will be a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Enable Technology offers instructor led training taught by technology specialists. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a Access course at an alternative training site in Ashton-under-lyne. We are happy to discuss customising the course content should you have particular Access training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Shell UK Oil Products Ltd, Lloyds TSB Bank PLC, Carillion PLC, Barclays Bank PLC, Total Telecommunications Limited, University of Birmingham, Royal & Sun Alliance Group PLC and GKN PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Ashton-under-lyne
- 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 ... Using Break Mode during Run Mode
- See Training Course Details...
Working with Events
Navigating the Access Object Hierarchy
Understanding the DoCmd Object
Creating a Standard Module
Understanding Collections
Understanding Objects
Understanding Error Handling
Declaring and Creating Object Variables
Understanding the Order of Events
Understanding the Form Object
Guidelines for use of Branching Structures
Why Program in Access?
Using Visual Basic Help
Trapping Errors with the On Error Statement
Using the For...Next Structure
Working with the ADODB Recordset Object
Using the Select Case...End Select Structure
Microsoft Access
- 2 day course
- Location: Ashton-under-lyne
- 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 ... Setting Table Relationships
- See Training Course Details...
Creating a Lookup Database
Creating and Using Forms
Designing a Lookup Database
Parameter Queries
Data Validation
Querying Techniques
Creating and Using Macros
Relational Database Design
Multi Table Queries
Sorting and Filtering
Creating and Using Reports
An Introduction to VBA
Creating Queries
Macro Techniques
Formatting Tables
Using a Navigation Form
DIY Forms
Importing and Exporting Records
Working With Records
Calculations in Queries
Email us about this courses
Other Ashton-under-lyne Enable Technology Training Courses
JavaScript Ashton-under-lyne Training Courses
JQuery Mobile Ashton-under-lyne Training Courses
Oracle SQL Ashton-under-lyne Training Courses
TSQL - Ashton-under-lyne SQL Training Courses
Data Warehouse - Ashton-under-lyne SQL Training Courses
JQuery Ashton-under-lyne Training Courses