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. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away Access courseware which can be used as reference materials after the training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. 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 you prefer we can offer an offsite socially distanced training location in Lytham Urmston. We are happy to modify the Access syllabus to match your teams training requirements.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Royal & Sun Alliance Group PLC, Nuclear Engineering Services, Lloyds TSB Bank PLC, Yell Group PLC, Loughborough University, Vodafone Group Services, Barclays Bank PLC and Fujistu PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Lytham Urmston
- 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 ... Understanding Recordset Cursor Properties - Optional
- See Training Course Details...
Using the For Each...Next Structure
Creating a Standard Module
Determining the Value of Expressions
Working with Methods
Using Intrinsic Functions
Organizing Code and Procedures
Understanding Data Types
Understanding Errors
Understanding VBA's Error Trapping Options
Understanding Collections
Why Program in Access?
Calling Procedures
Naming Procedures
Using the For...Next Structure
Understanding the Err Object
Declaring Variables
Using the Select Case...End Select Structure
Understanding Objects
Working with the Code Editor
Microsoft Access
- 2 day course
- Location: Lytham Urmston
- 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 ... Setting Table Relationships
- See Training Course Details...
Aggregation Queries
Navigation Pane Protection
Creating and Using Reports
Designing a Lookup Database
Formatting Tables
Adding Records to a Table
Adding Transactional Records
Action Queries
Sorting and Filtering
Creating a Relational Database
Parameter Queries
An Introduction to VBA
DIY Forms
Creating and Using Forms
Calculations in Queries
Database Wellness
Modifying Table Structures
Data Validation
Macro Techniques
Importing and Exporting Records
Email us about this courses
Other Lytham Urmston Enable Technology Training Courses
Power BI Lytham Urmston Training Courses
Power Query - Lytham Urmston Excel Training Courses
JQuery Mobile Lytham Urmston Training Courses
Excel 365 Basic - Lytham Urmston Excel Training Courses
SQL Lytham Urmston Training Courses
PL/SQL Lytham Urmston Training Courses