Microsoft Office Access 2007 LiveLessons (Video Training) [Multiple-component retail product]

Section 1 Whats 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 Whats 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: Whats New with Security: An Overview . . . . . . . . . . . . . .
. . . . . . . . . 9

Lesson 13: Whats New with ADP Files. . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . 10

Lesson 14: Whats New with Replication . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . 10

 

Section 4 Whats 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 Whats 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

Alison Balter

is the president of InfoTech Services Group, Inc., a computer consulting firm based

in Newbury Park, California. Alison is a highly experienced independent trainer and consultant

specializing in Windows applications training and development. During her 24 years in the computer

industry, she has trained and consulted with many corporations and government agencies.

Since Alison founded InfoTech Services Group, Inc. (formerly InfoTechnology Partners) in 1990,

its client base has expanded to include major corporations and government agencies such as Cisco,

Shell Oil, Accenture, AIG Insurance, Northrop, the Drug Enforcement Administration, Prudential

Insurance, Transamerica Insurance, Fox Broadcasting, the United States Navy, and others.

Alison is the author of more than 300 internationally marketed computer training videos, including

18 Access 2000 videos, 35 Access 2002 videos, and 15 Access 2003 videos. Alison travels throughout

North America giving training seminars in Microsoft Access and Microsoft SQL Server.

Alison is also author of 14 books published by Sams Publishing: Alison Balters Mastering Access

95 Development, Alison Balters Mastering Access 97 Development, Alison Balters Master Access

2000 Development, Alison Balters Mastering Access 2002 Desktop Development, Alison Balters

Mastering Access 2002 Enterprise Development, Alison Balters Mastering Microsoft Access

Office 2003, Teach Yourself Microsoft Office Access 2003 in 24 Hours, Access Office 2003 in a

Snap, Alison Balterss Mastering Access 2007 Development, a power user book on Microsoft

Access 2007, three e-books on Microsoft Access 2007, and Teach Yourself SQL Express 2005 in 24

Hours.

An active participant in many user groups and other organizations, Alison is a past president of the

Independent Computer Consultants Association of Los Angeles and of the Los Angeles Clipper

Users Group. She is also past president of the Ventura County Professional Womens Network,

and is currently their Director of Networking.

Although Alison has not given up her computer consulting business, her latest passion has been to

become a life coach. Alison enjoys helping people overcome their obstacles and achieve their

dreams. After a one-year training program, Alison founded Achieve Your Dreamz Coaching

Center. Alison works with people to define what it is they want in life and then helps them to get

there. She does this by taking them through a step-by-step process that allows them to turn their

dreams into reality.

On a personal note, Alison keeps herself busy skiing, ice skating, running, lifting weights, hiking,

traveling, and dancing. She most enjoys spending time with her husband, Dan, their daughter

Alexis, their son Brendan, and their Golden Retriever, Brandy.

Alisons firm, InfoTech Services Group, Inc., is available for consulting work and onsite training

in Microsoft Access, Visual Studio .NET, Visual Basic, and SQL Server, as well as for Windows

Server 2003, Vista, PC networking, and Microsoft Exchange Server. Contact Alison by electronic

mail at Alison@InfoTechServicesGroup.com, or visit InfoTech Services Groups website at

www.InfoTechServicesGroup.com. For life coaching contact Alison at Alison@achieveyourdreamz.

com, or visit her Web site www.AchieveYourDreamz.com.