ACCESS TRAINING COURSES WREXHAM
About Enable Technology Wrexham Access Training Courses
We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Professionals. We will issue each Access training participant with learning resources which they can refer to post training. 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.
Courses are instructor led and groups sizes small. We can set up a training lab at your premises and deliver Access courses onsite at your site. The Access course could also be scheduled at a socially distanced site near you in Wrexham. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Birmingham City Council, Capita Group PLC, Birmingham City University, Queen's Medical Centre Nottingham, Aston University, Halfords Group PLC, Norfolk Police Constabulary and Homeserve PLC.
Microsoft Access
- 2 day course
- Location: Wrexham
- 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 ... Multi Table Queries
- See Training Course Details...
Creating and Using Forms
Designing a Lookup Database
Setting Table Relationships
Data Validation
Adding Records to a Table
Getting to Know Access
Creating a Lookup Database
Parameter Queries
Querying Techniques
Creating Queries
Adding Transactional Records
Calculations in Queries
Action Queries
Database Security
Relational Database Design
Using a Navigation Form
Working With Records
Creating and Using Macros
Formatting Tables
Navigation Pane Protection
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wrexham
- 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 ... Working with Boolean Expressions
- See Training Course Details...
Working with Methods
Using the Immediate Window to Call Procedures
Working with the Application Object
Understanding Procedures
Why Program in Access?
Understanding Classes and Objects
Controlling Program Execution
Creating a Function Procedure
Working with Recordsets
Specifying a Recordset Cursor Type
Using the CacheSize Property - Optional
Debugging Code
Understanding Expressions and Statements
Understanding Objects
Creating a Sub Procedure
Using Intrinsic Functions
Email us about this courses
Other Wrexham Enable Technology Training Courses
Report Builder Wrexham Training Courses
JQuery Mobile - Wrexham JavaScript Training Courses
Data Warehouse - Wrexham SQL Training Courses
Excel 365 Intermediate - Wrexham Excel Training Courses
Oracle SQL Wrexham Training Courses
SQL - Wrexham SQL Training Courses