ACCESS TRAINING COURSES BANGOR
About Enable Technology Bangor Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each person attending a course takes away Access courseware which can be used as reference materials after the 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.
Enable Technology offers instructor led training taught by technology specialists. We can set up a training lab at your premises and deliver Access courses onsite at your site. We can also deliver the Access course at a socially distanced local training venue in Bangor. We are happy to discuss customising the course content should you have particular Access 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.
We have operated primarily in the West Midlands for twenty years. Our clients include: Royal Air Force, Vodafone Group Services, South Staffordshire Water PLC, Queen's Medical Centre Nottingham, Countrywide Homes Limited, National Power PLC, Carillion PLC and Birmingham City Council.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bangor
- 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 ... Creating a Standard Module
- See Training Course Details...
Locking Records for Updating
Creating a Function Procedure
Working with the ADODB Recordset Object
Handling Errors
Understanding Modules
Understanding the Development Environment
Understanding Recordset Cursor Properties - Optional
Working with Boolean Expressions
Determining the Value of Expressions
Calling Procedures
Using the For Each...Next Structure
Understanding Objects
Guidelines for use of Branching Structures
Working with Recordsets
Using Visual Basic Help
Using the Object Browser
Working with Procedures and Functions
Working with Properties
Using the Do...Loop Structure
Microsoft Access
- 2 day course
- Location: Bangor
- 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 ... Modifying Table Structures
- See Training Course Details...
Getting to Know Access
Database Security
Adding Records to a Table
Working With Records
Creating and Using Macros
DIY Forms
Creating Queries
Creating and Using Forms
Navigation Pane Protection
Macro Techniques
Setting Table Relationships
Querying Techniques
Multi Table Queries
Creating a Relational Database
Aggregation Queries
Formatting Tables
Calculations in Queries
Action Queries
Modifying Forms
Macros on Forms
Email us about this courses
Other Bangor Enable Technology Training Courses
SSIS - Bangor SQL Server Integration Services Training Courses
SSRS Bangor Training Courses
Excel 365 Advanced Bangor Training Courses
SSAS Tabular - Bangor SQL Server Analysis Services Training Courses
SQL - Bangor SQL Training Courses
Data Warehouse - Bangor SQL Training Courses