Advanced Microsoft Access
Course
Online
Description
-
Type
Course
-
Level
Advanced
-
Methodology
Online
-
Class hours
8h
-
Duration
Flexible
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
Dive deeper into Microsoft access with our Advanced Microsoft Access course. With our advanced course you’ll learn how to automate tasks to save you time, how to apply advanced techniques such as macros and VBAs and overall Access best practice.
Facilities
Location
Start date
Start date
About this course
Microsoft Access is a database program that allows you to manage your data in the most efficient way possible. From creating custom web apps and tracking assets to organising contacts and managing inventory, the incredible range of functions will transform how you manage data.
Best of all, it is easily accessible to anyone with just a basic knowledge of spreadsheets.
We’ll make you an advanced user of this video training course. Add Microsoft Access to your skillset to become more effective at work, stand out and get ahead.
How to effectively link to other data sources.
How to split a database by splitting the frontend and backend.
To create and maintain macros.
The use of Visual Basic for Applications (VBA).
Advanced options for the use of forms.
Packaging your application for distribution.
CPD UK
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 4 years
Subjects
- Access
- Microsoft Access
- Datasheet
- SQL
- Databases
- Splitting a Database
- Database
- Splitting
- VBA
- Web Apps
- Application
Course programme
Section 1: Introduction
- Unit 1.1 - Introduction
- Unit 1.2 - Datasheet View
- Unit 2.1 - Linking to Other Access Databases
- Unit 2.2 - Multi-user Aspects and Splitting a Database
- Unit 3.1 - Macros
- Unit 3.2 - The Ribbon
- Unit 3.3 - Visual Basic for Applications
- Unit 4.1 - Events
- Unit 4.2 - Forms▸
- Unit 4.3 - SQL and Joins
- Unit 4.4 - Action Queries
- Unit 4.5 - Packaging your Application
- Unit 4.6 - Web Apps
- Unit 5.1 - Conclusion
Advanced Microsoft Access