ACCESS TRAINING COURSES ASHTON-UNDER-LYNE
About Enable Technology Ashton-under-lyne Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Professionals. Every course participant will receives course practice files and Access course resources that can be referenced post training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Courses are instructor led and groups sizes small. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. Another way we could deliver the Access course is at a local socially distanced training site. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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 operated primarily in the West Midlands for twenty years. Some of our clients are Lloyds TSB Bank PLC, Total Telecommunications Limited, Norfolk Police Constabulary, Halfords Group PLC, Birmingham City University, West Bromwich Building Society, Royal Air Force and National Power PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Ashton-under-lyne
- Telephone on 01952 305730
- 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 the Select Case...End Select Structure
- See Training Course Details...
Understanding the Order of Events
Working with Variable Scope
Stepping through Code
Specifying a Recordset Cursor Location - Optional
Handling Errors
Using Intrinsic Constants
Calling Procedures
Understanding Recordset Cursor Properties - Optional
Using Input Boxes
Understanding Constants
Creating a Function Procedure
Controlling Program Execution
Understanding the Form Object
Using Expressions, Variables, and Intrinsic Functions
Working with Events
Working with the ADODB Recordset Object
Working with Methods
Creating a Sub Procedure
Microsoft Access
- 2 day course
- Location: Ashton-under-lyne
- Telephone on 01952 305730
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Adding Transactional Records
- See Training Course Details...
DIY Forms
Action Queries
Creating a Lookup Database
Modifying Table Structures
Navigation Pane Protection
Querying Techniques
Creating and Using Macros
Creating and Using Reports
Getting to Know Access
Designing a Lookup Database
Data Validation
Modifying Forms
Sorting and Filtering
An Introduction to VBA
Database Wellness
Using a Navigation Form
Aggregation Queries
Importing and Exporting Records
Formatting Tables
Relational Database Design
Email us about this courses
Other Ashton-under-lyne Enable Technology Training Courses
SSRS 2016 Ashton-under-lyne Training Courses
SSRS 2005 Ashton-under-lyne Training Courses
Power BI Ashton-under-lyne Training Courses
Excel Power Pivot - Ashton-under-lyne Excel Training Courses
Excel Advanced - Ashton-under-lyne Excel Training Courses
Excel Intermediate - Ashton-under-lyne Excel Training Courses