ACCESS TRAINING COURSES GWYNEDD
About Enable Technology Gwynedd Access Training Courses
We offer intensive two and three days Access courses. The training will be delivered by a Microsoft professional with development experience. We will issue each Access training participant with learning resources which they can refer to post training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Courses are instructor led and groups sizes small. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a course at a local socially distanced venue in Gwynedd. The Access syllabus can be modified to accommodate your specific training needs.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Norfolk Police Constabulary, TalkTalk Direct Limited, Barclays Bank PLC, Royal Air Force, DHL Express, Lloyds TSB Bank PLC, Nationwide Building Society Limited and Birmingham City University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Gwynedd
- 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 ... Guidelines for use of Branching Structures
- See Training Course Details...
Understanding Errors
Creating a Sub Procedure
Using Message Boxes
Working with Variable Scope
Using Visual Basic Help
Naming Procedures
Using the CacheSize Property - Optional
Why Program in Access?
Declaring Variables
Using the If...End If Decision Structures
Understanding Error Handling
Working with the Code Editor
Understanding the DoCmd Object
Handling Errors
Specifying a Recordset Cursor Location - Optional
Organizing Code and Procedures
Working with Events
Understanding Expressions and Statements
Working with Methods
Microsoft Access
- 2 day course
- Location: Gwynedd
- 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 ... Parameter Queries
- See Training Course Details...
Relational Database Design
Querying Techniques
Sorting and Filtering
Designing a Lookup Database
Navigation Pane Protection
Setting Table Relationships
Understanding VBA
Database Wellness
Adding Records to a Table
Macro Techniques
Database Security
Aggregation Queries
DIY Forms
Calculations in Queries
Creating and Using Forms
Creating a Relational Database
Creating a Lookup Database
Using a Navigation Form
Modifying Forms
Data Validation
Email us about this courses
Other Gwynedd Enable Technology Training Courses
Oracle SQL Gwynedd Training Courses
JavaScript - Gwynedd JavaScript Training Courses
SSRS Gwynedd Training Courses
Excel 365 Intermediate - Gwynedd Excel Training Courses
Excel 365 Basic Gwynedd Training Courses
VBA Gwynedd Training Courses