Skip to main content
SpringerLink
Log in
Book cover

Inside Relational Databases with Examples in Access

  • Book
  • © 2007

Overview

Authors:
  1. Mark Whitehorn

    1. Applied Computing Division, University of Dundee, UK

    View author publications

    You can also search for this author in PubMed   Google Scholar

  2. Bill Marklyn

    1. Seattle, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  • A reader-friendly explanation of the relational model and it's importance to database designers and developers, tailored to suit Access users

  • 59k Accesses

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 34.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 44.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (36 chapters)

  1. Front Matter

    Pages i-xiv
    Download chapter PDF

  2. Introduction

    1. Introduction

      Pages 1-9

  3. A simple, single-table database

    1. Front Matter

      Pages 11-11
      Download chapter PDF

    2. Introduction to Part 1

      Pages 13-16

    3. Tables

      Pages 17-35

    4. Queries/Views

      Pages 36-44

    5. Forms

      Pages 45-53

    6. Reports

      Pages 54-55

    7. Summary of Part 1

      Pages 56-58
Back to top

Keywords

About this book

Contents Should we tell you the whole story? Of course, there is an inevitable tension in trying to work like this. For example, in Chapter 16 we talk about referential integrity. There are - sentially six different flavors of referential integrity but Access only s- ports four of them (they are the most important ones however, so you aren’t missing out on too much). The problem is this. Should we tell you about the other two? If we do, as an Access user you have every right to be annoyed that we are telling you about a feature you can’t use. On the other hand, the six different types that we describe are part of the re- tional world and this book is about that world – we are not trying to teach you how to use Access, we are simply using Access to illustrate the relational model. Ultimately we decided to risk your ire and to describe all of the features of the relational model as we see it, even if Access doesn’t support all of them. One advantage of this approach is that if you need to use a different database engine you will almost certainly find the extra information useful. Incidentally, this is not meant to imply that Access is somehow lacking as a relational database engine. The reason we chose it for the first book is that it is such a good example of a relational database tool.

Authors and Affiliations

  • Applied Computing Division, University of Dundee, UK

    Mark Whitehorn

  • Seattle, USA

    Bill Marklyn

About the authors

Mark Whitehorn teaches database design and practice, both to undergraduates and in the commercial world.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation