ACCESS TRAINING COURSES DUDLEY
About Enable Technology Dudley Access Training Courses
Enable Technology offer short intensive skills based Access training courses. We guarantee the training will be delivered by a Microsoft certified expert. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to 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. 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 course at a local socially distanced venue in Dudley. We are happy to modify the Access syllabus to match your teams training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
We have operated primarily in the West Midlands for twenty years. Our clients include: Norfolk Police Constabulary, Lloyds TSB Bank PLC, Queen's Medical Centre Nottingham, Keele University, Royal & Sun Alliance Group PLC, Carillion PLC, Royal Air Force and South Staffordshire Water PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Dudley
- 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 ... Using Input Boxes
- See Training Course Details...
Understanding Error Handling
Working with Properties
Creating a Function Procedure
Guidelines for use of Branching Structures
Understanding the Form Object
Locking Records for Updating
Why Program in Access?
Organizing Code and Procedures
Using the Select Case...End Select Structure
Writing an Error-Handling Routine
Navigating the Access Object Hierarchy
Handling Errors
Specifying a Recordset Cursor Location - Optional
Understanding Data Types
Calling Procedures
Stepping through Code
Using the CacheSize Property - Optional
Working with Inline Error Handling
Understanding Classes and Objects
Microsoft Access
- 2 day course
- Location: Dudley
- 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 ... Macro Techniques
- See Training Course Details...
Creating Queries
DIY Forms
Data Validation
Working With Records
Database Wellness
Setting Table Relationships
Importing and Exporting Records
Creating a Relational Database
Relational Database Design
Querying Techniques
Getting to Know Access
Macros on Forms
Creating and Using Macros
Action Queries
Formatting Tables
Using a Navigation Form
Modifying Forms
Modifying Table Structures
Navigation Pane Protection
Database Security
Email us about this courses
Other Dudley Enable Technology Training Courses
Power Query - Dudley Excel Training Courses
Excel 365 Intermediate Dudley Training Courses
DAX - Dudley Excel Training Courses
SSIS Dudley Training Courses
SSAS Dudley Training Courses
Excel Power Pivot - Dudley Excel Training Courses