ACCESS TRAINING COURSES LEYLAND
About Enable Technology Leyland Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each course participant will be issued with training Access resources which they can continue to use after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
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. The Access course could also be scheduled at a socially distanced site near you in Leyland. All Access courses can be customised to meet your particular requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Countrywide Homes Limited, Halfords Group PLC, Norfolk Police Constabulary, National Power PLC, South Staffordshire Water PLC, Wolverhampton City Council, Birmingham City Council and TalkTalk Direct Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Leyland
- 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 ... Naming Procedures
- See Training Course Details...
Declaring Variables
Guidelines for use of Branching Structures
Using the Select Case...End Select Structure
Using Visual Basic Help
Controlling Program Execution
Using Message Boxes
Creating a Function Procedure
Using Debugging Tools
Working with Events
Setting Break Expressions
Understanding Control-of-Flow Structures
Working with Variable Lifetime
Working with the Application Object
Understanding Recordset Cursor Properties - Optional
Specifying a Recordset Cursor Type
Using Expressions, Variables, and Intrinsic Functions
Understanding Procedures
Declaring and Creating Object Variables
Navigating the Access Object Hierarchy
Microsoft Access
- 2 day course
- Location: Leyland
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Using a Navigation Form
- See Training Course Details...
Querying Techniques
Parameter Queries
Database Wellness
Setting Table Relationships
Understanding VBA
Calculations in Queries
Formatting Tables
Designing a Lookup Database
Getting to Know Access
Macros on Forms
Adding Records to a Table
Action Queries
Multi Table Queries
Working With Records
Modifying Table Structures
Creating and Using Macros
Modifying Forms
Macro Techniques
DIY Forms
Creating and Using Forms
Email us about this courses
Other Leyland Enable Technology Training Courses
Oracle SQL - Leyland SQL Training Courses
JQuery - Leyland JavaScript Training Courses
SQL - Leyland SQL Training Courses
SSRS Leyland Training Courses
Power Query - Leyland Excel Training Courses
Excel 365 Basic - Leyland Excel Training Courses