ACCESS TRAINING COURSES PRESTWICH
About Enable Technology Prestwich 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. Every person attending a Access course will be provided with training materials and practice files to retain after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
We provide instructor led training coupled with hands on training. 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 socially distanced local training venue in Prestwich. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Halfords Group PLC, Birmingham City University, TalkTalk Direct Limited, Unipart Group, DHL Express, Canadian High Commission, GKN PLC and Keele University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Prestwich
- 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 ... Working with Events
- See Training Course Details...
Using the CacheSize Property - Optional
Using Message Boxes
Understanding VBA's Error Trapping Options
Working with Variable Scope
Creating a Function Procedure
Using the Object Browser
Working with Boolean Expressions
Using Expressions, Variables, and Intrinsic Functions
Declaring Variables
Using Visual Basic Help
Using the For...Next Structure
Introduction to Programming in Access
Using the If...End If Decision Structures
Understanding the Form Object
Calling Procedures
Understanding Recordset Cursor Properties - Optional
Guidelines for use of Branching Structures
Microsoft Access
- 2 day course
- Location: Prestwich
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Adding Transactional Records
- See Training Course Details...
Importing and Exporting Records
Understanding VBA
Designing a Lookup Database
Data Validation
DIY Forms
Database Security
Creating and Using Macros
Navigation Pane Protection
Creating a Relational Database
Working With Records
Parameter Queries
Aggregation Queries
Creating and Using Reports
Calculations in Queries
Database Wellness
Modifying Forms
Adding Records to a Table
An Introduction to VBA
Creating and Using Forms
Creating a Lookup Database
Email us about this courses
Other Prestwich Enable Technology Training Courses
TSQL - Prestwich SQL Training Courses
SSRS Prestwich Training Courses
Power Query - Prestwich Excel Training Courses
PL/SQL - Prestwich SQL Training Courses
SQL Prestwich Training Courses
Data Warehouse Prestwich Training Courses