ACCESS TRAINING COURSES TROWBRIDGE
About Enable Technology Trowbridge Access Training Courses
Enable Technology specialise in succinct skills based Access training. All of our tutors are Microsoft Certified Professionals. Every course participant is given Access courseware which they can refer to after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Access courses are taught by a Microsoft Certified Solutions Expert. We are set up to deliver Access training courses onsite at your premises. We are also more than happy to organise a local course at a socially distanced training location in Trowbridge. We are happy to discuss customising the course content should you have particular Access training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Wolverhampton City Council, Barclays Bank PLC, Boots UK Limited, Homeserve PLC, Cadbury PLC, Birmingham City Council, Capita Group PLC and National Power PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Trowbridge
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Understanding the Development Environment
- See Training Course Details...
Working with Variable Lifetime
Specifying a Recordset Cursor Location - Optional
Creating a Sub Procedure
Calling Procedures
Working with Procedures and Functions
Guidelines for use of Branching Structures
Declaring Variables
Understanding Objects
Considering Variable Scope and Lifetime Together
Using the If...End If Decision Structures
Understanding Constants
Stepping through Code
Working with Variable Scope
Understanding Collections
Using the Object Browser
Using Expressions, Variables, and Intrinsic Functions
Using the For Each...Next Structure
Creating a Standard Module
Understanding the DoCmd Object
Using Intrinsic Constants
Microsoft Access
- 2 day course
- Location: Trowbridge
- Telephone on 01952 938014
- 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...
Aggregation Queries
Creating and Using Macros
Relational Database Design
Macros on Forms
Understanding VBA
Setting Table Relationships
Action Queries
Adding Records to a Table
Modifying Forms
Designing a Lookup Database
Creating and Using Forms
Adding Transactional Records
Navigation Pane Protection
Creating Queries
Creating a Relational Database
Data Validation
Importing and Exporting Records
Sorting and Filtering
Formatting Tables
DIY Forms
Email us about this courses
Other Trowbridge Enable Technology Training Courses
Report Builder Trowbridge Training Courses
DAX Trowbridge Training Courses
Excel Power Pivot Trowbridge Training Courses
Power Query Trowbridge Training Courses
Data Warehouse - Trowbridge SQL Training Courses
JavaScript Trowbridge Training Courses