Access 2007 Advanced
4.9 (4 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.
96 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Access 2007 Advanced to your Wishlist.

Add to Wishlist

Access 2007 Advanced

Learn how to bring all Access objects together to create a cohesive and effective application
4.9 (4 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.
96 students enrolled
Last updated 10/2016
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Basic Microsoft Windows and Intermediate Microsoft Access 2007 training or equivalent experience
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.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 38 Lectures Collapse All 38 Lectures 02:43:35
+
Introduction
1 Lecture 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.  
Preview 02:52
+
Designing the Application
4 Lectures 10:48

Putting the Entire Database on a Server
02:23

Splitting the Database
02:14

+
Subforms
4 Lectures 25:09
Creating a Subform Automatically
06:56

Creating a Subform Manually
06:37

Linking a Subform
03:26

Referencing Controls in a Subform
08:10
+
Dialog Boxes
4 Lectures 26:46

Creating a Dialog Box
02:39

Setting Dialog Box Properties
12:58

Setting Dialog Events
09:37
+
Controls
4 Lectures 28:19

Using the Command Button Contro
02:52

Using the Combo Box Control
16:29

Examining the Query and Form
02:58
+
Passing Form Values to Queries
1 Lecture 04:18
Using the Expression Builder
04:18
+
Simple Macros
2 Lectures 15:15

Creating a Simple Macro
12:29
+
Macro Groups
2 Lectures 11:46
Understanding Macro Groups
01:22

Creating a Macro Group
10:24
+
Conditional Macros
6 Lectures 22:39
Understanding Conditional Macros
02:34

Creating a Conditional Macro
03:06

Using the StopMacro Command
01:13

Fixing Syntax Errors
01:56


Validating input
10:32
+
System Wrap-Up
4 Lectures 10:44
Importance of Documenting the Database
01:58

Using the Database Documenter
02:52

Setting Autostart Options
03:52

Setting a Password
02:02
2 More Sections
About the Instructor
Intellezy Trainers
4.4 Average rating
2,999 Reviews
20,360 Students
133 Courses
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.