ACCESS TRAINING COURSES OXFORD
About Enable Technology Oxford Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All of our tutors are Microsoft Certified Professionals. Every person attending a Access course will be provided with training materials and practice files to retain after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a Access course at an alternative training site in Oxford. We will work with you prior to the course to tailor the Access syllabus to match your 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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Capita Group PLC, Fujistu PLC, Wolverhampton City Council, Queen's Medical Centre Nottingham, Canadian High Commission, South Staffordshire Water PLC, Keele University and Norwich Union PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Oxford
- 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 Development Environment
- See Training Course Details...
Working with Events
Using the CacheSize Property - Optional
Understanding Control-of-Flow Structures
Setting Breakpoints
Using the If...End If Decision Structures
Guidelines for use of Branching Structures
Understanding Collections
Using the For...Next Structure
Calling Procedures
Using the Select Case...End Select Structure
Organizing Code and Procedures
Understanding Errors
Understanding Procedures
Specifying a Recordset Cursor Type
Working with the ADODB Recordset Object
Naming Procedures
Working with Recordsets
Using Message Boxes
Writing an Error-Handling Routine
Microsoft Access
- 2 day course
- Location: Oxford
- 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 ... Creating and Using Forms
- See Training Course Details...
Understanding VBA
Modifying Table Structures
Using a Navigation Form
Action Queries
Calculations in Queries
Querying Techniques
Creating a Lookup Database
Adding Transactional Records
Working With Records
Adding Records to a Table
An Introduction to VBA
Sorting and Filtering
Parameter Queries
Database Wellness
DIY Forms
Getting to Know Access
Creating a Relational Database
Importing and Exporting Records
Designing a Lookup Database
Creating and Using Reports
Email us about this courses
Other Oxford Enable Technology Training Courses
Report Builder - Oxford SQL Server Reporting Services Training Courses
SQL - Oxford SQL Training Courses
DAX Oxford Training Courses
SSRS - Oxford SQL Server Reporting Services Training Courses
Data Warehouse Oxford Training Courses
Power Query - Oxford Excel Training Courses