Accessible Access 2003

1. Front Matter

   Pages i-xvii

   PDF

2. Introduction

   1. Front Matter

      Pages 1-1

      PDF

   2. Introduction

      Pages 3-11

3. Getting started

   1. Front Matter

      Pages 13-13

      PDF

   2. The Database wizard — or not

      Pages 15-24

   3. Tables — for storing your data

      Pages 25-35

   4. Queries — finding data

      Pages 36-55

   5. Forms — viewing and entering data

      Pages 56-68

   6. Reports — printing your data

      Pages 69-75

   7. The story so far

      Pages 76-78

4. Creating hand-crafted databases

   1. Front Matter

      Pages 79-79

      PDF

   2. Exploring tables in more depth

      Pages 81-119

   3. Tapping the power of Access queries

      Pages 120-158

   4. Forms again — design

      Pages 159-193

   5. Forms again — controlling data entry

      Pages 194-225

   6. Reports again — customizing printed output

      Pages 226-243

   7. Where are we now?

      Pages 244-245

5. More complex databases

   1. Front Matter

      Pages 247-247

      PDF

   2. Multiple table databases

      Pages 249-266

   3. Tables — making multiple tables work together

      Pages 267-280

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.

• Access
• Databases
• Microsoft Access
• database
• relational database
• user interface

• Information & Library Services, University College Worcester, Worcester, UK

  Mark Whitehorn

• Ocean Park Software Corporation, Seattle, USA

  Bill Marklyn

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

Policies and ethics