Microsoft Office Access 2003: Comprehensive Concepts and Techniques, CourseCard Edition / Edition 2

by Gary B. Shelly, Thomas J. Cashman, Philip J. Pratt, Mary Z. Last

Overview

Enjoy the proven step-by-step style and improved Access 2003 updates of the Shelly Cashman Seriesr and enhance your Office application skills today! Benefits:
• Nine projects, an Integration Feature, a Web Feature, SQL Feature, and six appendices offer a comprehensive presentation of Access 2003. Includes material for a ten- to fifteen-week period in a course that teaches Access 2003 as the primary component.
• We've made our Access textbook easier than ever to follow! With a more streamlined design, easy to follow steps and screen shots, your students will find this book to be an essential learning reference.
• Includes coverage of the new features of Microsoft Access, such as: automatic error checking, using smart tags, importing and linking SharePoint lists to Access databases, setting macro security, and changing the font size for SQL queries.
• Extensive end-of-project exercises, including the unique Learn It Online activities, reinforce the concepts and skills learned.
• NEW! Free perforated Access 2003 CourseCard back cover provides students a quick reference to Office 2003 skills at their fingertips.

Product Details

ISBN-13:	9781418843632
Publisher:	Cengage Learning
Publication date:	03/30/2005
Series:	Shelly Cashman Series
Edition description:	REV
Pages:	688
Product dimensions:	8.40(w) x 10.80(h) x 0.90(d)

About the Author

Gary B. Shelly wrote and published his first computer education textbook in 1969. More than twenty million copies of Shelly Cashman Series' textbooks have been sold. Gary and a talented group of contributing authors have produced books on computer programming, computer concepts, and application software that are the leading textbooks in the computer technology market today. Gary has hosted the annual Shelly Cashman Institute, a week-long training event focusing on the latest topics in technology, for the past 34 years.

Thomas J. Cashman received his education at California State University, Los Angeles. He established one of the first business data processing programs in the U.S. at Long Beach City College in California, where he taught and served as department head. In 1969, he began collaborating with now best-selling author, Gary Shelly.

Philip J. Pratt is Professor Emeritus of Mathematics and Computer Science at Grand Valley State University, where he taught for 33 years. His teaching interests include database management, systems analysis, complex analysis, and discrete mathematics. He has authored over 60 textbooks, including coauthoring three levels of Microsoft Office Access 2010 books for the Shelly Cashman Series and A Guide to SQL.

Mary Z. Last has taught computer information systems since 1984. She retired from the University of Mary Hardin-Baylor, Belton, TX where she was an Associate Professor and the Director of the Center for Effectiveness in Learning and Teaching. Mary is actively involved in the Computing Educator's Oral History Project that encourages young women to pursue careers in math and science. She has been a contributing author to the Shelly Cashman Series since 1992 and also authors many instructor resources for database texts.

Table of Contents

1. Creating and Using a Database 2. Querying a Database Using the Select Query Window 3. Maintaining a Database Using the Design and Update Features of Access Integration Feature: Sharing Data among Applications 4. Reports, Forms, and Combo Boxes 5. Enhancing Forms with OLE Fields, Hyperlinks, and Subforms 6. Switchboards, PivotTables, and PivotCharts Web Feature: Data Access Pages 7. Advanced Report and Form Techniques 8. Using Visual Basic for Applications (VBA) and Creating Multi-Page Forms 9. Administering a Database System SQL Feature: Using SQL Appendices A: Microsoft Access Help System B: Speech and Handwriting Recognition C: Publishing Office Web Pages to a Web Server D: Changing Screen Resolution and Resetting the Access Toolbars and Menus E: Microsoft Office Specialist Certification F: Database Design

Editorial Reviews

"The Shelly Cashman Series is to computer applications as Kleenex is to tissue." - Instructor Diane Folse

"I use the Cases and Places exercises as graded assignments, as well as for extra credit. They provide little guidance; the student has to apply what they learned in the project itself. This allows for flexibility; the student can use the formatting and layout that they want to in solving the problem. The solution files provided on CD make it convenient for grading/correcting as well as demonstration. I plan to continue to use the Shelly Cashman Series in my online and traditional course. The student feedback on the text is excellent. In fact, most students say they will keep the text as a source for future reference." - Associate Professor Thaddeus Jones, Jefferson Community College

" Shelly Cashman Series is the most comprehensive tool to prepare students for the Microsoft Office Specialist certification and future employment. The text is very thorough and closely aligns the teaching objectives to the Microsoft Office Specialist skill sets. The exercises in the text are also accurately mapped to the exams." - Professor Juanita H. Marquez, El Centro College

"After using your text this past semester, I think it is great! The instructor's supplemental material (tests, practice, PowerPoint slides, etc...) make the teaching task easier! The book and supporting materials are ten times better than our previous text." - Dr. Stanley E Meyers, Norwalk Community College

From the Publisher