Relational Databases and Microsoft Access

(0 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.

There are no reviews for this book

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.