ACCESS TRAINING COURSES THORNTON-CLEVELEYS
About Enable Technology Thornton-cleveleys Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
We provide instructor led training coupled with hands on training. We are set up to deliver Access training courses onsite at your premises. Alternatively we could schedule a Access course at an alternative training site in Thornton-cleveleys. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Nationwide Building Society Limited, Nuclear Engineering Services, DHL Express, Homeserve PLC, Norwich Union PLC, Barclays Bank PLC, National Power PLC and Royal Air Force.
Microsoft Access
- 2 day course
- Location: Thornton-cleveleys
- 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 ... Database Security
- See Training Course Details...
Database Wellness
An Introduction to VBA
Setting Table Relationships
Modifying Forms
Creating a Lookup Database
Navigation Pane Protection
Formatting Tables
Action Queries
Creating and Using Forms
Macros on Forms
DIY Forms
Sorting and Filtering
Creating Queries
Understanding VBA
Querying Techniques
Macro Techniques
Modifying Table Structures
Data Validation
Relational Database Design
Aggregation Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Thornton-cleveleys
- 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...
Understanding Collections
Organizing Code and Procedures
Writing an Error-Handling Routine
Using Message Boxes
Using the For...Next Structure
Using Intrinsic Functions
Working with the ADODB Recordset Object
Locking Records for Updating
Setting Break Expressions
Declaring Variables
Considering Variable Scope and Lifetime Together
Using the CacheSize Property - Optional
Understanding Data Types
Understanding Control-of-Flow Structures
Understanding Modules
Working with the Application Object
Naming Procedures
Using the Immediate Window to Call Procedures
Email us about this courses
Other Thornton-cleveleys Enable Technology Training Courses
Data Warehouse Thornton-cleveleys Training Courses
Excel 365 Intermediate - Thornton-cleveleys Excel Training Courses
DAX - Thornton-cleveleys Excel Training Courses
TSQL - Thornton-cleveleys SQL Training Courses
SSAS Tabular - Thornton-cleveleys SQL Server Analysis Services Training Courses
JQuery Mobile Thornton-cleveleys Training Courses