Your Office

Amy S. Kinser, Esq., Series Editor Amy holds a B.A. degree in Chemistry with a Business minor from Indiana University, and a J.D. from the Maurer School of Law, also at Indiana University. After working as an environmental chemist, starting her own technology consulting company, and practicing intellectual property law, she has spent the past 15 years teaching technology at the Kelley School of Business in Bloomington, Indiana. Currently, she serves as the Director of Computer Skills and Senior Lecturer at the Kelley School of Business at Indiana University. She also loves spending time with her two sons, Aidan and J. Matthew, and her husband J. Eric.   Kristyn A. Jacobson Kristyn holds an M.S. in Education from the University of Wisconsin-La Crosse and a B.S. in Business Education from the University of Wisconsin-Eau Claire. She has been a faculty member and department chair of the Business Technology department at Madison College in Madison, Wisconsin for over 14 years. She also serves as the curriculum coordinator for Microsoft Excel beginning, intermediate, and advanced level courses for the college. As well as teaching, Kristyn provides training to businesses on the Microsoft Office Suite including MS Project, project management, customer service, personal productivity, and time management. Prior to teaching at Madison College, she taught at a business college in Des Moines, Iowa where she helped implement their online learning program while also teaching traditional business courses.   J. Eric Kinser Eric Kinser received his B.S. degree in Biology from Indiana University and his M.S. in Counseling and Education from the Indiana School of Education. He has worked in the medical field and in higher education as a technology and decision support specialist. He is currently a senior lecturer in the Operations and Decision Technology Department at the Kelley School of Business at Indiana University. When not teaching he enjoys experimenting with new technologies, traveling, and hiking with his family.   Diane L. Kosharek Diane is a full-time Business Technology faculty member at Madison College in Madison, WI. In addition to her faculty role, she works closely with business and industry specialists, developing and delivering tailored training solutions to employees in areas such as customer service, software applications and business writing skills. Prior to joining Madison College, she worked as a Technology Training Consultant, providing consultation and production assistance to teaching faculty and staff to incorporate appropriate technology in their courses to enhance learning. Diane holds a Bachelor’s Degree in Education from the University of Wisconsin-Madison and a Master’s Degree in Educational Computing from Cardinal Stritch University.   Brant Moriarity Brant P. Moriarity earned a B.A. in Religious Studies/Philosophy and a M.S. in Information Systems at Indiana University. He is a Senior Lecturer at the Indiana University’s Kelley School of Business where he teaches topics such as data management and analysis, as well as the strategic use of Information Systems in business. He is also the founder of Beats Per Minute Technologies, LLC, bringing the benefits of business analytics to small businesses and non-profit organizations.  

COMMON FEATURES

Chapter 1: Understanding the Common Features of Microsoft Office                                     3

ACCESS

Chapter 1: The Four Main Database Objects                                                                      54

Chapter 2: Tables, Keys, and Relationships                                                                        98

Chapter 3: Queries and Data Access                                                                                 168

Chapter 4: Using Forms and Reports in Access                                                                  218

Chapter 5: Advanced Tables                                                                                            278

Chapter 6: Pattern Matching and Functions in Queries                                                       335

Chapter 7: Aggregated Calculations, Subquerying, and SQL                                               386

Chapter 8: Action Queries and Advanced Relationships                                                      447

Chapter 9: Advanced Form Settings and Form Types                                                         494

Chapter 10: Advanced Reports and Mailing Labels                                                             538

Chapter 11: Develop Navigation Forms and the User Interface                                            590

Chapter 12: Create a Refined User Experience with Macros                                                619

Chapter 13: Use VBA in Access                                                                                        670

Chapter 14: Implement Your Database                                                                             710

Appendix:                                                                                                                      748

Glossary:                                                                                                                       776

Index:                                                                                                                           785