ACCESS TRAINING COURSES NATIONAL
About Enable Technology National Access Training Courses
We offer intensive two and three days Access courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Access courses are taught by a Microsoft Certified Solutions Expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. If you prefer we can offer an offsite socially distanced training location in National. Every Access course can be modified to meet your bespoke requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Unipart Group, Total Telecommunications Limited, Nuclear Engineering Services, National Power PLC, Canadian High Commission, Capita Group PLC, Wolverhampton City Council and Birmingham Heartlands Hospital.
Microsoft Access
- 2 day course
- Location: National
- 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 ... Using a Navigation Form
- See Training Course Details...
Adding Transactional Records
Action Queries
Database Security
Aggregation Queries
Calculations in Queries
Macro Techniques
Understanding VBA
Querying Techniques
Adding Records to a Table
Creating Queries
Data Validation
Sorting and Filtering
Parameter Queries
Setting Table Relationships
Getting to Know Access
Designing a Lookup Database
Creating and Using Reports
Database Wellness
Formatting Tables
Creating a Lookup Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: National
- 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 Error Handling
- See Training Course Details...
Working with Inline Error Handling
Working with Variable Lifetime
Working with Events
Understanding the DoCmd Object
Using Message Boxes
Understanding Expressions and Statements
Using Intrinsic Functions
Using Input Boxes
Calling Procedures
Debugging Code
Controlling Program Execution
Understanding Data Types
Using the Do...Loop Structure
Handling Errors
Working with Properties
Understanding the Form Object
Stepping through Code
Email us about this courses
Other National Enable Technology Training Courses
Data Warehouse - National SQL Training Courses
Power BI - National Microsoft Power BI Training Courses
JQuery National Training Courses
JavaScript - National JavaScript Training Courses
TSQL National Training Courses
Excel 365 Basic National Training Courses