ACCESS TRAINING COURSES CHIPPENHAM
About Enable Technology Chippenham Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The tutor delivering the course will be a Microsoft certified expert. We provide every candidate with Access training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
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. We are also more than happy to organise a local course at a training location in Chippenham. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Homeserve PLC, Unipart Group, Shell UK Oil Products Ltd, DHL Express, Barclays Bank PLC, Yell Group PLC, Birmingham City University and South Staffordshire Water PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Chippenham
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Working with Boolean Expressions
- See Training Course Details...
Using the Do...Loop Structure
Creating a Standard Module
Understanding the Development Environment
Using the Immediate Window to Call Procedures
Setting Breakpoints
Understanding Constants
Understanding the Form Object
Using Intrinsic Constants
Working with Methods
Specifying a Recordset Cursor Location - Optional
Using the Object Browser
Working with Properties
Creating a Sub Procedure
Why Program in Access?
Calling Procedures
Using the If...End If Decision Structures
Organizing Code and Procedures
Microsoft Access
- 2 day course
- Location: Chippenham
- 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 ... Modifying Table Structures
- See Training Course Details...
Setting Table Relationships
Macro Techniques
Creating a Relational Database
Macros on Forms
Creating and Using Forms
An Introduction to VBA
Modifying Forms
Calculations in Queries
Formatting Tables
Relational Database Design
Aggregation Queries
Navigation Pane Protection
Creating and Using Macros
Using a Navigation Form
Creating Queries
Multi Table Queries
Database Security
DIY Forms
Importing and Exporting Records
Understanding VBA
Email us about this courses
Other Chippenham Enable Technology Training Courses
Data Warehouse - Chippenham SQL Training Courses
Oracle SQL - Chippenham SQL Training Courses
SSAS Tabular Chippenham Training Courses
Excel 365 Basic - Chippenham Excel Training Courses
VBA - Chippenham Excel Training Courses
JQuery Mobile - Chippenham JavaScript Training Courses