ACCESS TRAINING COURSES CHRISTCHURCH
About Enable Technology Christchurch Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The tutor delivering the course will be a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Access courses are taught by a Microsoft Certified Solutions Expert. 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. We can also deliver the Access course at a socially distanced local training venue in Christchurch. The Access syllabus can be adjusted and additional topics incorporated if helpful.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Keele University, Royal Air Force, Wolverhampton City Council, Loughborough University, Royal & Sun Alliance Group PLC, Carillion PLC, Boots UK Limited and West Bromwich Building Society.
Microsoft Access
- 2 day course
- Location: Christchurch
- 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 ... Relational Database Design
- See Training Course Details...
Adding Transactional Records
An Introduction to VBA
Creating and Using Reports
Setting Table Relationships
Adding Records to a Table
Calculations in Queries
Importing and Exporting Records
Working With Records
Navigation Pane Protection
Creating a Lookup Database
Aggregation Queries
Macros on Forms
Macro Techniques
Modifying Forms
Formatting Tables
Creating a Relational Database
Getting to Know Access
DIY Forms
Creating and Using Forms
Modifying Table Structures
Microsoft Access Programming Using VBA
- 3 day course
- Location: Christchurch
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Understanding Constants
- See Training Course Details...
Using the With Statement
Creating a Standard Module
Understanding Modules
Working with Variable Scope
Understanding Recordset Cursor Properties - Optional
Using Break Mode during Run Mode
Understanding the Form Object
Using the CacheSize Property - Optional
Setting Break Expressions
Understanding the DoCmd Object
Working with Boolean Expressions
Specifying a Recordset Cursor Type
Stepping through Code
Working with Inline Error Handling
Considering Variable Scope and Lifetime Together
Understanding Expressions and Statements
Using the For Each...Next Structure
Understanding Procedures
Understanding Control-of-Flow Structures
Email us about this courses
Other Christchurch Enable Technology Training Courses
Power BI Christchurch Training Courses
Excel 365 Basic - Christchurch Excel Training Courses
Oracle SQL - Christchurch SQL Training Courses
SSIS - Christchurch SQL Server Integration Services Training Courses
SSAS Christchurch Training Courses
DAX Christchurch Training Courses