Microsoft Office 2013 Chapter One Office Fundamentals and File Management: Taking the First Step 1 Objectives¿¿¿¿¿¿¿¿ 1
Case Study: Spotted Begonia Art Gallery 1
Windows 8 Startup 2
Logging In with Your Microsoft Account 2
Identifying the Start Screen Components 3
Interacting with the Start Screen 4
Accessing the Desktop 4
Hands-On Exercise 1:
Windows 8 Startup 6
Files and Folders¿¿¿¿¿¿¿¿ 10
Using File Explorer 10
Working with Folders and Files 13
Selecting, Copying, and Moving Multiple Files and Folders 15
Hands-On Exercise 2:
Files and Folders 17
Microsoft Office Software 22
Identifying Common Interface Components 22
Getting Office Help 28
Hands-On Exercise 3:
Microsoft Office Software 31
The Backstage View Tasks¿¿¿¿¿¿¿¿ 36
Opening a File 36
Printing a File 38
Closing a File and Application 39
Hands-On Exercise 4:
The Backstage View Tasks 41
Home Tab Tasks¿¿¿¿¿¿¿¿ 45
Selecting and Editing Text 45
Using the Clipboard Group Commands 49
Using the Editing Group Commands 52
Hands-On Exercise 5:
Home Tab Tasks 55
Insert Tab Tasks¿¿¿¿¿¿¿¿ 60
Inserting Objects 60
Review Tab Tasks¿¿¿¿¿¿¿¿ 62
Reviewing a File 62
Page Layout Tab Tasks¿¿¿¿¿¿¿¿ 65
Using the Page Setup Dialog Box 66
Hands-On Exercise 6:
Insert Tab Tasks, Page Layout Tab Tasks, and
Review Tab Tasks 68
Chapter Objectives Review¿¿¿¿¿¿¿¿ 72
Key Terms Matching¿¿¿¿¿¿¿¿ 73
Multiple Choice 74
Practice Exercises¿¿¿¿¿¿¿¿ 75
Mid-Level Exercises¿¿¿¿¿¿¿¿ 79
Beyond the Classroom¿¿¿¿¿¿¿¿ 81
Capstone Exercise 82
¿
Microsoft Office Access 2013
Chapter One Introduction to Access: Finding Your Way Through an Access Database 83
Objectives¿¿¿¿¿¿¿¿ 83
Case Study: Managing a Business in the Global
Economy 83
Databases Are Everywhere! 84
Understanding Database Fundamentals 84
Using an Existing Database 91
Hands-On Exercise 1:
Databases Are Everywhere! 95
Sorts and Filters¿¿¿¿¿¿¿¿ 102
Sorting Table Data on One or Multiple Fields 102
Creating, Modifying, and Removing Filters 103
Hands-On Exercise 2:
Sorts and Filters 106
Access Versus Excel, and Relational Databases¿¿¿¿¿¿¿¿ 111
Knowing When to Use Access or Excel to Manage Data 111
Understanding Relational Power 112
Hands-On Exercise 3:
Access Versus Excel, and Relational Databases 115
Access Database Creation¿¿¿¿¿¿¿¿ 119
Creating a Database 119
Hands-On Exercise 4:
Access Database Creation 123
Chapter Objectives Review¿¿¿¿¿¿¿¿ 127
Key Terms Matching¿¿¿¿¿¿¿¿ 128
Multiple Choice 129
Practice Exercises¿¿¿¿¿¿¿¿ 130
Mid-Level Exercises¿¿¿¿¿¿¿¿ 135
Beyond the Classroom¿¿¿¿¿¿¿¿ 139
Capstone Exercise 140
¿
Chapter Two Tables and Queries in Relational Databases: Designing
Databases and Extracting Data 141
Objectives¿¿¿¿¿¿¿¿ 141
Case Study: Bank Audit 141
Table Design, Creation, and Modification¿¿¿¿¿¿¿¿ 142
Designing a Table 142
Creating and Modifying Tables 146
Hands-On Exercise 1:
Table Design, Creation, and Modification 152
Multiple-Table Databases¿¿¿¿¿¿¿¿ 157
Sharing Data 157
Establishing Table Relationships 160
Hands-On Exercise 2:
Multiple-Table Databases 165
Single-Table Queries¿¿¿¿¿¿¿¿ 171
Creating a Single-Table Query 171
Specifying Query Criteria for Different Data Types 173
Understanding Query Sort Order 177
Running, Copying, and Modifying a Query 177
Using the Query Wizard 178
Hands-On Exercise 3:
Single-Table Queries 181
Multitable Queries¿¿¿¿¿¿¿¿ 184
Creating a Multitable Query 184
Modifying a Multitable Query 185
Hands-On Exercise 4:
Multitable Queries 189
Chapter Objectives Review¿¿¿¿¿¿¿¿ 193
Key Terms Matching¿¿¿¿¿¿¿¿ 195
Multiple Choice 196
Practice Exercises¿¿¿¿¿¿¿¿ 197
Mid-Level Exercises¿¿¿¿¿¿¿¿ 202
Beyond the Classroom¿¿¿¿¿¿¿¿ 206
Capstone Exercise 208
¿
Chapter Three Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions 211
Objectives¿¿¿¿¿¿¿¿ 211
Case Study: Housing Slump Means Opportunity
For College Students¿¿¿¿¿¿¿¿ 211
Calculations and Expressions¿¿¿¿¿¿¿¿ 212
Creating a Calculated Field in a Query 212
Formatting and Saving Calculated Results 215
Hands-On Exercise 1:
Calculations and Expressions 218
The Expression Builder and Functions¿¿¿¿¿¿¿¿ 223
Creating Expressions with the Expression Builder 223
Using Built-In Functions in Access 225
Hands-On Exercise 2:
The Expression Builder and Functions 228
Aggregate Functions¿¿¿¿¿¿¿¿ 233
Adding Aggregate Functions to Datasheets 233
Creating Queries with Aggregate Functions 234
Hands-On Exercise 3:
Aggregate Functions 240
Chapter Objectives Review¿¿¿¿¿¿¿¿ 243
Key Terms Matching¿¿¿¿¿¿¿¿ 244
Multiple Choice 245
Practice Exercises¿¿¿¿¿¿¿¿ 246
Mid-Level Exercises¿¿¿¿¿¿¿¿ 249
Beyond the Classroom¿¿¿¿¿¿¿¿ 253
Capstone Exercise 255
¿
Chapter Four Creating and Using Professional Forms and Reports:
Moving Beyond Tables and Queries 257
Objectives¿¿¿¿¿¿¿¿ 257
Case Study: Coffee Shop Starts New Business¿¿¿¿¿¿¿¿ 257
Form Basics¿¿¿¿¿¿¿¿ 258
Creating Forms Using Form Tools 258
Using Form Views 265
Working with a Form Layout Control 268
Sorting Records in a Form 270
Hands-On Exercise 1:
Form Basics 272
Report Basics¿¿¿¿¿¿¿¿ 278
Creating Reports Using Report Tools 278
Using Report Views 285
Modifying a Report 287
Sorting Records in a Report 290
Hands-On Exercise 2:
Report Basics 292
Chapter Objectives Review¿¿¿¿¿¿¿¿ 296
Key Terms Matching¿¿¿¿¿¿¿¿ 298
Multiple Choice 299
Practice Exercises¿¿¿¿¿¿¿¿ 300
Mid-Level Exercises¿¿¿¿¿¿¿¿ 303
Beyond the Classroom¿¿¿¿¿¿¿¿ 306
Capstone Exercise 307
Application Capstone Exercise
Access 309
Glossary 313
Index