- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
This book offers full, comprehensive coverage of Access. Move students beyond the point-and-click.The goal of the Exploring series is to move students beyond the point and click, to understanding the why and how behind each skill. And, because so much learning takes place outside of the classroom, this series provides learning tools that students can access anywhere, any time.Students go to college now with a different set of skills than they did years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everyone needs to know. NOTE: Before purchasing, check with your instructor to ensure you select the correct ISBN. Several versions of Pearson's MyLab & Mastering products exist for each title, and registrations are not transferable. To register for and use Pearson's MyLab & Mastering products, you may also need a Course ID, which your instructor will provide.Used books, rentals, and purchases made outside of PearsonIf purchasing or renting from companies other than Pearson, the access codes for Pearson's MyLab & Mastering products may not be included, may be incorrect, or may be previously redeemed. Check with the seller before completing your purchase.
Contents
Microsoft Office 2013 Chapter One Office Fundamentals and File Management: Taking the First Step 1 Objectives 1Case Study: Spotted Begonia Art Gallery 1Windows 8 Startup 2Logging In with Your Microsoft Account 2Identifying the Start Screen Components 3Interacting with the Start Screen 4Accessing the Desktop 4Hands-On Exercise 1:Windows 8 Startup 6Files and Folders 10Using File Explorer 10Working with Folders and Files 13Selecting, Copying, and Moving Multiple Files and Folders 15Hands-On Exercise 2:Files and Folders 17Microsoft Office Software 22Identifying Common Interface Components 22Getting Office Help 28Hands-On Exercise 3:Microsoft Office Software 31The Backstage View Tasks 36Opening a File 36Printing a File 38Closing a File and Application 39Hands-On Exercise 4:The Backstage View Tasks 41Home Tab Tasks 45Selecting and Editing Text 45Using the Clipboard Group Commands 49Using the Editing Group Commands 52Hands-On Exercise 5:Home Tab Tasks 55Insert Tab Tasks 60Inserting Objects 60Review Tab Tasks 62Reviewing a File 62Page Layout Tab Tasks 65Using the Page Setup Dialog Box 66Hands-On Exercise 6:Insert Tab Tasks, Page Layout Tab Tasks, andReview Tab Tasks 68Chapter Objectives Review 72Key Terms Matching 73Multiple Choice 74Practice Exercises 75Mid-Level Exercises 79Beyond the Classroom 81Capstone Exercise 82Microsoft Office Access 2013Chapter One Introduction to Access: Finding Your Way Through an Access Database 83Objectives 83Case Study: Managing a Business in the GlobalEconomy 83Databases Are Everywhere! 84Understanding Database Fundamentals 84Using an Existing Database 91Hands-On Exercise 1:Databases Are Everywhere! 95Sorts and Filters 102Sorting Table Data on One or Multiple Fields 102Creating, Modifying, and Removing Filters 103Hands-On Exercise 2:Sorts and Filters 106Access Versus Excel, and Relational Databases 111Knowing When to Use Access or Excel to Manage Data 111Understanding Relational Power 112Hands-On Exercise 3:Access Versus Excel, and Relational Databases 115Access Database Creation 119Creating a Database 119Hands-On Exercise 4:Access Database Creation 123Chapter Objectives Review 127Key Terms Matching 128Multiple Choice 129Practice Exercises 130Mid-Level Exercises 135Beyond the Classroom 139Capstone Exercise 140Chapter Two Tables and Queries in Relational Databases: DesigningDatabases and Extracting Data 141Objectives 141Case Study: Bank Audit 141Table Design, Creation, and Modification 142Designing a Table 142Creating and Modifying Tables 146Hands-On Exercise 1:Table Design, Creation, and Modification 152Multiple-Table Databases 157Sharing Data 157Establishing Table Relationships 160Hands-On Exercise 2:Multiple-Table Databases 165Single-Table Queries 171Creating a Single-Table Query 171Specifying Query Criteria for Different Data Types 173Understanding Query Sort Order 177Running, Copying, and Modifying a Query 177Using the Query Wizard 178Hands-On Exercise 3:Single-Table Queries 181Multitable Queries 184Creating a Multitable Query 184Modifying a Multitable Query 185Hands-On Exercise 4:Multitable Queries 189Chapter Objectives Review 193Key Terms Matching 195Multiple Choice 196Practice Exercises 197Mid-Level Exercises 202Beyond the Classroom 206Capstone Exercise 208Chapter Three Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions 211Objectives 211Case Study: Housing Slump Means OpportunityFor College Students 211Calculations and Expressions 212Creating a Calculated Field in a Query 212Formatting and Saving Calculated Results 215Hands-On Exercise 1:Calculations and Expressions 218The Expression Builder and Functions 223Creating Expressions with the Expression Builder 223Using Built-In Functions in Access 225Hands-On Exercise 2:The Expression Builder and Functions 228Aggregate Functions 233Adding Aggregate Functions to Datasheets 233Creating Queries with Aggregate Functions 234Hands-On Exercise 3:Aggregate Functions 240Chapter Objectives Review 243Key Terms Matching 244Multiple Choice 245Practice Exercises 246Mid-Level Exercises 249Beyond the Classroom 253Capstone Exercise 255Chapter Four Creating and Using Professional Forms and Reports:Moving Beyond Tables and Queries 257Objectives 257Case Study: Coffee Shop Starts New Business 257Form Basics 258Creating Forms Using Form Tools 258Using Form Views 265Working with a Form Layout Control 268Sorting Records in a Form 270Hands-On Exercise 1:Form Basics 272Report Basics 278Creating Reports Using Report Tools 278Using Report Views 285Modifying a Report 287Sorting Records in a Report 290Hands-On Exercise 2:Report Basics 292Chapter Objectives Review 296Key Terms Matching 298Multiple Choice 299Practice Exercises 300Mid-Level Exercises 303Beyond the Classroom 306Capstone Exercise 307Chapter Five Data Validation and Data Analysis: Reducing Errors andExtracting Better InformationObjectives 309Case Study: Implementing a New Database AtTommy's Shelter 309Data Validation in Tables 310Establishing Data Validation 310Creating an Input Mask 313Creating and Modifying a Lookup Field 315Hands-On Exercise 1:Data Validation in Tables 320Data Analysis Using Advanced Select Queries 325Creating a Parameter Query 325Using Advanced Functions in the Expression Builder 329Performing Date Arithmetic 335Hands-On Exercise 2:Data Analysis Using Advanced Select Queries 339Chapter Objectives Review 344Key Terms Matching 345Multiple Choice 346Practice Exercises 347Mid-Level Exercises 350Beyond the Classroom 352Capstone Exercise 354Chapter Six Action and Specialized Queries: Moving Beyond the Select Query 357Objectives 357Case Study: Replacememt China, Inc. 357Action Queries 358Determining When to Use an Action Query 358Updating Data with an Update Query 360Adding Records to a Table with an Append Query 363Creating a Table with a Make Table Query 366Deleting Records with a Delete Query 367Hands-On Exercise 1:Action Queries 370Queries for Special Conditions 377Summarizing Data with a Crosstab Query 377Finding Duplicate Records with a Query 381Finding Unmatched Records with a Query 383Hands-On Exercise 2:Queries for Special Conditions 387Chapter Objectives Review 391Key Terms Matching 392Multiple Choice 393Practice Exercises 394Mid-Level Exercises 398Beyond the Classroom 401Capstone Exercise 402Chapter Seven Advanced Forms and Reports: Moving Beyond the Basics 403Objectives 403Case Study: Technical Services 403Advanced Forms 404Restricting Edits in a Form 404Creating a Drop-Down Menu 406Setting the Tab Order 409Using Subforms 410Hands-On Exercise 1:Advanced Forms 414Controls and Sections 419Using Advanced Controls 419Using Sections 423Hands-On Exercise 2:Controls and Sections 431Chapter Objectives Review 436Key Terms Matching 437Multiple Choice 438Practice Exercises 439Mid-Level Exercises 442Beyond the Classroom 444Capstone Exercise 446Chapter Eight Get Connected: Exchanging Data Between Access and Other Applications 447Objectives 447Case Study: Property Management Data Exchange 447Connecting Access to External Files 448Creating a Hyperlink Field 448Adding an Attachment Field 450Adding Attachment Controls to Forms and Reports 453Hands-On Exercise 1:Connecting Access to External Files 456Exporting Data to Office AND OTHER Applications 463Exporting Data to Excel 463Exporting Data to Word 467Exporting Data to a PDF or XPS Document 470Exporting Objects to Another Access Database 473Hands-On Exercise 2:Exporting Data to Office and Other Applications 476Importing Data Into Access 484Linking to an Access Table 484Linking to an Excel Spreadsheet 487Importing an Excel Spreadsheet 490Importing a Text File 493Hands-On Exercise 2:Importing Data into Access 496Chapter Objectives Review 504Key Terms Matching 505Multiple Choice 506Practice Exercises 507Mid-Level Exercises 512Beyond the Classroom 516Capstone Exercise 517Chapter Nine Fine-Tuning the Database: Analyzing and ImprovingDatabase Performance 519Objectives 519Case Study: The Metropolitan Zoo 519Database Normalization 520Verifying First Normal Form 520Verifying Second Normal Form 523Verifying Third Normal Form 524Creating Relationships 526Hands-On Exercise 1:Database Normalization 527Built-In Analysis and Design Tools 531Using the Database Documenter Tool 531Using the Performance Analyzer Tool 533Using the Table Analyzer Tool 535Using the Database Splitter Tool 538Hands-On Exercise 2:Built-In Analysis and Design Tools 541Database Security 545Creating a Menu System 545Encrypting and Password Protecting a Database 548Digitally Signing and Publishing a Database 550Saving a Database as an ACCDE File 551Hands-On Exercise 3:Database Security 553Chapter Objectives Review 556Key Terms Matching 557Multiple Choice 558Practice Exercises 559Mid-Level Exercises 562Beyond the Classroom 566Capstone Exercise 567Chapter Ten Using Macros and SQL in Access: Advanced Techniques 569Objectives 569Case Study: Retirement Plan Helps Retain Employees 569Macro DESIGN 570Understanding the Purpose of a Macro 570Creating a Stand-Alone Macro 571Using the Macro Designer 572Attaching an Embedded Macro to an Event 573Hands-On Exercise 1:Macro Design 577Data Macros 583Identifying When to Use a Data Macro 583Creating an Event-Driven Data Macro 583Creating a Named Data Macro 584Hands-On Exercise 2:Data Macros 587Structured Query Language 593Understanding the Fundamentals of SQL 593Interpreting an SQL SELECT Statement 594Using an SQL SELECT Statement as a Record Source 596Hands-On Exercise 3:Structured Query Language 600Chapter Objectives Review 603Key Terms Matching 604Multiple Choice 605Practice Exercises 606Mid-Level Exercises 610BEYOND THE CLASSROOM 614Capstone Exercise 615Application Capstone ExercisesIntroductory (Chapters 1-4) 617Comprehensive (Chapters 5-10) 620Glossary 623Index
