For advanced courses in spreadsheets and databases using Microsoft Office Excel and Access 2003 applications. This series will appeal to students in a variety of disciplines including liberal arts, business, and the sciences.
This series gives the “how and why” of performing tasks in Office 2003. It provides new chapter opening case studies, numerous hands-on real-world practice exercises; full business and integrated end of chapter cases, and expert topics of Microsoft Office 2003. More than two million students have used previous editions of this highly successful series!
Published to Address User and Market Feedback
Based on your feedback and the changing nature of the introduction to computers course (i.e.–students with increasing skill levels and the importance of teaching them extensive Excel and Access skills), we are now providing an Advanced Edition text as part of the Exploring Series.
The Advanced Edition will provide students with intermediate to advanced knowledge of Excel and Access. This text is perfect for instructors who want to cover more advanced Excel and Access topics that cover SQL and Visual Basic programming topics in relation to Excel and Access Office 2003 programs, including database customization, data analysis and reporting.
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
About the Author :
DR. PHILIP A. KONEMAN
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.
