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
CC BY-NC-SA
Reviews
Learn more about reviews.
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
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
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
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
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
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
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
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
Ancillary Material
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.
Author
Ron McFadyen is a Professor in the Computer Science department at University of Winnipeg, Winnipeg, MB.
Posted by: donnettedonnettemolze0268115.blogspot.com
Source: https://open.umn.edu/opentextbooks/textbooks/442
0 Comments