Accessible Access 2003

ISBN-13: 9781852339494 / Angielski / Miękka / 2005 / 400 str.

Mark Whitehorn; Bill Marklyn

Opis

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

Spis treści

Part 1 – Introduction Chapter 1 – Introduction Part II – Getting Started Chapter 2 – The Database Wizard – or not Chapter 3 – Tables – for storing your data Chapter 4 – Queries – finding data Chapter 5 – Forms – viewing and entering data Chapter 6 – Reports – printing your data Chapter 7 – The story so far Part III – Creating hand-crafted databases Chapter 8 – Exploring tables in more depth Chapter 9 – Tapping the power of Access queries Chapter 10 – Forms again – design Chapter 11 – Forms again – controlling data entry Chapter 12 – Reports again – customizing printed output Chapter 13 – Where are we now? Part IV – More complex databases Chapter 14 – Multiple table databases Chapter 15 – Tables – making multiple tables work together Chapter 16 – Tables – a complete multi-table database Chapter 17 – Queries – finding data from multiple tables Chapter 18 – Forms – your interface to multiple tables Chapter 19 – Reports – printing data from multiple tables Chapter 20 – Producing a user interface for your database Chapter 21 – Data Access Pages Chapter 22 – You mean there’s even more?

O autorze

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

Blurb

Written by the team which brought you Inside Relational Databases and based on their best-selling book for Access 2000, Accessible Access has been totally re-written for Access 2003.

About the authors:

Bill Marklyn, as the Development Manager for the first two major releases of Access, oversaw the entire design and so provides an intimate knowledge of the product.

Mark Whitehorn's skills lie in making complex ideas easy to understand and entertaining to absorb. In addition he's a professional database developer which probably helps....

From the authors:

We wrote Accessible Access 2000 for people who were new to the world of building databases. In that book we tried very hard not to simply list everything that we knew about the product. Instead we tried to act as intelligent filters, presenting only the essential information that you need to get started.

We were delighted with the reception that the book received and have tried to keep the same philosophy for Accessible Access 2003. However, rather than simply reprinting the book with 2003 in the title, we have gone through it with a fine toothcomb. Every screen shot has been retaken and every section has been re-checked to ensure, not only that it still works, but also that it is actually still relevant. We have re-written parts where the product has changed and also added some. For example, there is a new section on Object Dependencies and a whole new chapter about Data Access Pages - helping you to put your Access database onto an intranet.