ACCESS TRAINING COURSES BRIDLINGTON
About Enable Technology Bridlington Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All of our tutors are Microsoft Certified Professionals. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Enable Technology offers instructor led training taught by technology specialists. We can set up a training lab at your premises and deliver Access courses onsite at your site. We are also more than happy to organise a local course at a socially distanced training location in Bridlington. The Access syllabus can be modified to accommodate your specific training needs.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are University of Birmingham, Royal Air Force, National Power PLC, Boots UK Limited, Capita Group PLC, Aston University, Nationwide Building Society Limited and Queen's Medical Centre Nottingham.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bridlington
- 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 Constants
- See Training Course Details...
Understanding Recordset Cursor Properties - Optional
Controlling Program Execution
Working with Recordsets
Locking Records for Updating
Navigating the Access Object Hierarchy
Understanding Control-of-Flow Structures
Writing an Error-Handling Routine
Organizing Code and Procedures
Using the Immediate Window to Call Procedures
Using the For Each...Next Structure
Working with the Application Object
Considering Variable Scope and Lifetime Together
Guidelines for use of Branching Structures
Setting Break Expressions
Using Message Boxes
Using the With Statement
Understanding Classes and Objects
Understanding Error Handling
Working with Variable Scope
Microsoft Access
- 2 day course
- Location: Bridlington
- 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 ... Formatting Tables
- See Training Course Details...
Data Validation
Understanding VBA
Creating a Relational Database
Importing and Exporting Records
Designing a Lookup Database
Modifying Forms
Macros on Forms
Querying Techniques
Modifying Table Structures
Creating Queries
Navigation Pane Protection
Creating a Lookup Database
Calculations in Queries
An Introduction to VBA
Using a Navigation Form
Creating and Using Forms
Aggregation Queries
Relational Database Design
Database Wellness
Working With Records
Email us about this courses
Other Bridlington Enable Technology Training Courses
SSRS - Bridlington SQL Server Reporting Services Training Courses
SSIS - Bridlington SQL Server Integration Services Training Courses
Power BI - Bridlington Microsoft Power BI Training Courses
Oracle SQL Bridlington Training Courses
Excel 365 Advanced Bridlington Training Courses
SSAS Tabular - Bridlington SQL Server Analysis Services Training Courses