ACCESS TRAINING COURSES EAST MIDLANDS
About Enable Technology East Midlands Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All of our tutors are Microsoft Certified Professionals. We will issue each Access training participant with learning resources which they can refer to post training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a Access course at an alternative training site in East Midlands. We are happy to discuss customising the course content should you have particular Access training 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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are GKN PLC, Nationwide Building Society Limited, Birmingham City University, Keele University, Total Telecommunications Limited, Aston University, Loughborough University and National Power PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: East Midlands
- Telephone on 01952 305730
- 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 ... Using Break Mode during Run Mode
- See Training Course Details...
Using Visual Basic Help
Understanding Data Types
Understanding Modules
Stepping through Code
Understanding the Order of Events
Using Expressions, Variables, and Intrinsic Functions
Declaring Variables
Declaring and Creating Object Variables
Working with Boolean Expressions
Understanding Objects
Trapping Errors with the On Error Statement
Calling Procedures
Locking Records for Updating
Specifying a Recordset Cursor Location - Optional
Using the Object Browser
Using the For...Next Structure
Microsoft Access
- 2 day course
- Location: East Midlands
- 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 ... Macro Techniques
- See Training Course Details...
Sorting and Filtering
Action Queries
Creating a Lookup Database
Importing and Exporting Records
Macros on Forms
Understanding VBA
Adding Records to a Table
An Introduction to VBA
Querying Techniques
Parameter Queries
Creating and Using Reports
Creating and Using Forms
Working With Records
Database Wellness
Navigation Pane Protection
Creating a Relational Database
Multi Table Queries
Data Validation
Modifying Forms
Database Security
Email us about this courses
Other East Midlands Enable Technology Training Courses
Excel Basic - East Midlands Excel Training Courses
PL/SQL - East Midlands SQL Training Courses
Crystal 2013 East Midlands Training Courses
SSRS 2008 East Midlands Training Courses
Project 2016 L1 - East Midlands Microsoft Project Training Courses
Oracle BI - East Midlands Data Analytics Training Courses
Midlands - Possible Access Training Course Locations
Kenilworth Access Training Courses
Kidderminster Access Training Courses
Rugby Access Training Courses
Bromsgrove Access Training Courses
Coventry Access Training Courses
Redditch Access Training Courses
Evesham Access Training Courses
Stoke On Trent Access Training Courses
Oxford Access Training Courses
Telford Access Training Courses
Warwick Access Training Courses
Wednesbury Access Training Courses
Droitwich Access Training Courses
Shropshire Access Training Courses
Birmingham Access Training Courses
Halesowen Access Training Courses
Leek Access Training Courses
Herefordshire Access Training Courses
Solihull Access Training Courses
Black Country Access Training Courses
Staffordshire Access Training Courses
East Midlands Access Training Courses
Bridgnorth Access Training Courses
Staffordshire Access Training Courses
Uttoxeter Access Training Courses
Chester Access Training Courses
Rowley Access Training Courses
Northhampton Access Training Courses
Warwickshire Access Training Courses
Milton Keynes Access Training Courses
Atherstone Access Training Courses
Tamworth Access Training Courses
Newcastle Under Lyme Access Training Courses
Shrewsbury Access Training Courses
Leicester Access Training Courses
Midlands Access Training Courses
Stratford Upon Avon Access Training Courses
Sandwell Access Training Courses
Stafford Access Training Courses
Hereford Access Training Courses
Crewe Access Training Courses
Rugeley Access Training Courses
Stourbridge Access Training Courses
Smethwick Access Training Courses
Burton On Trent Access Training Courses
Cannock Access Training Courses
Leamington Spa Access Training Courses
Wolverhampton Access Training Courses
Cheltenham Access Training Courses
Nottingham Access Training Courses
Walsall Access Training Courses
Kidsgrove Access Training Courses
West Midlands Access Training Courses
Tipton Access Training Courses
Worcester Access Training Courses
Nuneaton Access Training Courses
West Bromwich Access Training Courses
Derby Access Training Courses
Dudley Access Training Courses
Stourbridge Access Training Courses
Oswestry Access Training Courses
Bedworth Access Training Courses
Worcestershire Access Training Courses
Malvern Access Training Courses
Leicestershire Access Training Courses
Lichfield Access Training Courses
Kenilworth, Kidderminster, Rugby, Bromsgrove, Coventry, Redditch, Evesham, Stoke On Trent, Oxford, Telford, Warwick, Wednesbury, Droitwich, Shropshire, Birmingham, Halesowen, Leek, Herefordshire, Solihull, Black Country, Staffordshire, East Midlands, Bridgnorth, Staffordshire, Uttoxeter, Chester, Rowley, Northhampton, Warwickshire, Milton Keynes, Atherstone, Tamworth, Newcastle Under Lyme, Shrewsbury, Leicester, Midlands, Stratford Upon Avon, Sandwell, Stafford, Hereford, Crewe, Rugeley, Stourbridge, Smethwick, Burton On Trent, Cannock, Leamington Spa, Wolverhampton, Cheltenham, Nottingham, Walsall, Kidsgrove, West Midlands, Tipton, Worcester, Nuneaton, West Bromwich, Derby, Dudley, Stourbridge, Oswestry, Bedworth, Worcestershire, Malvern, Leicestershire, Lichfield