ACCESS TRAINING COURSES ABERYSTWYTH
About Enable Technology Aberystwyth Access Training Courses
We are a company that provides short intensive Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each person attending a course takes away Access courseware which can be used as reference materials after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
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 local training venue in Aberystwyth. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your 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 group of companies has been operating continuously providing IT training since 1998. Some of our clients are Nuclear Engineering Services, University of Birmingham, Homeserve PLC, DHL Express, Capita Group PLC, Vodafone Group Services, Unipart Group and Total Telecommunications Limited.
Microsoft Access
- 2 day course
- Location: Aberystwyth
- 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 Forms
- See Training Course Details...
Getting to Know Access
Macro Techniques
Database Security
Importing and Exporting Records
Macros on Forms
Understanding VBA
Relational Database Design
Using a Navigation Form
Creating and Using Forms
Parameter Queries
Adding Records to a Table
Setting Table Relationships
Modifying Table Structures
Database Wellness
Working With Records
Data Validation
Creating and Using Macros
Designing a Lookup Database
Formatting Tables
Aggregation Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Aberystwyth
- 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 ... Using Expressions, Variables, and Intrinsic Functions
- See Training Course Details...
Understanding Data Types
Setting Break Expressions
Using Debugging Tools
Working with Procedures and Functions
Introduction to Programming in Access
Using the CacheSize Property - Optional
Using the Do...Loop Structure
Working with the ADODB Recordset Object
Working with Inline Error Handling
Using the Object Browser
Understanding Objects
Using Intrinsic Functions
Understanding the Form Object
Specifying a Recordset Cursor Type
Naming Procedures
Using the Select Case...End Select Structure
Guidelines for use of Branching Structures
Using Input Boxes
Understanding Classes and Objects
Email us about this courses
Other Aberystwyth Enable Technology Training Courses
SSAS Tabular - Aberystwyth SQL Server Analysis Services Training Courses
Excel 365 Intermediate Aberystwyth Training Courses
Report Builder - Aberystwyth SQL Server Reporting Services Training Courses
VBA Aberystwyth Training Courses
Excel 365 Advanced Aberystwyth Training Courses
Data Warehouse - Aberystwyth SQL Training Courses