ACCESS TRAINING COURSES HARTLEPOOL
About Enable Technology Hartlepool Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a course at a local socially distanced venue in Hartlepool. Every Access course can be modified to meet your bespoke 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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Norwich Union PLC, Yell Group PLC, Homeserve PLC, DHL Express, Keele University, Nationwide Building Society Limited, Royal Air Force and Norfolk Police Constabulary.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Hartlepool
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Using the Object Browser
- See Training Course Details...
Working with Methods
Working with Events
Understanding Errors
Working with the ADODB Recordset Object
Understanding Classes and Objects
Working with Inline Error Handling
Considering Variable Scope and Lifetime Together
Understanding Objects
Working with Recordsets
Understanding the Development Environment
Understanding Data Types
Working with Variable Lifetime
Declaring Variables
Writing an Error-Handling Routine
Understanding Control-of-Flow Structures
Understanding Procedures
Using Intrinsic Constants
Using the For Each...Next Structure
Using the Immediate Window to Call Procedures
Creating a Sub Procedure
Microsoft Access
- 2 day course
- Location: Hartlepool
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Aggregation Queries
- See Training Course Details...
Creating Queries
Querying Techniques
Database Wellness
Navigation Pane Protection
Creating a Lookup Database
Parameter Queries
Sorting and Filtering
Adding Transactional Records
Macros on Forms
Working With Records
Data Validation
An Introduction to VBA
Setting Table Relationships
Action Queries
Creating a Relational Database
Modifying Table Structures
Understanding VBA
Creating and Using Macros
Modifying Forms
Using a Navigation Form
Email us about this courses
Other Hartlepool Enable Technology Training Courses
SQL - Hartlepool SQL Training Courses
Oracle SQL - Hartlepool SQL Training Courses
PL/SQL Hartlepool Training Courses
Excel 365 Basic Hartlepool Training Courses
Power BI - Hartlepool Microsoft Power BI Training Courses
SSAS - Hartlepool SQL Server Analysis Services Training Courses