ACCESS TRAINING COURSES YOEVIL
About Enable Technology Yoevil Access Training Courses
We are a company that provides short intensive Access training courses. 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. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Enable Technology training courses are delivered as instructor led courses. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Another option is we can organise a local training site in Yoevil. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Royal & Sun Alliance Group PLC, Unipart Group, EDF Energy PLC, Barclays Bank PLC, Loughborough University, West Bromwich Building Society, University of Birmingham and Boots UK Limited.
Microsoft Access
- 2 day course
- Location: Yoevil
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Calculations in Queries
- See Training Course Details...
Database Security
Using a Navigation Form
Getting to Know Access
Querying Techniques
Navigation Pane Protection
Creating a Lookup Database
Creating Queries
Macros on Forms
Macro Techniques
Adding Transactional Records
Relational Database Design
Parameter Queries
Formatting Tables
Importing and Exporting Records
Sorting and Filtering
DIY Forms
Creating and Using Forms
Setting Table Relationships
Creating and Using Reports
An Introduction to VBA
Microsoft Access Programming Using VBA
- 3 day course
- Location: Yoevil
- 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 ... Setting Break Expressions
- See Training Course Details...
Understanding the Order of Events
Declaring Variables
Working with Recordsets
Stepping through Code
Creating a Standard Module
Understanding Errors
Understanding Constants
Understanding Procedures
Setting Breakpoints
Working with the ADODB Recordset Object
Understanding Data Types
Understanding the DoCmd Object
Using Visual Basic Help
Using Break Mode during Run Mode
Writing an Error-Handling Routine
Understanding Collections
Using Expressions, Variables, and Intrinsic Functions
Working with Properties
Email us about this courses
Other Yoevil Enable Technology Training Courses
JavaScript - Yoevil JavaScript Training Courses
Power Query - Yoevil Excel Training Courses
JQuery Mobile - Yoevil JavaScript Training Courses
Power BI - Yoevil Microsoft Power BI Training Courses
Excel Power Pivot Yoevil Training Courses
SSIS Yoevil Training Courses