ACCESS TRAINING COURSES HARTLEPOOL
About Enable Technology Hartlepool Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every person attending a Access course will be provided with training materials and practice files to retain after the course. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. 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 local training venue in Hartlepool. The Access syllabus can be modified to accommodate your specific training needs.
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. Our clients include: Halfords Group PLC, West Bromwich Building Society, Cadbury PLC, Canadian High Commission, DHL Express, Boots UK Limited, Fujistu PLC and University of Birmingham.
Microsoft Access
- 2 day course
- Location: Hartlepool
- 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 ... Parameter Queries
- See Training Course Details...
Navigation Pane Protection
DIY Forms
Formatting Tables
Working With Records
Data Validation
Action Queries
Sorting and Filtering
Macros on Forms
Creating and Using Macros
Setting Table Relationships
Creating and Using Forms
Designing a Lookup Database
Modifying Forms
Getting to Know Access
Creating and Using Reports
Modifying Table Structures
Relational Database Design
Creating a Relational Database
Creating Queries
Multi Table Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Hartlepool
- Telephone on 01952 938014
- 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 ... Using the For...Next Structure
- See Training Course Details...
Using the If...End If Decision Structures
Considering Variable Scope and Lifetime Together
Understanding Data Types
Controlling Program Execution
Understanding the DoCmd Object
Understanding Modules
Calling Procedures
Using Break Mode during Run Mode
Using the CacheSize Property - Optional
Working with Inline Error Handling
Understanding Errors
Using the For Each...Next Structure
Creating a Standard Module
Working with Methods
Guidelines for use of Branching Structures
Writing an Error-Handling Routine
Understanding Recordset Cursor Properties - Optional
Working with the Code Editor
Email us about this courses
Other Hartlepool Enable Technology Training Courses
DAX - Hartlepool Excel Training Courses
VBA Hartlepool Training Courses
Data Warehouse - Hartlepool SQL Training Courses
SQL - Hartlepool SQL Training Courses
JQuery Mobile Hartlepool Training Courses
Excel 365 Intermediate - Hartlepool Excel Training Courses