ACCESS TRAINING COURSES HARROGATE
About Enable Technology Harrogate Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The tutor delivering the course will be a Microsoft certified expert. 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 training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a Access course at an alternative training site in Harrogate. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
We have operated primarily in the West Midlands for twenty years. Our clients include: Birmingham City Council, Homeserve PLC, Dollond & Aitchison Limited, Countrywide Homes Limited, South Staffordshire Water PLC, Unipart Group, Yell Group PLC and EDF Energy PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Harrogate
- 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 ... Understanding the Form Object
- See Training Course Details...
Calling Procedures
Stepping through Code
Understanding Control-of-Flow Structures
Trapping Errors with the On Error Statement
Using Input Boxes
Understanding Modules
Using Message Boxes
Using Break Mode during Run Mode
Understanding Recordset Cursor Properties - Optional
Understanding Data Types
Setting Break Expressions
Setting Breakpoints
Considering Variable Scope and Lifetime Together
Working with Recordsets
Using the Immediate Window to Call Procedures
Understanding Expressions and Statements
Working with Variable Lifetime
Writing an Error-Handling Routine
Controlling Program Execution
Understanding the Err Object
Microsoft Access
- 2 day course
- Location: Harrogate
- 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 ... Database Wellness
- See Training Course Details...
Macros on Forms
Creating a Lookup Database
Understanding VBA
Calculations in Queries
Modifying Table Structures
Querying Techniques
Creating and Using Forms
Creating a Relational Database
Creating and Using Macros
Creating Queries
Adding Transactional Records
Importing and Exporting Records
Parameter Queries
DIY Forms
Multi Table Queries
An Introduction to VBA
Navigation Pane Protection
Sorting and Filtering
Aggregation Queries
Getting to Know Access
Email us about this courses
Other Harrogate Enable Technology Training Courses
JQuery Mobile Harrogate Training Courses
Power BI Harrogate Training Courses
SQL Harrogate Training Courses
DAX Harrogate Training Courses
JQuery Harrogate Training Courses
Excel 365 Intermediate - Harrogate Excel Training Courses