ACCESS TRAINING COURSES CWMBRAN
About Enable Technology Cwmbran Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All Enable Technology tutors are Microsoft certified experts. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Courses are instructor led and groups sizes small. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a Access course at an alternative training site in Cwmbran. The Access syllabus can be modified to accommodate your specific training needs.
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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Wolverhampton City Council, Unipart Group, West Bromwich Building Society, TalkTalk Direct Limited, Carillion PLC, Fujistu PLC, Keele University and Boots UK Limited.
Microsoft Access
- 2 day course
- Location: Cwmbran
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Navigation Pane Protection
- See Training Course Details...
Calculations in Queries
Creating and Using Reports
Relational Database Design
Querying Techniques
Aggregation Queries
Macro Techniques
Formatting Tables
Multi Table Queries
Sorting and Filtering
An Introduction to VBA
Modifying Table Structures
Modifying Forms
Creating a Relational Database
Parameter Queries
Setting Table Relationships
Creating and Using Forms
Adding Transactional Records
Action Queries
Creating Queries
Importing and Exporting Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: Cwmbran
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Understanding Classes and Objects
- See Training Course Details...
Working with Recordsets
Working with the ADODB Recordset Object
Using the Do...Loop Structure
Working with Methods
Using the With Statement
Setting Breakpoints
Working with the Code Editor
Understanding Procedures
Working with Procedures and Functions
Using Visual Basic Help
Using Debugging Tools
Understanding the Order of Events
Setting Break Expressions
Understanding Constants
Working with Properties
Working with Inline Error Handling
Using Break Mode during Run Mode
Locking Records for Updating
Email us about this courses
Other Cwmbran Enable Technology Training Courses
SQL - Cwmbran SQL Training Courses
SSAS Tabular - Cwmbran SQL Server Analysis Services Training Courses
VBA Cwmbran Training Courses
SSAS Cwmbran Training Courses
TSQL Cwmbran Training Courses
Power Query Cwmbran Training Courses