GO! with Access 2007, Volume 1

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 (MIS Technical Training Institute)

 

    PROJECT 4A Classes and Instructors

        Objective 1: Customize Table Fields

            Activity 4.1 Add Captions to Fields

            Activity 4.2 Assign Smart Tags to Fields

            Activity 4.3 Create a Yes/No Field and Set a Default Value

            Activity 4.4 Create and populate an Attachment Field

        Objective 2: Structure Data Input

            Activity 4.5 Create a Lookup Field from a Typed List

            Activity 4.6 Create a Lookup Field from a Table

            Activity 4.7 Create an Input Mask using a Wizard

            Activity 4.8 Create a Custom Input Mask

        Objective 3: Validate Data Input

            Activity 4.9 Classify Fields as Required

            Activity 4.10 Assign Default Values to Fields

            Activity 4.11 Set Validation Properties

            Activity 4.12 Test a Validation System in a Form

 

    Project 4B Registration Information System

        Objective 4: Create Indexes and Change Sort Order

            Activity 4.13 Create an Index to Optimize Sorting

            Activity 4.14 Create an Index to Maintain Data Integrity

        Objective 5: Create Relationships between Tables

            Activity 4.15 Establish a One-to-One Relationship

            Activity 4.16 Work with Related Tables

            Activity 4.17 Create a One-to-Many Relationship

            Activity 4.18 Create a Many-to-Many Relationship

        Objective 6: Create Forms and Reports with Related Tables

            Activity 4.19 Create a Relationships Report

            Activity 4.20 Create a Query Using Related Tables

            Activity 4.21 Create a Form Using Related Tables

 

Chapter 5 Automate Data Entry with Forms (Rock Ridge Lighting)

 

    PROJECT 7A - Sales Opportunities

        Objective 1: Customize Form Views and Formats

            Activity 5.1 Create a Split Form

            Activity 5.2 Create a Multiple Items Form

            Activity 5.3 Create an Advanced Filter

        Objective 2: Add Controls to Forms

            Activity 5.4 Build a Form in Design View

            Activity 5.5 Align Controls Using Arrange Tools

            Activity 5.6 Add a List Box with a Typed List

            Activity 5.7 Add a Calculated Control

            Activity 5.8 Add an Option Button Group

            Activity 5.9 Add a Button Control

        Objective 3: Use Advanced Formatting Tools

            Activity 5.10 Set Tab Order

            Activity 5.11 Apply Conditional Formatting

            Activity 5.12 Apply Rich Text Formatting to DataPROJECT 7B - Sales Pipeline

        Objective 4: Create Forms with Subforms

            Activity 5.13 Create One-to-Many Relationships

            Activity 5.14 Create a Combo Box with Data from a Related Table

            Activity 5.15 Create a Form and Subform using the Form Wizard

            Activity 5.16 Create a Form and Subform using the Subform Control

            Activity 5.17 Format a Subform

            Activity 5.18 Format a Subform in a New Window

        Objective 5: Create a Group of Forms with a Tabbed Interface

            Activity 5.19 Add Tabbed Pages and Add Fields to Pages

            Activity 5.20 Format Tabbed Pages

            Activity 5.21 Add a Page and Insert a Chart

 

Chapter 6 Advanced Reports (The Petite Book)

 

    PROJECT 8A Order Fulfillment

        Objective 1: Build Reports Based on Queries

            Activity 6.1 Build a Select Query

            Activity 6.2 Build a report Based on a Select Query

            Activity 6.3 Add Automatic Line Numbers and a Record Count

            Activity 6.4 Optimize a Report for Black and White Printing

            Activity 6.5 Build and Modify Queries Using Copy and Paste

            Activity 6.6 Build and Modify Reports Using Copy and Paste

        Objective 2: Export Reports

            Activity 6.7 Export Reports as Web Pages

            Activity 6.8 Export Reports for the Snapshot Viewer

        Objective 3: Create a Labels Report

            Activity 6.9 Create an Aggregate Function Query

            Activity 6.10 Create a Labels ReportROJECT 8B Sales Reports

        Objective 4: Create a Subreport Using Design Tools

            Activity 6.11 Create a Report Using Report Design

            Activity 6.12 Create a Subreport using the SubReport Wizard

            Activity 6.13 Format a Report and Subreport

        Objective 5: Summarize Report Data

            Activity 6.14 Add Calculated Controls

            Activity 6.15 Create a Summary Report

            Activity 6.16 Insert and Format a Chart

            Activity 6.17 Filter and Print a Report

        Objective 6: Create a Report with an Interactive Filter

            Activity 6.18 Build a Daily Sales Report

            Activity 6.19 Create a Filter That Asks for User Input