ACCESS TRAINING COURSES WALLASEY
About Enable Technology Wallasey Access Training Courses
We have a twenty year history of providing skills based Access industry training. 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. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the Access course at a socially distanced local training venue in Wallasey. All Access courses can be customised to meet your particular requirements.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Keele University, South Staffordshire Water PLC, Capita Group PLC, Canadian High Commission, Nationwide Building Society Limited, DHL Express, Birmingham City University and Shell UK Oil Products Ltd.
Microsoft Access
- 2 day course
- Location: Wallasey
- 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 ... Sorting and Filtering
- See Training Course Details...
Creating a Relational Database
Modifying Table Structures
Creating and Using Reports
Relational Database Design
DIY Forms
Creating and Using Forms
Modifying Forms
Macros on Forms
Using a Navigation Form
Data Validation
Database Security
An Introduction to VBA
Getting to Know Access
Creating Queries
Creating a Lookup Database
Action Queries
Working With Records
Importing and Exporting Records
Calculations in Queries
Designing a Lookup Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wallasey
- 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 ... Using Break Mode during Run Mode
- See Training Course Details...
Working with Methods
Organizing Code and Procedures
Using Expressions, Variables, and Intrinsic Functions
Debugging Code
Working with the ADODB Recordset Object
Understanding Error Handling
Using Input Boxes
Creating a Function Procedure
Using the For Each...Next Structure
Understanding Constants
Using the Do...Loop Structure
Understanding Procedures
Specifying a Recordset Cursor Location - Optional
Working with Recordsets
Working with the Code Editor
Working with Inline Error Handling
Understanding Objects
Understanding Data Types
Using Visual Basic Help
Using the If...End If Decision Structures
Email us about this courses
Other Wallasey Enable Technology Training Courses
SSAS Tabular - Wallasey SQL Server Analysis Services Training Courses
DAX - Wallasey Excel Training Courses
JavaScript - Wallasey JavaScript Training Courses
Excel 365 Basic - Wallasey Excel Training Courses
PL/SQL - Wallasey SQL Training Courses
Excel 365 Advanced - Wallasey Excel Training Courses