ACCESS TRAINING COURSES SOLIHULL
About Enable Technology Solihull 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. Every person attending a Access course will be provided with training materials and practice files to retain after the course. 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.
Courses are instructor led and groups sizes small. 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. We are also more than happy to organise a local course at a training location in Solihull. We are happy to discuss customising the course content should you have particular Access 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. Some of our clients are Shell UK Oil Products Ltd, Lloyds TSB Bank PLC, EDF Energy PLC, Dollond & Aitchison Limited, Birmingham City University, TalkTalk Direct Limited, Unipart Group and Carillion PLC.
Microsoft Access
- 2 day course
- Location: Solihull
- 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 ... Importing and Exporting Records
- See Training Course Details...
Formatting Tables
Sorting and Filtering
Adding Records to a Table
Creating a Lookup Database
Setting Table Relationships
Aggregation Queries
Getting to Know Access
Querying Techniques
Understanding VBA
Macros on Forms
Parameter Queries
Creating and Using Forms
Navigation Pane Protection
Creating and Using Macros
Data Validation
Using a Navigation Form
Action Queries
Creating Queries
An Introduction to VBA
Modifying Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Solihull
- 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 ... Using the With Statement
- See Training Course Details...
Setting Break Expressions
Using Visual Basic Help
Working with Boolean Expressions
Using Intrinsic Functions
Understanding the DoCmd Object
Using Break Mode during Run Mode
Using the For Each...Next Structure
Working with Inline Error Handling
Understanding Error Handling
Understanding Control-of-Flow Structures
Specifying a Recordset Cursor Location - Optional
Understanding Expressions and Statements
Using Message Boxes
Declaring and Creating Object Variables
Working with Variable Lifetime
Debugging Code
Understanding Constants
Calling Procedures
Understanding the Order of Events
Using the Object Browser
Email us about this courses
Other Solihull Enable Technology Training Courses
Excel 365 Basic Solihull Training Courses
SQL - Solihull SQL Training Courses
Oracle SQL - Solihull SQL Training Courses
Power Query Solihull Training Courses
Excel 365 Intermediate - Solihull Excel Training Courses
TSQL - Solihull SQL Training Courses