: Mark Whitehorn, Bill Marklyn
: Accessible Access 2003
: Springer-Verlag
: 9781846281891
: 1
: CHF 32.10
:
: Informatik
: English
: 378
: Wasserzeichen
: PC/MAC/eReader/Tablet
: PDF
Thisiswherewetrytoc nvinceyoutobuythisbook,tellyo whatittriestodo, 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? TherearemanyAccessbooksonthem rket,whyshouldIbuythisone?Doe ithavemore 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'renotdo ngagreatjobofsellingthistome. 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 writtenabooktogetheraboutther lationalmodelthatunderliesAcc ssandall 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).

Acknowledgements6
Contents7
Preface to the second edition?14
Introduction15
Introduction16
Getting started25
The Database wizard – or not26
Tables – for storing your data36
Queries – finding data47
Forms – viewing and entering data67
Reports – printing your data80
The story so far87
Creating hand-crafted databases90
Exploring tables in more depth91
Tapping the power of Access queries130
Forms again – design169
Forms again – controlling data entry204
Reports again – customizing printed output236
Where are we now?254
More complex databases256
Multiple table databases257
Tables – making multiple tables work together275
Tables – a complete multi- table database289
Queries – finding data from multiple tables301
Forms – your interface to multiple tables311
Reports – printing data from multiple tables333
Producing a user interface for your database337
Data Access Pages349
You mean there’s even more?372
Index381