ACCESS TRAINING COURSES WARRINGTON
About Enable Technology Warrington Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The training will be delivered by a Microsoft professional with development experience. Every course participant is given Access courseware which they can refer to after the training. 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. 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. Another option is we can organise a local socially distanced training site in Warrington. We are happy to modify the Access syllabus to match your teams training 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.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Yell Group PLC, Halfords Group PLC, National Power PLC, GKN PLC, Shell UK Oil Products Ltd, Unipart Group, Nationwide Building Society Limited and EDF Energy PLC.
Microsoft Access
- 2 day course
- Location: Warrington
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Understanding VBA
- See Training Course Details...
Macro Techniques
Database Security
Adding Transactional Records
Relational Database Design
Creating a Lookup Database
Designing a Lookup Database
Navigation Pane Protection
Importing and Exporting Records
Setting Table Relationships
Calculations in Queries
Creating and Using Forms
Creating and Using Reports
Working With Records
Action Queries
Sorting and Filtering
Database Wellness
Multi Table Queries
Getting to Know Access
Macros on Forms
Using a Navigation Form
Microsoft Access Programming Using VBA
- 3 day course
- Location: Warrington
- 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 the Order of Events
- See Training Course Details...
Working with Variable Lifetime
Using Visual Basic Help
Working with Procedures and Functions
Using Input Boxes
Working with Methods
Understanding Collections
Using Intrinsic Functions
Understanding Error Handling
Using Break Mode during Run Mode
Understanding Constants
Working with Recordsets
Determining the Value of Expressions
Stepping through Code
Using the Immediate Window to Call Procedures
Creating a Sub Procedure
Considering Variable Scope and Lifetime Together
Setting Breakpoints
Understanding Modules
Email us about this courses
Other Warrington Enable Technology Training Courses
SSAS Warrington Training Courses
Power BI Warrington Training Courses
VBA - Warrington Excel Training Courses
PL/SQL - Warrington SQL Training Courses
Excel 365 Advanced - Warrington Excel Training Courses
Report Builder Warrington Training Courses