Summer Reading B2G1 Free
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | July 31, 2015

    Susan Casey: IMG Voices in the Ocean



    In 2010, the year dolphins came into my life, I spent my days working in midtown Manhattan, on the 36th floor of a big, impressive office building.... Continue »
    1. $19.57 Sale Hardcover add to wish list

    spacer
Qualifying orders ship free.
$66.00
List price: $101.50
Used Spiral
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Partner Warehouse General- General

More copies of this ISBN

Go! With Microsoft Access 2007, Volume 1 - With CD (08 Edition)

by

Go! With Microsoft Access 2007, Volume 1 - With CD (08 Edition) Cover

 

Synopses & Reviews

Please note that used books may not include additional media (study guides, CDs, DVDs, solutions manuals, etc.) as described in the publisher comments.

Publisher Comments:

The primary goal of this GO! Series title is to teach Microsoft Access 2007 quickly and easily, with an approach that is based on clearly-defined projects. A key feature of the book is the use of Microsoft procedural syntax: steps begin with where the action is to take place, followed by the action itself. The instruction is error-free, clearly written, and logically arranged. This book provides users with the skills to solve business problems using the computer as a tool. 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. GO! with Microsoft Access 2007, Volume 1, 1/e contains a CD-ROM. This edition covers the following topics: getting started with Access databases and tables; sorting and querying databases; forms, filters and reports; designing and building a rational database; automating data entry; advanced reports. An efficient and handy guide for anyone interested in a comprehensive introduction to Microsoft Access 2007.

About the Author

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.

Table of Contents

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

 

Chapter 4 Designing and Building a Relational Database

    PROJECT 4A Classes

        Objective 1: Customize Table Fields

            Activity 4.1 Adding Captions to Fields

            Activity 4.2 Creating a Yes/No Field and Set a Default Value

            Activity 4.3 Creating and populating an Attachment Field

        Objective 2: Structure Data Input

            Activity 4.4 Creating a Lookup Field from a Typed List

            Activity 4.5 Creating a Lookup Field from a Table

            Activity 4.6 Creating an Input Mask Using a Wizard

            Activity 4.7 Creating a Custom Input Mask

        Objective 3: Validate Data Input

            Activity 4.8 Classifying Fields as Required

            Activity 4.9 Assigning Default Values to Fields

            Activity 4.10 Setting Validation Properties

            Activity 4.11 Testing a Validation System in a For

     PROJECT 4B Registration

        Objective 4: Create Indexes and Change Sort Order

            Activity 4.12 Creating an Index to Optimize Sorting

            Activity 4.13 Creating an Index to Maintain Data Integrity

        Objective 5: Create Relationships between Tables

            Activity 4.14 Establishing a One-to-One Relationship

            Activity 4.15 Working with Related Tables

            Activity 4.16 Creating a One-to-Many Relationship

            Activity 4.17 Creating a Many-to-Many Relationship

        Objective 6: Create Forms and Reports with Related Tables

            Activity 4.18 Creating a Relationships Report

            Activity 4.19 Creating a Query Using Related Tables

            Activity 4.20 Creating a Form Using Related Tables

  Chapter 5 Automate Data Entry with Forms

    PROJECT 5A - Sales Force

        Objective 1: Create Forms with Subforms

            Activity 5.1 Creating One-to-Many Relationships

            Activity 5.2 Creating a Form and Subform using the Form Wizard

            Activity 5.3 Creating a Form Using the Blank Form Tool

            Activity 5.4 Adding a Subform using the Subform Control

            Activity 5.5 Formatting a Form and Subform in Layout View

        Objective 2: Create Forms with Special Views

            Activity 5.6 Creating a Split Form

            Activity 5.7 Creating a Multiple Items Form

            Activity 5.8 Creating a From with Tabbed Pages

     PROJECT 5B - Opportunities

        Objective 4: Build a Form in Design View

            Activity 5.9 Building a Form in Design View

            Activity 5.10 Aligning Controls Using Arrange Tools

            Activity 5.11 Creating a Combo Box with Data from a Related Table

            Activity 5.12 Adding a List Box and a Combo Box

            Activity 5.13 Adding a Calculated Control

            Activity 5.14 Adding an Option Button Group

            Activity 5.15 Adding a Command Button

            Activity 5.16 Inserting a Chart

        Objective 5: Use Advanced Formatting Tools

            Activity 5.17 Applying Conditional Formatting

            Activity 5.18 Applying Rich Text Formatting to Data

 

Chapter 6 Customize Data Output with Reports (The Petite Book)

    PROJECT 6A Orders

        Objective 1: Build Reports Based on Queries

            Activity 6.1 Building a Select Query

            Activity 6.2 Building a report Based on a Select Query

            Activity 6.3 Adding Line Numbers and a Record Count

            Activity 6.4 Optimizing a Report for Black and White Printing

            Activity 6.5 Building and Modifying Queries Using Copy and Paste

            Activity 6.6 Building and Modifying Reports Using Copy and Paste

        Objective 2: Export a Report and Create a Labels Report

            Activity 6.7 Exporting Reports as Web Pages

            Activity 6.8 Creating an Aggregate Function Query

            Activity 6.9 Creating a Labels Report

    PROJECT 6B Sales

        Objective 4: Create a Subreport Using Design Tools

            Activity 6.10 Creating a Report Using Report Design

            Activity 6.11 Creating a Subreport using the SubReport Wizard

            Activity 6.12 Formatting a Report and Subreport

            Activity 6.13 Adding Calculated Controls

        Objective 5: Summarize Report Data

            Activity 6.14 Creating a Summary Report

            Activity 6.15 Inserting a Chart

            Activity 6.16 Editing a Chart

            Activity 6.17 Filtering and Printing a Report

        Objective 6: Create a Report with an Interactive Filter

            Activity 6.18 Building a Daily Sales Report

            Activity 6.19 Creating a Filter That Asks for User Input

 

Product Details

ISBN:
9780135130407
Author:
Gaskin, Shelley
Publisher:
Prentice Hall
Author:
Townsend, Kris
Author:
Marks, Suzanne
Subject:
Desktop Applications - MS Access
Subject:
Database management
Subject:
Database Management - General
Subject:
Database design
Subject:
Personal Computers-Desktop Applications-Databases
Copyright:
Series:
GO! GO! for Office 2010 Go! Series
Publication Date:
June 2007
Binding:
Spiral, comb or coil bound book
Grade Level:
College/higher education:
Language:
English
Illustrations:
Y
Pages:
576
Dimensions:
10.70x8.88x1.00 in. 2.61 lbs.

Related Subjects

Computers and Internet » Personal Computers » Desktop Applications » Databases

Go! With Microsoft Access 2007, Volume 1 - With CD (08 Edition) Used Spiral
0 stars - 0 reviews
$66.00 In Stock
Product details 576 pages Prentice Hall - English 9780135130407 Reviews:
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.