ACCESS TRAINING COURSES STAFFORDSHIRE
About Enable Technology Staffordshire 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. Every course participant will receives course practice files and Access course resources that can be referenced post training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. If delivery onsite is an issue we will organise a venue near you in Staffordshire. We are happy to discuss customising the course content should you have particular Access training requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Norwich Union PLC, Norfolk Police Constabulary, National Power PLC, Homeserve PLC, Lloyds TSB Bank PLC, GKN PLC, Birmingham Heartlands Hospital and Halfords Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Staffordshire
- 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 ... Organizing Code and Procedures
- See Training Course Details...
Specifying a Recordset Cursor Location - Optional
Using Input Boxes
Trapping Errors with the On Error Statement
Declaring and Creating Object Variables
Using Message Boxes
Understanding Recordset Cursor Properties - Optional
Working with Methods
Understanding the Order of Events
Working with Recordsets
Using the If...End If Decision Structures
Working with Variable Lifetime
Using the Object Browser
Using the Do...Loop Structure
Understanding Control-of-Flow Structures
Understanding VBA's Error Trapping Options
Using Break Mode during Run Mode
Working with the Code Editor
Using the Select Case...End Select Structure
Handling Errors
Microsoft Access
- 2 day course
- Location: Staffordshire
- 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 Macros
- See Training Course Details...
Navigation Pane Protection
Database Security
Creating and Using Forms
Adding Transactional Records
Using a Navigation Form
Creating and Using Reports
Querying Techniques
Designing a Lookup Database
Creating Queries
Parameter Queries
Data Validation
Creating a Lookup Database
Database Wellness
Aggregation Queries
Action Queries
Sorting and Filtering
DIY Forms
Getting to Know Access
Formatting Tables
Calculations in Queries
Email us about this courses
Other Staffordshire Enable Technology Training Courses
Excel Power Pivot - Staffordshire Excel Training Courses
Data Warehouse Staffordshire Training Courses
JavaScript Staffordshire Training Courses
SQL - Staffordshire SQL Training Courses
SSRS - Staffordshire SQL Server Reporting Services Training Courses
TSQL - Staffordshire SQL Training Courses