ACCESS TRAINING COURSES ECCLES
About Enable Technology Eccles Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant is given Access courseware which they can refer to after the training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We also offer the option of scheduling of Access course at a venue near you in Eccles. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are South Staffordshire Water PLC, Fujistu PLC, Birmingham City Council, Keele University, Norwich Union PLC, Birmingham City University, Barclays Bank PLC and Royal & Sun Alliance Group PLC.
Microsoft Access
- 2 day course
- Location: Eccles
- 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 ... Database Security
- See Training Course Details...
Creating a Lookup Database
Macros on Forms
Creating and Using Forms
Understanding VBA
Macro Techniques
Adding Transactional Records
Creating and Using Macros
DIY Forms
Aggregation Queries
Action Queries
Calculations in Queries
Data Validation
Importing and Exporting Records
Database Wellness
Navigation Pane Protection
Formatting Tables
Setting Table Relationships
Using a Navigation Form
Modifying Table Structures
Querying Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Eccles
- 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 ... Determining the Value of Expressions
- See Training Course Details...
Understanding Procedures
Working with the Code Editor
Using Expressions, Variables, and Intrinsic Functions
Working with Procedures and Functions
Using the For Each...Next Structure
Working with the ADODB Recordset Object
Understanding Constants
Using the For...Next Structure
Locking Records for Updating
Using the With Statement
Understanding Expressions and Statements
Navigating the Access Object Hierarchy
Understanding Errors
Working with Variable Scope
Understanding the Err Object
Controlling Program Execution
Introduction to Programming in Access
Email us about this courses
Other Eccles Enable Technology Training Courses
Power Query Eccles Training Courses
Power BI Eccles Training Courses
SSRS Eccles Training Courses
VBA - Eccles Excel Training Courses
PL/SQL - Eccles SQL Training Courses
Excel 365 Basic - Eccles Excel Training Courses