ACCESS TRAINING COURSES SKELMERSDALE
About Enable Technology Skelmersdale Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Courses are instructor led and groups sizes small. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. If you prefer we can offer an offsite training location in Skelmersdale. All Access courses can be customised to meet your particular requirements.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Nationwide Building Society Limited, Birmingham Heartlands Hospital, Barclays Bank PLC, Birmingham City Council, South Staffordshire Water PLC, Cadbury PLC, Carillion PLC and Capita Group PLC.
Microsoft Access
- 2 day course
- Location: Skelmersdale
- 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 ... Adding Records to a Table
- See Training Course Details...
Navigation Pane Protection
Macros on Forms
Importing and Exporting Records
Creating a Relational Database
Querying Techniques
Data Validation
Getting to Know Access
Creating and Using Macros
Creating and Using Reports
Calculations in Queries
Aggregation Queries
Parameter Queries
Creating a Lookup Database
Sorting and Filtering
Creating and Using Forms
Database Security
Relational Database Design
Understanding VBA
Creating Queries
An Introduction to VBA
Microsoft Access Programming Using VBA
- 3 day course
- Location: Skelmersdale
- 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 ... Setting Break Expressions
- See Training Course Details...
Working with Events
Using the If...End If Decision Structures
Understanding Objects
Understanding Constants
Understanding Expressions and Statements
Why Program in Access?
Using the With Statement
Using the For...Next Structure
Understanding Data Types
Working with the Application Object
Creating a Function Procedure
Working with Methods
Controlling Program Execution
Trapping Errors with the On Error Statement
Naming Procedures
Introduction to Programming in Access
Using Visual Basic Help
Understanding the DoCmd Object
Email us about this courses
Other Skelmersdale Enable Technology Training Courses
Excel 365 Advanced - Skelmersdale Excel Training Courses
Data Warehouse - Skelmersdale SQL Training Courses
Excel 365 Basic Skelmersdale Training Courses
JavaScript Skelmersdale Training Courses
Report Builder - Skelmersdale SQL Server Reporting Services Training Courses
TSQL - Skelmersdale SQL Training Courses