ACCESS TRAINING COURSES LEEK
About Enable Technology Leek Access Training Courses
Enable Technology specialise in succinct skills based Access training. The training will be delivered by a Microsoft professional with development experience. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We are also more than happy to organise a local course at a training location in Leek. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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. Our clients include: Unipart Group, Aston University, DHL Express, Total Telecommunications Limited, Norfolk Police Constabulary, Countrywide Homes Limited, Shell UK Oil Products Ltd and Birmingham Heartlands Hospital.
Microsoft Access
- 2 day course
- Location: Leek
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... An Introduction to VBA
- See Training Course Details...
Parameter Queries
Database Security
Adding Transactional Records
Querying Techniques
Getting to Know Access
Setting Table Relationships
Modifying Table Structures
Sorting and Filtering
Creating and Using Forms
Creating Queries
DIY Forms
Creating and Using Reports
Macro Techniques
Designing a Lookup Database
Macros on Forms
Adding Records to a Table
Importing and Exporting Records
Navigation Pane Protection
Aggregation Queries
Using a Navigation Form
Microsoft Access Programming Using VBA
- 3 day course
- Location: Leek
- 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 ... Understanding Modules
- See Training Course Details...
Using Intrinsic Functions
Using the CacheSize Property - Optional
Using the For...Next Structure
Organizing Code and Procedures
Using Visual Basic Help
Understanding Errors
Understanding Classes and Objects
Locking Records for Updating
Understanding the Form Object
Specifying a Recordset Cursor Type
Handling Errors
Creating a Function Procedure
Creating a Standard Module
Working with Boolean Expressions
Working with Recordsets
Understanding Constants
Using the Object Browser
Guidelines for use of Branching Structures
Determining the Value of Expressions
Email us about this courses
Other Leek Enable Technology Training Courses
JQuery Leek Training Courses
SSAS Leek Training Courses
Excel 365 Basic - Leek Excel Training Courses
Power Query Leek Training Courses
SSRS - Leek SQL Server Reporting Services Training Courses
Oracle SQL Leek Training Courses