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

Section 1: Getting Started .............................................................................................................. 1

Lesson 1.1: Starting Out ........................................................................................................................ 2

What is Microsoft Access? ................................................................................................................................. 2

What’s New in Access 2007? ............................................................................................................................... 3

Basic Terminology ............................................................................................................................................. 7

Opening Microsoft Access.................................................................................................................................. 9

Interface Overview ........................................................................................................................................... 10

Closing Microsoft Access ................................................................................................................................. 18

Step-By-Step ..................................................................................................................................................... 19

Skill Sharpener ................................................................................................................................................. 27

Lesson 1.2: Using the Getting Started Window ................................................................................. 28

Overview of the Window .................................................................................................................................. 28

Navigating Through the Window ....................................................................................................................... 29

Creating a Database from a Template ............................................................................................................... 31

Creating a Blank Database ............................................................................................................................... 33

Step-By-Step ..................................................................................................................................................... 35

Skill Sharpener ................................................................................................................................................. 42

Lesson 1.3: The Trust Center .............................................................................................................. 43

Warnings You May See when Opening a Database ........................................................................................... 43

Enabling Content ............................................................................................................................................. 44

About Digital Signatures .................................................................................................................................. 45

About Trusted Locations .................................................................................................................................. 45

Opening the Trust Center ................................................................................................................................. 45

Assigning a Password to your Database ............................................................................................................ 48

Step-By-Step ..................................................................................................................................................... 51

Skill Sharpener ................................................................................................................................................. 55

Lesson 1.4: Getting Help ...................................................................................................................... 56

Opening the Help Screen ................................................................................................................................. 56

Overview of the Help Screen .............................................................................................................................. 57

Online Help vs. Offline Help .............................................................................................................................. 59

Searching for Help ........................................................................................................................................... 61

Step-By-Step ..................................................................................................................................................... 65

Skill Sharpener ................................................................................................................................................. 69

Section 1: Case Study ........................................................................................................................... 70

Section 1: Review Questions ................................................................................................................ 71

Section 2: The New Interface ...................................................................................................... 73

Lesson 2.1: Using the Quick Access Toolbar ...................................................................................... 74

About the Default Buttons ................................................................................................................................ 74

Adding Buttons ................................................................................................................................................. 75

Removing Buttons ............................................................................................................................................ 75

Customizing the Toolbar .................................................................................................................................. 76

Step-By-Step ..................................................................................................................................................... 81

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

Lesson 2.2: Basics of Tabs .................................................................................................................... 86

About Tabs ....................................................................................................................................................... 86

Opening Dialog Boxes from the Tab .................................................................................................................. 87

About the Office Menu ..................................................................................................................................... 89

Step-By-Step ..................................................................................................................................................... 93

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

Lesson 2.3: The Home Tab .................................................................................................................. 98

Views ................................................................................................................................................................ 98

Clipboard ......................................................................................................................................................... 98

Font ................................................................................................................................................................ 100

Rich Text ........................................................................................................................................................ 100

Records .......................................................................................................................................................... 101

Sort and Filter ................................................................................................................................................ 102

Find ................................................................................................................................................................ 102

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

Skill Sharpener ............................................................................................................................................... 108

Lesson 2.4: Create Tab ....................................................................................................................... 109

Tables ............................................................................................................................................................. 109

Forms ............................................................................................................................................................. 111

Reports ........................................................................................................................................................... 113

Other .............................................................................................................................................................. 114

Step-By-Step ................................................................................................................................................... 115

Skill Sharpener ............................................................................................................................................... 119

Lesson 2.5: External Data Tab .......................................................................................................... 120

Import ............................................................................................................................................................. 120

Export ............................................................................................................................................................. 121

Collect Data ................................................................................................................................................... 123

SharePoint Lists ............................................................................................................................................. 123

Step-By-Step ................................................................................................................................................... 125

Skill Sharpener ............................................................................................................................................... 130

Lesson 2.6: Database Tools Tab ........................................................................................................ 131

Macro ............................................................................................................................................................. 131

Show/Hide ...................................................................................................................................................... 132

Analyze ........................................................................................................................................................... 132

Move Data ...................................................................................................................................................... 133

Database Tools .............................................................................................................................................. 134

Step-By-Step ................................................................................................................................................... 135

Skill Sharpener ............................................................................................................................................... 140

Section 2: Case Study ......................................................................................................................... 141

Section 2: Review Questions .............................................................................................................. 142

Section 3: Creating a Database ................................................................................................. 144

Lesson 3.1: First Steps ........................................................................................................................ 145

Planning a Database ...................................................................................................................................... 146

Creating a Database from a Template ............................................................................................................. 147

Creating a Blank Database .............................................................................................................................. 148

Using Database Objects ................................................................................................................................. 149

Setting Navigation Options .............................................................................................................................. 153

Step-By-Step ................................................................................................................................................... 158

Skill Sharpener ............................................................................................................................................... 163

Lesson 3.2: About Records ................................................................................................................ 164

What is a Record? .......................................................................................................................................... 164

Navigation Tips .............................................................................................................................................. 164

Adding Records .............................................................................................................................................. 165

Editing Records .............................................................................................................................................. 166

Deleting Records ............................................................................................................................................ 167

E-Mailing Records ......................................................................................................................................... 169

Printing Records ............................................................................................................................................ 172

Step-By-Step ................................................................................................................................................... 174

Skill Sharpener ............................................................................................................................................... 177

Lesson 3.3: Creating a Table ............................................................................................................. 178

About Tables .................................................................................................................................................. 178

Creating a Table ............................................................................................................................................ 178

Entering Data into a Table .............................................................................................................................. 181

Formatting a Table ........................................................................................................................................ 184

Step-By-Step ................................................................................................................................................... 187

Skill Sharpener ............................................................................................................................................... 192

Lesson 3.4: Formatting Text .............................................................................................................. 193

Using the Zoom Box ....................................................................................................................................... 193

Selecting Data ................................................................................................................................................ 194

Cutting, Copying, and Pasting ......................................................................................................................... 197

Using the Format Painter ............................................................................................................................... 198

Using Undo and Redo .................................................................................................................................... 200

Checking your Spelling .................................................................................................................................. 201

Step-By-Step ................................................................................................................................................... 204

Skill Sharpener ............................................................................................................................................... 208

Section 3: Case Study ......................................................................................................................... 209

Section 3: Review Questions .............................................................................................................. 210

Section 4: Doing More with your Database .............................................................................. 212

Lesson 4.1: Creating Forms ............................................................................................................... 213

What is a Form? ............................................................................................................................................. 213

Bound vs. Unbound Controls ........................................................................................................................... 214

Creating a Form with the Wizard .................................................................................................................... 216

Using Design View to Modify Your Form ........................................................................................................ 220

Using Forms ................................................................................................................................................... 225

Step-By-Step ................................................................................................................................................... 226

Skill Sharpener ............................................................................................................................................... 230

Lesson 4.2: Creating Queries ............................................................................................................. 231

What is a Query?............................................................................................................................................ 231

Creating a Query with the Wizard ................................................................................................................... 233

Using Design View to Modify a Query ............................................................................................................. 236

Using Queries ................................................................................................................................................ 239

Step-By-Step ................................................................................................................................................... 240

Skill Sharpener ............................................................................................................................................... 243

Lesson 4.3: Reports........................................................................................................................... 244

What is a Report? ........................................................................................................................................... 244

Creating a Report with the Wizard .................................................................................................................. 244

Using Design View to Modify a Report ............................................................................................................ 249

Using Reports ................................................................................................................................................. 251

Step-By-Step ................................................................................................................................................... 252

Skill Sharpener ............................................................................................................................................... 258

Lesson 4.4: Sorting and Filtering Data ............................................................................................. 259

Using Find and Replace ................................................................................................................................. 259

Sort Ascending or Descending ......................................................................................................................... 262

Toggling Filter ............................................................................................................................................... 263

Using Selection Sort ....................................................................................................................................... 264

Using Advanced Sort ...................................................................................................................................... 266

Step-By-Step ................................................................................................................................................... 270

Skill Sharpener ............................................................................................................................................... 275

Lesson 4.5: Viewing Data ................................................................................................................... 276

Using the View Menu ..................................................................................................................................... 276

Using the View Icons ...................................................................................................................................... 278

Using the Tabs ............................................................................................................................................... 278

Closing Individual Tabs ................................................................................................................................. 279

Step-By-Step ................................................................................................................................................... 280

Skill Sharpener ............................................................................................................................................... 284

Lesson 4.6: Printing a Database Object ............................................................................................ 285

Using the Print Menu ..................................................................................................................................... 285

Using Print Preview ....................................................................................................................................... 287

Using the Print Preview Tab ............................................................................................................................ 288

Printing vs. Exporting .................................................................................................................................... 290

Step-By-Step ................................................................................................................................................... 291

Skill Sharpener ............................................................................................................................................... 294

Section 4: Case Study ......................................................................................................................... 295

Section 4: Review Questions .............................................................................................................. 296

Index ......................................................................................................................................... 298