ACCESS TRAINING COURSES DONCASTER
About Enable Technology Doncaster Access Training Courses
We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Professionals. 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.
Access courses are taught by a Microsoft Certified Solutions Expert. 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. Another way we could deliver the Access course is at a local socially distanced training site. The Access syllabus can be modified to accommodate your specific training needs.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are EDF Energy PLC, DHL Express, South Staffordshire Water PLC, Lloyds TSB Bank PLC, Royal Air Force, Boots UK Limited, Capita Group PLC and Nuclear Engineering Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Doncaster
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Understanding Constants
- See Training Course Details...
Using Visual Basic Help
Working with Variable Scope
Setting Breakpoints
Using the With Statement
Determining the Value of Expressions
Declaring and Creating Object Variables
Understanding Classes and Objects
Understanding Recordset Cursor Properties - Optional
Understanding Error Handling
Stepping through Code
Specifying a Recordset Cursor Type
Using Message Boxes
Controlling Program Execution
Working with Properties
Working with Recordsets
Locking Records for Updating
Understanding Errors
Working with Boolean Expressions
Introduction to Programming in Access
Microsoft Access
- 2 day course
- Location: Doncaster
- 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 ... Creating a Relational Database
- See Training Course Details...
Understanding VBA
DIY Forms
Sorting and Filtering
Using a Navigation Form
Data Validation
An Introduction to VBA
Adding Records to a Table
Working With Records
Aggregation Queries
Creating Queries
Relational Database Design
Creating and Using Reports
Macro Techniques
Creating and Using Macros
Setting Table Relationships
Modifying Table Structures
Calculations in Queries
Multi Table Queries
Getting to Know Access
Database Security
Email us about this courses
Other Doncaster Enable Technology Training Courses
JQuery Mobile Doncaster Training Courses
Excel Power Pivot - Doncaster Excel Training Courses
Oracle SQL - Doncaster SQL Training Courses
DAX Doncaster Training Courses
Data Warehouse - Doncaster SQL Training Courses
JQuery - Doncaster JavaScript Training Courses