ACCESS TRAINING COURSES DROITWICH
About Enable Technology Droitwich Access Training Courses
We offer intensive two and three days Access courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Courses are instructor led and groups sizes small. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We also offer the option of scheduling of Access course at a socially distanced venue near you in Droitwich. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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. Our clients include: Nuclear Engineering Services, Norfolk Police Constabulary, Canadian High Commission, GKN PLC, Birmingham City Council, Capita Group PLC, West Bromwich Building Society and Norwich Union PLC.
Microsoft Access
- 2 day course
- Location: Droitwich
- 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 ... Creating a Relational Database
- See Training Course Details...
DIY Forms
Creating a Lookup Database
Using a Navigation Form
Relational Database Design
Creating and Using Reports
Macro Techniques
Understanding VBA
Querying Techniques
Sorting and Filtering
Parameter Queries
Adding Transactional Records
Working With Records
Multi Table Queries
Action Queries
Data Validation
Getting to Know Access
Navigation Pane Protection
Formatting Tables
Creating Queries
Creating and Using Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Droitwich
- 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 ... Determining the Value of Expressions
- See Training Course Details...
Using Visual Basic Help
Using Intrinsic Constants
Understanding Constants
Understanding Errors
Working with the Application Object
Considering Variable Scope and Lifetime Together
Working with Boolean Expressions
Working with Procedures and Functions
Trapping Errors with the On Error Statement
Understanding Procedures
Understanding the DoCmd Object
Understanding the Err Object
Stepping through Code
Understanding Error Handling
Understanding VBA's Error Trapping Options
Creating a Sub Procedure
Working with Inline Error Handling
Email us about this courses
Other Droitwich Enable Technology Training Courses
Microsoft Project Level 3 - Droitwich Microsoft Project Training Courses
JQuery - Droitwich JavaScript Training Courses
SSIS 2008 Droitwich Training Courses
Crystal 2013 Droitwich Training Courses
SSAS Tabular - Droitwich SQL Server Analysis Services Training Courses
SSRS 2016 Droitwich Training Courses
Midlands - Possible Access Training Course Locations
Shrewsbury Access Training Courses Shrewsbury, West Midlands, Worcester, Birmingham, Droitwich, Staffordshire, Stoke On Trent, Crewe, Black Country, Wolverhampton, Shropshire, Halesowen, Newcastle Under Lyme, Atherstone, Stourbridge, Leicester, Lichfield, Rugeley, Telford, Sandwell, Northhampton, Chester, Smethwick, Stafford, Cannock, Leamington Spa, East Midlands, Redditch, Burton On Trent, Worcestershire, Oxford, Midlands, Kenilworth, Leicestershire, Hereford, Stourbridge, Evesham, Rowley, Walsall, West Bromwich, Kidderminster, Staffordshire, Nottingham, Cheltenham, Leek, Tipton, Nuneaton, Malvern, Bedworth, Warwick, Oswestry, Bromsgrove, Kidsgrove, Uttoxeter, Warwickshire, Coventry, Rugby, Milton Keynes, Solihull, Derby, Bridgnorth, Dudley, Tamworth, Wednesbury, Herefordshire, Stratford Upon Avon
West Midlands Access Training Courses
Worcester Access Training Courses
Birmingham Access Training Courses
Droitwich Access Training Courses
Staffordshire Access Training Courses
Stoke On Trent Access Training Courses
Crewe Access Training Courses
Black Country Access Training Courses
Wolverhampton Access Training Courses
Shropshire Access Training Courses
Halesowen Access Training Courses
Newcastle Under Lyme Access Training Courses
Atherstone Access Training Courses
Stourbridge Access Training Courses
Leicester Access Training Courses
Lichfield Access Training Courses
Rugeley Access Training Courses
Telford Access Training Courses
Sandwell Access Training Courses
Northhampton Access Training Courses
Chester Access Training Courses
Smethwick Access Training Courses
Stafford Access Training Courses
Cannock Access Training Courses
Leamington Spa Access Training Courses
East Midlands Access Training Courses
Redditch Access Training Courses
Burton On Trent Access Training Courses
Worcestershire Access Training Courses
Oxford Access Training Courses
Midlands Access Training Courses
Kenilworth Access Training Courses
Leicestershire Access Training Courses
Hereford Access Training Courses
Stourbridge Access Training Courses
Evesham Access Training Courses
Rowley Access Training Courses
Walsall Access Training Courses
West Bromwich Access Training Courses
Kidderminster Access Training Courses
Staffordshire Access Training Courses
Nottingham Access Training Courses
Cheltenham Access Training Courses
Leek Access Training Courses
Tipton Access Training Courses
Nuneaton Access Training Courses
Malvern Access Training Courses
Bedworth Access Training Courses
Warwick Access Training Courses
Oswestry Access Training Courses
Bromsgrove Access Training Courses
Kidsgrove Access Training Courses
Uttoxeter Access Training Courses
Warwickshire Access Training Courses
Coventry Access Training Courses
Rugby Access Training Courses
Milton Keynes Access Training Courses
Solihull Access Training Courses
Derby Access Training Courses
Bridgnorth Access Training Courses
Dudley Access Training Courses
Tamworth Access Training Courses
Wednesbury Access Training Courses
Herefordshire Access Training Courses
Stratford Upon Avon Access Training Courses