Goodreads helps you keep track of books you want to read.

Start by marking “Access Database Design & Programming” as Want to Read:

Other editions

Enlarge cover

Rate this book

Clear rating

1 of 5 stars 2 of 5 stars 3 of 5 stars 4 of 5 stars 5 of 5 stars

Open Preview

Access Database Design & Programming

by Steven Roman

3.47 · Rating Details · 30 Ratings · 0 Reviews

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

Paperback, 450 pages

Published January 14th 2002 by O'Reilly Media (first published 1997)

More Details... edit details

Get a copy:

Or buy for

Friend Reviews

To see what your friends thought of this book, please sign up.

Reader Q&A

To ask other readers questions about Access Database Design & Programming, please sign up.

Be the first to ask a question about Access Database Design & Programming

Lists with This Book

This book is not yet featured on Listopia. Add this book to your favorite list »

Community Reviews

(showing 1-30 of 111)

filter | sort: default (?) | Rating Details

Bondoc Alina marked it as to-read
Sep 24, 2016

Sutton marked it as to-read
Jul 16, 2016

Jon added it
Jul 15, 2016

Kevin C. rated it it was amazing
Apr 12, 2016

Michelle H added it
Jan 24, 2016

Marguerite Guthridge added it
Jan 22, 2016

Charlie rated it it was ok
Jan 20, 2016

Peggy Burns rated it it was amazing
Jan 05, 2016

S Searle rated it it was amazing
Dec 20, 2015

Michael Libby added it
Oct 08, 2015

Thangaraj rated it liked it
Aug 09, 2015

David P. Rush rated it it was amazing
Jul 21, 2015

Charlene marked it as to-read
Jul 02, 2015

Donald Tucker Jr rated it really liked it
Jun 04, 2015

Aohori marked it as to-read
Jun 04, 2015

Ayshe is currently reading it
Apr 24, 2015

Billiegreen added it
Apr 20, 2015

Tony Gasson rated it really liked it
Mar 28, 2015

Sonisha Alcide rated it really liked it
Mar 02, 2015

Rebecca marked it as to-read
Feb 28, 2015

Melissa Smith marked it as to-read
Jan 04, 2015

Daniel Gross added it
Jan 03, 2015

Jim added it
Oct 23, 2014

John rated it really liked it
Sep 30, 2014

John Sage marked it as to-read
Sep 17, 2014

Steve Atkins added it
Sep 07, 2014

Peter Anderson marked it as to-read
Aug 26, 2014

Darlene rated it liked it
Jul 27, 2014

Natalia Corres rated it liked it
Jul 19, 2014

Ravneek marked it as to-read
Jun 25, 2014

« previous 1 2 3 4 next »

new topic
Discuss This Book

There are no discussion topics on this book yet. Be the first to start one »

Recommend It | Stats | Recent Status Updates

Goodreads is hiring!

If you like books and love to build cool products, we may be looking for you.
Learn more »

Genres

Computer Science > Computers

5 users

Science > Technology

4 users

Computer Science > Programming

3 users

Computer Science > Software

3 users

Nonfiction

2 users

See top shelves…

Books by Steven Roman

More…

Share This Book

+ Share on your website

Trivia About Access Database D...

No trivia or quizzes yet. Add some now »

title link	preview: Access Database Design & Programming
avg rating	preview: Access Database Design & Programming Goodreads rating: 3.47 (30 ratings)
small image	preview: click here [close]
med image	preview: click here [close]
BBCode	[url=https://www.goodreads.com/book/show/1168954.Access_Database_Design_Programming?utm_medium=api&utm_source=blog_book][img]https://d.gr-assets.com/books/1371080257l/1168954.jpg[/img][/url] [url=https://www.goodreads.com/book/show/1168954.Access_Database_Design_Programming?utm_medium=api&utm_source=blog_book]Access Database Design & Programming by Steven Roman[/url]

See a Problem?

Preview — Access Database Design & Programming by Steven Roman

Access Database Design & Programming

Friend Reviews

Reader Q&A

Lists with This Book

Community Reviews

new topic
Discuss This Book

Goodreads is hiring!

Genres

Books by Steven Roman

Share This Book

Share on your website

Trivia About Access Database D...

See a Problem?

Preview — Access Database Design & Programming by Steven Roman

Access Database Design & Programming

Friend Reviews

Reader Q&A

Lists with This Book

Community Reviews

new topicDiscuss This Book

Goodreads is hiring!

Genres

Books by Steven Roman

Share This Book

Share on your website

Trivia About Access Database D...

new topic
Discuss This Book