Access
Microsoft Access databases offer the capability to build great data analysis facilities or a fully featured application for your organisation. This suite of courses takes you through the essentials of database design, building the various components of a database application, and learning how to confidently manage your data.
Introduction
Who is this course for?
No prior knowledge of Microsoft Access is required for this course. It’s ideal for a person to start out with and take their first responsibilities with this database.
Course Duration: 1 Day
Key Learning Topics
- Creating a database
- Creating and editing tables
- How to select information by query
- Creating Forms
- Creating Reports
Click to download the course outline
Intermediate
Who is this course for?
The course focus is the relational aspects of Microsoft Access. Making it ideal for those who need to gain a better understanding of database design, and how to get more out of query writing by making use of multiple tables
Course Duration: 1 Day
Key Learning Topics
- Understanding database relationships
- Creating and editing relationships
- Joining tables in a query
- Updating and inserting data by query
- Using sections in forms and reports
Click to download the course outline
Advanced
Who is this course for?
Someone who wants to take their first steps in programming Microsoft Access using both Macros and the Visual Basic for Applications (VBA), language. Using these languages it’s possible to build customised database software for your own use.
Note: For those that want to take this further we also a more detailed course in programming Access with VBA.
Course Duration: 1 Day
Key Learning Topics
- Creating a macro
- Connecting a macro to a command button
- Writing a simple subroutine in VBA
- Understanding VBA variables
- Creating a function
- Using VBA to automate simple task
Click to download the course outline
Access VBA
Who is this course for?
This is a Visual Basic for Applications course that focuses on learning how to write programs within Microsoft Access. This course is ideal for a delegate who needs to create custom applications and work processes.
Course Duration: 1 Day
Key Learning Topics
- Understanding VBA Modules
- Structuring VBA Code
- Writing Functions and Subroutines
- How to handle logical decisions
- Controlling forms
- Data cleansing and validation.
Click to download a course outline
About our Trainers
All of the training provided by ClearCut IT is delivered by subject experts; having not only a vast amount of teaching experience, but also years of real-world knowledge that they bring to the classroom.