ACCESS TRAINING COURSES MANCHESTER
About Enable Technology Manchester Access Training Courses
We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We will issue each Access training participant with learning resources which they can refer to post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a course at a local socially distanced venue in Manchester. The Access syllabus can be modified to accommodate your specific training needs.
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.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Fujistu PLC, Nationwide Building Society Limited, Nuclear Engineering Services, Cadbury PLC, Carillion PLC, Norfolk Police Constabulary, Canadian High Commission and Wolverhampton City Council.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Manchester
- 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 the CacheSize Property - Optional
- See Training Course Details...
Understanding Procedures
Understanding Errors
Handling Errors
Working with Boolean Expressions
Understanding Modules
Using Visual Basic Help
Declaring and Creating Object Variables
Understanding the Form Object
Organizing Code and Procedures
Understanding the Development Environment
Working with the ADODB Recordset Object
Working with the Application Object
Introduction to Programming in Access
Understanding the Order of Events
Understanding the DoCmd Object
Guidelines for use of Branching Structures
Using the With Statement
Using the For...Next Structure
Microsoft Access
- 2 day course
- Location: Manchester
- Telephone on 01952 305730
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Database Security
- See Training Course Details...
Formatting Tables
DIY Forms
Data Validation
Calculations in Queries
Creating and Using Forms
Creating Queries
Adding Transactional Records
Multi Table Queries
Creating a Lookup Database
Creating and Using Reports
Importing and Exporting Records
Macro Techniques
Sorting and Filtering
Working With Records
Aggregation Queries
Setting Table Relationships
Understanding VBA
Querying Techniques
Designing a Lookup Database
Navigation Pane Protection
Email us about this courses
Other Manchester Enable Technology Training Courses
Project 2016 - Manchester Microsoft Project Training Courses
SSRS 2016 - Manchester SQL Server Reporting Services Training Courses
SSIS 2005 - Manchester SQL Server Integration Services Training Courses
Crystal XI Manchester Training Courses
JavaScript - Manchester JavaScript Training Courses
Oracle BI Manchester Training Courses
North West - Possible Access Training Course Locations
Denton Access Training Courses Denton, Wallasey, Morecambe, Sale, Liverpool, Leigh, Wythenshawe, Southport, Rochdale, Thornton-cleveleys, Bury, North West, Crewe, Crosby, Huyton, Barrow-in-furness, Blackpool, Salford, Winsford, Eccles, Birkenhead, Blackburn, Preston, Manchester, Chorley, Cheshire, Bolton, Skelmersdale, Altrincham, Lancaster, Leyland, Oldham, Northwich, Lancashire, Widnes, Carlisle, Middleton, Farnworth, Burnley, Runcorn, Ellesmere Port, Ashton-under-lyne, Merseyside, Wigan, Chester, Warrington, Saddleworth, Stockport, Stretford, Bootle, Macclesfield, Chadderton, Kirkby, Hyde, Prestwich, Lytham Urmston, Accrington
Wallasey Access Training Courses
Morecambe Access Training Courses
Sale Access Training Courses
Liverpool Access Training Courses
Leigh Access Training Courses
Wythenshawe Access Training Courses
Southport Access Training Courses
Rochdale Access Training Courses
Thornton-Cleveleys Access Training Courses
Bury Access Training Courses
North West Access Training Courses
Crewe Access Training Courses
Crosby Access Training Courses
Huyton Access Training Courses
Barrow-in-Furness Access Training Courses
Blackpool Access Training Courses
Salford Access Training Courses
Winsford Access Training Courses
Eccles Access Training Courses
Birkenhead Access Training Courses
Blackburn Access Training Courses
Preston Access Training Courses
Manchester Access Training Courses
Chorley Access Training Courses
Cheshire Access Training Courses
Bolton Access Training Courses
Skelmersdale Access Training Courses
Altrincham Access Training Courses
Lancaster Access Training Courses
Leyland Access Training Courses
Oldham Access Training Courses
Northwich Access Training Courses
Lancashire Access Training Courses
Widnes Access Training Courses
Carlisle Access Training Courses
Middleton Access Training Courses
Farnworth Access Training Courses
Burnley Access Training Courses
Runcorn Access Training Courses
Ellesmere Port Access Training Courses
Ashton-under-Lyne Access Training Courses
Merseyside Access Training Courses
Wigan Access Training Courses
Chester Access Training Courses
Warrington Access Training Courses
Saddleworth Access Training Courses
Stockport Access Training Courses
Stretford Access Training Courses
Bootle Access Training Courses
Macclesfield Access Training Courses
Chadderton Access Training Courses
Kirkby Access Training Courses
Hyde Access Training Courses
Prestwich Access Training Courses
Lytham Urmston Access Training Courses
Accrington Access Training Courses