30.00$
Table of Contents
Microsoft Office 2013
Chapter One Office Fundamentals and File Management: Taking the First Step 1Objectives 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
***THIS IS NOT THE ACTUAL BOOK. YOU ARE BUYING the Test Bank in e-version of the following book***
Exploring: Microsoft Access 2013, Introductory PDF Manual Solutions , PDF Exploring: Microsoft Access 2013, Introductory , Fast Download Exploring: Microsoft Access 2013, Introductory , Mary Anne Poatsy, Montgomery County Community College Cynthia Krebs, Utah Valley University Eric Cameron, Passaic County Community College Robert T. Grauer, University of Miami,Category : Higher Education
0 commentaires:
Enregistrer un commentaire