ACCESS TRAINING COURSES SHREWSBURY
About Enable Technology Shrewsbury Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The tutor delivering the course will be a Microsoft certified expert. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
We provide instructor led training coupled with hands on training. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a Access course at an alternative training site in Shrewsbury. The Access syllabus can be adjusted and additional topics incorporated if helpful.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to 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 West Bromwich Building Society, Birmingham Heartlands Hospital, DHL Express, Norfolk Police Constabulary, Countrywide Homes Limited, Homeserve PLC, Norwich Union PLC and Vodafone Group Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Shrewsbury
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Specifying a Recordset Cursor Location - Optional
- See Training Course Details...
Understanding the Err Object
Naming Procedures
Why Program in Access?
Organizing Code and Procedures
Introduction to Programming in Access
Creating a Function Procedure
Declaring Variables
Working with the Application Object
Using the Object Browser
Trapping Errors with the On Error Statement
Determining the Value of Expressions
Using the Do...Loop Structure
Understanding Errors
Controlling Program Execution
Using the For Each...Next Structure
Using Intrinsic Constants
Understanding Recordset Cursor Properties - Optional
Using Input Boxes
Microsoft Access
- 2 day course
- Location: Shrewsbury
- 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...
An Introduction to VBA
Modifying Table Structures
Sorting and Filtering
Action Queries
DIY Forms
Creating and Using Macros
Parameter Queries
Setting Table Relationships
Creating and Using Forms
Querying Techniques
Creating Queries
Adding Transactional Records
Importing and Exporting Records
Database Security
Database Wellness
Understanding VBA
Creating a Relational Database
Navigation Pane Protection
Formatting Tables
Aggregation Queries
Email us about this courses
Other Shrewsbury Enable Technology Training Courses
TSQL - Shrewsbury SQL Training Courses
Power Query - Shrewsbury Excel Training Courses
PL/SQL - Shrewsbury SQL Training Courses
SSIS Shrewsbury Training Courses
VBA - Shrewsbury Excel Training Courses
Excel 365 Advanced Shrewsbury Training Courses