Accessible Access 2003 (eBook)

Mark Whitehorn, Bill Marklyn (Autoren)

eBook Download: PDF

2007 | 2005
XVIII, 378 Seiten
Springer London (Verlag)
978-1-84628-189-1 (ISBN)

Infos

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).

Inhalt

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

Produkt-Details

• Erscheint lt. Verlag: 22.3.2007
• Zusatzinfo: XVIII, 378 p. 445 illus.
• Verlagsort: London
• Sprache: englisch
• Themenwelt: Mathematik / Informatik ► Informatik ► Datenbanken
• Themenwelt: Informatik ► Office Programme ► Access
• Themenwelt: 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