Higher Education

Microsoft® Access 2013: Comprehensive, 1st Edition

  • Philip J. Pratt Grand Valley State University
  • Mary Z. Last
  • ISBN-10: 1285168968  |  ISBN-13: 9781285168968
  • 888 Pages
  • Previous Editions: 2011, 2008
  • © 2014 | Published
  • College Bookstore Wholesale Price = $152.00
  • 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.

About

Overview

Introduce your students to the latest that Microsoft Office has to offer 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 MICROSOFT ACCESS 2013, we're continuing our history of innovation by enhancing our proven pedagogy to reflect the learning styles of today's students. In this text 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 MICROSOFT ACCESS 2013 through experimentation, critical thought, and personalization. With these enhancements and more, the Shelly Cashman Series® continues to deliver the most effective educational materials for you and your students.

Additional Product Information

Features and Benefits

  • Step-by-step, screen by screen approach presents students with explanatory and navigational information when they need to know it, and addresses all learning styles to help students retain and apply skills in their personal and professional lives.
  • Proven pedagogy with an emphasis on project planning frames each chapter around a practical problem to be solved, and encourages critical thinking about how to proceed at various points in the chapter.
  • Extensive end-of-chapter activities provide a variety of reinforcement opportunities for students to apply and expand their skills.

Table of Contents

Office 2013 and Windows 8: Essential Concepts and Skills.
Office 365 Essentials.
1. Databases and Database Objects: An Introduction.
2. Querying a Database.
3. Maintaining a Database.
4. Creating Reports and Forms.
5. Multitable Forms.
6. Advanced Report Techniques.
7. Advanced Form Techniques.
8. Macros, Navigation Forms, and Data Macros.
9. Administering a Database System.
10. Using SQL.
11. Database Design.
Certification Appendix.
Index.
Quick Reference.
Important Notes for Windows 7 Users.

What's New

  • Now, when students complete projects they are told WHY each step in the process is necessary, in addition to being told what they will be doing and how to accomplish each task.
  • New mini-roadmaps are provided throughout each chapter, visually showing students where they are in the process of completing the chapter project.
  • Critical thinking has been expanded throughout the text. Consider This boxes throughout each chapter provide thought-provoking questions and problem-solving activities. Chapter-ending Consider This: Plan Ahead boxes and Consider This: Your Turn assignments engage students in critical thinking and problem-solving skills to create their own solutions. Plus, every student assignment ends with a question that requires students' thoughts and opinions.
  • New emphasis on personalization asks students to include a personal detail in their solutions to every chapter project and assignment, ensuring that each student solution will be unique.
  • New lab on integrating Cloud and Web technologies with Microsoft Access challenges students to use general guidelines to learn and investigate independently.
  • Coverage of Office 2013 and Windows 8 chapter, Database Design, SQL, Office 365, and how to perform tasks using both a mouse and touch screen methods.

Learning Resource Bundles

Choose the textbook packaged with the resources that best meet your course and student needs. Contact your Learning Consultant for more information.

ePack: Microsoft® Access 2013: Comprehensive + SAM 2013 Assessment, Training and Projects with MindTap Reader for New Perspectives on Microsoft® Office 2013, First Course

ISBN-10: 1305129334  | ISBN-13: 9781305129337

List Price = $248.95  | CengageBrain Price = $248.95  | College Bookstore Wholesale Price = $186.71

This Bundle Includes:

  • Microsoft® Access 2013: Comprehensive
    List Price = $201.95  | CengageBrain Price = $201.95  | College Bookstore Wholesale Price = $152.00
  • SAM 2013 Assessment, Training and Projects with MindTap Reader Instant Access
    List Price = $153.00  | CengageBrain Price = $153.00  | College Bookstore Wholesale Price = $153.00


ePack: Text + SAM 2013 Assessment, Training and Projects with MindTap Reader + Microsoft Office 365 180-Day Trial Instant Access

ISBN-10:  1305136128  | ISBN-13:  9781305136120

List Price = $260.95  | CengageBrain Price = $260.95  | College Bookstore Wholesale Price = $195.71

This Bundle Includes:

  • Microsoft® Access 2013: Comprehensive
    List Price = $201.95  | CengageBrain Price = $201.95  | College Bookstore Wholesale Price = $152.00
  • SAM 2013 Assessment, Training and Projects with MindTap Reader, 1 term (6 months) for Microsoft® Access 2013: Comprehensive
    List Price = $153.00  | CengageBrain Price = $153.00  | College Bookstore Wholesale Price = $153.00
  • Microsoft Office 365 180-Day Trial, 1 term (6 months) Instant Access
    List Price = $18.00  | College Bookstore Wholesale Price = $18.00


ePack: Text + SAM 2013 Assessment, Training, and Projects v1.0 Instant Access Code + Microsoft Office 365 180-Day Trial Instant Access

ISBN-10:  1305249917  | ISBN-13:  9781305249912

List Price = $250.95  | CengageBrain Price = $250.95  | College Bookstore Wholesale Price = $188.21

This Bundle Includes:

  • Microsoft® Access 2013: Comprehensive
    List Price = $201.95  | CengageBrain Price = $201.95  | College Bookstore Wholesale Price = $152.00
  • SAM 2013 Assessment, Training, and Projects v1.0 Multi-Term Instant Access
    List Price = $138.00  | CengageBrain Price = $138.00  | College Bookstore Wholesale Price = $138.00
  • Microsoft Office 365 180-Day Trial, 1 term (6 months) Instant Access
    List Price = $18.00  | College Bookstore Wholesale Price = $18.00


ePack: Printed Text: Microsoft® Access 2013: Comprehensive+ SAM 2013 Assessment, Training, and Projects v1.0 Instant Access Code + Microsoft Office 365 180-Day Trial Instant Access + Microsoft® Windows 7: Essential

ISBN-10:  1305625692  | ISBN-13:  9781305625693

List Price = $276.95  | CengageBrain Price = $276.95  | College Bookstore Wholesale Price = $207.71

This Bundle Includes:

  • Microsoft® Access 2013: Comprehensive
    List Price = $201.95  | CengageBrain Price = $201.95  | College Bookstore Wholesale Price = $152.00
  • SAM 2013 Assessment, Training, and Projects v1.0 Multi-Term Instant Access
    List Price = $138.00  | CengageBrain Price = $138.00  | College Bookstore Wholesale Price = $138.00
  • Microsoft Office 365 180-Day Trial, 1 term (6 months) Instant Access
    List Price = $18.00  | College Bookstore Wholesale Price = $18.00
  • Microsoft® Windows 7: Essential
    List Price = $37.95  | CengageBrain Price = $37.95  | College Bookstore Wholesale Price = $28.25


ePack: Text + SAM 2013 Assessment, Training and Projects with MindTap Reader Instant Access

ISBN-10:  1305240057  | ISBN-13:  9781305240056

List Price = $248.95  | CengageBrain Price = $248.95  | College Bookstore Wholesale Price = $186.71

This Bundle Includes:

  • Microsoft® Access 2013: Comprehensive
    List Price = $201.95  | CengageBrain Price = $201.95  | College Bookstore Wholesale Price = $152.00
  • SAM 2013 Assessment, Training and Projects with MindTap Reader, 1 term (6 months) for Microsoft® Access 2013: Comprehensive
    List Price = $153.00  | CengageBrain Price = $153.00  | College Bookstore Wholesale Price = $153.00


ePack: Text + MindLink for SAM 2013 Assessment, Training, and Projects with MindTap Reader

ISBN-10:  130542705X  | ISBN-13:  9781305427051

List Price = $248.95  | CengageBrain Price = $248.95  | College Bookstore Wholesale Price = $186.71

This Bundle Includes:

  • Microsoft® Access 2013: Comprehensive
    List Price = $201.95  | CengageBrain Price = $201.95  | College Bookstore Wholesale Price = $152.00
  • MindLink for SAM 2013 Assessment, Training, and Projects with MindTap Reader, (6 months) Instant Access
    List Price = $153.00  | CengageBrain Price = $153.00  | College Bookstore Wholesale Price = $153.00


ePack: Text + SAM 2013 Assessment, Training, and Projects v1.0 Instant Access Code

ISBN-10:  1305249577  | ISBN-13:  9781305249578

List Price = $237.95  | CengageBrain Price = $237.95  | College Bookstore Wholesale Price = $178.46

This Bundle Includes:

  • Microsoft® Access 2013: Comprehensive
    List Price = $201.95  | CengageBrain Price = $201.95  | College Bookstore Wholesale Price = $152.00
  • SAM 2013 Assessment, Training, and Projects v1.0 Multi-Term Instant Access
    List Price = $138.00  | CengageBrain Price = $138.00  | College Bookstore Wholesale Price = $138.00


ePack: Text + SAM 2013 Assessment, Training, and Projects v1.0 Instant Access Code + Microsoft Office 365 180-Day Trial Instant Access

ISBN-10:  130552621X  | ISBN-13:  9781305526211

List Price = $250.95  | CengageBrain Price = $250.95  | College Bookstore Wholesale Price = $188.21

This Bundle Includes:

  • Microsoft® Access 2013: Comprehensive
    List Price = $201.95  | CengageBrain Price = $201.95  | College Bookstore Wholesale Price = $152.00
  • SAM 2013 Assessment, Training, and Projects v1.0 Multi-Term Instant Access
    List Price = $138.00  | CengageBrain Price = $138.00  | College Bookstore Wholesale Price = $138.00
  • Microsoft Office 365 180-Day Trial, 1 term (6 months) Instant Access
    List Price = $18.00  | College Bookstore Wholesale Price = $18.00


Bundle: Microsoft® Access 2013: Comprehensive + SAM 2013 Projects v1.0 Printed Access Card + MOS 2007/2010 Paper Exam Voucher

ISBN-10:  1305140702  | ISBN-13:  9781305140707

List Price = $254.95  | CengageBrain Price = $254.95  | College Bookstore Wholesale Price = $191.21

This Bundle Includes:

  • Microsoft® Access 2013: Comprehensive
    List Price = $201.95  | CengageBrain Price = $201.95  | College Bookstore Wholesale Price = $152.00
  • SAM 2013 Projects v1.0 Printed Access Card
    List Price = $77.00  | College Bookstore Wholesale Price = $57.75
  • MOS 2007/2010 Paper Exam Voucher
    List Price = $84.95  | CengageBrain Price = $84.95  | College Bookstore Wholesale Price = $67.50


Bundle: SAM 2013 Assessment, Training, and Projects v1.0 Printed Access Card + Microsoft® Access 2013: Comprehensive

ISBN-10:  113328504X  | ISBN-13:  9781133285045

List Price = $237.95  | College Bookstore Wholesale Price = $178.46

This Bundle Includes:

  • SAM 2013 Assessment, Training, and Projects v1.0 Printed Access Card
    List Price = $138.00  | College Bookstore Wholesale Price = $103.50
  • Microsoft® Access 2013: Comprehensive
    List Price = $201.95  | CengageBrain Price = $201.95  | College Bookstore Wholesale Price = $152.00


Bundle: Microsoft® Access 2013: Comprehensive + SAM 2013 with MindTap Reader Printed Access Card for Pratt/Last's Microsoft® Access 2013: Comprehensive + Microsoft Office 2013 180 Day Trial, PC Version Printed Access Card

ISBN-10:  1337364606 | ISBN-13:  9781337364607

List Price = $260.95  | CengageBrain Price = $260.95  | College Bookstore Wholesale Price = $195.71

This Bundle Includes:

  • SAM 2013 with MindTap Reader Printed Access Card
    List Price = $153.00  | College Bookstore Wholesale Price = $114.75
  • Microsoft Office 2013 180 Day Trial, PC Version Printed Access Card
    List Price = $18.00  | College Bookstore Wholesale Price = $18.00
  • Microsoft® Access 2013: Comprehensive
    List Price = $201.95  | CengageBrain Price = $201.95  | College Bookstore Wholesale Price = $152.00


Supplements

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's Resource CD-ROM  (ISBN-10: 128516685X | ISBN-13: 9781285166858)

Go beyond the book with Instructor Resources to help you make the most of your classroom and lessons. Here you will find additional information on how to use our text as well as teaching and testing aids.

Review Pack  (ISBN-10: 1285166663 | ISBN-13: 9781285166667)

CD containing all Microsoft Office 2013 student data files.

List Price = $18.95  | CengageBrain Price = $18.95  | College Bookstore Wholesale Price = $14.00

Student Supplements

Review Pack  (ISBN-10: 1285166663 | ISBN-13: 9781285166667)

CD containing all Microsoft Office 2013 student data files.

List Price = $18.95  | CengageBrain Price = $18.95  | College Bookstore Wholesale Price = $14.00

LMS Integrated for SAM 2013 Assessment, Training, and Projects with MindTap Reader, 1 term  (ISBN-10: 1305510437 | ISBN-13: 9781305510432)

List Price = $153.00  | CengageBrain Price = $153.00  | College Bookstore Wholesale Price = $153.00

MindLink for SAM 2013 Assessment, Training, and Projects with MindTap Reader, (6 months) Instant Access  (ISBN-10: 1305443225 | ISBN-13: 9781305443228)

Go from Office user to Office expert SAM –Skills Assessment Manager – is the top online training resource for Microsoft Office suites. No matter what your skill level, SAM helps you learn with confidence so you have a better chance to make better grades. Navigate easily from day one SAM has all your course content in one easy location, offering an intuitive homepage which ensures you always get where you need to go. See how Office is used in the real world SAM training and assessments simulate the real MS Office environment, which will prepare you for more workplace success. Set yourself up for better grades Automatic feedback on assignments and a personalized study plan help you stay on track for improved grades. Student Testimonials: “My course experience using SAM has been great. It has actually helped me more in class because it lets us do an unlimited amount of training. If we do need help with something, we can just log onto SAM and do it.” - Student Westchester Community College “[SAM] told me all of the mistakes I made, and when I saw the mistakes, it allowed me to use critical thinking of what I could do to make that problem 100% correct.” - Student Hutchinson Community College CTA: Ask your instructor about SAM for this course. Visit us online: sam.cengage.com

List Price = $153.00  | CengageBrain Price = $153.00  | College Bookstore Wholesale Price = $153.00

SAM 2013 Assessment, Training and Projects with MindTap Reader, 1 term (6 months) for Microsoft® Access 2013: Comprehensive  (ISBN-10: 1285752104 | ISBN-13: 9781285752105)

Go from Office user to Office expert SAM –Skills Assessment Manager – is the top online training resource for Microsoft Office suites. No matter what your skill level, SAM helps you learn with confidence so you have a better chance to make better grades. Navigate easily from day one SAM has all your course content in one easy location, offering an intuitive homepage which ensures you always get where you need to go. See how Office is used in the real world SAM training and assessments simulate the real MS Office environment, which will prepare you for more workplace success. Set yourself up for better grades Automatic feedback on assignments and a personalized study plan help you stay on track for improved grades. Student Testimonials: “My course experience using SAM has been great. It has actually helped me more in class because it lets us do an unlimited amount of training. If we do need help with something, we can just log onto SAM and do it.” - Student Westchester Community College “[SAM] told me all of the mistakes I made, and when I saw the mistakes, it allowed me to use critical thinking of what I could do to make that problem 100% correct.” - Student Hutchinson Community College CTA: Ask your instructor about SAM for this course. Visit us online: sam.cengage.com

List Price = $153.00  | CengageBrain Price = $153.00  | College Bookstore Wholesale Price = $153.00

SAM 2013 with MindTap Reader Printed Access Card  (ISBN-10: 1285752090 | ISBN-13: 9781285752099)

Go from Office user to Office expert SAM –Skills Assessment Manager – is the top online training resource for Microsoft Office suites. No matter what your skill level, SAM helps you learn with confidence so you have a better chance to make better grades. Navigate easily from day one SAM has all your course content in one easy location, offering an intuitive homepage which ensures you always get where you need to go. See how Office is used in the real world SAM training and assessments simulate the real MS Office environment, which will prepare you for more workplace success. Set yourself up for better grades Automatic feedback on assignments and a personalized study plan help you stay on track for improved grades. Student Testimonials: “My course experience using SAM has been great. It has actually helped me more in class because it lets us do an unlimited amount of training. If we do need help with something, we can just log onto SAM and do it.” - Student Westchester Community College “[SAM] told me all of the mistakes I made, and when I saw the mistakes, it allowed me to use critical thinking of what I could do to make that problem 100% correct.” - Student Hutchinson Community College CTA: Ask your instructor about SAM for this course. Visit us online: sam.cengage.com

List Price = $153.00  | College Bookstore Wholesale Price = $114.75

Meet the Author

Author Bio

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.