ACCESS TRAINING COURSES KIDSGROVE
About Enable Technology Kidsgrove Access Training Courses
We offer intensive two and three days Access courses. The tutor delivering the course will be a Microsoft certified expert. All course participants are issued Access training manuals they can refer to 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.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the Access course at a local training venue in Kidsgrove. We are happy to discuss customising the course content should you have particular Access training requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Capita Group PLC, Canadian High Commission, Yell Group PLC, Fujistu PLC, Nationwide Building Society Limited, Cadbury PLC, GKN PLC and Boots UK Limited.
Microsoft Access
- 2 day course
- Location: Kidsgrove
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Getting to Know Access
- See Training Course Details...
Adding Records to a Table
Database Security
Creating and Using Macros
Creating a Relational Database
Creating Queries
Using a Navigation Form
Modifying Table Structures
Querying Techniques
Navigation Pane Protection
DIY Forms
Working With Records
Multi Table Queries
Data Validation
An Introduction to VBA
Database Wellness
Sorting and Filtering
Macros on Forms
Creating and Using Forms
Modifying Forms
Designing a Lookup Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: Kidsgrove
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Working with Boolean Expressions
- See Training Course Details...
Creating a Sub Procedure
Understanding Procedures
Introduction to Programming in Access
Understanding Objects
Using the Do...Loop Structure
Understanding the Order of Events
Working with the Application Object
Working with Properties
Working with Methods
Understanding VBA's Error Trapping Options
Specifying a Recordset Cursor Location - Optional
Why Program in Access?
Using the CacheSize Property - Optional
Working with Recordsets
Understanding Collections
Using Message Boxes
Using Intrinsic Constants
Setting Breakpoints
Working with Variable Scope
Email us about this courses
Other Kidsgrove Enable Technology Training Courses
VBA - Kidsgrove Excel Training Courses
DAX - Kidsgrove Excel Training Courses
SSIS - Kidsgrove SQL Server Integration Services Training Courses
Excel 365 Advanced Kidsgrove Training Courses
SSAS Tabular - Kidsgrove SQL Server Analysis Services Training Courses
SSAS Kidsgrove Training Courses