ACCESS TRAINING COURSES LICHFIELD
About Enable Technology Lichfield Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. We provide every candidate with Access training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Courses are instructor led and groups sizes small. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite training location in Lichfield. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
We have operated primarily in the West Midlands for twenty years. Our clients include: Vodafone Group Services, Shell UK Oil Products Ltd, TalkTalk Direct Limited, Carillion PLC, DHL Express, GKN PLC, Canadian High Commission and Yell Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Lichfield
- 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 the Err Object
- See Training Course Details...
Determining the Value of Expressions
Specifying a Recordset Cursor Location - Optional
Working with Variable Lifetime
Understanding the Form Object
Why Program in Access?
Using the If...End If Decision Structures
Understanding Errors
Understanding Expressions and Statements
Introduction to Programming in Access
Working with Recordsets
Understanding Recordset Cursor Properties - Optional
Creating a Sub Procedure
Using the Select Case...End Select Structure
Using the For Each...Next Structure
Using Visual Basic Help
Using Input Boxes
Using Intrinsic Constants
Microsoft Access
- 2 day course
- Location: Lichfield
- 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 ... Formatting Tables
- See Training Course Details...
An Introduction to VBA
Adding Records to a Table
Understanding VBA
Database Security
Navigation Pane Protection
Creating a Relational Database
Parameter Queries
Working With Records
Relational Database Design
Using a Navigation Form
Designing a Lookup Database
Database Wellness
Importing and Exporting Records
Multi Table Queries
DIY Forms
Setting Table Relationships
Creating and Using Reports
Creating a Lookup Database
Macros on Forms
Adding Transactional Records
Email us about this courses
Other Lichfield Enable Technology Training Courses
Excel 365 Intermediate Lichfield Training Courses
Excel 365 Basic Lichfield Training Courses
Power Query Lichfield Training Courses
SSAS Tabular - Lichfield SQL Server Analysis Services Training Courses
Report Builder - Lichfield SQL Server Reporting Services Training Courses
SSAS - Lichfield SQL Server Analysis Services Training Courses