ACCESS TRAINING COURSES NEWTOWN
About Enable Technology Newtown Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each course participant will be issued with training Access resources which they can continue to use after the training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We are also more than happy to organise a local course at a training location in Newtown. We are happy to modify the Access syllabus to match your teams 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.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Carillion PLC, Birmingham City University, South Staffordshire Water PLC, Barclays Bank PLC, Unipart Group, Dollond & Aitchison Limited, National Power PLC and West Bromwich Building Society.
Microsoft Access
- 2 day course
- Location: Newtown
- 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 ... Navigation Pane Protection
- See Training Course Details...
Querying Techniques
Using a Navigation Form
Understanding VBA
Database Wellness
Working With Records
An Introduction to VBA
Parameter Queries
Calculations in Queries
Macros on Forms
Getting to Know Access
Creating and Using Macros
Multi Table Queries
Modifying Forms
Creating a Relational Database
Macro Techniques
DIY Forms
Creating a Lookup Database
Creating and Using Forms
Creating and Using Reports
Adding Transactional Records
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 ... Why Program in Access?
- See Training Course Details...
Understanding Data Types
Using Message Boxes
Creating a Standard Module
Understanding Modules
Creating a Sub Procedure
Calling Procedures
Working with the Code Editor
Setting Break Expressions
Using the With Statement
Organizing Code and Procedures
Using the Select Case...End Select Structure
Declaring and Creating Object Variables
Naming Procedures
Specifying a Recordset Cursor Type
Working with the ADODB Recordset Object
Guidelines for use of Branching Structures
Understanding the Order of Events
Using Break Mode during Run Mode
Understanding Constants
Email us about this courses
Other Newtown Enable Technology Training Courses
SSIS Newtown Training Courses
SSAS Tabular - Newtown SQL Server Analysis Services Training Courses
SSAS - Newtown SQL Server Analysis Services Training Courses
SQL - Newtown SQL Training Courses
Oracle SQL - Newtown SQL Training Courses
Report Builder - Newtown SQL Server Reporting Services Training Courses