Home > Store > Data > Access

Microsoft Office Access 2007 LiveLessons (Video Training)

Microsoft Office Access 2007 LiveLessons (Video Training)

Your browser doesn't support playback of this video. Please download the file to view it.

DVD

  • Your Price: $31.99
  • List Price: $39.99
  • Usually ships in 24 hours.

Downloadable Video

  • Your Price: $39.99
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Register your product to gain access to bonus material or receive a coupon.

Audio & Video

Video

Sample: Lesson 9, Working with Multi-valued Fields
 

You need to upgrade your Flash Player. You need version 9 or above to view this video. You may download it here. You may also see this message if you have JavaScript turned off. If this is the case, please enable JavaScript and reload the page.

Buy Lessons

DRM-Free Video Downloads. Purchase and immediately download individual lessons from this video. Make your lesson selections below and click on the Buy button.

Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec. Requires the free QuickTime Player software.

Lesson 0

Access and the Internet, Downloadable Version

These five power-packed lessons will instruct you on saving database objects as HTML; linking to HTML files; importing HTML files; exporting data to XML; and importing XML data into Access. All in less than 20 minutes!

Duration: 00:19:30  File Size: 45 MB

Lesson 1

What's New in the Access 2007 User Interface?, Downloadable Version

This section discusses the significant changes in the user interface. For example, menus have been replaced by the Ribbon and the Database Window has been replaced by the Navigation Pane. Alison discusses these changes, as well as the Quick Access Toolbar, Tabbed Documents, and more in these five video lessons.

Duration: 00:28:18  File Size: 72 MB

Lesson 2

What's New with Access 2007 Tables?, Downloadable Version

These six video lessons cover the exciting new enhancements to tables in Access 2007. Topics covered include the new Attachemnt Data Type and using Memo Field History Tracking.

Duration: 00:25:24  File Size: 58 MB

Lesson 3

Overview of Other Special Topics You Need to Know About with Access 2007, Downloadable Version

These three important video lessons cover what is new in Access 2007 regarding security, ADP files, and replication. 

Duration: 00:17:23  File Size: 31 MB

Lesson 4

What's New with Access 2007 Forms?, Downloadable Version

Have fun exploring what's new with forms in Access 2007. These six lessons will get you up to speed on topics like Layout View, Tabular Layouts,  Split Forms, and Alternate Background Colors.

Duration: 00:35:18  File Size: 87 MB

Lesson 5

What's New with Access 2007 Reports?, Downloadable Version

Discover all the new features for reports in Access 2007. These five lessons take on topics such as the Group, Sort and Total feature and Report Properties.

Duration: 00:33:57  File Size: 85 MB

Lesson 6

Creating Macros in Access 2007, Downloadable Version

In just under an hour, these ten lessons will show you all you need to know about creating macros in Access 2007. You'll start with the basics and then cover modifying, documenting, and embedding macros. Finally, you'll tackle error handling, variables, and creating an AutoExec macro.

Duration: 00:59:16  File Size: 122 MB

Lesson 7

Power Table Techniques, Downloadable Version

In just three lessons and under 20 minutes, you'll explore power table techniques such as field properties, table properties, and indexes.

Duration: 00:18:48  File Size: 34 MB

Lesson 8

Power Query Techniques, Downloadable Version

In these seven lessons, discover power query techniques such as Adding Calculated Columns to Select Queries; Applying Advanced Criteria; Creating and Running Parameter Queries; and Working with Outer Joins.

Duration: 00:51:31  File Size: 121 MB

Lesson 9

Power Form Techniques, Downloadable Version

In just six lessons and under 30 minutes, you'll master power form technigues like Control Properties and Why to Use Them; Bound, Unbound, and Calculated Controls; Using the Expression Builder to Help You to Enhance Forms; Basing Forms on Queries and Embedded SQL Statements and more.

Duration: 00:29:34  File Size: 74 MB

Lesson 10

Power Report Techniques, Downloadable Version

Discover power report techniques like Control Properties and Why to Use Them; Inserting Page Breaks; Bound, Unbound, and Calculated Controls; Basing Reports on Queries and Embedded SQL Statements and more.

Duration: 00:29:29  File Size: 78 MB

Lesson 11

Sharing Data with Other Applications, Downloadable Version

Ten powerful lesosns get you up to speed on sharing data in Access with other applications. Topics covered include exporting to another Access database, an Excel spreadsheet, Text, and a PDF file. You'll also learn to import from another Access database or a spreadsheet. Finally, you'll learn all about linking to various sources.

Duration: 00:39:13  File Size: 39 MB

Lesson 13

Database Administration, Downloadable Version

Learn five essetial database administration skills in under 20 minutes! 

  • Backing Up a Database
  • Compacting and Repairing a Database
  • Converting a Database to Another File Format
  • Creating an ACCDE File
  • Using the Database Splitter Wizard

Duration: 00:20:51  File Size: 38 MB

Lesson 14

Database Documentation, Downloadable Version

These three video lessons will help you master database documentation essentials that include preparing an application to be self-documenting; using the database documenter; and learning the Object Dependencies feature.

Duration: 00:17:16  File Size: 37 MB

Lesson 15

Finishing Touches, Downloadable Version

Don't forget the finishing touches! Take a few minutes to learn how to set Startup options and control environmental settings. You'll be glad you did!

Duration: 00:08:39  File Size: 16 MB

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Description

  • Copyright 2009
  • Dimensions: 7-1/2 X 9-1/8
  • Pages: 96
  • Edition: 1st
  • DVD
  • ISBN-10: 0-7897-3801-5
  • ISBN-13: 978-0-7897-3801-1

Microsoft® Office Access 2007 Live Lessons

Mastering the Smartest, Fastest Ways to Use Access 2007

Alison Balter

DVD includes:

. 6+ HOURS OF VIDEO INSTRUCTION

. OVER 80 TIPS & TECHNIQUES

. SKILLS YOU CAN LEARN IN FIVE MINUTES OR LESS

You’ve got Microsoft Office Access 2007...now get the most out of it, faster and more easily than ever before! In more than 80 quick video lessons, Alison Balter shows you all you need to maximize your productivity with Access 2007’s best new tools and shortcuts and its brand-new ribbon interface!

Microsoft Office Access 2007 teaches Access 2007’s most sophisticated features and techniques visually: just watch! You’ll master high-powered Office Access 2007 skills at your own pace—and get specific answers and solutions immediately, whenever you need them!

These practical videos show you how to make the most of Access 2007 tables, forms, reports, security, macros, even replication! You’ll discover power techniques for improving performance… supercharging your queries… creating smarter reports… publishing Access data to the Web… administering, repairing, and documenting databases…

and plenty more!

For anyone who wants to master Access 2007 fast—especially upgraders from previous versions and professionals who want to analyze their own data!

Looking for a better way to master today’s rapidly changing 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 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 five 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 exactly how to get great results in your real-world environment.

World-renowned Access expert Alison Balter presents easy, practical video introductions to Access 2007’s most powerful enhancements: everything from the Quick Access Toolbar to new Split Forms, Views, and Attachment Data Types! Click play to follow along as Alison walks you through using Access 2007’s most important new features…all you need to do is watch!

Alison Balter, founder and President of InfoTechnology Partners, Inc., has been programming, teaching, and writing about Access for more than 12 years. She has authored or coauthored 13 books on Access and speaks regularly on Access at conferences worldwide. Her clients have included Shell Oil, the Archdiocese of Los Angeles, Southern California Edison, Accenture, Prudential Insurance, and the International Cinematographer’s Guild.

Databases

Sample Content

Table of Contents

Section 1 What’s New in the Access 2007 User Interface 1

Lesson 1: Exploring the Ribbon . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1

Lesson 2: Using the Navigation Pane . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2

Lesson 3: Performing Tasks with the Quick Access Toolbar . . . . . . . . . . . . . . 2

Lesson 4: Working with Tabbed Documents . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

Lesson 5: Advanced Navigation Pane Techniques . . . . . . . . . . . . . . . . . . . . . . . . . 3

Section 2 What’s New with Access 2007 Tables 5

Lesson 6: Working with the Attachment Data Type. . . . . . . . . . . . . . . . . . . . . . . . 5

Lesson 7: Adding Rich Text to Memo Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6

Lesson 8: Using Memo Field History Tracking . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6

Lesson 9: Multivalued Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6

Lesson 10: Working with Field Templates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8

Lesson 11: Adding Totals to a Datasheet. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8

Section 3 Overview of Other Special Topics You Need to Know

About with Access 2007 9

Lesson 12: What’s New with Security: An Overview . . . . . . . . . . . . . . . . . . . . . . . 9

Lesson 13: What’s New with ADP Files. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10

Lesson 14: What’s New with Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10

Section 4 What’s New with Access 2007 Forms 13

Lesson 15: Creating a Form in Layout View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

Lesson 16: Working with the Layout Design Window. . . . . . . . . . . . . . . . . . . . 13

Lesson 17: Using Stacked and Tabular Layouts . . . . . . . . . . . . . . . . . . . . . . . . . . . 15

Lesson 18: Getting to Know Split Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15

Lesson 19: Using Alternate Background Colors. . . . . . . . . . . . . . . . . . . . . . . . . . . 16

Lesson 20: What Form Properties Are Available . . . . . . . . . . . . . . . . . . . . . . . . . . 16

Section 5 What’s New with Access 2007 Reports 19

Lesson 21: Creating a Report in Layout View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19

Lesson 22: Working with the Layout Design Window. . . . . . . . . . . . . . . . . . . . 19

Lesson 23: The Group, Sort, and Total Feature . . . . . . . . . . . . . . . . . . . . . . . . . . . 20

Lesson 24: Using Alternate Background Colors. . . . . . . . . . . . . . . . . . . . . . . . . . . 21

Lesson 25: Report Properties and Why to Use Them . . . . . . . . . . . . . . . . . . . . 21

Section 6 Creating Macros in Access 2007 23

Lesson 26: The Basics of Creating an Access Macro . . . . . . . . . . . . . . . . . . . . . 23

Lesson 27: More About Running an Access Macro. . . . . . . . . . . . . . . . . . . . . . . 24

Lesson 28: Modifying an Existing Macro . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25

Lesson 29: Documenting a Macro. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26

Lesson 30: Creating Conditional Macros . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26

Lesson 31: Working with Embedded Macros. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26

Lesson 32: Adding Error Handling to the Macros That You Build. . . . . . 26

Lesson 33: Including Variables in Your Macros . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27

Lesson 34: When Should You Use Macros? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27

Lesson 35: Creating an AutoExec Macro. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27

Section 7 Power Table Techniques 29

Lesson 36: Working with Field Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29

Lesson 37: Working with Table Properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31

Lesson 38: Using Indexes to Improve Performance . . . . . . . . . . . . . . . . . . . . . . 32

Section 8 Power Query Techniques 33

Lesson 39: Adding Calculated Columns to Select Queries . . . . . . . . . . . . . 33

Lesson 40: Applying Advanced Criteria . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34

Lesson 41: Creating and Running Parameter Queries . . . . . . . . . . . . . . . . . . . 35

Lesson 42: Creating and Running Action Queries . . . . . . . . . . . . . . . . . . . . . . . . 35

Lesson 43: Using Aggregate Functions to Summarize

Numeric Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36

Lesson 44: Working with Outer Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37

Lesson 45: Refining Queries with Field, Field List, and

Query Properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38

Section 9 Power Form Techniques 39

Lesson 46: Control Properties and Why to Use Them . . . . . . . . . . . . . . . . . . . 39

Lesson 47: Bound, Unbound, and Calculated Controls . . . . . . . . . . . . . . . . . . 43

Lesson 48: Using the Expression Builder to Help You to

Enhance Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43

Lesson 49: The Command Button Wizard. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44

Lesson 50: Building Forms Based on More Than One Table. . . . . . . . . . . . 44

Lesson 51: Basing Forms on Queries and Embedded SQL

Statements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45

Section 10 Power Report Techniques 47

Lesson 52: Control Properties and Why to Use Them . . . . . . . . . . . . . . . . . . . 47

Lesson 53: Inserting Page Breaks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48

Lesson 54: Bound, Unbound, and Calculated Controls . . . . . . . . . . . . . . . . . . 48

Lesson 55: Using the Expression Builder to Help You to

Enhance Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49

Lesson 56: Building Reports Based on More Than One Table. . . . . . . . . . 49

Lesson 57: Working with Section Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50

Lesson 58: Basing Reports on Queries and Embedded SQL

Statements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51

Section 11 Sharing Data with Other Applications 53

Lesson 59: Exporting to Another Access Database . . . . . . . . . . . . . . . . . . . . . . 53

Lesson 60: Exporting to an Excel Spreadsheet . . . . . . . . . . . . . . . . . . . . . . . . . . . 54

Lesson 61: Exporting to Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54

Lesson 62: Exporting to a PDF File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54

Lesson 63: Importing from Another Access Database . . . . . . . . . . . . . . . . . . . 55

Lesson 64: Importing Spreadsheet Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55

Lesson 65: Importing Text Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56

Lesson 66: Linking to Tables in Another Access Database . . . . . . . . . . . . . . 56

Lesson 67: Introduction to Linking to an ODBC Database. . . . . . . . . . . . . . 57

Lesson 68: The Linked Table Manager. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57

Section 12 Access and the Internet 59

Lesson 69: Saving Database Objects as HTML. . . . . . . . . . . . . . . . . . . . . . . . . . . . 59

Lesson 70: Linking to HTML Files. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59

Lesson 71: Importing HTML Files. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60

Lesson 72: Exporting Data to XML. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60

Lesson 73: Importing XML Data into Access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61

Section 13 Database Administration 63

Lesson 74: Backing Up a Database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63

Lesson 75: Compacting and Repairing a Database . . . . . . . . . . . . . . . . . . . . . . 64

Lesson 76: Converting a Database to Another File Format. . . . . . . . . . . . . 65

Lesson 77: Creating an ACCDE File. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65

Lesson 78: Using the Database Splitter Wizard . . . . . . . . . . . . . . . . . . . . . . . . . . . 65

Section 14 Database Documentation 67

Lesson 79: Preparing an Application to Be Self-Documenting . . . . . . . . . 67

Lesson 80: Using the Database Documenter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68

Lesson 81: The Object Dependencies Feature. . . . . . . . . . . . . . . . . . . . . . . . . . . . 69

Section 15 Finishing Touches 71

Lesson 82: Setting Startup Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71

Lesson 83: Controlling Environmental Settings . . . . . . . . . . . . . . . . . . . . . . . . . . . 71

Updates

Submit Errata

More Information

ONE MONTH ACCESS!

WITH PURCHASE


Get unlimited 30-day access to thousands of Books & Training Videos about technology, professional development and digital media If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months.