ACCESS TRAINING COURSES PUDSEY
About Enable Technology Pudsey Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The tutor delivering the course will be a Microsoft certified expert. Every course participant is given Access courseware which they can refer to after the 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.
Access courses are taught by a Microsoft Certified Solutions Expert. We can deliver at your premises. We can provide the equipment. 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.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
We have operated primarily in the West Midlands for twenty years. Some of our clients are Cadbury PLC, University of Birmingham, GKN PLC, Loughborough University, West Bromwich Building Society, Aston University, Birmingham City University and Norfolk Police Constabulary.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Pudsey
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Understanding the DoCmd Object
- See Training Course Details...
Using the With Statement
Working with Recordsets
Understanding Expressions and Statements
Using the Select Case...End Select Structure
Understanding Objects
Understanding Constants
Working with Variable Lifetime
Creating a Standard Module
Creating a Sub Procedure
Working with Variable Scope
Why Program in Access?
Using the For...Next Structure
Working with Inline Error Handling
Trapping Errors with the On Error Statement
Using the CacheSize Property - Optional
Understanding Procedures
Specifying a Recordset Cursor Type
Understanding Error Handling
Using Break Mode during Run Mode
Microsoft Access
- 2 day course
- Location: Pudsey
- 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 ... Creating and Using Forms
- See Training Course Details...
Parameter Queries
Creating and Using Macros
Creating a Relational Database
Designing a Lookup Database
Relational Database Design
Macro Techniques
Formatting Tables
DIY Forms
Using a Navigation Form
Setting Table Relationships
Navigation Pane Protection
Database Security
Multi Table Queries
Creating and Using Reports
Creating Queries
Working With Records
Importing and Exporting Records
Calculations in Queries
Modifying Forms
Getting to Know Access
Email us about this courses
Other Pudsey Enable Technology Training Courses
JQuery - Pudsey JavaScript Training Courses
Excel Power Pivot Pudsey Training Courses
SQL Pudsey Training Courses
DAX - Pudsey Excel Training Courses
Power Query Pudsey Training Courses
SSAS Pudsey Training Courses