ACCESS TRAINING COURSES YORK
About Enable Technology York Access Training Courses
We are a company that provides short intensive Access training courses. We guarantee the training will be delivered by a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
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. Alternatively we could schedule a course at a local venue in York. All Access courses can be customised to meet your particular 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.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Halfords Group PLC, Birmingham Heartlands Hospital, Queen's Medical Centre Nottingham, Fujistu PLC, National Power PLC, Norfolk Police Constabulary, University of Birmingham and Birmingham City Council.
Microsoft Access
- 2 day course
- Location: York
- 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 ... Creating and Using Macros
- See Training Course Details...
Importing and Exporting Records
Designing a Lookup Database
Getting to Know Access
Modifying Forms
Formatting Tables
Macro Techniques
Creating Queries
Macros on Forms
Adding Records to a Table
Aggregation Queries
Multi Table Queries
Creating and Using Reports
Database Security
Using a Navigation Form
Creating a Lookup Database
Navigation Pane Protection
Setting Table Relationships
Creating a Relational Database
Creating and Using Forms
Relational Database Design
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 ... Understanding Control-of-Flow Structures
- See Training Course Details...
Why Program in Access?
Declaring Variables
Understanding Errors
Using Debugging Tools
Using the With Statement
Using Intrinsic Functions
Determining the Value of Expressions
Understanding VBA's Error Trapping Options
Debugging Code
Using the For Each...Next Structure
Specifying a Recordset Cursor Type
Using the CacheSize Property - Optional
Using the Do...Loop Structure
Using the If...End If Decision Structures
Using Intrinsic Constants
Creating a Standard Module
Using the Object Browser
Locking Records for Updating
Email us about this courses
Other York Enable Technology Training Courses
Excel 365 Intermediate York Training Courses
Excel Power Pivot York Training Courses
SQL - York SQL Training Courses
Report Builder York Training Courses
SSIS - York SQL Server Integration Services Training Courses
SSRS - York SQL Server Reporting Services Training Courses