ACCESS TRAINING COURSES KIRKBY
About Enable Technology Kirkby Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away Access courseware which can be used as reference materials after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. 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 Kirkby. We are happy to discuss customising the course content should you have particular Access training 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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Homeserve PLC, West Bromwich Building Society, Carillion PLC, DHL Express, EDF Energy PLC, Total Telecommunications Limited, Canadian High Commission and Birmingham Heartlands Hospital.
Microsoft Access
- 2 day course
- Location: Kirkby
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... DIY Forms
- See Training Course Details...
Action Queries
Creating and Using Reports
Macros on Forms
Macro Techniques
Sorting and Filtering
Getting to Know Access
Understanding VBA
Working With Records
Importing and Exporting Records
Creating Queries
Creating a Lookup Database
Creating a Relational Database
Multi Table Queries
Relational Database Design
Modifying Forms
Creating and Using Forms
Setting Table Relationships
Designing a Lookup Database
Navigation Pane Protection
Formatting Tables
Microsoft Access Programming Using VBA
- 3 day course
- Location: Kirkby
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Working with Procedures and Functions
- See Training Course Details...
Understanding Collections
Using the Object Browser
Understanding the DoCmd Object
Using Message Boxes
Working with Boolean Expressions
Why Program in Access?
Using the With Statement
Understanding Constants
Setting Break Expressions
Using Break Mode during Run Mode
Using the Do...Loop Structure
Stepping through Code
Determining the Value of Expressions
Using the CacheSize Property - Optional
Understanding the Form Object
Understanding Control-of-Flow Structures
Specifying a Recordset Cursor Type
Using the For...Next Structure
Considering Variable Scope and Lifetime Together
Email us about this courses
Other Kirkby Enable Technology Training Courses
TSQL Kirkby Training Courses
SSAS Tabular - Kirkby SQL Server Analysis Services Training Courses
Data Warehouse Kirkby Training Courses
JQuery Kirkby Training Courses
JavaScript Kirkby Training Courses
VBA Kirkby Training Courses