ACCESS TRAINING COURSES ALTRINCHAM
About Enable Technology Altrincham Access Training Courses
Enable Technology specialise in succinct skills based Access training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All course participants are issued Access training manuals they can refer to after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. Another option is we can organise a local training site in Altrincham. The Access syllabus can be modified to accommodate your specific training needs.
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.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Boots UK Limited, Norfolk Police Constabulary, Countrywide Homes Limited, Vodafone Group Services, Yell Group PLC, Unipart Group, University of Birmingham and Canadian High Commission.
Microsoft Access
- 2 day course
- Location: Altrincham
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Understanding VBA
- See Training Course Details...
Adding Transactional Records
Getting to Know Access
Parameter Queries
Working With Records
Creating and Using Macros
Navigation Pane Protection
Relational Database Design
Designing a Lookup Database
An Introduction to VBA
Modifying Forms
Adding Records to a Table
DIY Forms
Sorting and Filtering
Aggregation Queries
Multi Table Queries
Creating a Lookup Database
Database Security
Modifying Table Structures
Creating and Using Reports
Creating and Using Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Altrincham
- 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 Expressions and Statements
- See Training Course Details...
Using Expressions, Variables, and Intrinsic Functions
Working with the ADODB Recordset Object
Debugging Code
Controlling Program Execution
Understanding Classes and Objects
Using the For...Next Structure
Using Break Mode during Run Mode
Understanding Objects
Understanding Data Types
Using Intrinsic Functions
Understanding the Order of Events
Understanding the Form Object
Using the Do...Loop Structure
Calling Procedures
Understanding Collections
Working with Methods
Writing an Error-Handling Routine
Understanding Procedures
Email us about this courses
Other Altrincham Enable Technology Training Courses
Excel 365 Intermediate Altrincham Training Courses
VBA - Altrincham Excel Training Courses
JQuery Altrincham Training Courses
SSRS Altrincham Training Courses
Power Query - Altrincham Excel Training Courses
SSIS Altrincham Training Courses