ACCESS TRAINING COURSES NATIONAL
About Enable Technology National Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. We guarantee the training will be delivered by a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Another option is we can organise a local socially distanced training site in National. All Access courses can be customised to meet your particular requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Cadbury PLC, Birmingham Heartlands Hospital, Keele University, University of Birmingham, Birmingham City Council, Aston University, Birmingham City University and West Bromwich Building Society.
Microsoft Access Programming Using VBA
- 3 day course
- Location: National
- Telephone on 01952 305730
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Using Expressions, Variables, and Intrinsic Functions
- See Training Course Details...
Working with Methods
Using the If...End If Decision Structures
Navigating the Access Object Hierarchy
Working with Events
Working with Variable Lifetime
Writing an Error-Handling Routine
Working with Variable Scope
Understanding Control-of-Flow Structures
Creating a Standard Module
Using Input Boxes
Using Intrinsic Constants
Using Visual Basic Help
Trapping Errors with the On Error Statement
Organizing Code and Procedures
Understanding VBA's Error Trapping Options
Using Message Boxes
Understanding Objects
Setting Breakpoints
Specifying a Recordset Cursor Type
Considering Variable Scope and Lifetime Together
Microsoft Access
- 2 day course
- Location: National
- Telephone on 01952 305730
- 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 ... Creating a Lookup Database
- See Training Course Details...
Modifying Forms
Multi Table Queries
Designing a Lookup Database
An Introduction to VBA
Sorting and Filtering
Formatting Tables
Creating and Using Forms
Macro Techniques
Database Wellness
Aggregation Queries
Database Security
Parameter Queries
Macros on Forms
Modifying Table Structures
Creating and Using Reports
Calculations in Queries
Getting to Know Access
Creating and Using Macros
Navigation Pane Protection
Adding Transactional Records
Email us about this courses
Other National Enable Technology Training Courses
SSAS Tabular National Training Courses
Data Mining - National Data Analytics Training Courses
TSQL National Training Courses
SSIS 2014 National Training Courses
Oracle SQL - National SQL Training Courses
CSS - National Web Development Training Courses