skip to content
Microsoft Office Access 2010. Comprehensive Preview this item
ClosePreview this item
Checking...

Microsoft Office Access 2010. Comprehensive

Author: Robert T Grauer; Keith Mast; Mary Anne Poatsy
Publisher: Upper Saddle River : Prentice Hall, ©2011.
Series: Exploring series (Pearson/Prentice Hall)
Edition/Format:   Book : CD for computer : EnglishView all editions and formats
Database:WorldCat
Summary:

The goal of the Exploring series has been to move students beyond the point and click, helping them understand the why and how behind each skill.

Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Document Type: Book
All Authors / Contributors: Robert T Grauer; Keith Mast; Mary Anne Poatsy
ISBN: 9780135098257 0135098254 2900135098256
OCLC Number: 660801167
Notes: Includes index.
Description: xx, 634 p. : col. ill. ; 28 cm. + 1 CD-ROM (4 3/4 in.)
Contents: OFFICE FUNDAMENTALS AND FILE MANAGEMENT CHAPTER ONE ' Office Fundamentals and File Management CASE STUDY: RAILS AND TRAILS OBJECTIVES FILES AND FOLDERS Using Windows Explorer Working with Folders and Files Selecting, Copying, and Moving Multiple Files and Folders HANDS-ON EXERCISE 1: Files and Folders MICROSOFT OFFICE SOFTWARE Identifying Common Interface Components Getting Office Help HANDS-ON EXERCISE 2: Microsoft Office Software BACKSTAGE VIEW TASKS Opening a File Printing a File Closing a File and Application HANDS-ON EXERCISE 3: Backstage View Tasks HOME TAB TASKS Selecting and Editing Text Using the Clipboard Group Tasks Using the Editing Group Tasks HANDS-ON EXERCISE 4: Home Tab Tasks INSERT TAB TASKS Inserting Objects REVIEW TAB TASKS Reviewing a File PAGE LAYOUT TAB TASKS Changing Page Settings HANDS-ON EXERCISE 5: Tasks on the Insert Tab, Page Layout Tab, and Review Tab CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE MICROSOFT OFFICE ACCESS 2010 CHAPTER ONE ' Introduction to Access CASE STUDY: MANAGING A BUSINESS IN THE GLOBAL ECONOMY OBJECTIVES DATABASES ARE EVERYWHERE! Navigating Among the Objects in an Access Database Understanding the Difference Between Working in Storage and Memory Practicing Good Database File Management Backing Up, Compacting, and Repairing Access Files HANDS-ON EXERCISE 1: Databases Are Everywhere! FILTERS, SORTS, AND ACCESS VERSUS EXCEL Creating Filters Sorting Table Data on One or More Fields Knowing When to Use Access or Excel to Manage Data HANDS-ON EXERCISE 2: Filters, Sorts, and Access Versus Excel RELATIONAL DATABASE Using the Relationships Windows Understanding Relational Power HANDS-ON EXERCISE 3: Relational Database CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM CHAPTER TWO ' Relational Databases and Queries CASE STUDY: BANK AUDITOR UNCOVERS MIDHANDLED FUNDS OBJECTIVES TABLE DESIGN, PROPERTIES, VIEWS, AND WIZARDS Designing Data Creating Tables HANDS-ON EXERCISE 1: Table Design, Properties, Views, and Wizards MULTIPLE TABLE DATABASES Understanding Table Relationships Sharing Data with Excel Establishing Table Relationships HANDS-ON EXERCISE 2: Multiple Table Databases SINGLE-TABLE QUERIES Creating a Single-Table Query Specifying Criteria for Different Data Types Copying and Running a Query Using the Query Wizard HANDS-ON EXERCISE 3: Single-Table Queries MULTI-TABLE QUERIES Creating a Multi-Table Query Modifying a Multi-Table Query HANDS-ON EXERCISE 4: Multi-Table Queries CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM CHAPTER THREE ' Customize, Analyze, and Summarize Query Data CASE STUDY: HOUSING SLUMP MEANS OPPORTUNITY FOR COLLEGE STUDENTS OBJECTIVES CALCULATIONS, EXPRESSIONS, AND FUNCTIONS Understanding the Order of Operations Creating a Calculated Field in a Query HANDS-ON EXERCISE 1: Calculations, Expressions, and Functions EXPRESSION BUILDER, FUNCTIONS, AND DATE ARITHMETIC Creating Expressions with the Expression Builder Using Built-In Functions in Access Performing Date Arithmetic HANDS-ON EXERCISE 2: Expression Builder, Functions, and Date Arithmetic AGGREGATE FUNCTIONS Adding Aggregate Functions to Datasheets and Queries HANDS-ON EXERCISE 3: Aggregate Functions CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM CHAPTER FOUR ' Creating and Using Professional Forms and Reports CASE STUDY: COFFEE SHOP STARTS NEW BUSINESS OBJECTIVES FORM BASICS Creating Forms Using the Form Tools Modifying a Form Sorting Records in a Form HANDS-ON EXERCISE 1: Form Basics FORM SECTIONS, VIEWS, AND CONTROLS Identifying Form Sections Revising Forms Using Form Views Identifying Control Types in Forms HANDS-ON EXERCISE 2: Form Sections, Views, and Controls REPORT BASICS Creating Reports Using Report Tools Modifying a Report Sorting Records in a Report HANDS-ON EXERCISE 3: Report Basics REPORT SECTIONS, VIEWS, AND CONTROLS Identifying Report Sections Revising Reports Using Report Views Identifying Control Types in Reports HANDS-ON EXERCISE 4: Report Sections, Views, and Controls CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM CHAPTER FIVE ' PivotTables and PivotCharts CASE STUDY: RETAINING EMPLOYEES IN TOUGH TIMES OBJECTIVES DATA MINING WITH PIVOTTABLES Creating a PivotTable Adding Aggregate Functions to a PivotTable Modifying a PivotTable HANDS-ON EXERCISE 1: Data Mining with PivotTables CHARTS CONVEY INFORMATION Creating a PivotChart Identifying Chart Elements Modifying a PivotChart HANDS-ON EXERCISE 2: Charts Convey Information CALCULATIONS IN PIVOTTABLES Adding Calculations to a PivotTable Working with Calculations in a PivotTable HANDS-ON EXERCISE 3: Calculations in PivotTables CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM CHAPTER SIX ' Data Validation Techniques CASE STUDY: MANAGER FIRED OVER DATA ENTRY ERRORS OBJECTIVES DATA VALIDATION IN TABLES Establishing Data Validation Creating an Input Mask Creating and Modifying a Lookup Field HANDS-ON EXERCISE 1: Data Validation in Tables DATA VALIDATION IN FORMS AND DATA MACROS Setting the Tab Order Creating a Combo Box Control Restricting Edits in a Form Comparing Fields Using a Data Macro HANDS-ON EXERCISE 2: Data Validation in Forms and Data Macros DATA VALIDATION WITH QUERIES AND REPORTS Creating a Query to Display Missing Data Creating a Missing Data Report Creating an Aggregate Report HANDS-ON EXERCISE 3: Data Validation with Queries and Reports CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM CHAPTER SEVEN ' Advanced Queries CASE STUDY: REPLACEMENTS, LTD. OBJECTIVES ACTION QUERIES Determining When to Use an Action Query Updating Data with an Update Query Adding Records to a Table with an Append Query Creating a Table with a Make Table Query Deleting Records with a Delete Query HANDS-ON EXERCISE 1: Action Queries QUERIES FOR SPECIAL CONDITIONS Creating a Parameter Query to Provide Flexibility Summarizing Data with a Crosstab Query Finding Unmatched Records with a Query Finding Duplicate Records with a Query HANDS-ON EXERCISE 2: Queries for Special Conditions CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM CHAPTER EIGHT ' Get Connected CASE STUDY: DATA EXCHANGE OBJECTIVES CONNECTING ACCESS TO EXTERNAL FILES Creating a Hyperlink Field Adding an Attachment Field Adding Attachment Controls to Forms and Reports HANDS-ON EXERCISE 1: Connecting Access to External Files EXPORTING DATA TO OFFICE APPLICATIONS Exporting Data to Excel Exporting Data to Word Exporting Data to a PDF or XPS Document Exporting Objects to Another Access Database HANDS-ON EXERCISE 2: Exporting Data to Office Applications IMPORTING DATA INTO ACCESS Linking to an Excel Spreadsheet Linking to an Access Table Importing a Text File HANDS-ON EXERCISE 3: Importing Data into Access CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM CHAPTER NINE ' Fine-Tuning the Database CASE STUDY: THE METROPOLITAN ZOO OBJECTIVES NORMALIZING DATABASE TABLES Verifying First Normal Form Verifying Second Normal Form Verifying Third Normal Form HANDS-ON EXERCISE 1: Normalizing Database Tables USING THE BUILT-IN ANALYSIS AND DESIGN TOOLS Using the Database Documenter Tool Using the Performance Analyzer Tool Using the Table Analyzer Tool Using the Database Splitter Tool HANDS-ON EXERCISE 2: Using the Built-In Analysis and Design Tools SAFEGUARDING YOUR DATABASE APPLICATION Creating a Menu System Encrypting and Password-Protecting a Database Digitally Signing and Publishing a Database Saving a Database as an ACCDE File HANDS-ON EXERCISE 3: Safeguarding Your Database Application CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM CHAPTER TEN ' Using Macros and SQL in Access CASE STUDY: RETIREMENT PLAN HELPS RETAIN EMPLOYEES OBJECTIVES WORKING WITH MACROS Understanding the Purpose of a Macro Creating a Stand-Alone Macro Using the Macro Builder Attaching an Embedded Macro to an Event HANDS-ON EXERCISE 1: Working with Macros WORKING WITH DATA MACROS Identifying When to Use a Data Macro Creating an Event-Driven Data Macro Creating a Named Data Macro HANDS-ON EXERCISE 2: Working with Data Macros USING STRUCTURED QUERY LANGUAGE Understanding the Fundamentals of SQL Interpreting an SQL Select Statement Using an SQL Select Statement as a Record Source HANDS-ON EXERCISE 3: Using Structured Query Language CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM GLOSSARY INDEX
Series Title: Exploring series (Pearson/Prentice Hall)
Responsibility: Robert T. Grauer, Keith Mast, Mary Anne Poatsy.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

All user tags (3)

View most popular tags as: tag list | tag cloud

Similar Items

Related Subjects:(2)

User lists with this item (1)

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


<http://www.worldcat.org/oclc/660801167>
library:oclcnum"660801167"
library:placeOfPublication
library:placeOfPublication
owl:sameAs<info:oclcnum/660801167>
rdf:typeschema:Book
rdf:typej.2:Compact_Disc
schema:about
schema:about
schema:about
schema:about
schema:about
schema:contributor
schema:contributor
schema:copyrightYear"2011"
schema:creator
schema:datePublished"2011"
schema:exampleOfWork<http://worldcat.org/entity/work/id/1221988312>
schema:inLanguage"en"
schema:name"Microsoft Office Access 2010. Comprehensive"@en
schema:numberOfPages"634"
schema:publisher
schema:url
schema:workExample
schema:workExample

Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.