ACCESS TRAINING COURSES WALSALL
About Enable Technology Walsall Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The training will be delivered by a Microsoft professional with development experience. 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.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. 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 option is we can organise a local socially distanced training site in Walsall. All Access courses can be customised to meet your particular requirements.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We have operated primarily in the West Midlands for twenty years. Some of our clients are West Bromwich Building Society, TalkTalk Direct Limited, Boots UK Limited, Halfords Group PLC, Keele University, Nuclear Engineering Services, GKN PLC and Birmingham City Council.
Microsoft Access
- 2 day course
- Location: Walsall
- Telephone on 01952 938014
- 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 ... Creating and Using Reports
- See Training Course Details...
Creating and Using Forms
DIY Forms
Macros on Forms
Calculations in Queries
Working With Records
Creating and Using Macros
Data Validation
Setting Table Relationships
Database Wellness
Creating Queries
Formatting Tables
Creating a Relational Database
Navigation Pane Protection
Action Queries
Querying Techniques
Understanding VBA
Modifying Table Structures
Adding Transactional Records
Modifying Forms
Getting to Know Access
Microsoft Access Programming Using VBA
- 3 day course
- Location: Walsall
- 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 Classes and Objects
- See Training Course Details...
Working with Properties
Understanding VBA's Error Trapping Options
Stepping through Code
Using the For Each...Next Structure
Why Program in Access?
Setting Break Expressions
Trapping Errors with the On Error Statement
Understanding the Err Object
Creating a Function Procedure
Locking Records for Updating
Understanding the Development Environment
Using Debugging Tools
Understanding Error Handling
Understanding Procedures
Using Message Boxes
Understanding Control-of-Flow Structures
Working with Variable Lifetime
Specifying a Recordset Cursor Location - Optional
Navigating the Access Object Hierarchy
Email us about this courses
Other Walsall Enable Technology Training Courses
Excel 365 Intermediate Walsall Training Courses
Excel 365 Advanced - Walsall Excel Training Courses
DAX - Walsall Excel Training Courses
Report Builder - Walsall SQL Server Reporting Services Training Courses
Data Warehouse Walsall Training Courses
SSAS Walsall Training Courses