Access Database Design & Programming

BUY THIS BOOK

Print Book $34.95

PDF $24.99

Safari Books Online

What is this?

Print Book £24.95

What is this?

Looking to Reprint or License this content?

Tell a friend

Access Database Design & Programming, Third Edition

By Steven Roman, Ph.D.
Third Edition January 2002
Pages: 448
ISBN 10: 0-596-00273-4 | ISBN 13: 9780596002732
(Average of 7 Customer Reviews)

Book description

When using GUI-based software, we often focus so much on the interface that we forget about the general concepts required to use the software effectively. Access Database Design & Programming takes you behind the details of the interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications. The main sections of this book include: database design,queries, and programming.
Full Description

Access Database Design & Programming takes you behind the details of the Access interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications. When using software products with graphical interfaces, we frequently focus so much on the interface that we forget about the general concepts that allow us to understand and use the software effectively. In particular, this book focuses on three areas:

Database design. The book provides an enjoyable, informative overview of database design that carefully shows you how to normalize tables to eliminate redundancy without losing data.
Queries. The book examines multi-table queries (i.e.,various types of joins) and shows how to implement them indirectly by using the Access interface or directly by using Access SQL.
Programming. The book examines the VBA integrated development environment (IDE). It then goes on to provide an excellent introduction to Data Access Objects (DAO), ActiveX Data Objects (ADO), and ADO Extensions for Data Definition and Security (ADOX). These sections serve as a handy introduction and primer for basic database operations,such as modifying a table under program control, dynamically adding and deleting a record, and repositioning a record pointer. The concluding chapter focuses on common programming problems, such as computing running sums and comparing two sets.

Unlike other Access books that take the long, detailed approach to every topic of concern to Access programmers, Access Database Design &Programming instead focuses on the core concepts, enabling programmers to develop solid, effective database applications. This book also serves as a 'second course' in Access that provides a relatively experienced Access user who is new to programming with the frequently overlooked techniques necessary to develop successfully in the Microsoft Access environment. Anyone interested in learning Access in depth, rather than just scraping the surface, will enjoy and benefit immensely from reading this book.

Browse within this book

Cover | Table of Contents | Colophon

Featured customer reviews

Excellent Book, January 02 2007

Rating:

Submitted by Motolep [Respond | View]

this book is very benefit and very excellent.
Unlike other Access books,most access database books focus about access interfaces , but this books focus on the design & programming rules.
I advise every one who want to learn access database to buy this book .

A true no-nonsense book, July 13 2004

Rating:

Submitted by Samid_V [Respond | View]

In my experience of reading beginner´s books, I have only encountered authors that think you have never seen a computer in your life and keep everything as simplistic as possible. Steven Roman is not that kind of author.

This book is a perfect introduction not only to Access but to Database Design. The author first introduces some mathematical concepts regarding databases and keeps building a strong ground based on that. SQL queries, VBA programming, ActiveX Data Objects, everything is here challenging the reader in a highly gratifying manner.

I look forward to read all the Roman Saga.

Access Database Design & Programming, April 21 2004

Rating:

Submitted by Alex G [Respond | View]

A clear, informative guide to Access programming. I got this book due to it's coverage of ADO and ADOX, as most books only seem to cover this in the context of ASP. It was very informative in these respects but also useful for the sections of Relational Algebra. This book now lives on my desk and I use it at least once a week. A must for anyone who has to programme Access on a regular or semi-regular basis.

Read all reviews

Access Database Design & Programming, 3rd Edition Review, April 02 2004

Rating:

Submitted by * [Respond | View]

Good price and well written informative book about access database design and design. Nothing more nothing less!

Emo

Access Database Design & Programming, 3rd Edition Review, May 18 2002

Rating:

Submitted by anom [Respond | View]

really nice book especially explaining design, DAO, VBA

need more infos on ADO !

Access Database Design & Programming, 3rd Edition Review, February 08 2002

Rating:

Submitted by Tristan Blais [Respond | View]

I really recommand this book. Its absolutly amazing. Anyone who has a hard time understanding normalization or other database design concepts will find this book a life saver. Its also a great refresher or reference for others who have to use Access from time to time. I'm looking forward to this 3rd Edition. In fact, I'll buy it today. Keep up the great work!

Access Database Design & Programming, 3rd Edition Review, January 25 2002

Rating:

Submitted by h [Respond | View]

as a reader of v.2 i was interested to see what was new in v.3.

basically, all of the good stuff in the prior book was kept intact

and some new good stuff was added. my primary complaint is that

the size has grown enough so that it doesnt use lay-flat binding.

as the preface mentions, it added a couple extra chapters at the

end for ADOX and some more example problems. the examples are

heartily recommended, but the ADOX was difficult to follow (not

the authors fault, but rather MS for making it so hard to do).

i liked the change in the grammar from 1st plural to 1st singular

so that sentences went from "we can do xxx" to "i now do xxx".

yet this jarred when i came across politically-correct examples

later on that referred to "she can" when i assume the author is

male. but this is a nitpick when the book is decidedly general.

as a general book on access and db-design it is without peer.

if you buy it for no other reason that to understand how to

normalize your initial db-design then it is money well-spent.

Media reviews "Steven Roman's 'Access Database Design & Programming' (3rd ed.) is a remarkable book because it can easily appeal to multiple audiences simultaneously. Experienced Access users and programmers will likely skip the first two sections of the book devoted to database design and queries. Novice users will appreciate these sections for their basic introduction to relational databases, queries, and the lesson to think carefully about the design of a database before populating it with data...The greatest strength of this book is its consistent use of easy-to-understand examples...Roman has persuaded me that there is some flexibility to be gained by learning how to go below (or beyond) the Access user interface. I feel confidant that 'Access Database Design & Programming' will serve as a handy reference."
--Williamsburg Macromedia User Group, April 16, 2002

"'Access Database Design and Programming' covers a lot of ground quickly but lucidly?The result is a single book that can teach you all the basics of building database applications in Access."
--compbookreview,.com, March 2002

From Previous Editions:

Read all reviews

See larger cover