Access 2013 Textbook
MICROSOFT ACCESS 2013
Tutorial and Lab Manual
David Murray
Microsoft Access 2013
Tutorial and Lab Manual
David Murray
University at Buffalo
E‐Assign LLC
Copyright © 2014 by E‐Assign LLC All rights reserved. This book or any portion thereof may not be reproduced or used in any manner whatsoever without the express written permission of the publisher except for the use of brief quotations in a book review. Kendall Hunt Publishing Company previously published this book. Microsoft Access 2013 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‐00‐8
E‐Assign LLC www.e‐assign.com 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
Tutorial and Lab Manual
David Murray
Microsoft Access 2013
Tutorial and Lab Manual
David Murray
University at Buffalo
E‐Assign LLC
Copyright © 2014 by E‐Assign LLC All rights reserved. This book or any portion thereof may not be reproduced or used in any manner whatsoever without the express written permission of the publisher except for the use of brief quotations in a book review. Kendall Hunt Publishing Company previously published this book. Microsoft Access 2013 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‐00‐8
E‐Assign LLC www.e‐assign.com 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