ACCESS TRAINING COURSES ROTHERHAM
About Enable Technology Rotherham Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant is given Access courseware which they can refer to after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
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. We are also more than happy to organise a local course at a training location in Rotherham. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Carillion PLC, Birmingham City University, DHL Express, Vodafone Group Services, Norwich Union PLC, Canadian High Commission, GKN PLC and Halfords Group PLC.
Microsoft Access
- 2 day course
- Location: Rotherham
- 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 ... Aggregation Queries
- See Training Course Details...
An Introduction to VBA
Getting to Know Access
Creating a Lookup Database
Adding Records to a Table
Parameter Queries
Navigation Pane Protection
Creating a Relational Database
Creating and Using Reports
Modifying Table Structures
Creating and Using Forms
Database Wellness
Data Validation
Macros on Forms
Database Security
Calculations in Queries
Creating and Using Macros
Setting Table Relationships
Multi Table Queries
Importing and Exporting Records
DIY Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Rotherham
- Telephone on 01952 938014
- 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 ... Working with Variable Lifetime
- See Training Course Details...
Working with Recordsets
Understanding Collections
Using the For Each...Next Structure
Understanding Procedures
Introduction to Programming in Access
Understanding Constants
Understanding Error Handling
Guidelines for use of Branching Structures
Using the Do...Loop Structure
Using Intrinsic Constants
Understanding Data Types
Understanding Objects
Understanding Recordset Cursor Properties - Optional
Locking Records for Updating
Using Expressions, Variables, and Intrinsic Functions
Understanding the DoCmd Object
Using Break Mode during Run Mode
Working with Inline Error Handling
Email us about this courses
Other Rotherham Enable Technology Training Courses
Power BI Rotherham Training Courses
SSRS Rotherham Training Courses
Oracle SQL - Rotherham SQL Training Courses
SSIS Rotherham Training Courses
Excel 365 Advanced Rotherham Training Courses
Excel 365 Intermediate Rotherham Training Courses