ACCESS TRAINING COURSES SOUTH SHIELDS
About Enable Technology South Shields Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The tutor delivering the course will be a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Access courses are taught by a Microsoft Certified Solutions Expert. We are set up to deliver Access training courses onsite at your premises. Another option is we can organise a local training site in South Shields. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: EDF Energy PLC, Royal & Sun Alliance Group PLC, Keele University, West Bromwich Building Society, Homeserve PLC, Total Telecommunications Limited, Unipart Group and Capita Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: South Shields
- 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 ... Specifying a Recordset Cursor Location - Optional
- See Training Course Details...
Specifying a Recordset Cursor Type
Using Intrinsic Functions
Trapping Errors with the On Error Statement
Locking Records for Updating
Working with Inline Error Handling
Using Visual Basic Help
Using the Immediate Window to Call Procedures
Using the If...End If Decision Structures
Understanding Collections
Understanding Procedures
Setting Break Expressions
Using the With Statement
Determining the Value of Expressions
Using the Object Browser
Using the For...Next Structure
Writing an Error-Handling Routine
Using Intrinsic Constants
Creating a Sub Procedure
Microsoft Access
- 2 day course
- Location: South Shields
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Creating and Using Macros
- See Training Course Details...
Modifying Table Structures
Database Security
Understanding VBA
Using a Navigation Form
Sorting and Filtering
Importing and Exporting Records
Action Queries
Data Validation
Adding Transactional Records
DIY Forms
Multi Table Queries
Formatting Tables
Creating Queries
Setting Table Relationships
Adding Records to a Table
Querying Techniques
Working With Records
An Introduction to VBA
Macro Techniques
Database Wellness
Email us about this courses
Other South Shields Enable Technology Training Courses
JQuery - South Shields JavaScript Training Courses
Excel 365 Advanced South Shields Training Courses
Excel 365 Basic South Shields Training Courses
Excel Power Pivot South Shields Training Courses
JQuery Mobile - South Shields JavaScript Training Courses
SSIS South Shields Training Courses