ACCESS TRAINING COURSES GWENT
About Enable Technology Gwent Access Training Courses
We offer intensive two and three days Access courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant will receives course practice files and Access course resources that can be referenced post training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
We provide instructor led training coupled with hands on training. 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 training location in Gwent. We are happy to discuss customising the course content should you have particular Access training requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are EDF Energy PLC, Nuclear Engineering Services, Royal Air Force, Birmingham Heartlands Hospital, Total Telecommunications Limited, Yell Group PLC, Royal & Sun Alliance Group PLC and Lloyds TSB Bank PLC.
Microsoft Access
- 2 day course
- Location: Gwent
- 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 ... Creating a Lookup Database
- See Training Course Details...
Database Security
Adding Records to a Table
Creating a Relational Database
Macro Techniques
DIY Forms
Understanding VBA
Action Queries
Working With Records
Modifying Table Structures
Adding Transactional Records
Macros on Forms
Importing and Exporting Records
Getting to Know Access
Setting Table Relationships
Creating Queries
An Introduction to VBA
Modifying Forms
Designing a Lookup Database
Creating and Using Forms
Calculations in Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Gwent
- 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 ... Working with the ADODB Recordset Object
- See Training Course Details...
Using the For Each...Next Structure
Using the If...End If Decision Structures
Guidelines for use of Branching Structures
Understanding Errors
Using Intrinsic Constants
Trapping Errors with the On Error Statement
Calling Procedures
Understanding Constants
Working with Variable Scope
Locking Records for Updating
Understanding VBA's Error Trapping Options
Working with Procedures and Functions
Understanding Objects
Handling Errors
Understanding the DoCmd Object
Determining the Value of Expressions
Understanding Data Types
Working with Inline Error Handling
Declaring Variables
Email us about this courses
Other Gwent Enable Technology Training Courses
Power BI Gwent Training Courses
JQuery Gwent Training Courses
JQuery Mobile - Gwent JavaScript Training Courses
SQL Gwent Training Courses
Report Builder - Gwent SQL Server Reporting Services Training Courses
PL/SQL Gwent Training Courses