ACCESS TRAINING COURSES GATESHEAD
About Enable Technology Gateshead Access Training Courses
We have a twenty year history of providing skills based Access industry training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We will issue each Access training participant with learning resources which they can refer to post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If you prefer we can offer an offsite training location in Gateshead. 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
We have operated primarily in the West Midlands for twenty years. Some of our clients are Yell Group PLC, Shell UK Oil Products Ltd, DHL Express, Cadbury PLC, West Bromwich Building Society, Aston University, Royal Air Force and Unipart Group.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Gateshead
- 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 Object Browser
- See Training Course Details...
Working with Inline Error Handling
Understanding Classes and Objects
Understanding Collections
Understanding the Err Object
Navigating the Access Object Hierarchy
Using the Select Case...End Select Structure
Calling Procedures
Understanding the Development Environment
Setting Breakpoints
Using the CacheSize Property - Optional
Considering Variable Scope and Lifetime Together
Understanding Modules
Trapping Errors with the On Error Statement
Debugging Code
Using the With Statement
Why Program in Access?
Writing an Error-Handling Routine
Understanding Expressions and Statements
Microsoft Access
- 2 day course
- Location: Gateshead
- 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 ... Relational Database Design
- See Training Course Details...
Adding Transactional Records
Modifying Forms
Sorting and Filtering
Navigation Pane Protection
Creating and Using Macros
Macro Techniques
Adding Records to a Table
Importing and Exporting Records
Database Security
Data Validation
Formatting Tables
Action Queries
Calculations in Queries
Designing a Lookup Database
Database Wellness
Aggregation Queries
Parameter Queries
DIY Forms
Creating a Lookup Database
Setting Table Relationships
Email us about this courses
Other Gateshead Enable Technology Training Courses
Excel Power Pivot - Gateshead Excel Training Courses
Oracle SQL Gateshead Training Courses
PL/SQL - Gateshead SQL Training Courses
JQuery Mobile - Gateshead JavaScript Training Courses
Power BI - Gateshead Microsoft Power BI Training Courses
SSAS - Gateshead SQL Server Analysis Services Training Courses