InformIT: Safari Books Online - 9780768682830 - Microsoft Office Access 2007 LiveLessons

Advanced Search

Table of Contents

Microsoft Office Access 2007 LiveLessons

Browse by Category

Safari Books Online is an on-demand digital library that delivers expert content from the world's most trusted leaders in technology publishing to professionals worldwide. Safari brings you thousands of books, manuscripts, short topics, articles, and instructional video from expert authors, innovators, and thought leaders. Subscribe now! If you're interested in workgroup accounts, please visit our Multi-User Accounts page.

Microsoft Office Access 2007 LiveLessons

by Alison Balter

Publisher: Que

Pub Date: July 07, 2008

Print ISBN-10: 0-7686-8283-5

Print ISBN-13: 978-0-7686-8283-0

Running Time: 8 hours 54 minutes

Overview

Microsoft® Office Access 2007 Live Lessons

Mastering the Smartest, Fastest Ways to Use Access 2007

Alison Balter

Online Video 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 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.

Table of Contents

Video Preferences

Table of Contents

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

URL http://my.safaribooksonline.com/9780768682830