ACCESS TRAINING COURSES ATHERSTONE
About Enable Technology Atherstone Access Training Courses
Enable Technology offer short intensive skills based Access training 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. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. Another way we could deliver the Access course is at a local training site. We are happy to discuss customising the course content should you have particular Access training 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 Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are DHL Express, Cadbury PLC, GKN PLC, Royal & Sun Alliance Group PLC, Birmingham Heartlands Hospital, West Bromwich Building Society, Capita Group PLC and Lloyds TSB Bank PLC.
Microsoft Access
- 2 day course
- Location: Atherstone
- 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 ... Navigation Pane Protection
- See Training Course Details...
Importing and Exporting Records
Data Validation
Macros on Forms
Setting Table Relationships
Creating and Using Forms
An Introduction to VBA
Working With Records
Adding Records to a Table
Database Security
Multi Table Queries
Using a Navigation Form
Adding Transactional Records
Action Queries
Creating and Using Macros
Relational Database Design
Understanding VBA
Querying Techniques
Parameter Queries
Creating Queries
Calculations in Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Atherstone
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Understanding Classes and Objects
- See Training Course Details...
Naming Procedures
Working with the Application Object
Using the Object Browser
Creating a Sub Procedure
Using Intrinsic Constants
Understanding Control-of-Flow Structures
Organizing Code and Procedures
Working with Properties
Working with Variable Lifetime
Creating a Function Procedure
Why Program in Access?
Calling Procedures
Locking Records for Updating
Understanding the Order of Events
Using the For Each...Next Structure
Understanding Recordset Cursor Properties - Optional
Understanding the Err Object
Using the With Statement
Email us about this courses
Other Atherstone Enable Technology Training Courses
SSRS Atherstone Training Courses
DAX Atherstone Training Courses
Report Builder Atherstone Training Courses
SSAS Tabular Atherstone Training Courses
Excel 365 Intermediate - Atherstone Excel Training Courses
PL/SQL - Atherstone SQL Training Courses