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 you how to bring all of the different Access objects and development phases together to make a cohesive application. It also teaches you many different techniques to make Access even more interactive by using dialog boxes, subforms, and more controls. Finally, the course shows you how to create different types of macros and how to select the proper Control and Event for the best possible outcome. The course will cover programming tips as well.
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 throughout this course, please down load the attached .zip file, which contains the individual files the instructor.
|Section 2: Designing the Application|
The Access Development PhasesPreview
Putting the Entire Database on a Server
Splitting the Database
Creating a Database ProjectPreview
|Section 3: Subforms|
Creating a Subform Automatically
Creating a Subform Manually
Linking a Subform
Referencing Controls in a Subform
|Section 4: Dialog Boxes|
Understanding Dialog BoxesPreview
Creating a Dialog Box
Setting Dialog Box Properties
Setting Dialog Events
|Section 5: Controls|
Using the Option Group ControlPreview
Using the Command Button Contro
Using the Combo Box Control
Examining the Query and Form
|Section 6: Passing Form Values to Queries|
Using the Expression Builder
|Section 7: Simple Macros|
Understanding Macro typesPreview
Creating a Simple Macro
|Section 8: Macro Groups|
Understanding Macro Groups
Creating a Macro Group
|Section 9: Conditional Macros|
Understanding Conditional Macros
Creating a Conditional Macro
Using the StopMacro Command
Fixing Syntax Errors
Handling a False ConditionPreview
|Section 10: System Wrap-Up|
Importance of Documenting the Database
Using the Database Documenter
Setting Autostart Options
Setting a Password
|Section 11: Programming Tips|
Simple is Best
|Section 12: 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.