Relational Databases and Microsoft Access

(2 reviews)

star01star02star03star04star05

Ron McFadyen, University of Winnipeg

Pub Date: 2016

ISBN 13:

Publisher: Independent

Read This Book

Conditions of Use

Attribution-NonCommercial-ShareAlike
CC BY-NC-SA

Reviews

  All reviews are licensed under a CC BY-ND license.

Learn more about reviews.

star01star02star03star04star05

Reviewed by Gregory Turcotte, Instructor, Portland Community College, on 6/21/2017.

I was very pleased to find an Access book that covers Entity Relationship Modeling and Normalization. Having an Access book that includes database … read more

 

star01star02star03star04star05

Reviewed by Owen Morgan, Faculty Instructor, Lane Community College, on 6/21/2017.

Relational Databases and Microsoft Access provides a fairly comprehensive introduction to both relational database principles and using Microsoft … read more

 

Table of Contents

Table of Contents
Preface

  • 1 Relational Databases and MS Access
  • 2. Creating Tables
  • 3. Creating Forms
  • 4 Microsoft Access Queries
  • 5 Relationships and the Relationships Tool
  • 6 Microsoft Access Queries – Advanced
  • 7 Entity Relationship Modelling
  • 8 Mapping an ERD to a Relational Database
  • 9 Data Definition Language (DDL)
  • 10 Normalization

Appendix A: Forms Involving Multiple Tables
Appendix B: SuperTypes and Subtypes

About the Book

This text is a free introductory text that introduces MS Access and relational database design. The motivation is to support a second-year course on database systems which, to the student, is either a service course providing an introduction to database concepts, or, as a prerequisite for more advanced study in the field.

About the Contributors

Author(s)

Ron McFadyen is a Professor in the Computer Science department at University of Winnipeg, Winnipeg, MB.