Prentice Hall

Information Technology



GO! with Microsoft Access 2007, Brief
Shelley Gaskin
Suzanne Marks, Bellevue Community College

ISBN-10: 0132448165
ISBN-13: 9780132448161

Publisher: Prentice Hall
Copyright: 2008
Format: Spiralbound with CD-ROM; 336 pp
Published: 05/16/2007

Suggested retail price: $43.33
Buy from myPearsonStore

For Introductory Computer courses in Microsoft Office 2007 or courses in Computer Concepts with a lab component for Microsoft Office 2007 applications.

 

Teach the course YOU want in LESS TIME! The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation, with an approach that is based on clearly-defined projects for students and a one of a kind supplements package.

Sequential chapter numbering: In addition to sequential page numbering GO! chapters are now numbered 1 through 22 instead of Word Chapter 1, Excel Chapter 1, etc. This makes the text even easier to navigate.

 

Project-Based Approach: GO!’s project-based approach clusters the learning objectives around the projects rather than around software features. Teaches students to solve real problems as they practice and learn the features.

  • Texts are now organized by objectives and student learning outcomes and there are always two instructional projects per chapter

“There’s More You Can Do” feature

 

·        Try It! exercises teach students additional skills or new office features that are not  included within the instructional portion of the chapter.

 

Workshop feature for Excel and PowerPoint chapters help students better understand the uses of these applications.

 

·        The Excel Workshop teaches formulas and other basic math skills and a separate PowerPoint Workshop teaches essential presentation skills

 

End-of-Chapter organized into two sections: Content–Based Assessments and Outcomes-Based Assessments.

  • Now your content-based or defined-solution assessments that can be graded with a solution file or GO! Highlighted Overlays are separated from your non-defined solution assessments that can be graded with the GO! Rubric. 

End-of-Chapter assessments provide even more options for quizzing and review.

 

·        GO! with Help teaches the student to work with the Help feature in Office as a project.

·        Group Business Running Case is a project that runs through entire textbook and designed to be assigned to group of students.

 

Audio/Video Expert Demonstration Documents (A/V-EDDs) are multimedia versions of the GO! Expert Demonstration Documents that provide an alternative scripted lecture scenario of each chapter project in the text.

 

·        Provided in Flash file format for easy delivery, these are ideal for online, lecture reinforcement, and lecture replacement.

 

Assignment Tags for Problem Solving assessments provide task-specific scoring checklists that save time in grading open-ended assessments (assessments without defined solutions).

 

GO!-Specific instructional content in the new myitlab assessment and training software for Office 2007!

 

  • New MyITLab training scenarios deliver the exact same step-by-step content as the projects in the GO! textbook while the assessment provides two additional scenarios of each GO! project.  

Chapter 1 Getting Started with Access Databases and Tables

    PROJECT 1A Create a New Blank Database

        Objective 1 Start Access and Create a New Blank Database

            Activity 1.1 Starting Access, Creating and Naming a Folder, and Creating a Database from a

            New Blank Database

        Objective 2 Add Records to a Table

            Activity 1.2 Adding Records to a Table

        Objective 3 Rename Table Fields in Datasheet View

            Activity 1.3 Renaming the Fields In a Table in Datasheet View

            Activity 1.4 Changing the Data Type of a Field in Datasheet View

        Objective 4 Modify the Design of a Table

            Activity 1.5 Deleting a Field in Design View

            Activity 1.6 Modifying a Field Size and Description in Design View

            Activity 1.7 Setting a Primary Key and Saving a Table

        Objective 5 Add a Second Table to a Database

            Activity 1.8 Adding a Second Table to a Database

            Activity 1.9 Adding Records to a Second Table

        Objective 6 Print a Table

            Activity 1.10 Adjusting Column Widths and Printing a Table

        Objective 7 Create and Use a Query

            Activity 1.11 Using the Simple Query Wizard to Create a Query

        Objective 8 Create and Use a Form

            Activity 1.12 Creating a Form

        Objective 9 Create and Print a Report

            Activity 1.13 Creating and Printing a Report

        Objective 10 Close and Save a Database

            Activity 1.14 Closing and Saving a Database

    PROJECT 1B Create a Database from a Template

        Objective 11 Create a Database Using a Template

            Activity 1.15 Creating a New Database Using a Template

            Activity 1.16 Building a Table by Entering Records in a Multiple Items Form

        Objective 12 Organize Database Objects in the Navigation Pane

            Activity 1.17 Organizing Database Objects in the Navigation Pane

        Objective 13 Create a New Table in a Database Created with a Template

            Activity 1.18 Creating a New Table and Changing Its Design

        Objective 14 View a Report and Print a Table in a Database Created with a Template

            Activity 1.19 Viewing a Report

            Activity 1.20 Printing a Table

        Objective 15 Use the Access Help System

            Activity 1.21 Using the Access Help System

 

Chapter 2 Sort and Query a Database

    PROJECT 2A Sort and Query a Database

        Objective 1 Open an Existing Database

            Activity 2.1 Renaming and Opening an Existing Database

            Activity 2.2 Opening an Existing Database and Resolving Security Alerts

        Objective 2 Create Table Relationships

            Activity 2.3 Creating Table Relationships and Enforcing Referential Integrity

            Activity 2.4 Printing a Relationship Report

        Objective 3 Sort Records in a Table

            Activity 2.5 Sorting Records in a Table in Ascending or Descending Order

            Activity 2.6 Sorting Records in a Table on Multiple Fields

        Objective 4 Create a Query in Design View

            Activity 2.7 Creating a New Select Query in Design View

            Activity 2.8 Running, Saving, Printing, and Closing a Query

        Objective 5 Create a New Query from an Existing Query

            Activity 2.9 Creating a New Query From an Existing Query

        Objective 6 Sort Query Results

            Activity 2.10 Sorting Query Results

        Objective 7 Specify Criteria in a Query

            Activity 2.11 Specifying Text Criteria in a Query

            Activity 2.12 Specifying Criteria Using a Field Not Displayed in the Query Result

            Activity 2.13 Using Is Null Criteria to Find Empty Fields

    PROJECT 2B Create a Database Table from an Excel Spreadsheet and Create Complex Queries

        Objective 8 Create a New Table by Importing an Excel Spreadsheet

            Activity 2.14 Opening an Existing Database and Preparing to Import an Excel Spreadsheet

            Activity 2.15 Creating a New Table by Importing an Excel Spreadsheet

        Objective 9 Specify Numeric Criteria in a Query

            Activity 2.16 Specifying Numeric Criteria in a Query

            Activity 2.17 Using Comparison Operators

            Activity 2.18 Using the Between. . . And Comparison Operator

        Objective 10 Use Compound Criteria

            Activity 2.19 Using AND Criteria in a Query

            Activity 2.20 Using OR Criteria in a Query

        Objective 11 Create a Query Based on More Than One Table

            Activity 2.21 Creating a Query Based on More Than One Table

        Objective 12 Use Wildcards in a Query

            Activity 2.22 Using a Wildcard in a Query

        Objective 13 Use Calculated Fields in a Query

            Activity 2.23 Using Calculated Fields in a Query

        Objective 14 Group Data and Calculate Statistics in a Query

            Activity 2.24 Using the MIN, MAX, AVG and SUM Functions in a Query

            Activity 2.25 Grouping Data in a Query

 

Chapter 3 Forms, Filters, and Reports

    PROJECT 3A Create Forms to Enter and Display Data in a Database

        Objective 1 Create a Form

            Activity 3.1 Creating a Form

        Objective 2 Use a Form to Add and Delete Records

            Activity 3.2 Adding Records to a Table by Using a Form

            Activity 3.3 Deleting Records from a Table by Using a Form

            Activity 3.4 Printing a Form

        Objective 3 Create a Form by Using the Form Wizard

            Activity 3.5 Creating a Form Using the Form Wizard

        Objective 4 Modify a Form in Design View and in Layout View

            Activity 3.6 Modifying a Form in Design View

            Activity 3.7 Adding, Resizing, and Moving Controls in Layout View

            Activity 3.8 Formatting and Aligning Controls in Layout View

        Objective 5 Filter Records

            Activity 3.9 Filtering Data by Selection on One Field

            Activity 3.10 Using Filter by Form

    PROJECT 3B Create Reports to Display Database Information

        Objective 6 Create a Report by Using the Report Tool

            Activity 3.11 Creating and Modifying a Report by Using the Report Tool and Layout View

        Objective 7 Create a Report by Using the Blank Report Tool

            Activity 3.12 Creating a Report by Using the Blank Report Tool

        Objective 8 Create a Report by Using the Report Wizard

            Activity 3.13 Creating a Report by Using the Report Wizard

        Objective 9 Modify the Design of a Report

            Activity 3.14 Modifying a Report in Layout View

            Activity 3.15 Modifying a Report in Design View

        Objective 10 Print a Report and Keep Data Together

            Activity 3.16 Keeping Data Together and Printing a Report

Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois   University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.

View a Sample Chapter PDF:

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, contact your Pearson Higher Education representative for pricing and ordering information.

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, browse our available packages below, or contact your Pearson Higher Education representative to create your own package.



Copyright ©2008 Pearson Education. All rights reserved. Legal Notice | Privacy Policy | Permissions