ACCESS TRAINING COURSES LEIGH
About Enable Technology Leigh Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every person attending a Access course will be provided with training materials and practice files to retain after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can bring the equipment necessary to deliver Access courses at your site. Another way we could deliver the Access course is at a local socially distanced training site. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
Our teaching team have over twenty years continuous technical training experience. Our clients include: GKN PLC, Total Telecommunications Limited, Halfords Group PLC, Cadbury PLC, Aston University, Loughborough University, Dollond & Aitchison Limited and Boots UK Limited.
Microsoft Access
- 2 day course
- Location: Leigh
- Telephone on 01952 305730
- 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 ... Querying Techniques
- See Training Course Details...
Calculations in Queries
Creating and Using Forms
An Introduction to VBA
Database Wellness
Macro Techniques
Navigation Pane Protection
Importing and Exporting Records
Adding Records to a Table
Using a Navigation Form
Parameter Queries
Creating and Using Macros
Multi Table Queries
Creating Queries
Database Security
Adding Transactional Records
Modifying Table Structures
Working With Records
Understanding VBA
Modifying Forms
Setting Table Relationships
Microsoft Access Programming Using VBA
- 3 day course
- Location: Leigh
- Telephone on 01952 305730
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Why Program in Access?
- See Training Course Details...
Working with Recordsets
Organizing Code and Procedures
Working with the Application Object
Declaring Variables
Working with Procedures and Functions
Trapping Errors with the On Error Statement
Using the Immediate Window to Call Procedures
Using Input Boxes
Using the With Statement
Working with the ADODB Recordset Object
Calling Procedures
Understanding Constants
Understanding the Order of Events
Understanding Objects
Using the CacheSize Property - Optional
Considering Variable Scope and Lifetime Together
Working with Boolean Expressions
Understanding the DoCmd Object
Understanding Procedures
Email us about this courses
Other Leigh Enable Technology Training Courses
SSAS 2005 - Leigh SQL Server Analysis Services Training Courses
HTML Leigh Training Courses
VBA Leigh Training Courses
Oracle SQL - Leigh SQL Training Courses
Report Builder - Leigh SQL Server Reporting Services Training Courses
HTML Leigh Training Courses
North West - Possible Access Training Course Locations
Warrington Access Training Courses
Leyland Access Training Courses
Thornton-Cleveleys Access Training Courses
Rochdale Access Training Courses
Skelmersdale Access Training Courses
Saddleworth Access Training Courses
Widnes Access Training Courses
Carlisle Access Training Courses
Birkenhead Access Training Courses
Accrington Access Training Courses
Altrincham Access Training Courses
Cheshire Access Training Courses
Chadderton Access Training Courses
Northwich Access Training Courses
Winsford Access Training Courses
Lancaster Access Training Courses
Chester Access Training Courses
Lytham Urmston Access Training Courses
Stockport Access Training Courses
Bury Access Training Courses
Wigan Access Training Courses
Prestwich Access Training Courses
Crosby Access Training Courses
Ellesmere Port Access Training Courses
Ashton-under-Lyne Access Training Courses
Eccles Access Training Courses
Lancashire Access Training Courses
Merseyside Access Training Courses
Oldham Access Training Courses
Wallasey Access Training Courses
Stretford Access Training Courses
Burnley Access Training Courses
Macclesfield Access Training Courses
Barrow-in-Furness Access Training Courses
Manchester Access Training Courses
Crewe Access Training Courses
Liverpool Access Training Courses
Morecambe Access Training Courses
Huyton Access Training Courses
Blackburn Access Training Courses
Chorley Access Training Courses
Leigh Access Training Courses
Hyde Access Training Courses
Bolton Access Training Courses
Kirkby Access Training Courses
Wythenshawe Access Training Courses
Runcorn Access Training Courses
Bootle Access Training Courses
Preston Access Training Courses
Farnworth Access Training Courses
Southport Access Training Courses
Salford Access Training Courses
Denton Access Training Courses
Blackpool Access Training Courses
North West Access Training Courses
Middleton Access Training Courses
Sale Access Training Courses
Warrington, Leyland, Thornton-cleveleys, Rochdale, Skelmersdale, Saddleworth, Widnes, Carlisle, Birkenhead, Accrington, Altrincham, Cheshire, Chadderton, Northwich, Winsford, Lancaster, Chester, Lytham Urmston, Stockport, Bury, Wigan, Prestwich, Crosby, Ellesmere Port, Ashton-under-lyne, Eccles, Lancashire, Merseyside, Oldham, Wallasey, Stretford, Burnley, Macclesfield, Barrow-in-furness, Manchester, Crewe, Liverpool, Morecambe, Huyton, Blackburn, Chorley, Leigh, Hyde, Bolton, Kirkby, Wythenshawe, Runcorn, Bootle, Preston, Farnworth, Southport, Salford, Denton, Blackpool, North West, Middleton, Sale