Inside Relational Databases with Examples in Access
(Sprache: Englisch)
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...
Leider schon ausverkauft
versandkostenfrei
Buch
42.79 €
Produktdetails
Produktinformationen zu „Inside Relational Databases with Examples in Access “
Klappentext zu „Inside Relational Databases with Examples in Access “
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.
Inhaltsverzeichnis zu „Inside Relational Databases with Examples in Access “
From the contents:Part 1
- A simple, single-table database
- Introduction to Part 1
- Tables
- Forms
- Queries/Views
- Reports
- Tables
- Rows and columns
- Records and fields
- Numbers of rows and columns
- Field Names
- Table structures
- Building a table
- Types of data
- Meaningful operations
- Excluding certain errors
- Making storage more efficient
- Making data recall more rapid
- Field size
- General notes on table design
- Think first
- Context-PC or not PC? That is the question
- Controlling data entry
- Field names
- Splitting names, addresses etc
- Don't store redundant information
- Base tables
- not defined here
- Queries/Views
- Queries usually find subsets of the data
- Queries, answer tables and base tables finally defined properly and closure mentioned briefly
- Summarizing data
- Other useful queries
- Update
- Append
- Delete
- Graphical querying tools
- SQL and Views
- Forms
- Multiple forms per table
- Text boxes can be made read only
- Text boxes don't have to present data from just one field
- it isn't necessary for each field in a table to appear on the form.
Autoren-Porträt von Mark Whitehorn, Bill Marklyn
Dr. Mark Whitehorn has a boundless fascination for databases. He teaches relational database theory and practice at the University of Dundee, writes a monthly database column in 'Personal Computer World' and is a popular commentator on the computer industry. His enthusiasm, clarity of communication and devotion to real-world examples are much appreciated by students and readers alike. He is co-author of 'Inside Relational Databases - with examples in Access', also available from Springer-Verlag.
Bibliographische Angaben
- Autoren: Mark Whitehorn , Bill Marklyn
- 2006, 2007, 372 Seiten, Maße: 17,8 x 23,5 cm, Kartoniert (TB), Englisch
- Verlag: Springer, London
- ISBN-10: 1846283949
- ISBN-13: 9781846283949
- Erscheinungsdatum: 31.10.2006
Sprache:
Englisch
Kommentar zu "Inside Relational Databases with Examples in Access"
0 Gebrauchte Artikel zu „Inside Relational Databases with Examples in Access“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "Inside Relational Databases with Examples in Access".
Kommentar verfassen