ACCESS TRAINING COURSES SCARBOROUGH
About Enable Technology Scarborough Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Everyone attending a Access course receives learning resources which also serves as a reference source 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. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a course at a local socially distanced venue in Scarborough. We are happy to modify the Access syllabus to match your teams training requirements.
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 operated primarily in the West Midlands for twenty years. Our clients include: Birmingham City University, Cadbury PLC, Boots UK Limited, GKN PLC, University of Birmingham, Nationwide Building Society Limited, Total Telecommunications Limited and Loughborough University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Scarborough
- 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 With Statement
- See Training Course Details...
Setting Break Expressions
Using the For Each...Next Structure
Naming Procedures
Using Visual Basic Help
Understanding VBA's Error Trapping Options
Using the Object Browser
Controlling Program Execution
Understanding Constants
Navigating the Access Object Hierarchy
Introduction to Programming in Access
Stepping through Code
Creating a Sub Procedure
Understanding the Order of Events
Understanding Recordset Cursor Properties - Optional
Using Expressions, Variables, and Intrinsic Functions
Working with the ADODB Recordset Object
Microsoft Access
- 2 day course
- Location: Scarborough
- 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 ... Creating and Using Macros
- See Training Course Details...
Sorting and Filtering
Understanding VBA
Data Validation
Creating and Using Reports
Database Security
Macro Techniques
Designing a Lookup Database
Modifying Forms
Creating and Using Forms
Setting Table Relationships
Querying Techniques
Adding Records to a Table
Using a Navigation Form
Navigation Pane Protection
Formatting Tables
Database Wellness
Creating Queries
Importing and Exporting Records
Relational Database Design
Macros on Forms
Email us about this courses
Other Scarborough Enable Technology Training Courses
Crystal 2008 Scarborough Training Courses
SSAS 2017 - Scarborough SQL Server Analysis Services Training Courses
Crystal 2016 - Scarborough Crystal Reports Training Courses
Microsoft Project Level 3 Scarborough Training Courses
JQuery Mobile Scarborough Training Courses
Excel Power Pivot Scarborough Training Courses
North - Possible Access Training Course Locations
Scunthorpe Access Training Courses Scunthorpe, Normanton, Rotherham, North East, Bridlington, Batley, Scarborough, Doncaster, Hartlepool, Huddersfield, Wakefield, Wetherby, Barnsley, Middlesbrough, Gateshead, Newcastle Upon Tyne, Leeds, Hexham, Castleford, Keighley, South Shields, Pudsey, Grimsby, York, Yorkshire, Halifax, Sunderland, Dewsbury, Harrogate, Sheffield, Durham
Normanton Access Training Courses
Rotherham Access Training Courses
North East Access Training Courses
Bridlington Access Training Courses
Batley Access Training Courses
Scarborough Access Training Courses
Doncaster Access Training Courses
Hartlepool Access Training Courses
Huddersfield Access Training Courses
Wakefield Access Training Courses
Wetherby Access Training Courses
Barnsley Access Training Courses
Middlesbrough Access Training Courses
Gateshead Access Training Courses
Newcastle Upon Tyne Access Training Courses
Leeds Access Training Courses
Hexham Access Training Courses
Castleford Access Training Courses
Keighley Access Training Courses
South Shields Access Training Courses
Pudsey Access Training Courses
Grimsby Access Training Courses
York Access Training Courses
Yorkshire Access Training Courses
Halifax Access Training Courses
Sunderland Access Training Courses
Dewsbury Access Training Courses
Harrogate Access Training Courses
Sheffield Access Training Courses
Durham Access Training Courses