ACCESS TRAINING COURSES BURTON ON TRENT
About Enable Technology Burton On Trent Access Training Courses
Enable Technology provides practical Access skills based technology training. The tutor delivering the course will be a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver Access courses onsite at your site. Another option is we can organise a local training site in Burton On Trent. The Access syllabus can be modified to accommodate your specific 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.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Vodafone Group Services, EDF Energy PLC, Nuclear Engineering Services, Norfolk Police Constabulary, West Bromwich Building Society, Loughborough University, Birmingham Heartlands Hospital and GKN PLC.
Microsoft Access
- 2 day course
- Location: Burton On Trent
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Relational Database Design
- See Training Course Details...
Using a Navigation Form
Modifying Table Structures
Multi Table Queries
Parameter Queries
Sorting and Filtering
Designing a Lookup Database
Calculations in Queries
An Introduction to VBA
Creating and Using Forms
Adding Transactional Records
Creating a Relational Database
Modifying Forms
Database Security
Navigation Pane Protection
Understanding VBA
Importing and Exporting Records
Working With Records
Formatting Tables
Creating and Using Reports
Querying Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Burton On Trent
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Creating a Standard Module
- See Training Course Details...
Understanding Expressions and Statements
Introduction to Programming in Access
Specifying a Recordset Cursor Location - Optional
Using the With Statement
Working with Events
Creating a Sub Procedure
Setting Breakpoints
Declaring and Creating Object Variables
Working with the ADODB Recordset Object
Understanding Classes and Objects
Understanding Modules
Trapping Errors with the On Error Statement
Working with Boolean Expressions
Understanding VBA's Error Trapping Options
Using the CacheSize Property - Optional
Working with Variable Scope
Organizing Code and Procedures
Using Intrinsic Functions
Naming Procedures
Email us about this courses
Other Burton On Trent Enable Technology Training Courses
SSIS Burton On Trent Training Courses
JavaScript Burton On Trent Training Courses
SSAS Burton On Trent Training Courses
JQuery - Burton On Trent JavaScript Training Courses
TSQL Burton On Trent Training Courses
Excel 365 Advanced Burton On Trent Training Courses