ACCESS TRAINING COURSES GWENT
About Enable Technology Gwent Access Training Courses
We have a twenty year history of providing skills based Access industry training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We will issue each Access training participant with learning resources which they can refer to post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We are also more than happy to organise a local course at a socially distanced training location in Gwent. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: EDF Energy PLC, Vodafone Group Services, Queen's Medical Centre Nottingham, Loughborough University, Birmingham City University, Birmingham Heartlands Hospital, Aston University and Countrywide Homes Limited.
Microsoft Access
- 2 day course
- Location: Gwent
- Telephone on 01952 938014
- 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 ... Creating a Lookup Database
- See Training Course Details...
Setting Table Relationships
Formatting Tables
Multi Table Queries
Aggregation Queries
Parameter Queries
Creating and Using Forms
Using a Navigation Form
Designing a Lookup Database
Database Wellness
Understanding VBA
Importing and Exporting Records
DIY Forms
Creating Queries
Modifying Forms
Adding Transactional Records
Modifying Table Structures
Macros on Forms
Action Queries
Navigation Pane Protection
Adding Records to a Table
Microsoft Access Programming Using VBA
- 3 day course
- Location: Gwent
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Understanding Data Types
- See Training Course Details...
Using Message Boxes
Considering Variable Scope and Lifetime Together
Using Expressions, Variables, and Intrinsic Functions
Using Break Mode during Run Mode
Using the With Statement
Working with Recordsets
Declaring and Creating Object Variables
Declaring Variables
Using Intrinsic Constants
Using the Immediate Window to Call Procedures
Working with Events
Debugging Code
Using the Object Browser
Writing an Error-Handling Routine
Setting Break Expressions
Working with the Code Editor
Using the CacheSize Property - Optional
Understanding VBA's Error Trapping Options
Guidelines for use of Branching Structures
Email us about this courses
Other Gwent Enable Technology Training Courses
DAX - Gwent Excel Training Courses
Excel Power Pivot - Gwent Excel Training Courses
PL/SQL Gwent Training Courses
Excel 365 Basic Gwent Training Courses
Excel 365 Intermediate - Gwent Excel Training Courses
Report Builder Gwent Training Courses