ACCESS TRAINING COURSES SOUTH SHIELDS
About Enable Technology South Shields Access Training Courses
Enable Technology specialise in succinct skills based Access training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant is given Access courseware which they can refer to after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We are set up to deliver Access training courses onsite at your premises. If delivery onsite is an issue we will organise a venue near you in South Shields. We are happy to modify the Access syllabus to match your teams training 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 two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Carillion PLC, EDF Energy PLC, Nuclear Engineering Services, Barclays Bank PLC, Dollond & Aitchison Limited, Royal Air Force, Yell Group PLC and Shell UK Oil Products Ltd.
Microsoft Access
- 2 day course
- Location: South Shields
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Multi Table Queries
- See Training Course Details...
Action Queries
Modifying Table Structures
Adding Transactional Records
Formatting Tables
Working With Records
Macros on Forms
Designing a Lookup Database
Modifying Forms
Creating and Using Macros
Parameter Queries
Navigation Pane Protection
Database Security
Understanding VBA
Importing and Exporting Records
Sorting and Filtering
Getting to Know Access
An Introduction to VBA
Aggregation Queries
Creating Queries
Setting Table Relationships
Microsoft Access Programming Using VBA
- 3 day course
- Location: South Shields
- Telephone on 01952 938014
- 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 ... Using the If...End If Decision Structures
- See Training Course Details...
Using the For...Next Structure
Working with Variable Scope
Creating a Sub Procedure
Using the Select Case...End Select Structure
Declaring Variables
Using the With Statement
Guidelines for use of Branching Structures
Understanding Constants
Understanding the Order of Events
Declaring and Creating Object Variables
Understanding Modules
Using Expressions, Variables, and Intrinsic Functions
Calling Procedures
Handling Errors
Working with Properties
Working with the ADODB Recordset Object
Understanding Procedures
Email us about this courses
Other South Shields Enable Technology Training Courses
Excel Power Pivot - South Shields Excel Training Courses
VBA South Shields Training Courses
SSAS - South Shields SQL Server Analysis Services Training Courses
Oracle SQL South Shields Training Courses
SQL South Shields Training Courses
JQuery - South Shields JavaScript Training Courses