Relational Databases and Microsoft Access

(3 reviews)


Ron McFadyen, University of Winnipeg

Pub Date: 2016

ISBN 13:

Publisher: Independent

Read This Book

Conditions of Use



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

Learn more about reviews.


Reviewed by Marcus Lacher, Instructor, Minnesota State Community and Technical College, on 6/20/2018.

The text does a solid job of providing a comprehensive explanation of basic relational database theory and Microsoft Access functionality, … read more



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



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

  • 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


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