ACCESS TRAINING COURSES BURTON ON TRENT
About Enable Technology Burton On Trent Access Training Courses
Enable Technology provides practical Access skills based technology training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. 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.
Enable Technology offers instructor led training taught by technology specialists. We can bring the equipment necessary to deliver Access courses at your site. Another option is we can organise a local socially distanced training site in Burton On Trent. Every Access course can be modified to meet your bespoke requirements.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are University of Birmingham, Nationwide Building Society Limited, West Bromwich Building Society, Royal & Sun Alliance Group PLC, Loughborough University, Aston University, Shell UK Oil Products Ltd and EDF Energy PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Burton On Trent
- 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 Expressions, Variables, and Intrinsic Functions
- See Training Course Details...
Using Visual Basic Help
Calling Procedures
Naming Procedures
Working with the Code Editor
Understanding Objects
Debugging Code
Using Intrinsic Constants
Using the Do...Loop Structure
Understanding Data Types
Using the For Each...Next Structure
Working with the ADODB Recordset Object
Working with Recordsets
Understanding Collections
Creating a Sub Procedure
Understanding Error Handling
Declaring Variables
Creating a Function Procedure
Microsoft Access
- 2 day course
- Location: Burton On Trent
- 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 ... Multi Table Queries
- See Training Course Details...
DIY Forms
Creating a Lookup Database
Formatting Tables
Calculations in Queries
Adding Records to a Table
Querying Techniques
Action Queries
Macros on Forms
Sorting and Filtering
Navigation Pane Protection
Modifying Forms
Database Security
An Introduction to VBA
Creating and Using Macros
Importing and Exporting Records
Macro Techniques
Creating a Relational Database
Getting to Know Access
Adding Transactional Records
Relational Database Design
Email us about this courses
Other Burton On Trent Enable Technology Training Courses
DAX Burton On Trent Training Courses
SSAS - Burton On Trent SQL Server Analysis Services Training Courses
PL/SQL - Burton On Trent SQL Training Courses
Excel 365 Basic - Burton On Trent Excel Training Courses
SQL Burton On Trent Training Courses
JavaScript Burton On Trent Training Courses