ACCESS TRAINING COURSES MILFORD HAVEN
About Enable Technology Milford Haven Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Professionals. Every course participant will receives course practice files and Access course resources that can be referenced post training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another option is we can organise a local training site in Milford Haven. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your 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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Total Telecommunications Limited, Lloyds TSB Bank PLC, TalkTalk Direct Limited, Birmingham Heartlands Hospital, Keele University, Canadian High Commission, National Power PLC and Royal & Sun Alliance Group PLC.
Microsoft Access
- 2 day course
- Location: Milford Haven
- Telephone on 01952 938014
- 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 ... Creating and Using Reports
- See Training Course Details...
Importing and Exporting Records
Getting to Know Access
Macro Techniques
Database Security
Navigation Pane Protection
Multi Table Queries
Action Queries
Adding Transactional Records
Relational Database Design
An Introduction to VBA
Parameter Queries
Aggregation Queries
Creating and Using Macros
DIY Forms
Data Validation
Modifying Forms
Creating a Relational Database
Macros on Forms
Database Wellness
Adding Records to a Table
Microsoft Access Programming Using VBA
- 3 day course
- Location: Milford Haven
- 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 Recordset Cursor Properties - Optional
- See Training Course Details...
Working with Inline Error Handling
Understanding Data Types
Using the Select Case...End Select Structure
Understanding the Order of Events
Using Debugging Tools
Declaring Variables
Working with Recordsets
Creating a Sub Procedure
Working with Procedures and Functions
Understanding Objects
Working with the ADODB Recordset Object
Trapping Errors with the On Error Statement
Using Input Boxes
Considering Variable Scope and Lifetime Together
Understanding Collections
Creating a Function Procedure
Understanding Errors
Working with the Code Editor
Email us about this courses
Other Milford Haven Enable Technology Training Courses
Power BI Milford Haven Training Courses
Oracle SQL - Milford Haven SQL Training Courses
Power Query - Milford Haven Excel Training Courses
VBA - Milford Haven Excel Training Courses
TSQL Milford Haven Training Courses
Data Warehouse Milford Haven Training Courses