O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Office Access 2007 (Video Training)

Video Description

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 2007teaches 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

    Table of Contents

    1. Introduction
      1. Introduction 00:03:11
    2. Section 1: What's New in the Access 2007 User Interface
      1. Learning Objectives 00:01:40
      2. Lesson 1: Exploring the Ribbon 00:07:25
      3. Lesson 2: Using the Navigation Pane 00:06:26
      4. Lesson 3: Performing Tasks with the Quick Access Toolbar 00:04:27
      5. Lesson 4: Working with Tabbed Documents 00:06:06
      6. Lesson 5: Advanced Navigation Pane Techniques 00:08:09
    3. Section 2: What's New with Access 2007 Tables
      1. Learning Objectives 00:01:40
      2. Lesson 6: Working with the Attachment Data Type 00:05:18
      3. Lesson 7: Adding Rich Text to Memo Fields 00:03:38
      4. Lesson 8: Using Memo Field History Tracking 00:04:29
      5. Lesson 9: Multi-valued Fields 00:07:02
      6. Lesson 10: Working with Field Templates 00:05:27
      7. Lesson 11: Adding Totals to a Datasheet 00:04:56
    4. Section 3: Overview of Special Topics You Need to Know About with Access 2007
      1. Learning Objectives 00:01:33
      2. Lesson 12: What's New with Security - An Overview 00:07:32
      3. Lesson 13: What's New with ADP Files 00:01:49
      4. Lesson 14: What's New with Replication 00:10:02
    5. Section 4: What's New with Access 2007 Forms
      1. Learning Objectives 00:01:31
      2. Lesson 15: Creating a Form in Layout View 00:05:09
      3. Lesson 16: Working with the Layout Design Window 00:10:51
      4. Lesson 17: Using Stacked and Tabular Layouts 00:04:23
      5. Lesson 18: Getting to Know Split Forms 00:05:38
      6. Lesson 19: Using Alternate Background Colors 00:03:28
      7. Lesson 20: What Form Properties are Available 00:10:14
    6. Section 5: What's New with Access 2007 Reports Learning Objectives
      1. Learning Objectives 00:01:33
      2. Lesson 21: Creating a Report in Layout View 00:04:22
      3. Lesson 22: Working with the Layout Design Window 00:11:24
      4. Lesson 23: The Group, Sort, and Total Feature 00:08:57
      5. Lesson 24: Using Alternate Background Colors 00:05:27
      6. Lesson 25: Report Properties and Why to Use Them 00:08:10
    7. Section 6: Creating Macros in Access 2007 Learning Objectives
      1. Learning Objectives 00:01:36
      2. Lesson 26: The Basics of Creating a Macro 00:07:45
      3. Lesson 27: More About Running an Access Macro 00:08:16
      4. Lesson 28: Modifying an Existing Macro 00:05:09
      5. Lesson 29: Documenting a Macro 00:05:04
      6. Lesson 30: Creating Conditional Macros 00:18:22
      7. Lesson 31: Working with Embedded Macros 00:07:25
      8. Lesson 32: Adding Error Handling to the Macros that You Build 00:04:44
      9. Lesson 33: Including Variables in Your Macros 00:05:41
      10. Lesson 34: When Should You Use Macros 00:03:27
      11. Lesson 35: Creating an AutoExec Macro 00:03:36
    8. Section 7: Power Table Techniques Learning Objectives
      1. Learning Objectives 00:01:53
      2. Lesson 36: Working with Field Properties 00:10:39
      3. Lesson 37: Working with Table Properties 00:05:00
      4. Lesson 38: Using Indexes to Improve Performance 00:04:48
    9. Section 8: Power Query Techniques Learning Objectives
      1. Learning Objectives 00:01:35
      2. Lesson 39: Adding Calculated Columns to Select Queries 00:08:10
      3. Lesson 40: Applying Advanced Criteria 00:06:02
      4. Lesson 41: Creating and Running Parameter Queries 00:08:52
      5. Lesson 42: Creating and Running Action Queries 00:12:28
      6. Lesson 43: Using Aggregate Functions to Summarize Numeric Data 00:06:22
      7. Lesson 44: Working with Outer Joins 00:07:00
      8. Lesson 45: Refining Queries with Field, Field List, and Query Properties 00:09:19
    10. Section 9: Power Form Techniques Learning Objectives
      1. Learning Objectives 00:01:31
      2. Lesson 46: Control Properties and Why to Use Them 00:09:31
      3. Lesson 47: Bound, Unbound, and Calculated Controls 00:04:14
      4. Lesson 48: Using the Expression Builder to Help You to Enhance Forms 00:04:42
      5. Lesson 49: The Command Button Wizard 00:05:03
      6. Lesson 50: Building Forms Based on More Than One Table 00:07:21
      7. Lesson 51: Basing Forms on Queries and Embedded SQL Statements 00:04:18
    11. Section 10: Power Report Techniques Learning Objectives
      1. Learning Objectives 00:01:38
      2. Lesson 52: Control Properties and Why to Use Them 00:08:21
      3. Lesson 53: Inserting Page Breaks 00:04:28
      4. Lesson 54: Bound, Unbound, and Calculated Controls 00:03:22
      5. Lesson 55: Using the Expression Builder to Help You to Enhance Reports 00:03:07
      6. Lesson 56: Building Reports Based on More Than One Table 00:06:52
      7. Lesson 57: Working with Section Properties 00:06:13
      8. Lesson 58: Basing Reports on Stored Queries and Embedded SQL Statements 00:03:45
    12. Section 11: Sharing Data with Other Applications Learning Objectives
      1. Learning Objectives 00:01:36
      2. Lesson 59: Exporting to Another Access Database 00:04:35
      3. Lesson 60: Exporting to an Excel Spreadsheet 00:04:28
      4. Lesson 61: Exporting to Text 00:03:12
      5. Lesson 62: Exporting to a PDF File 00:04:40
      6. Lesson 63: Importing from Another Access Database 00:03:49
      7. Lesson 64: Importing Spreadsheet Data 00:05:51
      8. Lesson 65: Importing Text Data 00:06:20
      9. Lesson 66: Linking to Tables in Another Access Database 00:04:58
      10. Lesson 67: Introduction to Linking to an ODBC Database 00:06:27
      11. Lesson 68: The Linked Table Manager 00:05:08
    13. Section 12: Access and the Internet Learning Objectives
      1. Learning Objectives 00:01:31
      2. Lesson 69: Saving Database Objects as HTML 00:05:38
      3. Lesson 70: Linking to HTML Files 00:04:43
      4. Lesson 71: Importing HTML Files 00:04:07
      5. Lesson 72: Exporting Data to XML 00:05:18
      6. Lesson 73: Importing XML Data into Access 00:04:07
    14. Section 13: Database Administration Learning Objectives
      1. Learning Objectives 00:01:31
      2. Lesson 74: Backing Up a Database 00:04:26
      3. Lesson 75: Compacting and Repairing a Database 00:02:53
      4. Lesson 76: Converting a Database to Another File Format 00:07:17
      5. Lesson 77: Creating an ACCDE File 00:04:59
      6. Lesson 78: Using the Database Splitter Wizard 00:05:40
    15. Section 14: Database Documentation Learning Objectives
      1. Learning Objectives 00:01:27
      2. Lesson 79: Preparing an Application to be Self-Documenting 00:07:06
      3. Lesson 80: Using the Database Documenter 00:08:08
      4. Lesson 81: The Object Dependencies Feature 00:04:08
    16. Section 15: Finishing Touches Learning Objectives
      1. Learning Objectives 00:01:30
      2. Lesson 82: Setting Startup Options 00:04:25
      3. Lesson 83: Controlling Other Environmental Settings 00:05:06