GO! with Microsoft Access 2010 Introductory

ISBN-10: 0132454645
ISBN-13: 9780132454643
Edition: 2011
List price: $108.00 Buy it from $3.94
This item qualifies for FREE shipping

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Used Starting from $66.10
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $108.00
Copyright year: 2011
Publisher: Prentice Hall PTR
Publication date: 7/22/2010
Binding: Paperback
Pages: 576
Size: 9.00" wide x 11.00" long x 0.75" tall
Weight: 2.574
Language: English

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.

Common Features Chapter 1 Using the Common Features of Office 2010
Scenario: Oceana Palm Grill
Menu Plan
Use Windows Explorer to Locate Files and Folder
Using Windows Explorer to Locate Files and Folders
Locate and Start a Microsoft Office 2010 Program
Locating and Starting a Microsoft Office 2010 Program
Enter and Edit Text in an Office Program
Entering and Editing Text in an Office Program
Perform Commands From a Dialog Box
Performing Commands From a Dialog Box
Create a Folder, Save a File, and Close a Program
Creating a Folder, Saving a File, and Closing a Program
Print a File
Printing a File
Memo
Open an Existing File and Save it With a New Name
Opening an Existing File and Saving it With a New Name
Explore Application Options
Viewing Application Options
Perform Commands from the Ribbon
Performing Commands from the Ribbon
Minimizing and Using the Keyboard to Control the Ribbon
Apply Formatting in Office Programs
Formatting and Viewing Pages
Formatting Text
Using the Office Clipboard to Cut, Copy, and Paste
Use the Microsoft Office 2010 Help System
Using the Microsoft Office 2010 Help System in Excel
Compress Files
Compressing Files
Getting Started with Access Databases
Scenario: Capital Cities Community College
Contact Information
Identify Good Database Design
Using Good Design Techniques to Plan a Database
Create a Table and Define Fields in a New Blank Database
Starting with a New Blank Database
Creating Fields in a Table
Renaming Field in a Table
Adding a Record to a Table
Assigning the Data Type of a Field in Datasheet View
Adding Additional Records to a Table
Importing Data from an Excel Workbook to an Existing Access Table
Add and Change the Structure of Tables
Deleting a Table Field in Design View
Modifying a Field Size and Description in Design View
Setting a Primary Key and Saving a Table
Adding a Second Table to a Database by Importing an Excel Spreadsheet
Adjusting Column Widths
Printing a Table
Create and Use a Query, a Form, and a Report
Using the Simple Query Wizard to Create a Query
Creating a Form
Creating, Modifying, and Printing a Report
Save, Close, and Change the Properties of a Database
Changing Database Properties
Closing and Saving a Database
Student Workshops
Create a Database Using a Template
Creating a New Database Using a Template
Building a Table by Entering Records in a Multiple Items Form
Organize Database Objects in the Navigation Pane
Organizing Database Objects in the Navigation Pane
Create a New Table in a Database Created with a Template
Creating a New Table and Changing Its Design
View a Report and Print a Table in a Database Created with a Template
Viewing a Report
Printing a Table
Sort and Query a Database
Scenario: Capital Cities Community College
Instructors and Courses
Open an Existing Database
Opening and Renaming an Existing Database
Resolving Security Alerts and Renaming Tables
Create Table Relationships
Creating Table Relationships and Enforcing Referential Integrity
Printing a Relationship Report
Sort Records in a Table
Sorting Records in a Table in Ascending or Descending Order
Sorting Records in a Table on Multiple Fields
Create a Query in Design View
Creating a New Select Query in Design View
Running, Saving, Printing, and Closing a Query
Create a New Query from an Existing Query
Creating a New Query from an Existing Query
Sort Query Results
Sorting Query Results
Specify Criteria in a Query
Specifying Text Criteria in a Query
Specifying Criteria Using a Field Not Displayed in the Query Results
Using Is Null Criteria to Find Empty Fields
Athletic Scholarships
Specify Numeric Criteria in a Query
Opening an Existing Database and Importing a Spreadsheet
Creating Table Relationships
Specifying Numeric Criteria in a Query
Using Comparison Operators
Using the Between and Comparison Operator
Use Compound Criteria
Using AND Criteria in a Query
Using OR Criteria in a Query
Create a Query Based on More Than One Table
Creating a Query Based on More Than One Table
Use Wildcards in a Query
Using a Wildcard in a Query
Use Calculated Fields in a Query
Using Calculated Fields in a Query
Calculate Statistics and Group Data in a Query
Using the MIN, MAX, AVG, and SUM Functions in a Query
Grouping Data in a Query
Forms, Filters, and Reports
Scenario: Capital Cities Community College
Students and Majors
Create and Use a Form to Add and Delete Records
Creating a Form
Adding Records to a Table by Using a Form
Deleting Records from a Table by Using a Form
Printing a Form
Create a Form by Using the Form Wizard
Creating a Form by Using the Form Wizard
Modify a Form in Design View and in Layout View
Modifying a Form in Design View
Adding, Resizing, and Moving Controls in Layout View
Formatting and Aligning Controls in Layout View
Filter Records
Filtering Data by Selection on One Field
Using Filter By Form
Job Openings
Create a Report by Using the Report Tool
Creating a Report by Using the Report Tool
Modifying a Report in Layout View
Create Reports by Using the Blank Report Tool or the Report Wizard
Creating a Report by Using the Blank Report Tool
Creating a Report by Using the Report Wizard
Modify the Design of a Report
Modifying a Report in Layout View
Modifying a Report in Design View
Keep Data Together in a Printed Report
Keeping Data Together and Printing a Report
Enhancing Tables
Scenario: City of Westland Plains
Maneuver Data and Enforce Data Integrity
Manage Existing Tables
Backing Up a Database
Adding File Locations to Trusted Locations
Copying a Table and Modifying the Structure
Appending Records to a Table
Splitting a Table into Two Tables
Appending Records from Another Database
Modify Existing Tables
Finding and Deleting Records
Finding and Modifying Records
Adding and Moving Fields in Design View and Datasheet View
Checking Spelling
Create and Modify Table Relationships
Creating Table Relationships and Testing Referential Integrity
Setting and Testing Cascade Options
Format Tables and Validate Data Entry
Create a table in design view
Creating a Table in Design View
Change Data types
Changing Data Types
Create a Lookup Field
Creating a Lookup Field Based on a List of Values
Creating a Lookup Field Based on Data in Another Table
Set Field Properties
Creating an Input Mask using the Input Mask Wizard
Creating an Input Mask using the Input Mask Properties Box
Specifying a Required Field
Setting Default Values for Fields
Indexing Fields in a Table
Create Data Validation Rules and Validation Text
Creating Data Validation Rules and Validation Text
Testing Table Design and Field Properties
Attach Files to Records
Attaching a Word Document to a Record
Enhancing Queries
Scenario: Board Anywhere Surf and Snowboard Shop
Create Special-Purpose Queries
Create Calculated Fields in a Query
Creating a Calculated Field Based on Two Existing Fields
Creating a Calculated Field Based on One Existing Field and a Number
Use Aggregate Functions in a Query
Adding a Total Row to a Query
Creating a Totals Query
Create a Crosstab Query
Creating a Select Query as the Source for a Crosstab Query
Creating a Crosstab Query
Find Duplicate and Unmatched Records
Finding Duplicate Records
Finding Unmatched Records
Create a Parameter Query
Creating a Parameter Query Using One Criteria
Creating a Parameter Query Using Multiple Criteria
Create Action Queries and Modify Join Types
Create a Make Table Query
Creating a Select Query
Converting a Select Query to a Make Table Query
Create an Append Query
Creating an Append Query for a Table in the Current Database
Creating an Append Query for a Table in Another Database
Create a Delete Query
Creating a Delete Query
Create an Update Query
Creating an Update Query
Creating an Update Query with an Expression
Modify the Join Type
Viewing the Results of a Query Using an Inner Join
Changing the Join Type to an Outer Join
Customizing Forms and Reports
Scenario: Wild Islands Breeze
Customize Forms
Create a Form in Design View
Creating a Form in Design View
Adding Sections to the Form
Change and Add Controls
Changing Controls on a Form
Adding Controls to a Form
Format a Form
Adding a Background Color
Adding a Background Picture to a Form
Modifying the Borders of Controls
Make a Form User Friendly
Adding a Message to the Status Bar
Creating Custom ControlTips
Changing the Tab Order
Customize Reports
Create a Report Based on a Query Using a Wizard
Creating a Report Using a Wizard
Modifying a Report Created Using a Wizard
Create a Report in Design View
Creating a Report in Design view
Modifying the Sections of a Report
Add Controls to a Report
Adding Label and Text Box Controls to a Report
Adding an Image Control and a Line Control to a Report
Group, Sort, and Total Records in Design View
Adding a Grouping and Sort Level to a Report
Adding Calculated Controls to a Report

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×