Amazon no longer offers textbook rentals. We do!

Microsoft Office Access 2003, Illustrated Complete, CourseCard Edition

by: Friedrichsen, Lisa

Microsoft Office Access 2003, Illustrated Complete, CourseCard Edition

by: Friedrichsen, Lisa

ISBN 13:
9781418842994
ISBN 10:
1418842990
Edition: 1st
Format: Paperback
Copyright: 03/31/2005
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 Illustrated series, this text offers a visual, flexible way to build basic to advanced Microsoft Access 2003 skills.

Preface

WINDOWS XP

Getting Started with Windows XP

(1)

Starting Windows and Viewing the Desktop

(2)

Accessing the Internet from the Desktop

Using the Mouse

(2)

Starting a Program

(2)

Customizing the Start Menu

Moving and Resizing Windows

(2)

More about sizing windows

Using Menus, Keyboard Shortcuts, and Toolbars

(2)

Using Dialog Boxes

(2)

Using Scroll Bars

(2)

Using Windows Help and Support Center

(2)

Other forms of Help

Closing a Program and Shutting Down Windows

(2)

The Log Off command

Concepts Review

(1)

Skills Review

(2)

Independent Challenges

(1)

Visual Workshop

WINDOWS XP

Working with Programs, Files, and Folders

(1)

Creating and Saving a WordPad Document

(2)

Opening, Editing, and Saving an Existing Paint File

(2)

Working with Multiple Programs

(2)

Other Programs that Come with Windows XP

Understanding File Management

(2)

Viewing Files and Creating Folders with My Computer

(2)

Moving and Copying Files with My Computer

(2)

Managing Files with Windows Explorer

(2)

Searching for Files

(2)

Accessing files, folders, programs, and drives you use often

Deleting and Restoring Files

(2)

Customizing your Recycle Bin

Concepts Review

(1)

Skills Review

(1)

Independent Challenges

(2)

Visual Workshop

WINDOWS XP

Formatting a Floppy Disk

(1)

Formatting a Floppy Disk

(2)

More about disks

Data Files

ACCESS 2003

Getting Started with Access 2003

(1)

Understanding Relational Databases

(2)

Learning Database Terminology

(2)

Starting Access and Opening a Database

(2)

Personalized toolbars and menus in Access 2003

Working with the Database Window

(2)

Viewing objects

Navigating Records

(2)

Changing to Edit mode

Entering Records

(2)

Moving datasheet columns

Editing Records

(2)

Resizing datasheet columns

Previewing and Printing a Datasheet

(2)

Hiding fields

Getting Help and Exiting Access

(2)

Compact on Close

Concepts Review

(1)

Skills Review

(1)

Independent Challenges

(2)

Visual Workshop

ACCESS 2003

Using Tables and Queries

(1)

Organizing Fields

(2)

Choosing between the Text and Number data type

Planning Related Tables

(2)

Creating a Table

(2)

Modifying a Table

(2)

Learning about field properties

Formatting a Datasheet

(2)

Understanding Sorting, Filtering, and Finding

(2)

Using wildcards

Sorting Records and Finding Data

(2)

Using more than one sort field

Filtering Records

(2)

Searching for blank fields

Creating a Query

(2)

Modifying a Query

(2)

Understanding And and Or criteria

Concepts Review

(1)

Skills Review

(2)

Independent Challenges

(3)

Visual Workshop

ACCESS 2003

Using Forms

(1)

Planning a Form

(2)

Creating a Form

(2)

Using the AutoForm button

Moving and Resizing Controls

(2)

Modifying Labels

(2)

Using Text Boxes for Calculations

(2)

Modifying Tab Order

(2)

Entering, Editing, and Printing Records

(2)

Inserting an Image

(2)

Concepts Review

(2)

Skills Review

(2)

Independent Challenges

(4)

Visual Workshop

ACCESS 2003

Using Reports

(1)

Planning a Report

(2)

Creating a Report

(2)

Why reports should be based on queries

Using Group Sections

(2)

Changing the Sort Order

(2)

Adding a field to a report

Adding a Calculation

(2)

Aligning Controls

(2)

Precisely moving and resizing controls

Formatting Controls

(2)

Changing Page Layout

(2)

Concepts Review

(2)

Skills Review

(2)

Independent Challenges

(4)

Visual Workshop

ACCESS 2003

Modifying the Database Structure

(1)

Examining Relational Databases

(2)

Many-to-many relationships

Creating Related Tables

(2)

Creating foreign key fields

Creating One-to-Many Relationships

(2)

Enforcing referential integrity

Creating Lookup Fields

(2)

Modifying Text Fields

(2)

Input Mask property

Modifying Number and Currency Fields

(2)

Modifying Date/Time Fields

(2)

Smart Tags

Modifying Field Validation Properties

(2)

Concepts Review

(1)

Skills Review

(2)

Independent Challenges

(3)

Visual Workshop

ACCESS 2003

Creating Multiple Table Queries

(1)

Building Select Queries

(2)

Resizing Query Design View

Sorting a Query on Multiple Fields

(2)

Specifying a sort order different from the field order in the datasheet

Developing AND Criteria

(2)

Developing OR Criteria

(2)

Using wildcard characters in query criteria

Creating Calculated Fields

(2)

Building Summary Queries

(2)

Building Crosstab Queries

(2)

Query Wizards

Building PivotTables and PivotCharts

(2)

Concepts Review

(2)

Skills Review

(2)

Independent Challenges

(4)

Visual Workshop

ACCESS 2003

Developing Forms and Subforms

(1)

Understanding the Form/Subform Relationship

(2)

Creating Subforms Using the Form Wizard

(2)

Creating Subforms Using Queries

(2)

Linking the form and subform

Modifying Subforms

(2)

Error checking options

Adding a Combo Box for Data Entry

(2)

Choosing between a combo box and a list box

Adding a Combo Box to Find Records

(2)

Adding Option Groups

(2)

Protecting data

Adding Command Buttons

(2)

Adding ActiveX Controls

(2)

Concepts Review

(1)

Skills Review

(3)

Independent Challenges

(4)

Visual Workshop

ACCESS 2003

Sharing Information and Improving Reports

(1)

Importing Data

(2)

Applying Conditional Formatting

(2)

Adding Lines

(2)

Line troubles

Using the Format Painter and AutoFormats

(2)

Creating summary reports

Creating a Dynamic Web Page

(2)

Exporting Data

(2)

Compacting and Repairing a Database

(2)

Object dependencies

Backing Up a Database

(2)

Backing up an entire folder to floppy disks

Concepts Review

(2)

Skills Review

(2)

Independent Challenges

(4)

Visual Workshop

ACCESS 2003

Sharing Access Information with Other Office Programs

(1)

Examining Access Objects

(2)

Setting Relationships

(2)

Importing XML Data

(2)

Linking Data

(2)

Publishing Data to Word

(2)

Analyzing Data with Excel

(2)

Merging Data with Word

(2)

Exporting Data to XML

(2)

Using an Access Project with SQL Server

(2)

Concepts Review

(2)

Skills Review

(2)

Independent Challenges

(2)

Visual Workshop

ACCESS 2003

Creating Data Access Pages

(1)

Understanding the World Wide Web

(2)

Creating Hyperlink Fields

(2)

Understanding the Universal Naming Convention

Creating Pages for Interactive Reporting

(2)

Creating Pages for Data Entry

(2)

Creating PivotTables

(2)

Creating PivotCharts

(2)

Adding Hyperlinks

(2)

Creating a hyperlink from an image

Publishing Web Pages to Web Servers

(2)

The connection between the Web page and database file

Concepts Review

(2)

Skills Review

(3)

Independent Challenges

(3)

Visual Workshop

ACCESS 2003

Creating Advanced Queries

(1)

Querying for Top Values

(2)

Creating a Parameter Query

(2)

Modifying Query Properties

(2)

Creating a Make-Table Query

(2)

Creating an Append Query

(2)

1900 versus 2000 dates

Creating a Delete Query

(2)

Reviewing referential integrity

Creating an Update Query

(2)

Specifying Join Properties

(2)

Null and zero-length string values

Creating Find Unmatched Queries

(2)

Find Duplicate Query Wizard

Concepts Review

(2)

Skills Review

(3)

Independent Challenges

(3)

Visual Workshop

ACCESS 2003

Creating Advanced Forms and Reports

(1)

Adding Check Boxes and Toggle Buttons

(2)

Using Conditional Formatting in a Form

(2)

Creating Custom Help

(2)

Adding Tab Controls

(2)

Adding Charts

(2)

Modifying Charts

(2)

Adding Subreport Controls

(2)

Modifying Section Properties

(2)

Using Domain Functions

(2)

Concepts Review

(1)

Skills Review

(2)

Independent Challenges

(3)

Visual Workshop

ACCESS 2003

Managing Database Objects

(1)

Working with Objects

(2)

Updating names with Name AutoCorrect

Using the Documenter

(2)

Viewing object dependencies

Grouping Objects

(2)

Modifying Shortcuts and Groups

(2)

Speech recognition--interface of the future?

Creating a Dialog Box

(2)

Creating a Pop-up Form

(2)

Creating a Switchboard

(2)

Modifying a Switchboard

(2)

The Northwind database

Concepts Review

(1)

Skills Review

(2)

Independent Challenges

(3)

Visual Workshop

ACCESS 2003

Creating Macros

(1)

Understanding Macros

(2)

Creating a Macro

(2)

Modifying Actions and Arguments

(2)

Creating a Macro Group

(2)

Assigning a macro to a key combination

Setting Conditional Expressions

(2)

Working with Events

(2)

Assigning a macro to a command button

Customizing Toolbars

(2)

Troubleshooting Macros

(2)

Converting a macro to VBA

Concepts Review

(1)

Skills Review

(2)

Independent Challenges

(3)

Visual Workshop

ACCESS 2003

Creating Modules and VBA

(1)

Understanding Modules and VBA

(2)

Comparing Macros and Modules

(2)

Creating Functions

(2)

Using If Statements

(2)

Documenting Procedures

(2)

Creating Class Modules

(2)

Creating Sub Procedures

(2)

Troubleshooting Modules

(2)

Using Visual Basic screen prompts

Concepts Review

(1)

Skills Review

(2)

Independent Challenges

(3)

Visual Workshop

ACCESS 2003

Managing the Database

(1)

Converting Databases

(2)

Converting from Access 2000 to Access 2002-2003

Setting Passwords

(2)

Creating workgroups

Changing Startup Options

(2)

Encoding a Database

(2)

Creating an MDE file

Analyzing Performance

(2)

Splitting a Database

(2)

Client/Server computing

Replicating a Database

(2)

Using a Briefcase folder

Synchronizing a Database

(2)

Using the Briefcase with a laptop computer

Concepts Review

(1)

Skills Review

(1)

Independent Challenges

(2)

Visual Workshop

Glossary

(12)

Index

Amazon no longer offers textbook rentals. We do!

Microsoft Office Access 2003, Illustrated Complete, CourseCard Edition

Microsoft Office Access 2003, Illustrated Complete, CourseCard Edition

9781418842994

1418842990

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Microsoft Office Access 2003, Illustrated Complete, CourseCard Edition

Microsoft Office Access 2003, Illustrated Complete, CourseCard Edition

9781418842994

1418842990

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products