ACCESS TRAINING COURSES DENTON
About Enable Technology Denton Access Training Courses
Enable Technology specialise in succinct skills based Access training. The tutor delivering the course will be a Microsoft certified expert. All course participants are issued Access training manuals they can refer to after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can deliver at your premises. We can provide the equipment. We also offer the option of scheduling of Access course at a venue near you in Denton. 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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Birmingham City Council, Capita Group PLC, Canadian High Commission, TalkTalk Direct Limited, Barclays Bank PLC, Birmingham City University, Royal & Sun Alliance Group PLC and Keele University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Denton
- 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 ... Using Debugging Tools
- See Training Course Details...
Using Expressions, Variables, and Intrinsic Functions
Why Program in Access?
Understanding Error Handling
Calling Procedures
Understanding Modules
Understanding the Development Environment
Specifying a Recordset Cursor Location - Optional
Using the CacheSize Property - Optional
Creating a Standard Module
Understanding Objects
Using Intrinsic Constants
Using Visual Basic Help
Understanding the Form Object
Understanding Errors
Writing an Error-Handling Routine
Using Input Boxes
Understanding Collections
Understanding VBA's Error Trapping Options
Setting Break Expressions
Microsoft Access
- 2 day course
- Location: Denton
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Relational Database Design
- See Training Course Details...
Creating a Relational Database
Creating Queries
Creating and Using Forms
Formatting Tables
Getting to Know Access
Macro Techniques
Understanding VBA
Calculations in Queries
An Introduction to VBA
Setting Table Relationships
Creating and Using Macros
Creating a Lookup Database
Importing and Exporting Records
Macros on Forms
Using a Navigation Form
DIY Forms
Modifying Table Structures
Adding Transactional Records
Navigation Pane Protection
Data Validation
Email us about this courses
Other Denton Enable Technology Training Courses
SSRS Denton Training Courses
DAX Denton Training Courses
Excel 365 Advanced Denton Training Courses
SSIS Denton Training Courses
Data Warehouse Denton Training Courses
JQuery Mobile - Denton JavaScript Training Courses