30.00$ - Purchase this E-book
Category : Higher Education
Microsoft Office 2013 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 Table of Contents
Access 309
Glossary 313
Index
Get Exploring: Microsoft Access 2013, Introductory by Mary Anne Poatsy, Montgomery County Community College Cynthia Krebs, Utah Valley University Eric Cameron, Passaic County Community College Robert T. Grauer, University of Miami
0 commentaires:
Enregistrer un commentaire