ACCESS TRAINING COURSES NEWTOWN
About Enable Technology Newtown Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The training will be delivered by a Microsoft professional with development experience. All course participants are issued Access training manuals they can refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a Access course at an alternative training site in Newtown. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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: Norfolk Police Constabulary, University of Birmingham, Boots UK Limited, National Power PLC, Fujistu PLC, Nuclear Engineering Services, TalkTalk Direct Limited and Royal Air Force.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Newtown
- 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 Procedures and Functions
- See Training Course Details...
Naming Procedures
Using Message Boxes
Guidelines for use of Branching Structures
Understanding the Form Object
Using the For Each...Next Structure
Using the CacheSize Property - Optional
Stepping through Code
Controlling Program Execution
Declaring and Creating Object Variables
Navigating the Access Object Hierarchy
Declaring Variables
Using Visual Basic Help
Working with Events
Specifying a Recordset Cursor Location - Optional
Using Input Boxes
Working with Properties
Working with the ADODB Recordset Object
Introduction to Programming in Access
Calling Procedures
Microsoft Access
- 2 day course
- Location: Newtown
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Adding Transactional Records
- See Training Course Details...
Parameter Queries
Aggregation Queries
Setting Table Relationships
Creating a Lookup Database
Querying Techniques
Adding Records to a Table
Creating and Using Reports
Using a Navigation Form
DIY Forms
Data Validation
Understanding VBA
Action Queries
Multi Table Queries
Sorting and Filtering
Modifying Forms
Calculations in Queries
Creating and Using Macros
Database Wellness
An Introduction to VBA
Macros on Forms
Email us about this courses
Other Newtown Enable Technology Training Courses
Data Warehouse Newtown Training Courses
Excel Power Pivot - Newtown Excel Training Courses
Oracle SQL - Newtown SQL Training Courses
SSAS - Newtown SQL Server Analysis Services Training Courses
Report Builder - Newtown SQL Server Reporting Services Training Courses
DAX - Newtown Excel Training Courses