ACCESS TRAINING COURSES BUCKLEY
About Enable Technology Buckley Access Training Courses
Enable Technology specialise in succinct skills based Access training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. 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.
Courses are instructor led and groups sizes small. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. The Access course could also be scheduled at a socially distanced site near you in Buckley. Every Access course can be modified to meet your bespoke requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Boots UK Limited, Royal & Sun Alliance Group PLC, Wolverhampton City Council, Aston University, Birmingham City University, Unipart Group, South Staffordshire Water PLC and Nationwide Building Society Limited.
Microsoft Access
- 2 day course
- Location: Buckley
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Creating a Lookup Database
- See Training Course Details...
Modifying Forms
Adding Records to a Table
Multi Table Queries
Setting Table Relationships
Macros on Forms
Data Validation
Macro Techniques
Aggregation Queries
Adding Transactional Records
Formatting Tables
Creating Queries
Understanding VBA
Querying Techniques
Creating and Using Macros
Using a Navigation Form
Importing and Exporting Records
Calculations in Queries
Getting to Know Access
Database Security
Action Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Buckley
- 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 ... Working with Variable Scope
- See Training Course Details...
Determining the Value of Expressions
Using the For Each...Next Structure
Using the Object Browser
Declaring and Creating Object Variables
Locking Records for Updating
Writing an Error-Handling Routine
Setting Breakpoints
Understanding Procedures
Using Debugging Tools
Using Message Boxes
Declaring Variables
Understanding VBA's Error Trapping Options
Guidelines for use of Branching Structures
Working with Variable Lifetime
Understanding Collections
Using the With Statement
Handling Errors
Working with Methods
Email us about this courses
Other Buckley Enable Technology Training Courses
SQL Buckley Training Courses
DAX Buckley Training Courses
SSAS - Buckley SQL Server Analysis Services Training Courses
Excel 365 Basic Buckley Training Courses
SSAS Tabular Buckley Training Courses
SSIS Buckley Training Courses