Access database design

Stamp

Access Database Design & Programming, 3rd Edition

Steven Roman
Publisher: O'Reilly
Third Edition January 2002 ISBN: 0-596-00273-4, 448 pages

Copyright Table of Contents Index Full Description About the Author Reviews Reader reviews Errata

When using GUI-based software, we often focus so much on the interface that we forget about the general concepts required to use thesoftware effectively. Access Database Design & Programming takes you behind the details of the interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications. The main sections of this book include: database design, queries, and programming.

1
TEAM FLY PRESENTS

Table of Content
Table of Content............................................................................................................. 2 Preface............................................................................................................................. 7 Preface to the Third Edition........................................................................................ 7 Preface to the Second Edition..................................................................................... 8 The Book's Audience ................................................................................................ 11 The Sample Code...................................................................................................... 11 Organization of ThisBook........................................................................................ 11 Conventions in This Book ........................................................................................ 14 Obtaining Updated Information................................................................................ 15 Request for Comments.............................................................................................. 15Acknowledgments..................................................................................................... 15 Part I: Database Design................................................................................................. 17 Chapter 1. Introduction ................................................................................................. 17 1.1 DatabaseDesign.................................................................................................. 17 1.2 Database Programming....................................................................................... 23 Chapter 2. The Entity-Relationship Model of a Database ............................................ 24 2.1 What Is aDatabase?............................................................................................ 24 2.2 Entities and Their Attributes............................................................................... 24 2.3 Keys and Superkeys............................................................................................ 28 2.4 Relationships Between Entities........................................................................... 29 Chapter 3. ImplementingEntity-Relationship Models: Relational Databases ............. 31 3.1 Implementing Entities......................................................................................... 31 3.2 A Short Glossary................................................................................................. 33 3.3 Implementing the Relationships in a Relational Database ................................. 35 3.4The LIBRARY Relational Database................................................................... 39 3.5 Index Files........................................................................................................... 44 3.6 NULL Values...................................................................................................... 46 Chapter 4. Database Design Principles...