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 Expert
                                                                                                Table of Contents of The Instructor's Guide

Section 1: Add-ons to Access ......................................................................................................... 1

Lesson 1.1: COM Add-Ins ..................................................................................................................... 2

What is a COM Add-In? ...................................................................................................................................... 2

Using the Add-Ins Tab ........................................................................................................................................ 3

Opening the Add-In Manager .............................................................................................................................. 4

Loading Add-Ins .................................................................................................................................................. 6

Using the Trust Center ........................................................................................................................................ 6

Step-By-Step ...................................................................................................................................................... 10

Skill Sharpener .................................................................................................................................................. 14

Lesson 1.2: Digital Signatures ............................................................................................................. 15

What is a Digital Signature? .............................................................................................................................. 15

Obtaining a Digital Signature ............................................................................................................................ 15

Attaching Your Signature to a Database ............................................................................................................ 16

Skill Sharpener .................................................................................................................................................. 19

Lesson 1.3: Smart Tags ........................................................................................................................ 20

What is a Smart Tag? ........................................................................................................................................ 20

Inserting Smart Tags into a Database ................................................................................................................ 20

Customizing Smart Tags ................................................................................................................................... 23

Setting Smart Tag Options ................................................................................................................................ 24

Step-By-Step ...................................................................................................................................................... 25

Skill Sharpener .................................................................................................................................................. 28

Lesson 1.4: Managing Your Database ................................................................................................ 29

Analyzing Performance ..................................................................................................................................... 29

Analyzing Tables ............................................................................................................................................... 31

Viewing Object Dependencies ............................................................................................................................ 38

Splitting a Database .......................................................................................................................................... 39

Database Replication ........................................................................................................................................ 42

Step-By-Step ...................................................................................................................................................... 43

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

Lesson 1.5: Customizing Access .......................................................................................................... 50

Opening the Options Dialog .............................................................................................................................. 50

Overview of the Options Dialog ......................................................................................................................... 51

Changing User Information ............................................................................................................................... 55

Setting Security Options .................................................................................................................................... 56

Making Access Work Backwards ....................................................................................................................... 57

Step-By-Step ...................................................................................................................................................... 59

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

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

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

Section 2: Using Scripts in Access .............................................................................................. 67

Lesson 2.1: Macro Basics ..................................................................................................................... 68

Creating Macros ............................................................................................................................................... 69

Playing Macros ................................................................................................................................................. 70

Macro Security .................................................................................................................................................. 71

Deleting Macros ................................................................................................................................................ 72

Step-By-Step ...................................................................................................................................................... 73

Skill Sharpener .................................................................................................................................................. 77

Lesson 2.2: Other Macro Tasks ........................................................................................................... 78

Embedding a Macro .......................................................................................................................................... 78

Assigning a Macro to a Keystroke ..................................................................................................................... 80

Assigning a Macro to an Event .......................................................................................................................... 81

Assigning a Macro to a Control ......................................................................................................................... 83

Step-By-Step ...................................................................................................................................................... 84

Skill Sharpener .................................................................................................................................................. 87

Lesson 2.3: Visual Basic and Macros .................................................................................................. 88

Opening the Visual Basic Editor ........................................................................................................................ 88

Adding Code to your Macro ............................................................................................................................... 89

Adding Comments to VBA Code ........................................................................................................................ 91

Declaring Variables .......................................................................................................................................... 92

Prompting for User Input .................................................................................................................................. 92

Using If-Then-Else Statements ........................................................................................................................... 93

Step-By-Step ...................................................................................................................................................... 94

Skill Sharpener .................................................................................................................................................. 97

Lesson 2.4: Macro Groups ................................................................................................................... 98

Creating a Macro Group .................................................................................................................................. 98

Running a Macro Group ................................................................................................................................. 100

Editing a Macro Group ................................................................................................................................... 101

Step-By-Step .................................................................................................................................................... 103

Skill Sharpener ................................................................................................................................................ 106

Section 2: Case Study ......................................................................................................................... 107

Section 2: Review Questions .............................................................................................................. 108

Section 3: Using Access to Collaborate ..................................................................................... 110

Lesson 3.1: SharePoint Basics ........................................................................................................... 111

What is SharePoint? ........................................................................................................................................ 111

System Requirements ....................................................................................................................................... 112

Creating a Workspace ..................................................................................................................................... 112

Accessing a Workspace ................................................................................................................................... 116

Publishing to a Workspace ............................................................................................................................... 116

Step-By-Step .................................................................................................................................................... 119

Skill Sharpener ................................................................................................................................................ 124

Lesson 3.2: SharePoint Data .............................................................................................................. 125

Using Offline Lists .......................................................................................................................................... 125

Exporting a List ............................................................................................................................................... 127

Restricting Permission for Data Objects.......................................................................................................... 129

Skill Sharpener ................................................................................................................................................ 133

Lesson 3.3: Your Personal SharePoint Space .................................................................................. 134

Public and Private Views ................................................................................................................................ 134

Shared and Private Documents ........................................................................................................................ 136

Creating a List ................................................................................................................................................ 138

Creating a Page .............................................................................................................................................. 139

Personalizing your Space ................................................................................................................................ 140

Step-By-Step .................................................................................................................................................... 141

Skill Sharpener ................................................................................................................................................ 146

Section 3: Case Study ......................................................................................................................... 147

Section 3: Review Questions .............................................................................................................. 148

Section 4: SQL and Microsoft Access ....................................................................................... 150

Lesson 4.1: Understanding SQL ........................................................................................................ 151

What is an SQL Database? .............................................................................................................................. 151

What is an SQL Statement? .............................................................................................................................. 151

What is an SQL Convention? ........................................................................................................................... 152

What is SQL Syntax? ....................................................................................................................................... 153

Linking a Database to an SQL Server .............................................................................................................. 153

Step-By-Step .................................................................................................................................................... 156

Skill Sharpener ................................................................................................................................................ 160

Lesson 4.2: Using the SELECT Statement ....................................................................................... 161

Selecting All Data ........................................................................................................................................... 161

Selecting Specific Data ................................................................................................................................... 161

Selecting Conditional Data .............................................................................................................................. 162

Using the ORDER BY Statement ...................................................................................................................... 162

Step-By-Step .................................................................................................................................................... 163

Skill Sharpener ................................................................................................................................................ 166

Lesson 4.3: Using Subqueries ............................................................................................................ 167

What is a Subquery? ....................................................................................................................................... 167

Creating a Subquery ....................................................................................................................................... 168

Subqueries with Equality................................................................................................................................. 168

Subqueries with Aggregate Functions .............................................................................................................. 168

Nested Subqueries and Uses of the IN Keyword .............................................................................................. 170

Step-By-Step .................................................................................................................................................... 172

Skill Sharpener ................................................................................................................................................ 175

Lesson 4.4: Using SQL Joins ............................................................................................................. 176

Creating Simple Joins ..................................................................................................................................... 176

Using an Alias ................................................................................................................................................. 177

Sorting Joins ................................................................................................................................................... 177

Creating Outer Joins ....................................................................................................................................... 178

Step-By-Step .................................................................................................................................................... 181

Skill Sharpener ................................................................................................................................................ 183

Section 4: Case Study ......................................................................................................................... 184

Section 4: Review Questions .............................................................................................................. 185

Index ......................................................................................................................................... 188