ACCESS TRAINING COURSES BATH
About Enable Technology Bath Access Training Courses
We have a twenty year history of providing skills based Access industry training. We guarantee the training will be delivered by a Microsoft certified expert. We provide every candidate with Access training materials which they keep after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can deliver at your premises. We can provide the equipment. We also offer the option of scheduling of Access course at a venue near you in Bath. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Carillion PLC, Homeserve PLC, GKN PLC, DHL Express, Yell Group PLC, Capita Group PLC, Aston University and Nationwide Building Society Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bath
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Using the For...Next Structure
- See Training Course Details...
Setting Breakpoints
Using Intrinsic Functions
Using Break Mode during Run Mode
Specifying a Recordset Cursor Type
Working with Inline Error Handling
Creating a Function Procedure
Using the If...End If Decision Structures
Understanding Collections
Working with the ADODB Recordset Object
Controlling Program Execution
Creating a Standard Module
Working with Recordsets
Using Message Boxes
Using the Select Case...End Select Structure
Understanding Data Types
Understanding the DoCmd Object
Locking Records for Updating
Trapping Errors with the On Error Statement
Microsoft Access
- 2 day course
- Location: Bath
- 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 ... Data Validation
- See Training Course Details...
Getting to Know Access
DIY Forms
Relational Database Design
Understanding VBA
Adding Records to a Table
Working With Records
Designing a Lookup Database
Formatting Tables
Importing and Exporting Records
Navigation Pane Protection
Creating Queries
Modifying Forms
Creating a Relational Database
Database Wellness
Creating and Using Forms
Calculations in Queries
Creating and Using Reports
Using a Navigation Form
Macro Techniques
Action Queries
Email us about this courses
Other Bath Enable Technology Training Courses
DAX - Bath Excel Training Courses
SSRS - Bath SQL Server Reporting Services Training Courses
TSQL - Bath SQL Training Courses
JQuery Mobile Bath Training Courses
Excel Power Pivot - Bath Excel Training Courses
SSIS Bath Training Courses