ACCESS TRAINING COURSES DEVON
About Enable Technology Devon Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each course participant will be issued with training Access resources which they can continue to use after the training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Enable Technology offers instructor led training taught by technology specialists. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We also offer the option of scheduling of Access course at a venue near you in Devon. We are happy to modify the Access syllabus to match your teams training 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 group of companies has been operating continuously providing IT training since 1998. Some of our clients are Canadian High Commission, Fujistu PLC, TalkTalk Direct Limited, Countrywide Homes Limited, Aston University, Total Telecommunications Limited, GKN PLC and Royal & Sun Alliance Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Devon
- 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 ... Working with the ADODB Recordset Object
- See Training Course Details...
Understanding Errors
Understanding the Form Object
Using the CacheSize Property - Optional
Working with Recordsets
Using the Select Case...End Select Structure
Using Break Mode during Run Mode
Using Intrinsic Constants
Using Visual Basic Help
Creating a Function Procedure
Understanding the Order of Events
Working with Boolean Expressions
Understanding the Err Object
Understanding Objects
Using the Immediate Window to Call Procedures
Using Expressions, Variables, and Intrinsic Functions
Understanding Collections
Understanding Classes and Objects
Understanding Constants
Declaring Variables
Microsoft Access
- 2 day course
- Location: Devon
- 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 ... Modifying Forms
- See Training Course Details...
Macros on Forms
Getting to Know Access
An Introduction to VBA
DIY Forms
Data Validation
Modifying Table Structures
Action Queries
Navigation Pane Protection
Sorting and Filtering
Creating a Lookup Database
Formatting Tables
Macro Techniques
Multi Table Queries
Aggregation Queries
Creating and Using Reports
Database Wellness
Querying Techniques
Parameter Queries
Creating and Using Macros
Relational Database Design
Email us about this courses
Other Devon Enable Technology Training Courses
Data Warehouse - Devon SQL Training Courses
SSRS - Devon SQL Server Reporting Services Training Courses
JQuery Mobile - Devon JavaScript Training Courses
Excel Power Pivot - Devon Excel Training Courses
Excel 365 Intermediate - Devon Excel Training Courses
PL/SQL - Devon SQL Training Courses