ACCESS TRAINING COURSES KIDSGROVE
About Enable Technology Kidsgrove Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All Enable Technology tutors are Microsoft certified experts. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Enable Technology training courses are delivered as instructor led courses. We can deliver at your premises. We can provide the equipment. The Access course could also be scheduled at a socially distanced site near you in Kidsgrove. All Access courses can be customised to meet your particular 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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Birmingham City Council, Queen's Medical Centre Nottingham, Countrywide Homes Limited, Nuclear Engineering Services, Dollond & Aitchison Limited, Unipart Group, Capita Group PLC and Lloyds TSB Bank PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Kidsgrove
- Telephone on 01952 305730
- 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...
Working with Events
Guidelines for use of Branching Structures
Setting Break Expressions
Understanding Classes and Objects
Declaring Variables
Using Visual Basic Help
Working with Procedures and Functions
Working with Variable Lifetime
Using the With Statement
Using the For...Next Structure
Understanding Constants
Understanding the Order of Events
Working with Properties
Using Intrinsic Constants
Using Expressions, Variables, and Intrinsic Functions
Calling Procedures
Introduction to Programming in Access
Understanding Errors
Working with Inline Error Handling
Creating a Function Procedure
Microsoft Access
- 2 day course
- Location: Kidsgrove
- Telephone on 01952 305730
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Understanding VBA
- See Training Course Details...
Creating a Relational Database
Navigation Pane Protection
Sorting and Filtering
Modifying Table Structures
Adding Transactional Records
Action Queries
Multi Table Queries
Formatting Tables
An Introduction to VBA
Calculations in Queries
Data Validation
Using a Navigation Form
Creating a Lookup Database
Setting Table Relationships
Aggregation Queries
Creating and Using Reports
Importing and Exporting Records
Working With Records
DIY Forms
Database Security
Email us about this courses
Other Kidsgrove Enable Technology Training Courses
SQL - Kidsgrove SQL Training Courses
Crystal 2016 Kidsgrove Training Courses
Project 2016 Kidsgrove Training Courses
SSAS 2008 - Kidsgrove SQL Server Analysis Services Training Courses
VBA Kidsgrove Training Courses
Microsoft Project Level 2 - Kidsgrove Microsoft Project Training Courses
Midlands - Possible Access Training Course Locations
Kenilworth Access Training Courses Kenilworth, Evesham, Uttoxeter, Rugeley, Warwickshire, Birmingham, Halesowen, Malvern, Stratford Upon Avon, Milton Keynes, Nottingham, Bridgnorth, Herefordshire, Worcester, Kidderminster, Chester, Smethwick, Staffordshire, Derby, Stourbridge, Leamington Spa, Redditch, Stourbridge, Wolverhampton, West Midlands, Black Country, Shropshire, Cheltenham, Northhampton, Burton On Trent, West Bromwich, Wednesbury, Newcastle Under Lyme, Rowley, Rugby, Warwick, Oswestry, Lichfield, Oxford, Tipton, Leicestershire, Stoke On Trent, Cannock, Droitwich, Kidsgrove, Solihull, Worcestershire, Shrewsbury, Atherstone, Crewe, Midlands, Staffordshire, Hereford, Coventry, Leek, East Midlands, Nuneaton, Bromsgrove, Telford, Sandwell, Stafford, Leicester, Tamworth, Bedworth, Walsall, Dudley
Evesham Access Training Courses
Uttoxeter Access Training Courses
Rugeley Access Training Courses
Warwickshire Access Training Courses
Birmingham Access Training Courses
Halesowen Access Training Courses
Malvern Access Training Courses
Stratford Upon Avon Access Training Courses
Milton Keynes Access Training Courses
Nottingham Access Training Courses
Bridgnorth Access Training Courses
Herefordshire Access Training Courses
Worcester Access Training Courses
Kidderminster Access Training Courses
Chester Access Training Courses
Smethwick Access Training Courses
Staffordshire Access Training Courses
Derby Access Training Courses
Stourbridge Access Training Courses
Leamington Spa Access Training Courses
Redditch Access Training Courses
Stourbridge Access Training Courses
Wolverhampton Access Training Courses
West Midlands Access Training Courses
Black Country Access Training Courses
Shropshire Access Training Courses
Cheltenham Access Training Courses
Northhampton Access Training Courses
Burton On Trent Access Training Courses
West Bromwich Access Training Courses
Wednesbury Access Training Courses
Newcastle Under Lyme Access Training Courses
Rowley Access Training Courses
Rugby Access Training Courses
Warwick Access Training Courses
Oswestry Access Training Courses
Lichfield Access Training Courses
Oxford Access Training Courses
Tipton Access Training Courses
Leicestershire Access Training Courses
Stoke On Trent Access Training Courses
Cannock Access Training Courses
Droitwich Access Training Courses
Kidsgrove Access Training Courses
Solihull Access Training Courses
Worcestershire Access Training Courses
Shrewsbury Access Training Courses
Atherstone Access Training Courses
Crewe Access Training Courses
Midlands Access Training Courses
Staffordshire Access Training Courses
Hereford Access Training Courses
Coventry Access Training Courses
Leek Access Training Courses
East Midlands Access Training Courses
Nuneaton Access Training Courses
Bromsgrove Access Training Courses
Telford Access Training Courses
Sandwell Access Training Courses
Stafford Access Training Courses
Leicester Access Training Courses
Tamworth Access Training Courses
Bedworth Access Training Courses
Walsall Access Training Courses
Dudley Access Training Courses