ACCESS TRAINING COURSES ACCRINGTON
About Enable Technology Accrington Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. We guarantee the training will be delivered by a Microsoft certified expert. Each course participant will be issued with training Access resources which they can continue to use after the training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. 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. We are also more than happy to organise a local course at a socially distanced training location in Accrington. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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 have operated primarily in the West Midlands for twenty years. Our clients include: Capita Group PLC, Total Telecommunications Limited, Birmingham City University, Countrywide Homes Limited, University of Birmingham, Keele University, Canadian High Commission and Shell UK Oil Products Ltd.
Microsoft Access
- 2 day course
- Location: Accrington
- 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 ... Calculations in Queries
- See Training Course Details...
Working With Records
Adding Transactional Records
Getting to Know Access
Action Queries
Understanding VBA
Using a Navigation Form
Creating and Using Reports
Modifying Forms
Designing a Lookup Database
Multi Table Queries
Database Wellness
Navigation Pane Protection
An Introduction to VBA
Creating a Relational Database
Querying Techniques
Creating a Lookup Database
Setting Table Relationships
Sorting and Filtering
Macro Techniques
Creating and Using Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Accrington
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Why Program in Access?
- See Training Course Details...
Working with the Code Editor
Locking Records for Updating
Understanding Constants
Working with the ADODB Recordset Object
Understanding the Form Object
Using Intrinsic Constants
Understanding Objects
Understanding Modules
Naming Procedures
Understanding Procedures
Understanding the Order of Events
Understanding Expressions and Statements
Handling Errors
Using the Object Browser
Setting Break Expressions
Declaring and Creating Object Variables
Using the CacheSize Property - Optional
Controlling Program Execution
Email us about this courses
Other Accrington Enable Technology Training Courses
Power Query - Accrington Excel Training Courses
JavaScript - Accrington JavaScript Training Courses
Excel 365 Intermediate - Accrington Excel Training Courses
JQuery Mobile Accrington Training Courses
Report Builder Accrington Training Courses
VBA Accrington Training Courses