ACCESS TRAINING COURSES ELLESMERE PORT
About Enable Technology Ellesmere Port Access Training Courses
Enable Technology specialise in succinct skills based Access training. The training will be delivered by a Microsoft professional with development experience. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. 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 Ellesmere Port. We are happy to discuss customising the course content should you have particular Access 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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Wolverhampton City Council, University of Birmingham, Birmingham City Council, EDF Energy PLC, Norfolk Police Constabulary, Lloyds TSB Bank PLC, Keele University and Carillion PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Ellesmere Port
- 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 ... Understanding Data Types
- See Training Course Details...
Understanding Procedures
Understanding Error Handling
Creating a Standard Module
Understanding the Development Environment
Understanding Objects
Understanding Recordset Cursor Properties - Optional
Determining the Value of Expressions
Understanding Modules
Specifying a Recordset Cursor Location - Optional
Understanding the DoCmd Object
Working with the Code Editor
Working with Procedures and Functions
Specifying a Recordset Cursor Type
Declaring Variables
Working with Events
Creating a Function Procedure
Working with Inline Error Handling
Working with the ADODB Recordset Object
Microsoft Access
- 2 day course
- Location: Ellesmere Port
- 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 ... Designing a Lookup Database
- See Training Course Details...
Calculations in Queries
Working With Records
Modifying Forms
Understanding VBA
DIY Forms
Creating and Using Macros
Aggregation Queries
Modifying Table Structures
Action Queries
Creating and Using Forms
Navigation Pane Protection
Sorting and Filtering
Creating and Using Reports
Database Security
Adding Records to a Table
Setting Table Relationships
Using a Navigation Form
Importing and Exporting Records
Formatting Tables
Macro Techniques
Email us about this courses
Other Ellesmere Port Enable Technology Training Courses
JavaScript - Ellesmere Port JavaScript Training Courses
Oracle SQL - Ellesmere Port SQL Training Courses
JQuery Ellesmere Port Training Courses
SSIS - Ellesmere Port SQL Server Integration Services Training Courses
Report Builder - Ellesmere Port SQL Server Reporting Services Training Courses
Excel 365 Basic Ellesmere Port Training Courses