Amazon no longer offers textbook rentals. We do!

Microsoft Access 2000

by: SHELLY/CASHMAN/PRATT

Microsoft Access 2000

by: SHELLY/CASHMAN/PRATT

ISBN 13:
9780789556103
ISBN 10:
0789556103
Format: Paperback
Copyright: 12/20/1999
Publisher: Course Technology
Newer Edition

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

Part of the highly successful Shelly Cashman series, this comprehensive text offers a step-by-step, screen-by-screen approach that goes beyond the basics to teach introductory and advanced topics of Microsoft Access 2000. Covers Microsoft Access 2000 topics such as maintaining and querying a database, creating custom toolbars, menus, writing visual basic code, and more. This text includes nine complete projects that cover beginning and advanced Microsoft Access 2000 skills

Creating A Database Using Design and Datasheet Views

Objectives

(5)

What is Microsoft Access 2000?

(1)

Project One --- Bavant Marine Services Database

(6)

Starting Access and Creating a New Database

(3)

The Access Desktop and the Database Window

(1)

Creating a Table

(6)

Defining the Fields

(3)

Correcting Errors in the Structure

(1)

Saving a Table

(1)

Adding Records to a Table

(4)

Closing a Table and a Database and Quitting Access

(1)

Opening a Database

(2)

Adding Additional Records

(3)

Correcting Errors in the Data

(1)

Previewing and Printing the Contents of a Table

(4)

Creating Additional Tables

(2)

Adding Records to the Additional Table

(1)

Using a Form to View Data

(7)

Creating a Form

(1)

Closing and Saving the Form

(1)

Opening the Saved Form

(1)

Using the Form

(1)

Switching Between Form View and Database View

(2)

Creating a Report

(6)

Selecting the Fields for the Report

(2)

Completing the Report

(2)

Printing the Report

(1)

Closing the Database

(1)

Access Help System

(2)

Using the Office Assistant

(2)

Designing a Database

(3)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(2)

In the Lab

(6)

Cases and Places

Querying a Database Using the Select Query Window

Objectives

(3)

Introduction

(1)

Project Two --- Querying the Bavant Marine Services Database

(2)

Opening the Database

(1)

Creating a New Query

(8)

Using the Select Query Window

(1)

Displaying Selected Fields in a Query

(2)

Running a Query

(1)

Printing the Results of a Query

(1)

Returning to Design View

(2)

Closing a Query

(1)

Including All Fields in a Query

(2)

Clearing the Design Grid

(1)

Entering Criteria

(6)

Using Text Data in Criteria

(1)

Using Wildcards

(1)

Criteria for a Field Not in the Result

(2)

Using Numeric Data in Criteria

(1)

Using Comparison Operators

(1)

Using Compound Criteria

(3)

Using AND Criteria

(2)

Using OR Criteria

(1)

Sorting Data in a Query

(5)

Sorting on Multiple Keys

(2)

Omitting Duplicates

(2)

Joining Tables

(4)

Restricting Records in a Join

(1)

Using Calculated Fields in a Query

(3)

Calculating Statistics

(4)

Using Criteria in Calculating Statistics

(1)

Grouping

(1)

Saving a Query

(1)

Closing a Database

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(3)

Cases and Places

Maintaining a Database Using the Design and Update Features of Access

Objectives

(3)

Introduction

(1)

Project Three --- Maintaining the Bavant Marine Services Database

(1)

Opening the Database

(1)

Adding, Changing, and Deleting Records in a Table

(9)

Adding Records in a Table

(2)

Searching for a Record

(2)

Changing the Contents of a Record

(1)

Switching Between Views

(1)

Filtering Records

(2)

Deleting Records

(1)

Changing the Structure of a Database

(13)

Changing the Size of a Field

(2)

Adding a New Field

(2)

Deleting a Field from a Table

(1)

Updating the Restructured Database

(1)

Resizing Columns

(3)

Using an Update Query

(3)

Using a Delete Query to Delete a Group of Records

(2)

Creating Validation Rules

(10)

Specifying a Required Field

(1)

Specifying a Range

(1)

Specifying a Default Value

(1)

Specifying a Collection of Legal Values

(1)

Using a Format

(1)

Saving Rules, Values, and Formats

(1)

Updating a Table that Contains Validation Rules

(2)

Making Individual Changes to a Field

(2)

Specifying Referential Integrity

(3)

Using Subdatasheets

(1)

Ordering Records

(2)

Ordering Records on Multiple Fields

(1)

Creating and Using Indexes

(6)

How Does Access Use an Index?

(1)

When Should You Create an Index?

(1)

Creating Single-Field Indexes

(1)

Creating Multiple-Field Indexes

(2)

Closing the Database

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(6)

Cases and Places

WEB FEATURE

Publishing to the Internet using Data Access pages

(1)

Introduction

(2)

Opening the Database

(1)

Creating a Data Access Page

(5)

Previewing the Data Access Page

(1)

Using the Data Access Page

(1)

Web Feature Summary

(1)

What You Should Know

(1)

In the Lab

Reports, Forms and Combo Boxes

Objectives

(3)

Introduction

(3)

Opening the Database

(1)

Report Creation

(11)

Creating a Query

(1)

Creating a Report

(4)

Moving to Design View and Docking the Toolbox

(1)

Report Sections

(1)

Changing Properties

(2)

Closing and Saving a Report

(1)

Printing a Report

(1)

Grouping in a Report

(5)

Creating a Second Report

(5)

Reviewing the Report Design

(7)

Removing Unwanted Controls

(2)

Enlarging the Page Header Section

(1)

Changing Column Headings

(1)

Moving and Resizing Controls

(3)

Previewing a Report

(1)

Closing and Saving a Report

(1)

Printing a Report

(1)

Report Design Considerations

(1)

Creating and Using Custom Forms

(20)

Beginning the Form Creation

(2)

Modifying the Form Design

(2)

Adding a New Field

(1)

Changing the Format of a Field

(1)

Combo Boxes

(6)

Adding a Title

(4)

Enhancing a Title

(1)

Changing Tab Stops

(1)

Closing and Saving a Form

(1)

Opening a Form

(1)

Using a Form

(1)

Closing a Form

(1)

Form Design Considerations

(1)

Closing the Database

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(4)

Cases and Places

Enhancing Forms with OLE Fields, Hyperlinks, and Subforms

Objectives

(3)

Introduction

(1)

Project Five --- Enhancing the Bavant Marine Services Forms

(1)

Opening the Database

(1)

Date, Memo, OLE, and Hyperlink Fields

(1)

Adding Fields to a Table

(3)

Updating the New Fields

(11)

Updating Data Fields

(2)

Updating Memo Fields

(1)

Changing the Row and Column Size

(2)

Updating OLE Fields

(3)

Updating Hyperlink Fields

(2)

Saving the Table Properties

(1)

Advanced Form Techniques

(25)

Creating a Form with a Subform Using the Form Wizard

(5)

Modifying the Subform Design

(1)

Modifying the Form Design

(2)

Moving and Resizing Fields

(1)

Moving Labels

(1)

Resizing a Label

(1)

Moving Remaining Fields

(1)

Changing Label Alignment

(2)

Resizing the Labels

(1)

Changing the Size Mode of a Picture

(1)

Changing the Special Effects and Colors of Labels

(4)

Adding a Form Title

(2)

Viewing Data and Web Pages Using the Form

(3)

Using Date and Memo Fields in a Query

(1)

Closing the Database

(3)

Compacting a Database

(2)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(6)

Cases and Places

Creating an Application System Using Macros, Wizards, and the Switchboard Manager

Introduction

(3)

Project Six --- Creating an Application System for Bavant Marine Services

(1)

Opening the Database

(1)

Lookup and Input Mask Wizards

(3)

Using the Lookup Wizard

(3)

Using the Input Mask Wizard

(4)

Entering Data Using an Input Mask

(1)

Using the Lookup Wizard Field

(1)

Modifying a Report

(9)

Resizing and Moving Controls in a Report

(2)

Adding Controls to a Report

(5)

Previewing a Report

(1)

Modifying the Form

(4)

Adding Controls to a Form

(2)

Changing the Tab Order

(1)

Creating and Using Macros

(10)

The Macro Window

(1)

Adding Actions to and Saving a Macro

(2)

Running a Macro

(1)

Modifying a Macro

(2)

Errors in Macros

(1)

Additional Macros

(1)

Copying a Macro

(3)

Modifying the Copied Macro

(3)

Macro Arguments

(1)

Creating Additional Macros

(1)

Running the Macros

(1)

Creating and Using a Switchboard

(10)

Creating a Switchboard

(2)

Creating Switchboard Pages

(1)

Modifying Switchboard Pages

(3)

Modifying the Other Switchboard Pages

(2)

Using a Switchboard

(2)

Closing the Switchboard and Database

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(6)

Cases and Places

INTEGRATION FEATURE

Integrating Excel Worksheet Data into an Access Database

Introduction

(2)

Creating an Access Database

(1)

Importing an Excel Worksheet to an Access Database

(4)

Using the Access Table

(1)

Linking Versus Importing

(1)

Integration Feature Summary

(1)

In the Lab

Creating a Report Using Design View

Objectives

(3)

Introduction

(4)

Opening the Database

(1)

Creating the Additional Tables

(2)

Creting the New Tables

(1)

Importing the Data

(1)

Changing the Layout

(4)

Relating Several Tables

(1)

Creating a Lookup Wizard Field

(2)

Creating Join Queries

(9)

Creating a Query

(1)

Changing Join Properties

(1)

Changing Field Properties

(1)

Running the Query and Changing the Layout

(1)

Filtering the Query's Recordset

(1)

Creating a Parameter Query

(2)

Running a Parameter Query

(1)

creating Queries for Reports

(1)

Creating a Report

(23)

Creating the Initial Report

(3)

Adding the Fields

(1)

Saving the Report

(1)

Adding a Subreport

(4)

Modifying the Subreport

(5)

Moving the Subreport

(1)

Adding a Date

(2)

Adding a Page Number

(1)

Bolding Labels

(1)

Adding a Title

(3)

Changing Margins

(1)

Printing a Report

(1)

Mailing Labels

(4)

Creating Labels

(4)

Printing the Labels

(1)

Closing the Database

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(2)

In the Lab

(9)

Case and Places

Customizing Forms Using Visual Basic for Applications (VBA), Charts, and PivotTable Objects

Objectives

(3)

Introduction

(3)

Project Eight --- Using Advanced Form Techniques

(10)

Opening the Database

(1)

Enhancing the Form

(1)

Adding Command Buttons to the Form

(5)

Using the Buttons

(1)

Modifying the Add Record Button

(3)

Creating and Using Combo Boxes

(16)

Creating a Combo Box

(4)

Using the Combo Box

(2)

Issues with the Combo Box

(1)

Modifying the Combo Box

(1)

Using the Modifying Combo Box

(7)

Placing a Rectangle

(2)

Closing and Saving a Form

(1)

Opening a Form

(1)

Creating a Form Using Design View

(13)

Creating a Query for the Subform

(1)

Creating the Form

(1)

Placing a Subform

(3)

Closing and Saving the Form

(1)

Modifying the Subform

(2)

Resizing the Subform

(1)

Inserting a Chart

(4)

Inserting an Additional Chart

(1)

Adding a Title

(1)

Creating and Using PivotTable Forms

(6)

Creating a PivotTable Form

(3)

Using the PivotTable Form

(1)

Closing the Database

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(2)

In the Lab

(7)

Cases and Places

Administering a Database System

Objectives

(3)

Introduction

(2)

Project Nine --- Administering a Database System

(1)

Opening the Database

(1)

Using Microsoft Access Tools

(1)

Converting a Database to an Earlier Version

(1)

Using the Analyze Tool

(7)

Using the Table Analyzer

(4)

Using the Performance Analyzer

(1)

Using the Documenter

(2)

Integrity and Security Features

(12)

Using Input Masks

(2)

Specifying Referential Integrity Options

(2)

Updating Tables with the Cascade Options

(2)

Setting Startup Options

(1)

Setting Passwords

(2)

Encrypting a Database

(1)

Removing a Password

(2)

Creating a Grouped Data Access Page

(6)

Previewing the Data Access Page

(3)

Using Replication

(4)

Creating a Replica

(1)

Using a Replica

(2)

Synchronizing the Design Master and the Replica

(2)

SQL

(20)

Creating a New SQL Query

(1)

Including Only Certain Fields

(1)

Preparing to Enter a New SQL Command

(1)

Including All Fields

(1)

Using a Criterion Involving a Numeric Field

(1)

Using a Criterion Involving a Text Field

(1)

Using Compound Criteria

(1)

Using NOT in a Criterion

(1)

Using Computed Fields

(1)

Sorting the Results

(1)

Using Built-In Functions

(1)

Using Multiple Functions in the Same Command

(1)

Using Grouping

(2)

Restricting the Groups that Display

(1)

Joining Tables

(2)

Restricting the Records in a Join

(1)

Joining Multiple Tables

(2)

Closing the Query

(1)

Comparison with Access-Generated SQL

(1)

Closing the Database

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(5)

Cases and Places

INTEGRATION FEATURE

Using Access Data in Other Applications

Introduction

(2)

Opening the Database

(1)

Using the Export Command to Export Data to Excel

(3)

Using Drag-and-Drop to Export Data to Word

(2)

Using the Export Command to Create a Snapshot

(2)

Closing the Database

(1)

Integration Feature Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

APPENDIX A Microsoft Access 2000 Help System

(1)

Using the Access Help System

(1)

The Office Assistant

(3)

Showing and Hiding the Office Assistant

(1)

Turning the Office Assistant On and Off

(1)

Using the Office Assistant

(1)

The Microsoft Access Help Window

(4)

Using the Contents Sheet

(1)

Using the Answer Wizard Sheet

(1)

Using the Index Sheet

(2)

What's This? Command and Question Mark Button

(1)

What's This? Command

(1)

Question Mark Button

(1)

Office on the Web Command

(1)

Other Help Commands

(1)

Detect and Repair Command

(1)

About Microsoft Access Command

(1)

Use Help

APPENDIX B Publishing Office Web Pages to a Web Server

(1)

APPENDIX C Resetting the Access Menus and Toolbars

(1)

APPENDIX D Microsoft Office User Specialist Certification Program

(1)

Why Should You Get Certified?

(1)

The MOUS Exams

(1)

How Can You Prepare for the MOUS Exams?

(1)

How to Find an Authorized Testing Center

(1)

Shelly Cashman Series MOUS Web Page

(1)

Microsoft Access 2000 User Specialist Certification Map

Index

(1)

Microsoft Access 2000 Quick Reference Summary

Amazon no longer offers textbook rentals. We do!

Microsoft Access 2000

Microsoft Access 2000

9780789556103

0789556103

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Microsoft Access 2000

Microsoft Access 2000

9780789556103

0789556103

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products