Components of the Package:

Description

For introductory computer courses on Microsoft Access 2010 or courses in computer concepts with a lab component on Access.

Teach the course YOU want in LESS TIME!

The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation. This approach is based on clearly defined projects for students and a one-of-a-kind supplements package for instructors.

Table of Contents

Objective 1: Identify Good Database Design Activity 1.01 Using Good Design Techniques to Plan a Database

Objective 2: Create a Table and Define Fields in a New Blank Database Activity 1.02 Starting with a New Blank Database Activity 1.03 Creating Fields in a Table Activity 1.04 Renaming Field in a Table Activity 1.05 Adding a Record to a Table Activity 1.06 Assigning the Data Type of a Field in Datasheet View Activity 1.07 Adding Additional Records to a Table Activity 1.08 Importing Data from an Excel Workbook to an Existing Access Table

Objective 3: Add and Change the Structure of Tables Activity 1.09 Deleting a Table Field in Design View Activity 1.10 Modifying a Field Size and Description in Design View Activity 1.11 Setting a Primary Key and Saving a Table Activity 1.12 Adding a Second Table to a Database by Importing an Excel Spreadsheet Activity 1.13 Adjusting Column Widths Activity 1.14 Printing a Table

Objective 4: Create and Use a Query, a Form, and a Report Activity 1.15 Using the Simple Query Wizard to Create a Query Activity 1.16 Creating a Form Activity 1.17 Creating, Modifying, and Printing a Report

Objective 5: Create a New Query from an Existing Query Activity 2.09 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 Results Activity 2.13 Using Is Null Criteria to Find Empty Fields

Objective 1: Create and Use a Form to Add and Delete Records Activity 3.01 Creating a Form Activity 3.02 Adding Records to a Table by Using a Form Activity 3.03 Deleting Records from a Table by Using a Form Activity 3.04 Printing a FormObjective 2: Create a Form by Using the Form Wizard Activity 3.05 Creating a Form by Using the Form WizardObjective 3: Modify a Form in Design View and in Layout View Activity 3.06 Modifying a Form in Design View Activity 3.07 Adding, Resizing, and Moving Controls in Layout View Activity 3.08 Formatting and Aligning Controls in Layout ViewObjective 4: Filter Records Activity 3.09 Filtering Data by Selection on One Field Activity 3.10 Using Filter By Form

Project 3B: Job Openings

Objective 5: Create a Report by Using the Report Tool Activity 3.11 Creating a Report by Using the Report Tool Activity 3.12 Modifying a Report in Layout ViewObjective 6: Create Reports by Using the Blank Report Tool or the Report Wizard Activity 3.13 Creating a Report by Using the Blank Report Tool Activity 3.14 Creating a Report by Using the Report Wizard