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.
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
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.