ACCESS TRAINING COURSES SOMERSET
About Enable Technology Somerset Access Training Courses
We are a company that provides short intensive Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a Access course receives learning resources which also serves as a reference source after the course. 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Another way we could deliver the Access course is at a local training site. We are happy to discuss customising the course content should you have particular Access training requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are DHL Express, Royal & Sun Alliance Group PLC, Carillion PLC, Birmingham Heartlands Hospital, Fujistu PLC, Countrywide Homes Limited, Royal Air Force and Homeserve PLC.
Microsoft Access
- 2 day course
- Location: Somerset
- 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...
Sorting and Filtering
Relational Database Design
Database Security
Multi Table Queries
Working With Records
Database Wellness
Data Validation
Importing and Exporting Records
Parameter Queries
Creating a Lookup Database
Modifying Table Structures
Understanding VBA
Calculations in Queries
An Introduction to VBA
Designing a Lookup Database
Macro Techniques
Creating and Using Macros
Navigation Pane Protection
Querying Techniques
Creating a Relational Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: Somerset
- 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 ... Working with the Code Editor
- See Training Course Details...
Using Message Boxes
Understanding VBA's Error Trapping Options
Understanding Procedures
Using Break Mode during Run Mode
Working with Methods
Understanding the Development Environment
Understanding the DoCmd Object
Working with Inline Error Handling
Understanding Modules
Introduction to Programming in Access
Understanding the Form Object
Working with Properties
Using the Immediate Window to Call Procedures
Specifying a Recordset Cursor Location - Optional
Using the Select Case...End Select Structure
Working with Recordsets
Trapping Errors with the On Error Statement
Navigating the Access Object Hierarchy
Why Program in Access?
Email us about this courses
Other Somerset Enable Technology Training Courses
Excel 365 Basic Somerset Training Courses
Excel 365 Advanced - Somerset Excel Training Courses
Oracle SQL - Somerset SQL Training Courses
SSAS Somerset Training Courses
SQL Somerset Training Courses
JQuery Somerset Training Courses