ACCESS TRAINING COURSES BURNLEY
About Enable Technology Burnley Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The training will be delivered by a Microsoft professional with development experience. Each course participant will be issued with training Access resources which they can continue to use after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Access courses are taught by a Microsoft Certified Solutions Expert. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite training location in Burnley. We are happy to discuss customising the course content should you have particular Access training requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
We have operated primarily in the West Midlands for twenty years. Our clients include: Carillion PLC, Birmingham City Council, Vodafone Group Services, Royal & Sun Alliance Group PLC, Royal Air Force, Aston University, Barclays Bank PLC and Loughborough University.
Microsoft Access
- 2 day course
- Location: Burnley
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Aggregation Queries
- See Training Course Details...
Database Security
Database Wellness
Querying Techniques
Macros on Forms
Creating a Relational Database
Working With Records
Creating and Using Macros
Relational Database Design
Designing a Lookup Database
Importing and Exporting Records
Modifying Forms
Calculations in Queries
Navigation Pane Protection
Macro Techniques
Creating Queries
Multi Table Queries
Parameter Queries
DIY Forms
Creating and Using Reports
Adding Records to a Table
Microsoft Access Programming Using VBA
- 3 day course
- Location: Burnley
- Telephone on 01952 938014
- 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 ... Writing an Error-Handling Routine
- See Training Course Details...
Determining the Value of Expressions
Using the With Statement
Using Intrinsic Constants
Using Visual Basic Help
Working with Variable Lifetime
Locking Records for Updating
Considering Variable Scope and Lifetime Together
Working with Methods
Working with Procedures and Functions
Using Input Boxes
Using the For...Next Structure
Setting Break Expressions
Understanding the Err Object
Working with Inline Error Handling
Trapping Errors with the On Error Statement
Understanding Procedures
Creating a Sub Procedure
Using the Select Case...End Select Structure
Understanding the Development Environment
Email us about this courses
Other Burnley Enable Technology Training Courses
TSQL Burnley Training Courses
SQL - Burnley SQL Training Courses
JavaScript - Burnley JavaScript Training Courses
Oracle SQL - Burnley SQL Training Courses
SSRS Burnley Training Courses
Power Query - Burnley Excel Training Courses