ACCESS TRAINING COURSES SWANSEA
About Enable Technology Swansea Access Training Courses
Enable Technology specialise in succinct skills based Access training. The training will be delivered by a Microsoft professional with development experience. All candidates receive comprehensive Access training materials and practice files which are theirs to 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. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. The Access course could also be scheduled at a socially distanced site near you in Swansea. We are happy to modify the Access syllabus to match your teams 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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Norfolk Police Constabulary, Unipart Group, Canadian High Commission, Vodafone Group Services, Nuclear Engineering Services, EDF Energy PLC, University of Birmingham and Birmingham Heartlands Hospital.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Swansea
- 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 ... Understanding Data Types
- See Training Course Details...
Considering Variable Scope and Lifetime Together
Using the With Statement
Trapping Errors with the On Error Statement
Using the If...End If Decision Structures
Locking Records for Updating
Using Expressions, Variables, and Intrinsic Functions
Understanding Control-of-Flow Structures
Using Intrinsic Functions
Using Intrinsic Constants
Understanding Procedures
Introduction to Programming in Access
Using the Object Browser
Understanding Expressions and Statements
Understanding Error Handling
Understanding the Err Object
Understanding Objects
Creating a Standard Module
Understanding VBA's Error Trapping Options
Microsoft Access
- 2 day course
- Location: Swansea
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Getting to Know Access
- See Training Course Details...
Multi Table Queries
Working With Records
Action Queries
Creating a Lookup Database
Creating and Using Forms
Relational Database Design
An Introduction to VBA
Querying Techniques
Macro Techniques
Designing a Lookup Database
Calculations in Queries
Adding Records to a Table
Modifying Forms
Creating and Using Macros
Using a Navigation Form
Adding Transactional Records
Database Security
Database Wellness
Navigation Pane Protection
Aggregation Queries
Email us about this courses
Other Swansea Enable Technology Training Courses
JavaScript - Swansea JavaScript Training Courses
SSAS Swansea Training Courses
VBA - Swansea Excel Training Courses
Excel 365 Intermediate Swansea Training Courses
Power Query - Swansea Excel Training Courses
Data Warehouse - Swansea SQL Training Courses