ACCESS TRAINING COURSES SHEFFIELD
About Enable Technology Sheffield Access Training Courses
Enable Technology provides practical Access skills based technology training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We provide every candidate with Access training materials which they keep 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.
We provide instructor led training coupled with hands on training. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. Alternatively we could schedule a Access course at an alternative training site in Sheffield. 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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Aston University, Royal & Sun Alliance Group PLC, Canadian High Commission, Loughborough University, Homeserve PLC, Shell UK Oil Products Ltd, GKN PLC and Lloyds TSB Bank PLC.
Microsoft Access
- 2 day course
- Location: Sheffield
- 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 ... Formatting Tables
- See Training Course Details...
Setting Table Relationships
Creating and Using Macros
Data Validation
Creating and Using Forms
Macro Techniques
Using a Navigation Form
Adding Transactional Records
Understanding VBA
An Introduction to VBA
Parameter Queries
Navigation Pane Protection
Creating and Using Reports
Database Security
Getting to Know Access
Creating Queries
Aggregation Queries
Relational Database Design
Macros on Forms
Importing and Exporting Records
Database Wellness
Microsoft Access Programming Using VBA
- 3 day course
- Location: Sheffield
- 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 ... Understanding the Order of Events
- See Training Course Details...
Understanding Classes and Objects
Using the Object Browser
Working with Recordsets
Stepping through Code
Determining the Value of Expressions
Navigating the Access Object Hierarchy
Using Intrinsic Constants
Understanding the Err Object
Understanding Modules
Using the CacheSize Property - Optional
Using the Do...Loop Structure
Working with Boolean Expressions
Working with the Code Editor
Understanding Expressions and Statements
Understanding Objects
Using the Select Case...End Select Structure
Using Message Boxes
Setting Breakpoints
Using the For Each...Next Structure
Email us about this courses
Other Sheffield Enable Technology Training Courses
Data Warehouse - Sheffield SQL Training Courses
Excel 365 Basic Sheffield Training Courses
JQuery Mobile - Sheffield JavaScript Training Courses
Report Builder - Sheffield SQL Server Reporting Services Training Courses
PL/SQL Sheffield Training Courses
DAX - Sheffield Excel Training Courses