ACCESS TRAINING COURSES ASHTON-UNDER-LYNE
About Enable Technology Ashton-under-lyne Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. We also offer the option of scheduling of Access course at a venue near you in Ashton-under-lyne. We are happy to discuss customising the course content should you have particular Access training requirements.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Capita Group PLC, Carillion PLC, Cadbury PLC, Countrywide Homes Limited, Shell UK Oil Products Ltd, National Power PLC, Yell Group PLC and Fujistu PLC.
Microsoft Access
- 2 day course
- Location: Ashton-under-lyne
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Creating and Using Reports
- See Training Course Details...
Adding Transactional Records
Setting Table Relationships
Calculations in Queries
Action Queries
Modifying Table Structures
Querying Techniques
Macros on Forms
An Introduction to VBA
Relational Database Design
Understanding VBA
Database Security
Parameter Queries
Creating and Using Macros
Sorting and Filtering
DIY Forms
Working With Records
Creating a Relational Database
Modifying Forms
Importing and Exporting Records
Formatting Tables
Microsoft Access Programming Using VBA
- 3 day course
- Location: Ashton-under-lyne
- 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 ... Naming Procedures
- See Training Course Details...
Working with the ADODB Recordset Object
Working with Boolean Expressions
Working with Procedures and Functions
Using the For...Next Structure
Understanding Error Handling
Determining the Value of Expressions
Working with the Application Object
Using Input Boxes
Understanding Constants
Calling Procedures
Declaring Variables
Handling Errors
Specifying a Recordset Cursor Location - Optional
Using Expressions, Variables, and Intrinsic Functions
Working with Variable Lifetime
Using the Object Browser
Organizing Code and Procedures
Understanding Classes and Objects
Email us about this courses
Other Ashton-under-lyne Enable Technology Training Courses
SSAS Tabular Ashton-under-lyne Training Courses
Power Query - Ashton-under-lyne Excel Training Courses
Power BI - Ashton-under-lyne Microsoft Power BI Training Courses
JQuery Mobile - Ashton-under-lyne JavaScript Training Courses
Oracle SQL - Ashton-under-lyne SQL Training Courses
Data Warehouse - Ashton-under-lyne SQL Training Courses