ACCESS TRAINING COURSES LYTHAM URMSTON
About Enable Technology Lytham Urmston Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
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 also offer the option of scheduling of Access course at a venue near you in Lytham Urmston. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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. Some of our clients are Unipart Group, Norwich Union PLC, Cadbury PLC, South Staffordshire Water PLC, Shell UK Oil Products Ltd, Keele University, GKN PLC and Queen's Medical Centre Nottingham.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Lytham Urmston
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Locking Records for Updating
- See Training Course Details...
Debugging Code
Understanding Error Handling
Understanding the DoCmd Object
Using the CacheSize Property - Optional
Specifying a Recordset Cursor Location - Optional
Working with Recordsets
Using the Do...Loop Structure
Handling Errors
Calling Procedures
Controlling Program Execution
Specifying a Recordset Cursor Type
Using Expressions, Variables, and Intrinsic Functions
Using the Select Case...End Select Structure
Working with Boolean Expressions
Creating a Sub Procedure
Declaring and Creating Object Variables
Navigating the Access Object Hierarchy
Using Intrinsic Functions
Understanding the Development Environment
Microsoft Access
- 2 day course
- Location: Lytham Urmston
- 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 ... Working With Records
- See Training Course Details...
Sorting and Filtering
Adding Transactional Records
Modifying Table Structures
Formatting Tables
Macros on Forms
Creating and Using Macros
Modifying Forms
DIY Forms
Designing a Lookup Database
Creating and Using Reports
An Introduction to VBA
Creating a Relational Database
Aggregation Queries
Creating and Using Forms
Multi Table Queries
Using a Navigation Form
Database Security
Importing and Exporting Records
Understanding VBA
Action Queries
Email us about this courses
Other Lytham Urmston Enable Technology Training Courses
JavaScript Lytham Urmston Training Courses
SSRS Lytham Urmston Training Courses
PL/SQL Lytham Urmston Training Courses
Excel Power Pivot Lytham Urmston Training Courses
Power BI - Lytham Urmston Microsoft Power BI Training Courses
Oracle SQL - Lytham Urmston SQL Training Courses