MICROSOFT ACCESS 2019 Tutorial and Lab Manual

[Pages:122]MICROSOFT ACCESS 2019 Tutorial and Lab Manual

David Murray

Microsoft Access 2019 Tutorial and Lab Manual

David Murray University at Buffalo

Copyright ? 2020 by David J. Murray This work is licensed under a Creative Commons Attribution 4.0 International License. It is attributed to David J. Murray and the original work can be found at . To view a copy of this license, visit licenses/by/4.0/.

Kendall Hunt Publishing Company previously published this book. Microsoft Access 2019 Tutorial and Lab Manual is an independent textbook and is not affiliated with, nor has been authorized, sponsored, or otherwise approved by Microsoft Corporation. Printed in the United States of America First Printing, 2014 ISBN 978-1-942163-02-2

This book is dedicated to my loving wife Amy and my precious daughter Giacinta.

Table of Contents

Preface .....................................................................................................vi Chapter 1 ? Overview of Microsoft Access Databases ................................1 Chapter 2 ? Design and Create Tables to Store Data ..................................7 Chapter 3 ? Simplify Data Entry with Forms .............................................19 Chapter 4 ? Obtain Valuable Information Using Queries ..........................32 Chapter 5 ? Create Professional Quality Output with Reports ..................47 Chapter 6 ? Design and Implement Powerful Relational Databases ..........58 Chapter 7 ? Build User-Friendly Database Systems ..................................68 Chapter 8 ? Team Building and Group Work Exercises .............................83 Chapter 9 ? Supplemental Lab Exercises ..................................................94 Appendix A: Relational Database Design Reference ...............................113

v

Are You Ready to Learn Microsoft Access?

Many students find learning a brand new technology to be an overwhelming and often confusing and frustrating experience. If you are intimidated by Microsoft Access, take heart! Let me assure you that no matter how little experience you have or how much you hate computers (or they hate you), you CAN learn this software program with a little work, time, and dedication. This book is written so that you will learn the fundamentals of Microsoft Access in a step-by-step and hands-on fashion. The hands-on walkthrough and applied practice is what makes this textbook "work," but that is only half of the formula to make your learning effective. There must also be a commitment from you, the reader, to take an active and engaged role in the learning process. Specifically, while you are reading and working through this book, do so in a deliberate manner, paying careful attention to what is being explained. Blindly pointing and clicking through the exercises without thinking about the material being covered will not result in effective learning of the software. I hope that this book will provide you with the foundational knowledge to comfortably work with Microsoft Access databases. There is so much you can do in Microsoft Access that is beyond the scope of this textbook, and this foundation will ultimately help you independently learn how to do advanced things with the software. As with most books, this book can provide only limited depth into the material. Your true learning will begin after you have mastered the basics in this textbook and start attempting to use the software in real-world applications. Good luck!

vi

Chapter 1 Overview of Microsoft Access Databases

Introduction

This first introductory chapter will provide you with a broad overview of Microsoft Access and will introduce you to some general database terminology used throughout the book. This is accomplished by looking at Access databases from an end-user perspective so that you can familiarize yourself with what databases are, what they contain, and in general how they are used. Subsequent chapters focus on the technical details of databases, and by the end of this book, the topics come full circle in an attempt to tie together all of the concepts covered in this book. Each chapter begins with a brief textual overview of the material, followed by a Guided Exercise, which takes you step-by-step through a hands-on database example of the chapter contents. At the conclusion of most chapters, you have the opportunity to complete an Applied Exercise to check your knowledge and application of the material learned. Adhering to the chapter readings and paying attention to the "Guided Exercises" should prepare you to successfully complete the Applied Exercises, which are a true test of the material you have learned.

Have You Ever Used a Database?

If you are learning Microsoft Access for the first time, you may instinctively answer "no" to the question of whether you have ever used a database. I'm absolutely positive, however, that you have interacted with many databases, whether you realize it or not. To understand this, let's examine what the term database truly means by listing some basic characteristics of databases. ? Databases store all kinds of data. ? Databases are either low-tech (manual) or high-tech (electronic). ? Databases are highly structured and organized.

? Databases are somewhat analogous to multiple spreadsheets that are linked together. ? Databases are designed to allow easy extraction and use of the stored data. So, if you have ever used a phone book or a library card catalog, you have indeed used a database. Also, many online search engines and e-commerce websites rely on databases for their proper functioning, so you likely have interacted with them. See, you may already be more familiar with databases than you realize! Although the concept of a database may still seem foreign and new to you, it is helpful to relate the material in this book to examples of databases you are familiar with. Doing so will often help you to demystify and better understand these strange things called databases.

Overview of Microsoft Access Databases 1

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download