Relational Databases and Microsoft Access 365



Book Details
Author | Ron McFadyen |
Publisher | Loyalist College |
Published | 2021 |
Edition | 1 |
Paperback | 256 pages |
Language | English |
License | Creative Commons Attribution-NonCommercial-ShareAlike |
Book Description
A database is an organized collection of data. A database may be on paper, or, held in computer files such as spreadsheets or more formally in a software system known as a computerized database management system (for example: DB2, db4o, IMS, MS Access, MS SQL Server, mySQL, Oracle, Sybase, Total, Versant). In this book we focus on Relational databases and one specific relational database system: Microsoft Access available with Microsoft 365.
There are many different commercial relational database systems and what you learn here will assist you in using those others. Because MS Access is a workstation/personal system it is a convenient system for beginners.
This open book provides you with: a working knowledge of Microsoft Access, a solid understanding of SQL (focusing on the SELECT statement), and an awareness of the essential concepts and techniques for database design.
This book is available under a Creative Commons Attribution-NonCommercial-ShareAlike license (CC BY-NC-SA), which means that you are free to copy, distribute, and modify it, as long as you credit the original author, don't use it for commercial purposes, and share any adaptations under the same license.
If you enjoyed the book and would like to support the author, you can purchase a printed copy (hardcover or paperback) from official retailers.