ACCESS TRAINING COURSES RUGBY
About Enable Technology Rugby Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. We provide every candidate with Access training materials which they keep after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Enable Technology training courses are delivered as instructor led courses. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite training location in Rugby. The Access syllabus can be modified to accommodate your specific 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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Unipart Group, Halfords Group PLC, Homeserve PLC, Yell Group PLC, Vodafone Group Services, TalkTalk Direct Limited, Queen's Medical Centre Nottingham and Nationwide Building Society Limited.
Microsoft Access
- 2 day course
- Location: Rugby
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Using a Navigation Form
- See Training Course Details...
Parameter Queries
Formatting Tables
Creating a Lookup Database
Navigation Pane Protection
Adding Records to a Table
Setting Table Relationships
Aggregation Queries
DIY Forms
Designing a Lookup Database
Creating Queries
Calculations in Queries
Adding Transactional Records
Relational Database Design
Multi Table Queries
Database Security
Importing and Exporting Records
Creating a Relational Database
Action Queries
Creating and Using Forms
Modifying Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Rugby
- 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 ... Why Program in Access?
- See Training Course Details...
Declaring and Creating Object Variables
Working with Procedures and Functions
Understanding the Form Object
Setting Breakpoints
Working with Variable Scope
Stepping through Code
Specifying a Recordset Cursor Type
Using the Select Case...End Select Structure
Working with Inline Error Handling
Understanding Control-of-Flow Structures
Understanding the DoCmd Object
Using the For Each...Next Structure
Determining the Value of Expressions
Understanding Recordset Cursor Properties - Optional
Using the CacheSize Property - Optional
Email us about this courses
Other Rugby Enable Technology Training Courses
Excel 365 Intermediate Rugby Training Courses
DAX Rugby Training Courses
JavaScript - Rugby JavaScript Training Courses
Excel 365 Basic Rugby Training Courses
TSQL - Rugby SQL Training Courses
SSAS Tabular Rugby Training Courses