Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

Application Development with Microsoft® Access 2007

Live Lessons

Microsoft Access/Databases

For Access power users, programmers, and anyone who wants to master Access 2007 development fast.

In Application Development with Access 2007, renowned Access developer, trainer, and author Alison Balter teaches all the skills you

need to build professional-quality Access 2007 applications.

This package brings together more than twelve hours of personalized, expert video training: 100+ quick, practical video lessons that demonstrate all the skills you need to build virtually any Access application. You’ll learn one step at a time, at your own pace—using hands-on examples that reflect realistic development challenges and showcase Access 2007’s remarkable capabilities.

Application Development with Access 2007 delivers the power of the best classroom training at a small fraction of the cost. If you don’t

have time to read a huge book on Access development, this is exactly what you’ve been searching for!

Looking for a better way to master today’s rapidly changing programming technologies? Want expert help, but don’t have the time or energy to read a book? Can’t find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world’s leading technology experts.

  • LiveLessons are video courses, on DVD with a book supplement, that are organized into bite-sized, self-contained sessions—you’ll learn key skills in as little as fifteen minutes!

  • Each lesson begins with well-defined learning objectives and ends with comprehensive summaries, which help you track

  • your progress.

  • Follow along as your instructor shows how to get results in today’s top development environments: including Microsoft’s Visual Studio and eclipse.org’s Eclipse.

“We are reaching more and more for video alternatives because they make sense! The imprints of Pearson Technology Group are the most trusted source of quality technology books, and they will be the brands we turn to for visual learning.”

  —Leo J. Hauguel, Information Security Analyst 5

Wells Fargo Services Company

Alison Balter, one of the world’s most experienced Access developers and trainers, has created Access applications ranging from small end-user projects to enterprise-wide systems. Her thirteen books on Access include Alison Balter’s Mastering Microsoft Office Access 2007 Development.

System Requirements

  • Operating System: Windows 98, 2000, XP, or Vista; Mac OS X; versions of Linux with the Flash 8 Player or later

  • Multimedia: DVD drive, an 800x600 or higher display, and sound card with speakers

  • Computer: 500MHz or higher, 128MB RAM or more 

Subscriber Reviews

Average Rating: 4.5 out of 5 rating Based on 4 Ratings

No Subscribers have provided a review for this video.

Table of Contents

Chapter/Selection

Time

Live Lessons Introduction

Live Lessons Introduction

Play Video

00:03:26

Section 1: Access as a Development Tool

Learning Objectives

Play Video

00:01:40

Lesson 1: What's New with the User Interface?

Preview

00:08:47

Lesson 2: What's New with Tables?

Preview

00:12:10

Lesson 3: Enhancements to DataSheet View

Preview

00:06:12

Lesson 4: What's New with Forms?

Preview

00:08:37

Lesson 5: What's New with Reports?

Play Video

00:10:15

Lesson 6: The New and Improved Embedded Macros

Preview

00:12:14

Section 2: VBA: A Foundational Review

Learning Objectives

Play Video

00:01:36

Lesson 7: What Types of Modules are Available?

Play Video

00:08:23

Lesson 8: Working with Variables

Preview

00:08:35

Lesson 9: Working with Constants

Preview

00:04:52

Lesson 10: Adding Comments to Your Code

Preview

00:03:08

Lesson 11: Using the Line Continuation Character

Play Video

00:04:23

Lesson 12: Using VBA Control Structures

Preview

00:07:51

Lesson 13: Passing Parameters and Returning Values

Preview

00:05:38

Lesson 14: Executing Procedures in the Code Window

Preview

00:04:23

Lesson 15: The DoCmd Object: Performing Macro Actions

Preview

00:04:53

Lesson 16: Working with Built-In Functions

Play Video

00:04:56

Lesson 17: Using Built-In Dialog Boxes

Preview

00:06:12

Lesson 18: Editor Tips and Tricks

Preview

00:08:34

Section 3: Objects, Properties, Methods, and Events Explained

Learning Objectives

Play Video

00:01:36

Lesson 19: Understanding Access's Object Model

Preview

00:06:56

Lesson 20: Understanding Objects, Properties, Events, and Methods

Play Video

00:04:41

Lesson 21: Referring to Objects

Preview

00:06:43

Lesson 22: Declaring and Assigning Object Variables

Preview

00:04:45

Lesson 23: Differences Between Objects and Collections

Preview

00:05:51

Lesson 24: Passing Objects to Subroutines and Functions

Preview

00:04:01

Lesson 25: Determining the Type of a Control

Preview

00:04:00

Lesson 26: Special Properties That Refer to Objects

Preview

00:03:46

Section 4: Debugging: Your Key to Successful Development

Learning Objectives

Play Video

00:01:37

Lesson 27: Avoiding Bugs

Preview

00:04:11

Lesson 28: Harnessing the Power of the Immediate Window

Preview

00:07:10

Lesson 29: Using Breakpoints to Troubleshoot

Preview

00:03:54

Lesson 30: Stepping Through Code

Preview

00:06:08

Lesson 31: Setting the Next Statement to Execute

Preview

00:03:02

Lesson 32: Using the Call Stack Window

Preview

00:03:42

Lesson 33: Working with the Locals Window

Preview

00:04:33

Lesson 34: Working with the Watch Window

Play Video

00:08:10

Section 5: Error Handling: Preparing for the Inevitable

Learning Objectives

Play Video

00:01:39

Lesson 35: Implementing Error Handling

Preview

00:04:38

Lesson 36: Using On Error Statements

Preview

00:06:51

Lesson 37: Using Resume Statements

Preview

00:05:44

Lesson 38: The Cascading Error Effect

Play Video

00:03:57

Lesson 39: Raising an Error

Preview

00:04:20

Lesson 40: Using the Errors Collection

Preview

00:03:50

Lesson 41: Creating a Generic Error Handler

Preview

00:11:43

Lesson 42: Preventing Your Own Error Handling from Being Invoked

Preview

00:03:47

Section 6: What Are ActiveX Data Objects and Data Access Objects?

Learning Objectives

Play Video

00:01:39

Lesson 43: The Data Access Object Model

Preview

00:07:32

Lesson 44: Getting to Know DBEngine

Preview

00:03:09

Lesson 45: Using CurrentDB

Play Video

00:02:31

Lesson 46: Working with DAO Recordset Types

Preview

00:05:30

Lesson 47: DAO Recordset Properties and Methods

Preview

00:13:35

Lesson 48: Using DAO Code to Modify Table Data

Preview

00:09:33

Lesson 49: Using DAO Code to Modify Database Objects

Preview

00:05:41

Lesson 50: Examining the ADO Object Model

Preview

00:03:17

Lesson 51: Working with Connections

Preview

00:03:36

Lesson 52: Working with ADO Recordset Types

Preview

00:10:54

Lesson 53: ADO Recordset Properties and Methods

Preview

00:12:42

Lesson 54: Using ADO Code to Modify Table Data

Preview

00:10:21

Lesson 55: Using ADO Code to Modify Database Objects

Preview

00:08:22

Section 7: Advanced Form Techniques

Learning Objectives

Play Video

00:01:33

Lesson 56: Form Events and When To Use Them?

Play Video

00:15:29

Lesson 57: Order of Events for Forms

Preview

00:02:56

Lesson 58: Utilizing Section and Control Events

Preview

00:10:55

Lesson 59: Taking Advantage of Built-In Form-Filtering Features

Preview

00:05:32

Lesson 60: Switching a Form's Record Source

Preview

00:07:24

Lesson 61: Power Combo Box and List Box Techniques

Preview

00:05:45

Lesson 62: Synchronizing a Form with Its Underlying Recordset

Preview

00:03:11

Section 8: Advanced Report Techniques

Learning Objectives

Play Video

00:01:30

Lesson 63: Report Events and When to Use Them

Preview

00:07:30

Lesson 64: Order of Events for Reports

Preview

00:01:54

Lesson 65: Practical Applications of Report Techniques

Preview

00:19:38

Section 9: Advanced Query Techniques

Learning Objectives

Play Video

00:01:34

Lesson 66: Understanding SQL

Preview

00:10:30

Lesson 67: Self-Joins

Preview

00:04:26

Lesson 68: Union Queries

Preview

00:05:14

Lesson 69: Pass-Through Queries

Preview

00:07:38

Lesson 70: Subqueries

Preview

00:03:50

Lesson 71: Propagation of Nulls

Preview

00:03:45

Lesson 72: Using User-Defined Functions with Queries

Preview

00:06:31

Section 10: Advanced VBA Techniques

Learning Objectives

Play Video

00:01:37

Lesson 73: Working with Arrays

Preview

00:07:16

Lesson 74: Advanced Function Techniques

Preview

00:14:09

Lesson 75: Working with Empty and Null

Preview

00:09:30

Lesson 76: Creating and Working with Custom Collections

Preview

00:04:09

Section 11: Exploiting the Power of Class Modules

Learning Objectives

Play Video

00:01:30

Lesson 77: Creating and Using a Class Module

Preview

00:09:24

Lesson 78: Creating Multiple Class Instances

Preview

00:03:58

Lesson 79: More About Collections

Preview

00:04:13

Lesson 80: Custom Collections in Use

Play Video

00:06:15

Section 12:Using External Data

Learning Objectives

Play Video

00:01:30

Lesson 81: Using Code to Import External Data

Preview

00:06:44

Lesson 82: Using Code to Link to External Data

Preview

00:09:15

Lesson 83: Refreshing and Removing Links

Preview

00:06:26

Section 13: Automation: Communicating with Other Applications

Learning Objectives

Play Video

00:01:34

Lesson 84: Creating an Automation Object

Preview

00:06:36

Lesson 85: Controlling Excel from Access

Preview

00:06:27

Lesson 86: Closing an Excel Automation Object

Preview

00:03:56

Lesson 87: Creating a Graph from Access

Preview

00:10:29

Lesson 88: Controlling Word from Access

Preview

00:07:24

Lesson 89: Controlling PowerPoint from Access

Preview

00:07:36

Lesson 90: Controlling Access from Other Applications

Preview

00:09:03

Section 14: Exploiting the Power of the Windows API

Learning Objectives

Play Video

00:01:39

Lesson 91: Declaring a Windows API Function

Preview

00:03:43

Lesson 92: Getting Information About the Operating Environment

Preview

00:07:57

Lesson 93: Determining Drive Information

Preview

00:08:18

Section 15: Developing Multiuser and Enterprise Applications

Learning Objectives

Play Video

00:01:45

Lesson 94: Designing a Multiuser Application

Preview

00:04:39

Lesson 95: Understanding Access's Locking Mechanisms

Play Video

00:04:19

Lesson 96: Understanding the Client/Server Model

Preview

00:03:14

Lesson 97: Deciding When to Go Client/Server

Preview

00:06:28

Lesson 98: Roles Access Plays in the Application Design Model

Preview

00:06:05

Lesson 99: What is a Linked Client/Server Application

Preview

00:02:04

Lesson 100: Defining an ODBC Data Source

Preview

00:05:54

Lesson 101: Upsizing an existing Access Database

Preview

00:11:36

Lesson 102: Working with Linked Tables

Preview

00:09:06

Lesson 103: Working with SQL Server Views

Preview

00:09:21

Lesson 104: Using Pass-Through Queries

Preview

00:07:02

Lesson 105: Executing Stored Procedures

Preview

00:10:23

Lesson 106: Building Client/Server Friendly Forms

Preview

00:12:38

Lesson 107: Building Client/Server Friendly Reports

Preview

00:16:07

Section 16: Working With and Customizing Ribbons

Learning Objectives

Play Video

00:01:35

Lesson 108: Customizing the Ribbon

Preview

00:06:44

Lesson 109: Applying a Ribbon when a Database Opens

Preview

00:03:57

Lesson 110: Associating a Custom Ribbon with a Form or Report

Preview

00:03:23

Lesson 111: Executing a Macro from a Ribbon

Preview

00:05:28

Section 17: Working With Microsoft Sharepoint

Learning Objectives

Play Video

00:01:40

Lesson 112: What Is SharePoint, and Why Use It With Your Applications?

Preview

00:01:47

Lesson 113: Exporting Data to a SharePoint Site

Preview

00:04:21

Lesson 114: Publishing Data to a SharePoint Site

Preview

00:06:12

Lesson 115: Opening Access Forms and Reports from a SharePoint Site

Preview

00:05:42

Lesson 116: Importing and Linking to SharePoint Lists

Preview

00:03:32

Lesson 117: Taking SharePoint Lists Offline

Preview

00:07:15

Lesson 118: Reestablishing Links When a Site Has Been Moved

Preview

00:02:35

Section 18: Database Security Made Easy

Learning Objectives

Play Video

00:01:33

Lesson 119: What's New in Access 2007 Security?

Preview

00:02:46

Lesson 120: Working with the Trust Center

Preview

00:04:54

Lesson 121: Using an Access 2007 Database in a Trusted Location

Preview

00:05:23

Lesson 122: Using a Database Password to Encrypt an Access 2007 Database

Preview

00:04:11

Lesson 123: Packaging, Signing, and Distributing an Access 2007 Database

Preview

00:06:09

Extras

The publisher has provided additional content related to this title.


Description
Content

These files have been provided by the publisher.

  • mac.sitx
  • win.zip