Dive deeper into Microsoft Access with this advanced course. Here, you'll learn how to automate tasks to save you time, how to apply advanced techniques like macros and VBAs, and just overall best practices of using Access.
Access 16 units & 8 hours of content 24/7
Discover how to effectively link to other data sources
Learn how to split a database by splitting the frontend & backend
Follow along as you learn to create & maintain macros
Explore the use of Visual Basic for Applications (VBA)
Discover advanced options for the use of forms
Dive into options for packaging your application for distribution
Test your knowledge with an online quiz & Certificate of Completion
Formed in 2009, Excel with Business was created by founders Marc, Vin and Chris to solve a problem close to their hearts – ineffective Microsoft Excel training. As three Strategy and Management Consultants they understood the importance of being able to apply MS Excel skills in a business context.
The main issue was that too many Excel courses were focussing on the software functionality rather than how that was applicable in business. They taught everything, creating long and laborious courses – rather than focusing on the most business-relevant parts of Excel… so an idea was born:
A business relevant Excel training course that was affordable and personalized to each person taking it.
The first Excel course quickly attracted over 100,000 users. Fast forward a few years and we have expanded our focus on improving personal productivity and helping people achieve their career ambitions through a comprehensive library of 50+ Microsoft and Business training courses. The principles of getting the right training to the right user remain and has become more sophisticated through the introduction of the filter on many courses.
For more details on this course and instructor, click here.
Details & Requirements
Length of time users can access this course: lifetime
Access options: web streaming
Certification of completion included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: advanced
Compatibility
Internet required
Microsoft Access
Course Outline
Section 1: Introduction
Section 2: Databases and SQL
Section 3: Macros, VBA and Customizing the Interface
Microsoft Access is a powerful program that allows you to build a robust "data landing page." From creating custom web apps and tracking assets to organizing contacts and managing inventory, the incredible range of functions will transform how you manage data. In this course, you can dive deeper into Microsoft Access, advancing to an intermediate level.
Access 14 units & 10 hours of content 24/7
Set-up a database—on your desktop, or on the web
Learn how to add records, & save and delete data
Explore the Ribbon interface & how to work with touch devices
Use table templates to create forms & add custom elements
Sort data & run queries
Understand Macros & how they work
Import data from external sources
Test your knowledge with an online quiz & Certificate of Completion
Formed in 2009, Excel with Business was created by founders Marc, Vin and Chris to solve a problem close to their hearts – ineffective Microsoft Excel training. As three Strategy and Management Consultants they understood the importance of being able to apply MS Excel skills in a business context.
The main issue was that too many Excel courses were focussing on the software functionality rather than how that was applicable in business. They taught everything, creating long and laborious courses – rather than focusing on the most business-relevant parts of Excel… so an idea was born:
A business relevant Excel training course that was affordable and personalized to each person taking it.
The first Excel course quickly attracted over 100,000 users. Fast forward a few years and we have expanded our focus on improving personal productivity and helping people achieve their career ambitions through a comprehensive library of 50+ Microsoft and Business training courses. The principles of getting the right training to the right user remain and has become more sophisticated through the introduction of the filter on many courses.
For more details on this course and instructor, click here.
Details & Requirements
Length of time users can access this course: lifetime
Access options: web streaming
Certification of completion included
Redemption deadline: redeem your code within 30 days of purchase