Nelson Higher Education

Higher Education

Shelly Cashman Series® Microsoft® Office 365 & Access 2016: Comprehensive, 1st Edition

  • Philip J. Pratt
  • Mary Z. Last
  • ISBN-10: 1305870638
  • ISBN-13: 9781305870635
  • 856 Pages | Paperback
  • Previous Editions: 2016, 2014, 2011
  • COPYRIGHT: 2017 Published
Request a Copy for Review

Overview

About the Product

Introduce your students to the latest advancements that Microsoft® Access 2016 has to offer with MICROSOFT® OFFICE 365 & ACCESS 2016: COMPREHENSIVE -- the new edition in today’s generation of acclaimed Shelly Cashman Series® books. For more than three decades, the Shelly Cashman Series® has effectively introduced computer skills to millions. MICROSOFT® OFFICE 365 & ACCESS 2016: COMPREHENSIVE continues the Series’ strong history of innovation with a hallmark learning approach now enhanced to address the varied learning styles of today’s students. A trademark, step-by-step, screen-by-screen approach provides a thorough understanding of Microsoft® Access 2016 through experimentation, critical thought, and personalization. This new edition and accompanying resources deliver effective educational materials specifically designed to engage readers, improve retention, and prepare students for future success in working with all aspects of Microsoft® Access 2016.

Features

  • STEP-BY-STEP, SCREEN-BY-SCREEN APPROACH EFFECTIVELY INTRODUCES KEY ACCESS SKILLS. This proven visual approach presents students with explanatory and navigational information when they need to know it. The book addresses the needs of all learning styles to help students retain and apply skills in their personal and professional lives.

  • PROVEN PEDAGOGY EMPHASIZES PROJECT PLANNING. This project planning approach frames the explanations within each module around a practical problem that students need to solve. This introductory presentation encourages critical thinking as the learner determines how to proceed at various key points within the module.

  • EXTENSIVE END-OF-MODULE ACTIVITIES REINFORCE KEY ACCESS SKILLS AND APPLICATIONS. These proven, class-tested activities provide a variety of reinforcement opportunities for students to apply and expand their Access 2016 skills.

  • STEP-BY-STEP, SCREEN-BY-SCREEN APPROACH EFFECTIVELY INTRODUCES KEY MICROSOFT® ACCESS SKILLS. This proven visual approach presents students with explanatory and navigational information specifically when they need to know it in order to master Microsoft® Access 2016. The book addresses the needs of all learning styles to help students retain and apply skills in their personal and professional lives.

  • EXTENSIVE END-OF-MODULE ACTIVITIES REINFORCE A QUANTITY OF MICROSOFT® ACCESS SKILLS AND APPLICATIONS. These proven, class-tested activities provide a variety of reinforcement opportunities for students to apply and expand their thorough understanding of Microsoft® Access 2016 skills.

About the Author

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 books for the popular Shelly Cashman Series, in addition to the popular 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 leading database texts.

Table of Contents

Microsoft's New Productivity Tools for School and Work.
Office 2016 and Windows 10: Essential Concepts and Skills.
1. Databases and Database Objects: An Introduction.
2. Querying a Database.
3. Maintaining a Database.
4. Creating Reports and Forms.
5. Multiple-Table 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.
Index.

New to this edition

  • MODULE 1 PROVIDES MEANINGFUL PRACTICE WITH A NEW DATABASE PROJECT. Students work with a project that models the real working environment within a human resources outsourcing company as they master the use of query, report and form examples new to Microsoft® Access 2016.
  • MODULE 2 INTRODUCES NEW FORMS AND USEFUL REPORTS. Students learn to fully utilize Microsoft® Access 2016’s new query and crosstab examples as well as the new forms and reports created from a join query.
  • MODULE 3 OFFERS NEW EXAMPLES BASED ON CURRENT MICROSOFT® ACCESS 2016 OFFERINGS. This helpful module details the strengths of Microsoft® Access 2016, including Filter, Lookup Field and Multivalued Lookup Field examples.
  • MODULE 7 HIGHLIGHTS SEVERAL NEW MICROSOFT® ACCESS 2016 FORMS. Students work with the latest Access enhancements, including a new form that contains buttons and combo boxes, a new form containing a tab control, and new chart examples.
  • EXPANDED MODULES 8-11 EMPHASIZE ADDITIONAL MICROSOFT® ACCESS 2016 FEATURES. These modules are thoroughly updated in this edition to emphasize advanced features and new advantages that Microsoft® Access 2016 offers to users.
  • New Productivity Apps for Work and School module provide a visual introduction. These helpful, easy-to-use apps by technology author Corinne Hoisington visually guide students through using Microsoft® OneNote, Sway, Office Mix and Edge with fun, hands-on activities for active learning. Companion Sways provide videos and step-by-step instructions to help students learn to master each app.

Supplements

All supplements have been updated in coordination with the Main title.
Please see Main title page for new to this edition information.

Instructor Supplements

Instructor's Website, Comprehensive  (ISBN-10: 1305870646 | ISBN-13: 9781305870642)

Find everything you need for your course all in one place. All instructor resources are available instantly through the password-protected Instructor Companion Website, including the Instructor’s Manual, Test Bank and PowerPoint® slides.

Cengage Testing, powered by Cognero® Instant Access  (ISBN-10: 1305881516 | ISBN-13: 9781305881518)

Cengage Learning Testing, powered by Cognero®, is a flexible, online system that allows you to import, edit, and manipulate content from the text’s test bank or elsewhere, including your own favorite test questions. Create multiple test versions in an instant and deliver tests from your LMS, your classroom, or wherever you want.

MindTap Computing, 1 term (6 months) Instant Access for Pratt/Last’s Shelly Cashman Series® Microsoft® Office 365 & Access 2016: Comprehensive  (ISBN-10: 1305870662 | ISBN-13: 9781305870666)

MindTap Computing for Pratt/Last’s Shelly Cashman Series® Microsoft® Office 365 & Access 2016: Comprehensive is the digital learning solution that powers students from memorization to mastery. It gives you complete control of your course—to provide engaging content, to challenge every individual, and to build their confidence. Empower students to accelerate their progress with MindTap. MindTap: Powered by You. MindTap gives you complete ownership of your content and learning experience. Customize the interactive syllabi, emphasize the most important topics, and add your own material or notes in the eBook.

MindTap Computing, 2 terms (12 months) Instant Access for Pratt/Last’s Shelly Cashman Series® Microsoft® Office 365 & Access 2016: Comprehensive  (ISBN-10: 1305882873 | ISBN-13: 9781305882874)

MindTap Computing for Pratt/Last’s Shelly Cashman Series® Microsoft® Office 365 & Access 2016: Comprehensive is the digital learning solution that powers students from memorization to mastery. It gives you complete control of your course—to provide engaging content, to challenge every individual, and to build their confidence. Empower students to accelerate their progress with MindTap. MindTap: Powered by You. MindTap gives you complete ownership of your content and learning experience. Customize the interactive syllabi, emphasize the most important topics, and add your own material or notes in the eBook.

SAM 365 & 2016 Assessment, Training, and Projects Instant Access with 1 MindTap Reader, (6 months) Instant Access  (ISBN-10: 133711393X | ISBN-13: 9781337113939)

SAM trains and assesses essential Microsoft Office and computer concepts skills. Students engage in a hands-on simulated environment, then apply their skills live in the applications with real world scenarios. SAM’s auto-graded assignments and flexible reporting tools saves instructors time and energy.

Student Supplements

MindTap Computing, 1 term (6 months) Instant Access for Pratt/Last’s Shelly Cashman Series® Microsoft® Office 365 & Access 2016: Comprehensive  (ISBN-10: 1305870662 | ISBN-13: 9781305870666)

MindTap Computing for Pratt/Last’s Shelly Cashman Series® Microsoft® Office 365 & Access 2016: Comprehensive helps you learn on your terms. INSTANT ACCESS IN YOUR POCKET. Take advantage of the MindTap Mobile App to learn on your terms. Read or listen to textbooks and study with the aid of instructor notifications, flashcards, and practice quizzes. MINDTAP HELPS YOU CREATE YOUR OWN POTENTIAL. GEAR UP FOR ULTIMATE SUCCESS. Track your scores and stay motivated toward goals. Whether you have more work to do or are ahead of the curve, you’ll know where to focus efforts. And the MindTap Green Dot will charge your confidence along the way. MINDTAP HELPS YOU OWN YOUR PROGRESS. MAKE THE TEXT YOURS. No one knows what works for you better than you. Highlight key text, add notes, and create custom flashcards. When it’s time to study, gather everything you’ve flagged into a guide you organize.

MindTap Computing, 2 terms (12 months) Instant Access for Pratt/Last’s Shelly Cashman Series® Microsoft® Office 365 & Access 2016: Comprehensive  (ISBN-10: 1305882873 | ISBN-13: 9781305882874)

MindTap Computing for Pratt/Last’s Shelly Cashman Series® Microsoft® Office 365 & Access 2016: Comprehensive helps you learn on your terms. INSTANT ACCESS IN YOUR POCKET. Take advantage of the MindTap Mobile App to learn on your terms. Read or listen to textbooks and study with the aid of instructor notifications, flashcards, and practice quizzes. MINDTAP HELPS YOU CREATE YOUR OWN POTENTIAL. GEAR UP FOR ULTIMATE SUCCESS. Track your scores and stay motivated toward goals. Whether you have more work to do or are ahead of the curve, you’ll know where to focus efforts. And the MindTap Green Dot will charge your confidence along the way. MINDTAP HELPS YOU OWN YOUR PROGRESS. MAKE THE TEXT YOURS. No one knows what works for you better than you. Highlight key text, add notes, and create custom flashcards. When it’s time to study, gather everything you’ve flagged into a guide you organize.

SAM 365 & 2016 Assessment, Training, and Projects Instant Access with 1 MindTap Reader, (6 months) Instant Access  (ISBN-10: 133711393X | ISBN-13: 9781337113939)

This access code is available to you for as long as your institution uses SAM 365 & 2016. MindTap Reader access length is dependent upon how it was setup by your instructor. SAM – Skills Assessment Manager – is the top online training resource for Microsoft Office and computer concepts skills. With automatic feedback on assignments and personalized study guides, SAM helps you stay on track for improved grades. SAM has all your course content in one easy location. SAM training and assessments simulate the real Microsoft Office environment and SAM projects let you apply the skills live in the application using real-world scenarios, preparing you for more workplace success.