ACCESS TRAINING COURSES SHEFFIELD
About Enable Technology Sheffield Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The tutor delivering the course will be a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology training courses are delivered as instructor led courses. 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. We are also more than happy to organise a local course at a socially distanced training location in Sheffield. All Access courses can be customised to meet your particular requirements.
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.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Carillion PLC, Countrywide Homes Limited, Vodafone Group Services, GKN PLC, West Bromwich Building Society, Birmingham City Council, Cadbury PLC and Nuclear Engineering Services.
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 Error Handling
- See Training Course Details...
Working with Boolean Expressions
Debugging Code
Declaring Variables
Understanding Data Types
Guidelines for use of Branching Structures
Using Message Boxes
Working with Procedures and Functions
Using Input Boxes
Specifying a Recordset Cursor Location - Optional
Using Intrinsic Functions
Understanding the Err Object
Creating a Sub Procedure
Working with Events
Controlling Program Execution
Declaring and Creating Object Variables
Setting Breakpoints
Microsoft Access
- 2 day course
- Location: Sheffield
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Navigation Pane Protection
- See Training Course Details...
Designing a Lookup Database
Creating a Lookup Database
Creating and Using Macros
Sorting and Filtering
Creating and Using Reports
Relational Database Design
An Introduction to VBA
Getting to Know Access
Multi Table Queries
Macro Techniques
Creating Queries
Querying Techniques
Working With Records
Action Queries
Adding Records to a Table
Database Security
Aggregation Queries
Parameter Queries
Using a Navigation Form
Creating a Relational Database
Email us about this courses
Other Sheffield Enable Technology Training Courses
VBA Sheffield Training Courses
Oracle SQL Sheffield Training Courses
SSAS Tabular - Sheffield SQL Server Analysis Services Training Courses
Data Warehouse - Sheffield SQL Training Courses
DAX - Sheffield Excel Training Courses
JQuery - Sheffield JavaScript Training Courses