ACCESS TRAINING COURSES SHEFFIELD
About Enable Technology Sheffield Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The training will be delivered by a Microsoft professional with development experience. Each course participant will be issued with training Access resources which they can continue to use after the training. 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. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. If you prefer we can offer an offsite training location in Sheffield. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: National Power PLC, Vodafone Group Services, Cadbury PLC, Yell Group PLC, Norfolk Police Constabulary, Wolverhampton City Council, Nuclear Engineering Services and Aston University.
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 ... Setting Table Relationships
- See Training Course Details...
Data Validation
Modifying Forms
Relational Database Design
Creating and Using Reports
Calculations in Queries
Multi Table Queries
Modifying Table Structures
Navigation Pane Protection
Getting to Know Access
Sorting and Filtering
Creating a Relational Database
Importing and Exporting Records
Macros on Forms
Designing a Lookup Database
Adding Records to a Table
An Introduction to VBA
Action Queries
Parameter Queries
Working With Records
Adding Transactional Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: Sheffield
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Specifying a Recordset Cursor Type
- See Training Course Details...
Setting Break Expressions
Working with Procedures and Functions
Using Expressions, Variables, and Intrinsic Functions
Understanding Data Types
Using Visual Basic Help
Declaring and Creating Object Variables
Using Intrinsic Constants
Understanding Errors
Considering Variable Scope and Lifetime Together
Specifying a Recordset Cursor Location - Optional
Navigating the Access Object Hierarchy
Using Message Boxes
Understanding the Err Object
Working with Variable Scope
Using Intrinsic Functions
Using Break Mode during Run Mode
Stepping through Code
Working with the ADODB Recordset Object
Why Program in Access?
Email us about this courses
Other Sheffield Enable Technology Training Courses
PL/SQL - Sheffield SQL Training Courses
Excel 365 Advanced Sheffield Training Courses
JQuery Sheffield Training Courses
Excel 365 Basic - Sheffield Excel Training Courses
Excel Power Pivot - Sheffield Excel Training Courses
SSIS - Sheffield SQL Server Integration Services Training Courses