Course description
The course offers an exciting and innovative approach to Access training. It consists of 14 modules and includes media demonstrations, hands-on activities, and knowledge check questions. At the end of the course, you will complete a consolidation exercise, which will help you review what you have learned and assess your understanding.
The course also contains quizzes at the end of each module and a Validation Test at the end of the course. With successful completion of the course, you will receive a Pitman Training certificate to verify your achievement.
Upcoming start dates
Suitability - Who should attend?
Is this for you?
The course is designed for those who are familiar with Microsoft Access and who want to learn advanced concepts and techniques to work more productively with the software.
Pre-Requisites
This course follows Access.
Outcome / Qualification etc.
The aim of the course is for you to learn advanced-level concepts and features of the Microsoft Access database management application, so that you will be effective in creating, using, and managing databases.
Training Course Content
- Module 1:Primary Keys and Indexes
- Module 2:The Ribbon
- Module 3:Using Datasheet View
- Module 4:Linking Other Access Databases
- Module 5:Using ODBC and SQL Server
- Module 6:Splitting an Access Database
- Module 7:Macros
- Module 8:Introduction to Visual Basic for Applications
- Module 9:Visual Basic for Application Coding
- Module 10:Access Events Model
- Module 11:Forms
- Module 12:Advanced Uses of Queries
- Module 13:Action Queries
- Module 14:Packaging Your Application
Continuing Studies
Microsoft Access is a very popular database application widely used across many employment sectors to keep accurate, up-to-date records of customers, projects, products, etc. Knowing how to effectively set up and manage databases will be a valuable skillset in many work environments.
Request info
Pitman Training enables businesses to upskill their people and teams to take advantage of changing technologies and ways of working. This is reflected in our range of digital skills programmes that go far beyond Pitman Training’s traditional strengths in Office...