Higher Education

Microsoft® Office Access 2007: Comprehensive Concepts and Techniques, 1st Edition

  • Gary B. Shelly
  • Thomas J. Cashman
  • Philip J. Pratt Grand Valley State University
  • Mary Z. Last
  • ISBN-10: 1418843415  |  ISBN-13: 9781418843410
  • 792 Pages
  • © 2008 | Published
  • College Bookstore Wholesale Price = $144.75
  • Newer Edition Available
  *Why an online review copy?
  • It's the greener, leaner way to review! An online copy cuts down on paper and on time. Reduce the wait (and the weight) of printed texts. Your online copy arrives instantly, and you can review it anytime from your computer or favorite mobile device.

If you prefer a print copy to review, please contact your representative.



Introduce your students to the new generation of Microsoft Office with the new generation of Shelly Cashman Series books! For the past three decades, the Shelly Cashman Series has effectively introduced computer skills to millions of students. With Access 2007, we're continuing our history of innovation by enhancing our proven pedagogy to reflect the learning styles of today's students. In Microsoft Access 2007: Comprehensive Concepts and Techniques you'll find features that are specifically designed to engage students, improve retention, and prepare them for future success. Our trademark step-by-step, screen-by-screen approach now encourages students to expand their understanding of the Access 2007 software through experimentation, exploration, and planning ahead. Brand new end of chapter exercises prepare students to become more capable software users by requiring them to use critical thinking and problem-solving skills to create real-life documents.

Features and Benefits

  • Gives students a comprehensive presentation of Access 2007, including new features of the software, using the highly-successful Shelly Cashman Series pedagogy.
  • Meets the requirements of the Microsoft Certified Application Specialist exam for Microsoft Office Access 2007.

Table of Contents

1. Creating and Using a Database
2. Querying a Database
3. Maintaining a Database
Integration Feature: Sharing Data Among Applications
4. Creating Reports and Forms
5. Multi-Table Forms
6. Using Macros, Switchboards, PivotTables, and PivotCharts
SQL Feature: Using SQL
7. Advanced Report Techniques
8. Advanced Form Techniques
9. Administering a Database System
Web Feature: Sharing Access Data

A: Project Planning Guidelines
B: Introduction to Microsoft Office 2007
C: Microsoft Office Access 2007 Help
D: Publishing Office 2007 Web Pages to a Web Server
E: Customizing Microsoft Office Access 2007
F: Steps for the Windows XP User
G: Microsoft Business Certification Program
H: Database Design

What's New

  • Offers a new Plan Ahead feature which prepares students to create successful projects by encouraging them to think about what they are trying to accomplish before they begin.
  • Gives students the information they need to know when they need to know it through enhancements to the step-by-step instructions, a new Q&A feature, and improved call-outs.
  • Increases students' retention with brand new end-of-chapter exercises, including Make It Right, Extend Your Knowledge, and Make It Personal, which emphasize problem-solving and experimentation.
  • Engages students with new Experimental steps, which encourage them to go beyond step-by-step instructions to take advantage of the features in the Microsoft Office 2007 new user interface.

Alternate Formats

Choose the format that best fits your student's budget and course goals

To customize your learning solution, contact your Learning Consultant for more information.

  • Introductory: Chapters 1-3; 1 Special Feature; Appendices

    ISBN-10: 1418843393  | ISBN-13: 9781418843397

    List Price = $87.95  | College Bookstore Wholesale Price = $66.00

  • Complete: Chapters 1-6; 2 Special Features; Appendices

    ISBN-10:  1418843407 | ISBN-13:  9781418843403

    List Price = $144.95  | CengageBrain Price = $144.95  | College Bookstore Wholesale Price = $108.75


All supplements have been updated in coordination with the main title. Select the main title's "About" tab, then select "What's New" for updates specific to title's edition.

For more information about these supplements, or to obtain them, contact your Learning Consultant.

Instructor Supplements

Instructor Resource CD-ROM  (ISBN-10: 1423912268 | ISBN-13: 9781423912262)

Bundle: Microsoft Office Access 2007: Comprehensive Concepts and Techniques + Microsoft® Office Excel 2007: Comprehensive Concepts and Techniques  (ISBN-10: 1428326723 | ISBN-13: 9781428326729)

List Price = $366.95  | CengageBrain Price = $366.95  | College Bookstore Wholesale Price = $275.21

Student Supplements

Bundle: Microsoft Office Access 2007: Comprehensive Concepts and Techniques + Microsoft® Office Excel 2007: Comprehensive Concepts and Techniques  (ISBN-10: 1428326723 | ISBN-13: 9781428326729)

List Price = $366.95  | CengageBrain Price = $366.95  | College Bookstore Wholesale Price = $275.21

Meet the Author

Author Bio

Gary B. Shelly

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

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

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 more than 75 textbooks and has co-authored three levels of Microsoft® Office Access 2013 books for this popular Shelly Cashman Series and A Guide to SQL.

Mary Z. Last

Mary Z. Last has taught computer information systems since 1984. She retired from the University of Mary Hardin-Baylor, Belton, Texas, where she was an Associate Professor and the Director of the Center for Effectiveness in Learning and Teaching. Ms. Last 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. She also authors many instructor resources for database texts.