accicontents

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

Microsoft Access Intermediate

Table of Contents of The Instructor's Guide Section 1: Advanced File Tasks..................................................................................................... 1

Lesson 1.1: Using My Computer within Access ................................................................................... 2

Navigating with My Computer ............................................................................................................................. 2

Performing Basic Tasks with My Computer......................................................................................................... 5

Changing Views with my Computer ..................................................................................................................... 7

Using the My Places Toolbar ............................................................................................................................... 7

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

Skill Sharpener ................................................................................................................................................. 12

Lesson 1.2: Database Management ..................................................................................................... 13

Compact and Repair a Database ....................................................................................................................... 13

Backing up Your Database ............................................................................................................................... 14

Editing Database Properties .............................................................................................................................. 16

Step-By-Step ..................................................................................................................................................... 18

Skill Sharpener ................................................................................................................................................. 23

Lesson 1.3: Saving Your Files .............................................................................................................. 24

Using the Save As Dialog ................................................................................................................................. 24

Using the Save As Menu ................................................................................................................................... 26

Using File Properties ....................................................................................................................................... 28

Using AutoRecover .......................................................................................................................................... 29

Step-By-Step ..................................................................................................................................................... 30

Skill Sharpener ................................................................................................................................................. 34

Lesson 1.4: Exporting Files .................................................................................................................. 35

Exporting to PDF or XPS ................................................................................................................................ 35

Exporting to Word or Excel ............................................................................................................................... 40

Exporting to Other Destinations ........................................................................................................................ 45

Using Saved Exports ........................................................................................................................................ 46

Exporting to a CAB File ................................................................................................................................... 48

Exporting to Older Versions of Access .............................................................................................................. 51

Step-By-Step ..................................................................................................................................................... 54

Skill Sharpener ................................................................................................................................................. 59

Lesson 1.5: Linking Files ...................................................................................................................... 60

Linking to an Excel Spreadsheet ........................................................................................................................ 60

Linking to Another Database ............................................................................................................................. 65

Linking to a SharePoint Site .............................................................................................................................. 68

Other Types of Linked Documents ..................................................................................................................... 70

Creating a Hyperlink ....................................................................................................................................... 72

Step-By-Step ..................................................................................................................................................... 74

Skill Sharpener ................................................................................................................................................. 79

Section 1: Case Study ........................................................................................................................... 80

Section 1: Review Questions ................................................................................................................ 81

Section 2: Working with Tables................................................................................................... 84

Lesson 2.1: Customizing Tables .......................................................................................................... 85

Understanding Field Properties....................................................................................................................... 85

Adding a Primary Key to a Table....................................................................................................................... 86

Indexing a Field ............................................................................................................................................... 87

Inserting, Deleting, and Moving Fields.............................................................................................................. 89

Importing a Table from another Source ............................................................................................................. 91

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

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

Lesson 2.2: Formatting Tables ............................................................................................................ 98

Formatting Number Fields ............................................................................................................................... 98

Formatting Text Fields ................................................................................................................................... 100

Adding Field Descriptions ............................................................................................................................... 101

Changing Field Data Types ............................................................................................................................. 102

Adding Captions ............................................................................................................................................. 103

Step-By-Step ................................................................................................................................................... 104

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

Lesson 2.3: Controlling Table Data Entry ....................................................................................... 107

Setting a Default Value .................................................................................................................................. 107

Setting a Required Value ................................................................................................................................ 108

Creating and Using Input Masks ..................................................................................................................... 109

Creating and Removing Table Relationships ................................................................................................... 112

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

Skill Sharpener ............................................................................................................................................... 123

Lesson 2.4: Managing Table Data Entry .......................................................................................... 124

Using the Table Design Tab ............................................................................................................................. 124

How to Validate Data .................................................................................................................................... 125

Creating a Lookup Field ................................................................................................................................ 127

Modifying a Lookup Field ............................................................................................................................... 133

Creating a Value List ..................................................................................................................................... 134

Modifying a Value List ................................................................................................................................... 137

Step-By-Step ................................................................................................................................................... 138

Skill Sharpener ............................................................................................................................................... 144

Section 2: Case Study ......................................................................................................................... 145

Section 2: Review Questions .............................................................................................................. 146

Section 3: Working with Forms................................................................................................. 149

Lesson 3.1: Basic Form Controls ....................................................................................................... 150

Adding a Control ............................................................................................................................................ 150

Using the Control Wizard ............................................................................................................................... 156

Cutting, Copying, Pasting, and Moving a Control ........................................................................................... 157

Formatting a Control ..................................................................................................................................... 161

Step-By-Step ................................................................................................................................................... 162

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

Lesson 3.2: Advanced Form Controls ............................................................................................... 167

Modifying a Control’s Properties .................................................................................................................... 167

Changing a Control’s Data Source .................................................................................................................. 170

Changing a Control’s Default Value ............................................................................................................... 172

Creating a Calculated Control ......................................................................................................................... 173

Using Form Properties .................................................................................................................................. 176

Step-By-Step ................................................................................................................................................... 177

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

Lesson 3.3: Formatting Your Form .................................................................................................. 184

Formatting Gridlines ..................................................................................................................................... 184

Modifying the Font ......................................................................................................................................... 185

Adding Logos ................................................................................................................................................. 187

Changing the Layout ...................................................................................................................................... 188

Step-By-Step ................................................................................................................................................... 190

Skill Sharpener ............................................................................................................................................... 197

Lesson 3.4: Formatting Controls ....................................................................................................... 198

Changing the Color of a Control ..................................................................................................................... 198

Using Control Properties ............................................................................................................................... 199

Aligning Controls ........................................................................................................................................... 200

Applying Special Effects ................................................................................................................................. 201

Step-By-Step ................................................................................................................................................... 203

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

Lesson 3.5: Formatting Records ........................................................................................................ 209

Modifying Fonts ............................................................................................................................................. 209

Using AutoFormat .......................................................................................................................................... 210

Using the Format Tab .................................................................................................................................... 212

Using the Arrange Tab ................................................................................................................................... 214

Step-By-Step ................................................................................................................................................... 216

Skill Sharpener ............................................................................................................................................... 222

Section 3: Case Study ......................................................................................................................... 223

Section 3: Review Questions .............................................................................................................. 224

Section 4: Working with Reports ............................................................................................... 227

Lesson 4.1: Organizing Report Data ................................................................................................. 228

Adding and Removing Fields ........................................................................................................................... 228

Using Report Sections .................................................................................................................................... 231

Changing Section Properties ........................................................................................................................... 233

Grouping and Sorting in a Report.................................................................................................................... 233

Changing Group Properties ............................................................................................................................. 237

Using Calculated Controls in a Report ............................................................................................................ 239

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

Skill Sharpener ............................................................................................................................................... 244

Lesson 4.2: Formatting Reports ........................................................................................................ 245

Formatting Gridlines ..................................................................................................................................... 245

Modifying the Font ......................................................................................................................................... 246

Adding Logos ................................................................................................................................................. 246

Changing the Layout ...................................................................................................................................... 247

Using AutoFormat .......................................................................................................................................... 248

Step-By-Step ................................................................................................................................................... 251

Skill Sharpener ............................................................................................................................................... 255

Lesson 4.3: Common Report Tasks .................................................................................................. 256

Adding a Photo............................................................................................................................................... 256

Adjusting Page Properties ............................................................................................................................... 257

Adding Headers and Footers ........................................................................................................................... 259

Adding Page Numbers ................................................................................................................................... 260

Using the Label Wizard .................................................................................................................................. 260

Step-By-Step ................................................................................................................................................... 264

Skill Sharpener ............................................................................................................................................... 268

Section 4: Case Study ......................................................................................................................... 269

Section 4: Review Questions .............................................................................................................. 270

Section 5: Working with Queries............................................................................................... 273

Lesson 5.1: Basic Queries ................................................................................................................... 274

Review of Queries .......................................................................................................................................... 274

Creating a Query ........................................................................................................................................... 274

Sorting a Query .............................................................................................................................................. 281

Filtering a Query ........................................................................................................................................... 283

Hiding Fields ................................................................................................................................................. 288

Using AND OR Operators ............................................................................................................................... 289

Use of IIF Functions ...................................................................................................................................... 291

Step-By-Step ................................................................................................................................................... 292

Skill Sharpener ............................................................................................................................................... 295

Lesson 5.2: Multiple Table Queries .................................................................................................. 296

Creating a Multiple Table Query ..................................................................................................................... 296

Creating a Calculated Field ............................................................................................................................. 297

Using the Expression Builder ........................................................................................................................... 299

Using Queries to Summarize ............................................................................................................................ 300

Step-By-Step ................................................................................................................................................... 303

Skill Sharpener ............................................................................................................................................... 306

Lesson 5.3: Advanced Queries ........................................................................................................... 307

Creating a Parameter Query ........................................................................................................................... 307

Using Parameter Queries ............................................................................................................................... 308

Creating Crosstab Queries .............................................................................................................................. 309

Using Crosstab Queries ................................................................................................................................. 314

Using Make-Table Queries .............................................................................................................................. 315

Step-By-Step ................................................................................................................................................... 318

Skill Sharpener ............................................................................................................................................... 322

Lesson 5.4: Management (Action) Queries ...................................................................................... 323

Append Queries .............................................................................................................................................. 323

Delete Queries................................................................................................................................................ 325

Update Queries .............................................................................................................................................. 327

Exporting Queries .......................................................................................................................................... 329

Step-By-Step ................................................................................................................................................... 331

Skill Sharpener ............................................................................................................................................... 334

Section 5: Case Study ......................................................................................................................... 335

Section 5: Review Questions .............................................................................................................. 336

Index ......................................................................................................................................... 338