Access 2007 Advanced

Learn how to bring all Access objects together to create a cohesive and effective application
4.8 (2 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
79 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 38
  • Length 2.5 hours
  • Skill Level Expert Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2013 English

Course Description

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.

What are the requirements?

  • Basic Microsoft Windows and Intermediate Microsoft Access 2007 training or equivalent experience

What am I going to get from this course?

  • Understand how to design an application
  • Effectively use subforms, dialog boxes, and controls
  • Unleash the power of macros
  • Correctly wrap up development
  • Learn helpful programming tips

What is the target audience?

  • Students who are familiar with creating and expanding upon basic databases looking to automate their databases through the use of macros, create more effective reports and use controls

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
02:52
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 Phases
Preview
03:31
Putting the Entire Database on a Server
02:23
Splitting the Database
02:14
Creating a Database Project
Preview
02:40
Section 3: Subforms
Creating a Subform Automatically
06:56
Creating a Subform Manually
06:37
Linking a Subform
03:26
Referencing Controls in a Subform
08:10
Section 4: Dialog Boxes
Understanding Dialog Boxes
Preview
01:32
Creating a Dialog Box
02:39
Setting Dialog Box Properties
12:58
Setting Dialog Events
09:37
Section 5: Controls
Using the Option Group Control
Preview
06:00
Using the Command Button Contro
02:52
Using the Combo Box Control
16:29
Examining the Query and Form
02:58
Section 6: Passing Form Values to Queries
Using the Expression Builder
04:18
Section 7: Simple Macros
Understanding Macro types
Preview
02:46
Creating a Simple Macro
12:29
Section 8: Macro Groups
Understanding Macro Groups
01:22
Creating a Macro Group
10:24
Section 9: Conditional Macros
Understanding Conditional Macros
02:34
Creating a Conditional Macro
03:06
Using the StopMacro Command
01:13
Fixing Syntax Errors
01:56
Handling a False Condition
Preview
03:18
Validating input
10:32
Section 10: System Wrap-Up
Importance of Documenting the Database
01:58
Using the Database Documenter
02:52
Setting Autostart Options
03:52
Setting a Password
02:02
Section 11: Programming Tips
Data First
01:05
Table Properties
00:37
Form Design
00:49
Follow Windows
00:53
Close Buttons
00:38
Simple is Best
00:57
Section 12: Conclusion

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Intellezy Trainers, Computer Training Specialists

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.

Ready to start learning?
Take This Course