Microsoft Access 2010: A Case Approach, Complete / Edition 1

Microsoft Access 2010: A Case Approach, Complete / Edition 1

ISBN-10:
0077331354
ISBN-13:
9780077331351
Pub. Date:
10/11/2011
Publisher:
McGraw-Hill Higher Education
Select a Purchase Option (New Edition)
  • purchase options
    $117.53 $134.33 Save 13% Current price is $117.53, Original price is $134.33. You Save 13%.
  • purchase options
    $74.62 $134.33 Save 44% Current price is $74.62, Original price is $134.33. You Save 44%.
    icon-error
    Note: Access code and/or supplemental material are not guaranteed to be included with textbook rental or used textbook.
  • purchase options

Overview

Microsoft Access 2010: A Case Approach, Complete / Edition 1

Timothy and Linda O'Leary and the Computer Information Technology Team at McGraw-Hill Higher Education offer your students a fully integrated learning program with time-tested quality and reliability.

Office 2010: A Case Approach offers running case study throughout the text to help students understand the material in a consistent, relevant environment. Through this theme of “Making Office Relevant,” this text helps students understand why they need this course and these skills. Student success is assured through clear step-by-step instruction, plentiful screen captures and conceptual explanations. Each Lab, designed to be covered in 1 hour of class time, combines conceptual coverage with detailed software-specific instructions. Each Lab opens with a running case study that highlights real-world applications of each software program and leads students from problem to solution. The O'Leary Series helps students learn specific applications skills along with those that cross all Office applications, which is especially important in mastering this version of Office. The O'Leary Series also correlates with SimNet Online, our online training and assessment program for Office 2010.

Product Details

ISBN-13: 9780077331351
Publisher: McGraw-Hill Higher Education
Publication date: 10/11/2011
Edition description: New Edition
Pages: 688
Product dimensions: 8.20(w) x 10.80(h) x 0.90(d)

Table of Contents

Access 2010 Complete

Lab 1 Creating a Database

Designing a New Database

Creating a New Database

Creating a Table

Modifying Field Properties

Entering and Editing Records

Changing Column Width

Navigating Among Records

Deleting Records

Creating a Table in Design View

Creating Relationships

Setting Database and Object Properties

Previewing and Printing a Table

Closing and Opening a Database

Exiting Access

Lab 2 Modifying and Filtering a Table and Creating a Form Customising Fields

Hiding and Redisplaying Fields

Creating a Lookup Field

Searching, Finding and Replacing Data

Sorting Records

Formatting the Datasheet

Filtering a Table

Creating a Simple Form

Modifying a Form

Using a Form

Organising the Navigation Pane

Previewing and Printing a Form

Identiying Object Dependencies

Lab 3 Querying Tables and Creating Reports

Refining the Database Design

Defining and Modifying Relationships

Creating a Query

Displaying a Totals Row

Creating Reports

Preparing Reports for Printing

Compacting and Backing Up the Database

Working Together 1 Exporting Data

Exporting Data

Lab 4 Importing and Querying Tables

Importing Data

Controlling Field Input

Using Action Queries

Using Memo Fields

Adding a Multivalued Field

Using Calculations in Tables and Queries

Creating a Top-Values Query

Creating a Crosstab Query

Lab 5 Creating Custom Forms

Creating a Split Form

Creating a Datasheet Form and Subform

Creating a Form for Multiple Tables

Changing Control Properties

Adding Label Controls

Enhancing Form Controls

Aligning and Spacing Controls

Adding Subforms

Setting Tab Order

Using Command Buttons

Creating Page Headers and Footers

Previewing a Form

Deleting a Form

Lab 6 Creating Custom Reports, Charts, Pivot Charts and Mailing Lables

Creating a Grouped Report

Using the Report Wizard to Create a Grouped Report

Customising the Report Layout

Enhancing the Report

Changing the Record Source

Using Calculated Controls in a Report

Applying Conditional Formatting

Printing a Grouped Report

Creating a Chart in a Report

Using Pivot Chart View

Creating Mailing Labels

Creating a Startup Display Form

Securing a Database

Working Together 2: Linking and Splitting Databases

Linking to External Data Sources

Splitting a Database

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews