Read more about Relational Databases and Microsoft Access

Relational Databases and Microsoft Access

(7 reviews)

Ron McFadyen, University of Winnipeg

Copyright Year: 2016

Publisher: Ron McFadyen

Language: English

Formats Available

Conditions of Use

Attribution-NonCommercial-ShareAlike Attribution-NonCommercial-ShareAlike


Learn more about reviews.

Reviewed by Rose Ferro, Associate Professor in Computer Information Systems, Bristol Community College on 6/11/20

This text provides a reasonably comprehensive review of relational database principles using Microsoft Access. Given that this textbook was designed for second-level students, with no intended prerequisite, the level of detail that is included to... read more

Reviewed by Catherine Puopolo, Adjunct Faculty, Bunker Hill Community College on 6/10/20

Comprehensiveness rating: 4 The text delivers an in-depth and comprehensive explanation of relational database theory and design. The learning outcomes focus on Microsoft Access skills necessary to create a new database, construct data tables,... read more

Reviewed by David Owens, Instructor (Non-Tenure), Colorado State University on 12/6/19

Good basic introduction to relational database design concepts using MS Access examples, but it did not include a comprehensive discussion with current examples/references for some of the Table of Contents topics. It could be improved by including... read more

Reviewed by Leigh Mutchler, Assistant Professor, James Madison University on 3/6/19

The book is a good introductory database text that covers database design and includes some Access basics. A good table of contents is included but no glossary. There are a few references to external sources, primarily classic works in the... read more

Reviewed by Marcus Lacher, Instructor, Minnesota State Community and Technical College on 6/19/18

The text does a solid job of providing a comprehensive explanation of basic relational database theory and Microsoft Access functionality, specifically regarding table structure. The breadth of detail on forms and queries is not as extensive as... read more

Reviewed by Owen Morgan, Faculty Instructor, Lane Community College on 6/20/17

Relational Databases and Microsoft Access provides a fairly comprehensive introduction to both relational database principles and using Microsoft Access to build and use these databases. When reviewing this textbook I was delighted to see that... read more

Reviewed by Gregory Turcotte, Instructor, Portland Community College on 6/20/17

I was very pleased to find an Access book that covers Entity Relationship Modeling and Normalization. Having an Access book that includes database theory, such as the Boyce-Codd Normal Form, is very useful to me. In this area, the book is very... read more

Table of Contents

Table of ContentsPreface

  • 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 TablesAppendix B: SuperTypes and Subtypes

Ancillary Material

  • Submit ancillary resource
  • 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.

    Contribute to this Page

    Suggest an edit to this book record