Star Wars Sale

Special Offers see all

Enter to WIN!

Weekly drawing for $100 credit. Subscribe to for a chance to win.
Privacy Policy

More at Powell's

Recently Viewed clear list

Original Essays | June 20, 2014

Lauren Owen: IMG The Other Vampire

It's a wild and thundery night. Inside a ramshackle old manor house, a beautiful young girl lies asleep in bed. At the window, a figure watches... Continue »
  1. $18.90 Sale Hardcover add to wish list

    The Quick

    Lauren Owen 9780812993271


This item may be
out of stock.

Click on the button below to search for this title in other formats.

Check for Availability
Add to Wishlist

Other titles in the Exploring Series series:

Access & Excel 2003


Access & Excel 2003 Cover


Synopses & Reviews

Publisher Comments:

For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.

Master the How and Why of Office 2003!  Students master the "How and Why" of performing tasks in Office and gain a greater understanding of how to use the individual applications together to solve business problems.

About the Author


Dr. Koneman has over ten years of experience in computers and education. He is an Associate Professor of Computer Information Systems and Advanced Computer Applications at Colorado Christian University. His teaching responsibilities include Introduction to Computer Applications, where students learn the primary applications in Microsoft Office 2000 Premium Edition.


Dr. Koneman has a broad professional portfolio that includes a variety of activities outside the university. He assisted Nivo International in defining the MOUS Certification objectives for Office 2000. In addition to being an author on numerous Select modules; he is also the Series Consulting Editor for the entire Select series. Dr. Koneman is President of Instructional Design Consultants, Inc., a company that develops educational multimedia and provides consulting for curriculum design and educational measurement.


Dr. Koneman received his Ph.D. from the University of Colorado at Denver, School of Education, Division of Instructional Technology. His research interests include computer-based learning, educational testing and measurement, and ethical issues in computers and technology. He is a certified Microsoft Office User Specialist for Office 2000.


Table of Contents

Chapter 1 - Using Excel to Model Data and Make Decisions

Using Excel for What-If Analysis

Using Function to Calculate Consulting Revenue and Expenses

Analyzing Utilization Data

Chapter 2 - Using Queries and SQL to Manage and Analyze Data

Access Tables, Relationships, and Query Tables

Using Structured Query Language (SQL)

Linking an Excel Workbook and Creating a Table with a Make-Table Query

Importing Records from Excel and Creating an Archive Table

Using Access Queries to Analyze Consulting Profitability

Summarize Data on Multiple Fields Using Crosstab Queries

Chapter 3 - XML in Microsoft Office 2003

XML and Markup Languages

Using XML

XML and Microsoft Excel 2003

XML and Microsoft Access 2003

Creating a Query to Export Data as XML

Put It All Together: Using XML to Display Consulting Revenue Summaries on the Web

Chapter 4 - Learning to Program with Visual Basic for Applications (VBA)

Visual Basic for Applications

VBA in Excel and Access

Modules and Procedures

Display Messages Using VBA

Variables and Constants

User Input

Perform Calculations with Variables and Constants and Format Results

Chapter 5 - Using Programming Structures in Visual Basic for Applications (VBA)

Programming Structures

Repetition Structures

Anticipate and Trap Errors

Chapter 6 - Customizing Excel with Visual Basic for Applications (VBA)

Develop Custom Applications in Excel Using a Software Development Cycle

Objects and the Excel Object Model

Visual Basic Forms

Plan and Design a Data Entry Form

Use Functions

Initialize, Display and Close Forms

Chapter 7 - Customizing Access Databases Using Visual Basic for Applications (VBA)

Create Custom Forms in Access

Access Modules

Use the Active Data Object (ADO) and Recordset Objects

Perform Calculations with Procedures

Use Procedures to Calculate Federal and State Payroll Withholding Taxes

Create Additional Procedures to Add Functionality to the Application

Export Data as XML

Chapter 8 - Summarizing and Reporting Data in Excel and Access

Excel Lists, PivotTable Reports, and PivotChart Reports

Group Data in Excel PivotTable and PivotChart Reports

Summarize and Report Data in Microsoft Access

Chapter 9 - Use Smart Tags in Office 2003

Use HTML Data in Excel and Access

Publish Excel Worksheets and Workbooks to the Web

Data Access Pages

Appendix — Data Normalization

Database Design

Normalization and the Normal Forms

Product Details

Prentice Hall
Koneman, Philip A.
Database management
Business Software - MSOffice
Desktop Applications - MS Access
Spreadsheets - Excel
Spreadsheets - General
Presentation graphics software
Business -- Computer programs.
Personal Computers-Desktop Applications-Databases
Edition Description:
Trade paper
Grauer Exploring Office 2003 Series
Publication Date:
January 2005
Grade Level:
College/higher education:
10.83x8.71x.68 in. 2.35 lbs.

Related Subjects

» Arts and Entertainment » Music » General
» Computers and Internet » Personal Computers » Desktop Applications » Databases
» Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
» Computers and Internet » Personal Computers » Desktop Applications » Suites
» Health and Self-Help » Health and Medicine » General
» Health and Self-Help » Health and Medicine » General Medicine

Access & Excel 2003
0 stars - 0 reviews
$ In Stock
Product details 512 pages Prentice Hall - English 9780131466401 Reviews:
  • back to top
Follow us on...

Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at