ACCESS TRAINING COURSES YORK
About Enable Technology York Access Training Courses
We offer intensive two and three days Access courses. The training will be delivered by a Microsoft professional with development experience. We will issue each Access training participant with learning resources which they can refer to post training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Enable Technology offers instructor led training taught by technology specialists. We can deliver at your premises. We can provide the equipment. We also offer the option of scheduling of Access course at a venue near you in York. We will work with you prior to the course to tailor the Access syllabus to match your 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.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Yell Group PLC, Shell UK Oil Products Ltd, South Staffordshire Water PLC, Canadian High Commission, Unipart Group, Vodafone Group Services, GKN PLC and National Power PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: York
- 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 ... Stepping through Code
- See Training Course Details...
Specifying a Recordset Cursor Type
Using the If...End If Decision Structures
Specifying a Recordset Cursor Location - Optional
Understanding the Order of Events
Considering Variable Scope and Lifetime Together
Working with Inline Error Handling
Creating a Function Procedure
Understanding Objects
Working with the Code Editor
Understanding Constants
Debugging Code
Using Debugging Tools
Calling Procedures
Understanding Data Types
Working with Recordsets
Using Visual Basic Help
Writing an Error-Handling Routine
Working with Procedures and Functions
Determining the Value of Expressions
Setting Breakpoints
Microsoft Access
- 2 day course
- Location: York
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Database Security
- See Training Course Details...
Creating and Using Macros
Using a Navigation Form
Understanding VBA
Creating a Relational Database
DIY Forms
Multi Table Queries
Parameter Queries
Action Queries
Working With Records
Creating a Lookup Database
Database Wellness
Macro Techniques
Calculations in Queries
Sorting and Filtering
Formatting Tables
Modifying Forms
Relational Database Design
Querying Techniques
Creating and Using Forms
Aggregation Queries
Email us about this courses
Other York Enable Technology Training Courses
TSQL - York SQL Training Courses
Data Warehouse - York SQL Training Courses
JavaScript York Training Courses
JQuery Mobile York Training Courses
SQL York Training Courses
Excel 365 Basic - York Excel Training Courses