ACCESS TRAINING COURSES OXFORD
About Enable Technology Oxford Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. We guarantee the training will be delivered by a Microsoft certified expert. All course participants are issued Access training manuals they can refer to 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 training courses are delivered as instructor led courses. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. If delivery onsite is an issue we will organise a socially distanced venue near you in Oxford. All Access courses can be customised to meet your particular requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are EDF Energy PLC, Aston University, Capita Group PLC, Keele University, Carillion PLC, Yell Group PLC, Queen's Medical Centre Nottingham and West Bromwich Building Society.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Oxford
- 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 ... Considering Variable Scope and Lifetime Together
- See Training Course Details...
Using Intrinsic Constants
Declaring Variables
Using the Select Case...End Select Structure
Working with Variable Scope
Guidelines for use of Branching Structures
Why Program in Access?
Using the With Statement
Using Debugging Tools
Debugging Code
Determining the Value of Expressions
Using the Object Browser
Using the For...Next Structure
Specifying a Recordset Cursor Type
Creating a Standard Module
Understanding Constants
Trapping Errors with the On Error Statement
Working with Properties
Working with Variable Lifetime
Microsoft Access
- 2 day course
- Location: Oxford
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Designing a Lookup Database
- See Training Course Details...
DIY Forms
Querying Techniques
Modifying Forms
Formatting Tables
Multi Table Queries
Getting to Know Access
Creating a Relational Database
Adding Transactional Records
Creating and Using Reports
Creating and Using Macros
Macros on Forms
Creating a Lookup Database
Understanding VBA
Importing and Exporting Records
Calculations in Queries
Creating and Using Forms
Navigation Pane Protection
Macro Techniques
Creating Queries
Sorting and Filtering
Email us about this courses
Other Oxford Enable Technology Training Courses
Data Warehouse Oxford Training Courses
DAX - Oxford Excel Training Courses
VBA - Oxford Excel Training Courses
Power Query Oxford Training Courses
Excel Power Pivot Oxford Training Courses
SSAS Tabular Oxford Training Courses