Accessible Access 2003 (eBook)
XVIII, 378 Seiten
Springer London (Verlag)
978-1-84628-189-1 (ISBN)
Bill Marklyn, as the Development Manager for the first three versions of Access, oversaw the entire design and so provides an intimate knowledge of the product.
Mark Whitehorn designs and builds databases but is best known for his popular and long running database column in the UK magazine, Personal Computer World (PCW).
Thisiswherewetrytoconvinceyoutobuythisbook,tellyouwhatittriestodo, define a few terms and generally set the scene - all of which makes this more like an introduction than a first chapter, but no-one reads introductions so we called it a chapter. If you have already bought the book and know what it does, feel free to skip to Chapter 2 where the action starts. Whyshouldyoubuythisbook? TherearemanyAccessbooksonthemarket,whyshouldIbuythisone?Doesithavemore informationthananyotherbook? Errr, no, it actually has less than the big reference books you'll also find on the shelf. So,isitverycheap? Well, it isn't as expensive as some but, no, it isn't particularly cheap either. Tobebrutallyfrank,you'renotdoingagreatjobofsellingthistome. Right, time for the hard sell. Bill worked for Microsoft as the Development Manager for the first three versions of Access. I (Mark) work as a database consultant, teach database theory and practice at two Universities and have written the UK Personal ComputerWorld's database column for more than ten years. We met (at a database conference, not unreasonably, given our interests) in the summer before Access 1. 0 was launched and found that we shared similar views on how databases should be designed and built. Since then we have writtenabooktogetherabouttherelationalmodelthatunderliesAccessandall other relational database systems (see below for the inevitable plug). But why write a book about Access itself when there are already so many around? 3 1 Introduction Well, since Bill was in charge of the product's development, it was fair to assume that we had the technical side reasonably well covered.
Bill Marklyn, as the Development Manager for the first three versions of Access, oversaw the entire design and so provides an intimate knowledge of the product. Mark Whitehorn designs and builds databases but is best known for his popular and long running database column in the UK magazine, Personal Computer World (PCW).
Acknowledgements 6
Contents 7
Preface to the second edition? 14
Introduction 15
Introduction 16
Getting started 25
The Database wizard – or not 26
Tables – for storing your data 36
Queries – finding data 47
Forms – viewing and entering data 67
Reports – printing your data 80
The story so far 87
Creating hand-crafted databases 90
Exploring tables in more depth 91
Tapping the power of Access queries 130
Forms again – design 169
Forms again – controlling data entry 204
Reports again – customizing printed output 236
Where are we now? 254
More complex databases 256
Multiple table databases 257
Tables – making multiple tables work together 275
Tables – a complete multi- table database 289
Queries – finding data from multiple tables 301
Forms – your interface to multiple tables 311
Reports – printing data from multiple tables 333
Producing a user interface for your database 337
Data Access Pages 349
You mean there’s even more? 372
Index 381
Erscheint lt. Verlag | 22.3.2007 |
---|---|
Zusatzinfo | XVIII, 378 p. 445 illus. |
Verlagsort | London |
Sprache | englisch |
Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
Informatik ► Office Programme ► Access | |
Mathematik / Informatik ► Informatik ► Web / Internet | |
Schlagworte | ACCESS • Database • Databases • Microsoft Access • Relational Database • user interface |
ISBN-10 | 1-84628-189-X / 184628189X |
ISBN-13 | 978-1-84628-189-1 / 9781846281891 |
Haben Sie eine Frage zum Produkt? |
Größe: 8,6 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich