ACCESS TRAINING COURSES WAKEFIELD
About Enable Technology Wakefield Access Training Courses
We have a twenty year history of providing skills based Access industry training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All course participants are issued Access training manuals they can refer to after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Enable Technology offers instructor led training taught by technology specialists. We can set up a training lab at your premises and deliver Access courses onsite at your site. If you prefer we can offer an offsite training location in Wakefield. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
We have operated primarily in the West Midlands for twenty years. Our clients include: Norwich Union PLC, Birmingham City University, Capita Group PLC, Boots UK Limited, Nuclear Engineering Services, Cadbury PLC, Homeserve PLC and West Bromwich Building Society.
Microsoft Access
- 2 day course
- Location: Wakefield
- 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 ... Querying Techniques
- See Training Course Details...
Adding Transactional Records
Adding Records to a Table
Creating and Using Forms
Using a Navigation Form
Parameter Queries
Formatting Tables
Action Queries
Working With Records
Database Security
Creating a Relational Database
DIY Forms
Navigation Pane Protection
Creating a Lookup Database
Creating Queries
Macros on Forms
Creating and Using Macros
Calculations in Queries
Understanding VBA
Getting to Know Access
Creating and Using Reports
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wakefield
- 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 ... Trapping Errors with the On Error Statement
- See Training Course Details...
Using Message Boxes
Understanding Modules
Using the Do...Loop Structure
Understanding Recordset Cursor Properties - Optional
Using Intrinsic Functions
Using Break Mode during Run Mode
Using Debugging Tools
Controlling Program Execution
Declaring and Creating Object Variables
Understanding the Err Object
Using Expressions, Variables, and Intrinsic Functions
Specifying a Recordset Cursor Type
Using the Select Case...End Select Structure
Understanding the DoCmd Object
Working with Inline Error Handling
Using the CacheSize Property - Optional
Using the If...End If Decision Structures
Naming Procedures
Determining the Value of Expressions
Email us about this courses
Other Wakefield Enable Technology Training Courses
Power BI Wakefield Training Courses
Data Warehouse Wakefield Training Courses
Excel 365 Intermediate - Wakefield Excel Training Courses
SSIS - Wakefield SQL Server Integration Services Training Courses
Excel Power Pivot Wakefield Training Courses
SSAS Tabular Wakefield Training Courses