ACCESS TRAINING COURSES MILFORD HAVEN
About Enable Technology Milford Haven Access Training Courses
We have a twenty year history of providing skills based Access industry training. We guarantee the training will be delivered by a Microsoft certified expert. Each course participant will be issued with training Access resources which they can continue to use after the training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can bring the equipment necessary to deliver Access courses at your site. Alternatively we could schedule a course at a local venue in Milford Haven. Every Access course can be modified to meet your bespoke 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.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are EDF Energy PLC, DHL Express, TalkTalk Direct Limited, Shell UK Oil Products Ltd, Homeserve PLC, Nuclear Engineering Services, University of Birmingham and Royal Air Force.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Milford Haven
- 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 ... Using Input Boxes
- See Training Course Details...
Using Message Boxes
Guidelines for use of Branching Structures
Using the Immediate Window to Call Procedures
Understanding Constants
Understanding Objects
Understanding the Form Object
Understanding Errors
Why Program in Access?
Determining the Value of Expressions
Working with the Code Editor
Understanding Recordset Cursor Properties - Optional
Using the If...End If Decision Structures
Controlling Program Execution
Using the Object Browser
Naming Procedures
Understanding Error Handling
Organizing Code and Procedures
Understanding the Order of Events
Using the CacheSize Property - Optional
Navigating the Access Object Hierarchy
Microsoft Access
- 2 day course
- Location: Milford Haven
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Creating a Lookup Database
- See Training Course Details...
Getting to Know Access
Macro Techniques
Data Validation
Modifying Table Structures
Creating and Using Macros
Designing a Lookup Database
Querying Techniques
Calculations in Queries
Using a Navigation Form
Aggregation Queries
Database Security
Action Queries
Navigation Pane Protection
Relational Database Design
Modifying Forms
Macros on Forms
Database Wellness
Creating and Using Forms
Creating a Relational Database
Formatting Tables
Email us about this courses
Other Milford Haven Enable Technology Training Courses
Data Warehouse - Milford Haven SQL Training Courses
Report Builder - Milford Haven SQL Server Reporting Services Training Courses
SSAS Tabular Milford Haven Training Courses
TSQL Milford Haven Training Courses
Oracle SQL Milford Haven Training Courses
Excel Power Pivot Milford Haven Training Courses