GO! with Microsoft Access 2010 Introductory

Name: GO! with Microsoft Access 2010 Introductory
Price: 5.7 USD
Availability: InStock
ISBN: 9780132454643

ISBN-10: 0132454645

ISBN-13: 9780132454643

Edition: 2011

Authors: Shelley Gaskin, Carolyn E. McLellan, Nancy Graviett

List price: $108.00

30 day, 100% satisfaction guarantee!

Marketplace

1 new & used from $5.70

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Book details

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

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