ACCESS TRAINING COURSES CREWE
About Enable Technology Crewe Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Another way we could deliver the Access course is at a local socially distanced training site. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Halfords Group PLC, Homeserve PLC, Fujistu PLC, Loughborough University, Birmingham Heartlands Hospital, Countrywide Homes Limited, Birmingham City University and GKN PLC.
Microsoft Access
- 2 day course
- Location: Crewe
- Telephone on 01952 938014
- 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 ... Multi Table Queries
- See Training Course Details...
Understanding VBA
Macro Techniques
Importing and Exporting Records
Database Wellness
Formatting Tables
DIY Forms
Aggregation Queries
Modifying Table Structures
Using a Navigation Form
An Introduction to VBA
Creating Queries
Sorting and Filtering
Data Validation
Creating and Using Reports
Calculations in Queries
Creating a Relational Database
Designing a Lookup Database
Navigation Pane Protection
Adding Transactional Records
Creating and Using Macros
Microsoft Access Programming Using VBA
- 3 day course
- Location: Crewe
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Understanding the Form Object
- See Training Course Details...
Working with Boolean Expressions
Working with Procedures and Functions
Guidelines for use of Branching Structures
Stepping through Code
Understanding VBA's Error Trapping Options
Using Input Boxes
Declaring and Creating Object Variables
Using the With Statement
Trapping Errors with the On Error Statement
Understanding Procedures
Understanding Error Handling
Setting Break Expressions
Creating a Sub Procedure
Working with the ADODB Recordset Object
Specifying a Recordset Cursor Location - Optional
Working with the Code Editor
Understanding Control-of-Flow Structures
Using the Select Case...End Select Structure
Email us about this courses
Other Crewe Enable Technology Training Courses
Power BI - Crewe Microsoft Power BI Training Courses
Power Query - Crewe Excel Training Courses
Excel 365 Intermediate - Crewe Excel Training Courses
DAX - Crewe Excel Training Courses
Report Builder Crewe Training Courses
JavaScript Crewe Training Courses