ACCESS TRAINING COURSES LANCASHIRE
About Enable Technology Lancashire Access Training Courses
We offer intensive two and three days Access courses. We guarantee the training will be delivered by a Microsoft certified expert. We provide every candidate with Access training materials which they keep after the course. 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.
We provide instructor led training coupled with hands on training. 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. If delivery onsite is an issue we will organise a venue near you in Lancashire. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations 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.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Keele University, Total Telecommunications Limited, South Staffordshire Water PLC, Boots UK Limited, Fujistu PLC, Nationwide Building Society Limited, GKN PLC and Cadbury PLC.
Microsoft Access
- 2 day course
- Location: Lancashire
- 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 ... Navigation Pane Protection
- See Training Course Details...
Modifying Forms
Sorting and Filtering
Modifying Table Structures
Setting Table Relationships
Designing a Lookup Database
Adding Transactional Records
Calculations in Queries
Database Wellness
Getting to Know Access
Creating Queries
Database Security
Creating and Using Reports
Creating and Using Macros
Querying Techniques
Aggregation Queries
Understanding VBA
Action Queries
Importing and Exporting Records
Macros on Forms
Data Validation
Microsoft Access Programming Using VBA
- 3 day course
- Location: Lancashire
- 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 ... Stepping through Code
- See Training Course Details...
Understanding the Err Object
Understanding Error Handling
Working with Methods
Using Intrinsic Constants
Controlling Program Execution
Understanding Constants
Setting Breakpoints
Understanding Control-of-Flow Structures
Using Input Boxes
Understanding Collections
Naming Procedures
Using Break Mode during Run Mode
Understanding the DoCmd Object
Using Expressions, Variables, and Intrinsic Functions
Understanding Errors
Setting Break Expressions
Working with Properties
Introduction to Programming in Access
Email us about this courses
Other Lancashire Enable Technology Training Courses
DAX - Lancashire Excel Training Courses
SQL - Lancashire SQL Training Courses
TSQL Lancashire Training Courses
Excel 365 Advanced - Lancashire Excel Training Courses
VBA Lancashire Training Courses
SSIS - Lancashire SQL Server Integration Services Training Courses