ACCESS TRAINING COURSES ROTHERHAM
About Enable Technology Rotherham Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Professionals. 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite training location in Rotherham. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Barclays Bank PLC, Queen's Medical Centre Nottingham, Aston University, Capita Group PLC, University of Birmingham, National Power PLC, Birmingham City University and Homeserve PLC.
Microsoft Access
- 2 day course
- Location: Rotherham
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Querying Techniques
- See Training Course Details...
Database Security
Creating and Using Reports
Creating and Using Macros
Navigation Pane Protection
Macros on Forms
Modifying Forms
Aggregation Queries
Multi Table Queries
DIY Forms
Creating a Lookup Database
Action Queries
Relational Database Design
Adding Records to a Table
Adding Transactional Records
Getting to Know Access
Calculations in Queries
An Introduction to VBA
Importing and Exporting Records
Creating Queries
Modifying Table Structures
Microsoft Access Programming Using VBA
- 3 day course
- Location: Rotherham
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Controlling Program Execution
- See Training Course Details...
Declaring and Creating Object Variables
Understanding the Err Object
Writing an Error-Handling Routine
Understanding Collections
Working with Properties
Calling Procedures
Understanding Procedures
Understanding Constants
Using the Object Browser
Using the With Statement
Working with the Code Editor
Creating a Sub Procedure
Working with Boolean Expressions
Locking Records for Updating
Stepping through Code
Using the If...End If Decision Structures
Understanding Control-of-Flow Structures
Email us about this courses
Other Rotherham Enable Technology Training Courses
TSQL Rotherham Training Courses
Power Query Rotherham Training Courses
SSAS Tabular Rotherham Training Courses
VBA Rotherham Training Courses
Power BI - Rotherham Microsoft Power BI Training Courses
SSRS - Rotherham SQL Server Reporting Services Training Courses