ACCESS TRAINING COURSES NUNEATON
About Enable Technology Nuneaton Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The training will be delivered by a Microsoft professional with development experience. We will issue each Access training participant with learning resources which they can refer to post training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Access courses are taught by a Microsoft Certified Solutions Expert. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Another option is we can organise a local training site in Nuneaton. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Unipart Group, Birmingham City University, Aston University, GKN PLC, Norfolk Police Constabulary, Royal & Sun Alliance Group PLC, Cadbury PLC and Boots UK Limited.
Microsoft Access
- 2 day course
- Location: Nuneaton
- 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 ... Database Wellness
- See Training Course Details...
Creating Queries
Creating and Using Macros
Setting Table Relationships
Action Queries
Database Security
Creating a Lookup Database
Data Validation
Parameter Queries
Adding Records to a Table
Working With Records
Aggregation Queries
Navigation Pane Protection
Creating and Using Forms
Calculations in Queries
Modifying Table Structures
DIY Forms
Importing and Exporting Records
Macro Techniques
Getting to Know Access
Macros on Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Nuneaton
- 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 ... Handling Errors
- See Training Course Details...
Setting Breakpoints
Declaring and Creating Object Variables
Working with Properties
Why Program in Access?
Debugging Code
Setting Break Expressions
Trapping Errors with the On Error Statement
Understanding VBA's Error Trapping Options
Understanding Procedures
Understanding Control-of-Flow Structures
Working with Procedures and Functions
Using the With Statement
Working with Events
Writing an Error-Handling Routine
Using Message Boxes
Using the If...End If Decision Structures
Understanding the DoCmd Object
Email us about this courses
Other Nuneaton Enable Technology Training Courses
DAX - Nuneaton Excel Training Courses
Excel 365 Advanced - Nuneaton Excel Training Courses
PL/SQL - Nuneaton SQL Training Courses
Data Warehouse Nuneaton Training Courses
Excel Power Pivot Nuneaton Training Courses
Power BI - Nuneaton Microsoft Power BI Training Courses