ACCESS TRAINING COURSES WELLS
About Enable Technology Wells Access Training Courses
Enable Technology provides practical Access skills based technology training. All of our tutors are Microsoft Certified Professionals. All course participants are issued Access training manuals they can refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Courses are instructor led and groups sizes small. We can set up a training lab at your premises and deliver Access courses onsite at your site. We also offer the option of scheduling of Access course at a socially distanced venue near you in Wells. We are happy to discuss customising the course content should you have particular Access training requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Fujistu PLC, Queen's Medical Centre Nottingham, National Power PLC, EDF Energy PLC, Countrywide Homes Limited, Lloyds TSB Bank PLC, Unipart Group and Shell UK Oil Products Ltd.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wells
- 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...
Working with the Application Object
Creating a Sub Procedure
Using the For...Next Structure
Understanding the Err Object
Understanding Modules
Understanding the Order of Events
Understanding Objects
Using the Immediate Window to Call Procedures
Trapping Errors with the On Error Statement
Using the Object Browser
Writing an Error-Handling Routine
Why Program in Access?
Using the Select Case...End Select Structure
Stepping through Code
Working with Events
Using the If...End If Decision Structures
Understanding Errors
Understanding the DoCmd Object
Microsoft Access
- 2 day course
- Location: Wells
- 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 ... Navigation Pane Protection
- See Training Course Details...
Formatting Tables
Creating Queries
Calculations in Queries
Setting Table Relationships
Designing a Lookup Database
Aggregation Queries
Querying Techniques
DIY Forms
Creating and Using Reports
Getting to Know Access
Understanding VBA
Multi Table Queries
Adding Transactional Records
Database Wellness
Modifying Forms
An Introduction to VBA
Creating and Using Macros
Importing and Exporting Records
Macros on Forms
Modifying Table Structures
Email us about this courses
Other Wells Enable Technology Training Courses
SQL - Wells SQL Training Courses
Report Builder - Wells SQL Server Reporting Services Training Courses
JQuery Mobile Wells Training Courses
Excel 365 Advanced Wells Training Courses
DAX Wells Training Courses
TSQL Wells Training Courses