ACCESS TRAINING COURSES ROWLEY
About Enable Technology Rowley Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. 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.
We provide instructor led training coupled with hands on training. 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 Rowley. The Access syllabus can be adjusted and additional topics incorporated if helpful.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Royal & Sun Alliance Group PLC, Shell UK Oil Products Ltd, Nationwide Building Society Limited, Carillion PLC, Vodafone Group Services, Homeserve PLC, Unipart Group and Cadbury PLC.
Microsoft Access
- 2 day course
- Location: Rowley
- Telephone on 01952 938014
- 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 ... Adding Transactional Records
- See Training Course Details...
Data Validation
Macro Techniques
Parameter Queries
Creating and Using Macros
Relational Database Design
Getting to Know Access
Database Wellness
Action Queries
Understanding VBA
Importing and Exporting Records
Querying Techniques
Adding Records to a Table
Modifying Forms
Navigation Pane Protection
DIY Forms
Modifying Table Structures
Setting Table Relationships
Formatting Tables
Creating a Relational Database
Working With Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: Rowley
- 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 ... Using Debugging Tools
- See Training Course Details...
Calling Procedures
Understanding Data Types
Working with Recordsets
Declaring and Creating Object Variables
Working with the ADODB Recordset Object
Working with Properties
Understanding Control-of-Flow Structures
Creating a Function Procedure
Understanding the Order of Events
Specifying a Recordset Cursor Location - Optional
Understanding Errors
Working with Methods
Working with Procedures and Functions
Setting Breakpoints
Working with Events
Understanding Procedures
Understanding Error Handling
Understanding Objects
Email us about this courses
Other Rowley Enable Technology Training Courses
SSRS - Rowley SQL Server Reporting Services Training Courses
SSAS Rowley Training Courses
Power Query - Rowley Excel Training Courses
Power BI Rowley Training Courses
JavaScript - Rowley JavaScript Training Courses
Oracle SQL Rowley Training Courses