ACCESS TRAINING COURSES MIDDLESBROUGH
About Enable Technology Middlesbrough Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The tutor delivering the course will be a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the Access course at a local training venue in Middlesbrough. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Birmingham City University, Loughborough University, Nuclear Engineering Services, National Power PLC, Wolverhampton City Council, Norfolk Police Constabulary, University of Birmingham and Birmingham Heartlands Hospital.
Microsoft Access
- 2 day course
- Location: Middlesbrough
- 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 ... Creating a Relational Database
- See Training Course Details...
Action Queries
Data Validation
Adding Records to a Table
Formatting Tables
An Introduction to VBA
Modifying Table Structures
Creating Queries
Database Security
Querying Techniques
Creating and Using Reports
Macros on Forms
Calculations in Queries
Multi Table Queries
Relational Database Design
Creating and Using Macros
Understanding VBA
Database Wellness
Designing a Lookup Database
Setting Table Relationships
Aggregation Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Middlesbrough
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Understanding Control-of-Flow Structures
- See Training Course Details...
Understanding Error Handling
Using Intrinsic Constants
Understanding Modules
Using Message Boxes
Using the CacheSize Property - Optional
Understanding the Order of Events
Writing an Error-Handling Routine
Working with the Application Object
Creating a Standard Module
Using the If...End If Decision Structures
Calling Procedures
Understanding Collections
Specifying a Recordset Cursor Type
Working with Variable Scope
Working with the Code Editor
Using Input Boxes
Creating a Sub Procedure
Understanding the Development Environment
Understanding Constants
Email us about this courses
Other Middlesbrough Enable Technology Training Courses
Excel 365 Intermediate Middlesbrough Training Courses
JQuery - Middlesbrough JavaScript Training Courses
Power Query Middlesbrough Training Courses
JQuery Mobile Middlesbrough Training Courses
SQL Middlesbrough Training Courses
TSQL Middlesbrough Training Courses