ACCESS TRAINING COURSES GATESHEAD
About Enable Technology Gateshead Access Training Courses
We offer intensive two and three days Access courses. The tutor delivering the course will be a Microsoft certified expert. Each course participant will be issued with training Access resources which they can continue to use after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We are also more than happy to organise a local course at a socially distanced training location in Gateshead. All Access courses can be customised to meet your particular requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Countrywide Homes Limited, Loughborough University, GKN PLC, Homeserve PLC, Fujistu PLC, Shell UK Oil Products Ltd, Lloyds TSB Bank PLC and Royal Air Force.
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 ... Formatting Tables
- See Training Course Details...
Aggregation Queries
Macros on Forms
Sorting and Filtering
Creating a Relational Database
Creating Queries
Database Wellness
Creating a Lookup Database
An Introduction to VBA
Relational Database Design
Macro Techniques
Using a Navigation Form
Parameter Queries
DIY Forms
Data Validation
Adding Transactional Records
Modifying Forms
Database Security
Calculations in Queries
Creating and Using Macros
Creating and Using Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Gateshead
- 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 ... Using the Do...Loop Structure
- See Training Course Details...
Setting Breakpoints
Using Input Boxes
Locking Records for Updating
Working with Recordsets
Working with Variable Scope
Understanding Procedures
Understanding the DoCmd Object
Creating a Function Procedure
Using the Immediate Window to Call Procedures
Working with Variable Lifetime
Considering Variable Scope and Lifetime Together
Understanding the Form Object
Debugging Code
Understanding the Order of Events
Using the For Each...Next Structure
Trapping Errors with the On Error Statement
Creating a Sub Procedure
Using Message Boxes
Email us about this courses
Other Gateshead Enable Technology Training Courses
SSAS - Gateshead SQL Server Analysis Services Training Courses
Oracle SQL Gateshead Training Courses
PL/SQL Gateshead Training Courses
JQuery Mobile - Gateshead JavaScript Training Courses
Power Query Gateshead Training Courses
Excel Power Pivot Gateshead Training Courses