ACCESS TRAINING COURSES ABERYSTWYTH
About Enable Technology Aberystwyth Access Training Courses
We offer intensive two and three days Access courses. We guarantee the training will be delivered by a Microsoft certified expert. We will issue each Access training participant with learning resources which they can refer to post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Courses are instructor led and groups sizes small. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Another way we could deliver the Access course is at a local training site. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Boots UK Limited, Fujistu PLC, Royal Air Force, Shell UK Oil Products Ltd, National Power PLC, Loughborough University, Countrywide Homes Limited and Norfolk Police Constabulary.
Microsoft Access
- 2 day course
- Location: Aberystwyth
- 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 ... Calculations in Queries
- See Training Course Details...
Creating a Lookup Database
Database Wellness
Adding Records to a Table
Designing a Lookup Database
Modifying Table Structures
Understanding VBA
Macros on Forms
Multi Table Queries
Creating a Relational Database
Using a Navigation Form
Getting to Know Access
Relational Database Design
Sorting and Filtering
Navigation Pane Protection
Database Security
Formatting Tables
Adding Transactional Records
Setting Table Relationships
Modifying Forms
Querying Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Aberystwyth
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Working with Boolean Expressions
- See Training Course Details...
Understanding Objects
Working with the Application Object
Understanding the Form Object
Considering Variable Scope and Lifetime Together
Working with Methods
Understanding Constants
Understanding the DoCmd Object
Understanding the Order of Events
Working with the ADODB Recordset Object
Using Intrinsic Functions
Calling Procedures
Specifying a Recordset Cursor Location - Optional
Declaring Variables
Working with Variable Scope
Controlling Program Execution
Understanding VBA's Error Trapping Options
Setting Breakpoints
Using the Do...Loop Structure
Setting Break Expressions
Using the Object Browser
Email us about this courses
Other Aberystwyth Enable Technology Training Courses
Report Builder Aberystwyth Training Courses
VBA Aberystwyth Training Courses
SQL Aberystwyth Training Courses
SSAS Tabular Aberystwyth Training Courses
TSQL Aberystwyth Training Courses
Excel 365 Basic Aberystwyth Training Courses