Welcome to

 

         Lifeline to Learning®

          The online learning center for life's most important skills

                                                    About Our Courseware
    All Lifeline to Learning courseware has been developed, tested
    and proven effective over many years. Each program has been
    created as a tool to be used either by an instructor in a workshop
    environment, or for individual use.  All of our courses are user
    friendly and easily downloaded.

    System Requirements:   Adobe Reader, level 8 or newer
                                                   Microsoft Office, Version 2007
                                                      Get Adobe Reader

Microsoft Access Advanced
                                                                                                Table of Contents of The Instructor's Guide

Section 1: Advanced Data Management ....................................................................................... 1

Lesson 1.1: Referential Integrity ........................................................................................................... 2

Using the Relationships View and Tab ................................................................................................................ 2

Types of Relationships ....................................................................................................................................... 7

Establishing Referential Integrity ...................................................................................................................... 10

Enforcing Referential Integrity .......................................................................................................................... 10

Testing Referential Integrity .............................................................................................................................. 11

Step-By-Step ..................................................................................................................................................... 14

Skill Sharpener ................................................................................................................................................. 17

Lesson 1.2: Table Relationships .......................................................................................................... 18

About Join Lines............................................................................................................................................... 18

Normalizing Tables .......................................................................................................................................... 18

Using Cascade Delete and Cascade Update ...................................................................................................... 28

Setting Fields for Indexing ............................................................................................................................... 31

Using the Index ................................................................................................................................................ 32

Step-By-Step ..................................................................................................................................................... 33

Skill Sharpener ................................................................................................................................................. 36

Lesson 1.3: Switchboards ..................................................................................................................... 37

Using a Switchboard vs. Using the Navigation Pane and Tab .......................................................................... 38

Using the Switchboard Manager........................................................................................................................ 39

Creating a Switchboard ................................................................................................................................... 40

Editing a Switchboard ...................................................................................................................................... 41

Deleting a Switchboard .................................................................................................................................... 43

Step-By-Step ..................................................................................................................................................... 44

Skill Sharpener ................................................................................................................................................. 49

Lesson 1.4: Modal Dialog Boxes .......................................................................................................... 50

Creating a Modal Dialog Box ............................................................................................................................ 50

Adding Controls ............................................................................................................................................... 52

Setting Properties ............................................................................................................................................. 56

Formatting your Dialog Box .............................................................................................................................. 58

Step-By-Step ..................................................................................................................................................... 60

Skill Sharpener ................................................................................................................................................. 63

Section 1: Case Study ........................................................................................................................... 64

Section 1: Review Questions ................................................................................................................ 65

Section 2: Advanced Form Tasks ................................................................................................ 68

Lesson 2.1: Using Subforms ................................................................................................................. 69

Creating a Subform .......................................................................................................................................... 69

Modifying a Subform ........................................................................................................................................ 73

Working with a Subform................................................................................................................................... 74

Synchronizing Subform Data with a Main Form ............................................................................................... 76

Displaying a Subform within a Main Form........................................................................................................ 77

Step-By-Step ..................................................................................................................................................... 78

Skill Sharpener ................................................................................................................................................. 85

Lesson 2.2: Advanced Form Tasks ..................................................................................................... 86

Limiting User Access to a Form ......................................................................................................................... 86

Creating Check Boxes and Command Buttons ................................................................................................... 88

Creating Event Procedures ............................................................................................................................... 90

Customizing Error Messages ............................................................................................................................. 92

Step-By-Step ..................................................................................................................................................... 95

Skill Sharpener ............................................................................................................................................... 101

Lesson 2.3: Exporting Your Form .................................................................................................... 102

Sending a Form via E-Mail .............................................................................................................................. 102

Managing Replies .......................................................................................................................................... 111

Exporting your Form to XML .......................................................................................................................... 113

Step-By-Step ................................................................................................................................................... 120

Skill Sharpener ............................................................................................................................................... 126

Lesson 2.4: Using Outlook and SharePoint with Access ................................................................. 127

Creating an RSS Feed for Outlook ................................................................................................................... 127

Importing Contacts from Outlook .................................................................................................................... 128

Importing Contacts from a SharePoint Server ................................................................................................. 135

Moving your Database to a SharePoint Server ................................................................................................ 138

Publishing to a Web Server .............................................................................................................................. 142

Step-By-Step ................................................................................................................................................... 144

Skill Sharpener ............................................................................................................................................... 149

Section 2: Case Study ......................................................................................................................... 150

Section 2: Review Questions .............................................................................................................. 151

Section 3: Pivoting Data ............................................................................................................ 154

Lesson 3.1: Creating a PivotTable .................................................................................................... 155

About PivotTables .......................................................................................................................................... 155

Creating a PivotTable .................................................................................................................................... 156

More about PivotTable Fields ......................................................................................................................... 160

Completing your PivotTable ............................................................................................................................ 163

Step-By-Step ................................................................................................................................................... 165

Skill Sharpener ............................................................................................................................................... 171

Lesson 3.2: Creating a PivotChart .................................................................................................... 172

About PivotCharts .......................................................................................................................................... 172

Creating a PivotChart .................................................................................................................................... 173

More about PivotChart Fields ......................................................................................................................... 176

Completing Your PivotChart ............................................................................................................................ 177

Step-By-Step ................................................................................................................................................... 179

Skill Sharpener ............................................................................................................................................... 184

Lesson 3.3: Using PivotTables and PivotCharts .............................................................................. 185

Using a PivotTable ......................................................................................................................................... 185

Using a PivotChart ........................................................................................................................................ 189

Editing a PivotTable or a PivotChart .............................................................................................................. 189

Common PivotTable and PivotChart Editing Commands ................................................................................ 192

Creating a PivotTable and PivotChart from the Same Object ......................................................................... 196

Step-By-Step ................................................................................................................................................... 199

Skill Sharpener ............................................................................................................................................... 206

Section 3: Case Study ......................................................................................................................... 207

Section 3: Review Questions .............................................................................................................. 208

Section 4: Access and Windows................................................................................................. 211

Lesson 4.1: Access and Windows ...................................................................................................... 212

Recovering Access .......................................................................................................................................... 212

Starting Access on Windows Boot .................................................................................................................... 213

Using Office Diagnostics ............................................................................................................................... 215

Checking for Updates ..................................................................................................................................... 219

Step-By-Step ................................................................................................................................................... 220

Skill Sharpener ............................................................................................................................................... 226

Lesson 4.2: Using the Access Viewer................................................................................................. 227

What is the Access Viewer? .............................................................................................................................. 227

Downloading the Viewer ................................................................................................................................ 227

Using the Viewer ............................................................................................................................................ 228

Step-By-Step ................................................................................................................................................... 232

Skill Sharpener ............................................................................................................................................... 237

Lesson 4.3: An Introduction to SQL ................................................................................................. 238

What is SQL? ................................................................................................................................................. 238

Parts of an SQL Statement ............................................................................................................................... 238

SQL Keywords................................................................................................................................................ 239

Adding Where Clauses ................................................................................................................................... 242

Step-By-Step ................................................................................................................................................... 243

Skill Sharpener ............................................................................................................................................... 247

Section 4: Case Study ......................................................................................................................... 248

Section 4: Review Questions .............................................................................................................. 249

Index ......................................................................................................................................... 252