Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course builds on the Introduction and Intermediate courses to show techniques to bring all of the different Access objects together to make a cohesive application. It does this by showing the viewer how and why Microsoft Access utilizes the Properties and Events of the different objects. Finally, the course shows the viewer how to create macros using the new Macro editor and how to select the proper Control and Event for the best possible outcome.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
If you would like to work along with the instructor, please download the attached .zip file, which contains all the files used throughout this course.
|Section 2: Designing The Application|
Access Development PhasesPreview
Define Database Architecture
Entire Database on Server
Splitting the Database
Creating a Database Project
Integrating with SharePointPreview
|Section 3: Table Data Macros|
Different Data Macro TypesPreview
Event-Driven Data Macro
The Application Log
|Section 4: Creating Advanced Queries|
Using Left and Right Joins
Creating a Crosstab Query
Using Access Function within a Query
|Section 5: Advanced Form Design|
Creating an Autofill Form
Forms and Subforms
Advanced Calculated Controls
Using the Tab Control
Option Group Control
|Section 6: Macros|
Different Macro TypesPreview
Reviewing the Object Events
|Section 7: System Wrap-Up and Distribution|
Documenting a Database
Encrypting and Decrypting a Database
Converting to an .accde File
Packaging the Database
|Section 8: Conclusion|
At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.