Poetry Madness
 
 

Recently Viewed clear list


Interviews | March 17, 2014

Shawn Donley: IMG Peter Stark: The Powells.com Interview



Peter StarkIt's hard to believe that 200 years ago, the Pacific Northwest was one of the most remote and isolated regions in the world. In 1810, four years... Continue »
  1. $19.59 Sale Hardcover add to wish list

spacer

Access Database Design & Programming 3RD Edition

by

Access Database Design & Programming 3RD Edition Cover

 

Synopses & Reviews

Publisher Comments:

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.

Synopsis:

This volume takes the reader 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.

Synopsis:

For programmers who prefer content to frills, this guide has succinct and straightforward information for putting Access to its full, individually tailored use.

About the Author

Dr. Roman has authored 32 books, including a number of books on mathematics, such as Coding and Information Theory, Advanced Linear Algebra, and Field Theory, published by Springer-Verlag. He has also written Modules in Mathematics, a series of 15 small books designed for the general college-level liberal arts student. Besides his books for O'Reilly, Dr. Roman has written two other computer books, both published by Springer-Verlag.

Table of Contents

PrefacePart I: Database Design
  • Chapter 1: Introduction
  • Chapter 2: The Entity-Relationship Model of a Database
  • Chapter 3: Implementing Entity-Relationship Models: Relational Databases
  • Chapter 4: Database Design Principles
Part II: Database Queries
  • Chapter 5: Query Languages and the Relational Algebra
  • Chapter 6: Access Structured Query Language (SQL)
Part III: Database Architecture
  • Chapter 7: Database System Architecture
Part IV: Visual Basic for Applications
  • Chapter 8: The Visual Basic Editor, Part I
  • Chapter 9: The Visual Basic Editor, Part II
  • Chapter 10: Variables, Data Types, and Constants
  • Chapter 11: Functions and Subroutines
  • Chapter 12: Built-in Functions and Statements
  • Chapter 13: Control Statements
Part V: Data Access Objects
  • Chapter 14: Programming DAO: Overview
  • Chapter 15: Programming DAO: Data Definition Language
  • Chapter 16: Programming DAO: Data Manipulation Language
Part VI: ActiveX Data Objects
  • Chapter 17: ADO and OLE DB
  • Chapter 18: ADOX: Jet Data Definition in ADO
Part VII: Programming Problems
  • Chapter 19: Some Common Data Manipulation Problems
Part VIII: Appendixes
  • Appendix A: DAO 3.0/3.5 Collections, Properties, and Methods
  • Appendix B: The Quotient: An Additional Operation of the Relational Algebra
  • Appendix C: Open Database Connectivity (ODBC)
  • Appendix D: Obtaining or Creating the Sample Database
  • Appendix E: Suggestions for Further Reading
Colophon

Product Details

ISBN:
9780596002732
Author:
Roman, Steven
Publisher:
O'Reilly Media
Location:
Sebastopol CA
Subject:
Database Management - General
Subject:
Database Management - MSAccess
Subject:
Database management
Subject:
Database design
Subject:
Microsoft Access
Subject:
Desktop Applications - MS Access
Subject:
Personal Computers-Desktop Applications-Databases
Edition Number:
3
Edition Description:
Third Edition
Series:
Nutshell Handbook
Series Volume:
no. 1087
Publication Date:
20020131
Binding:
TRADE PAPER
Language:
English
Illustrations:
Yes
Pages:
450
Dimensions:
9.19 x 7 x 0.94 in 1.54 lb

Other books you might like

  1. Net Gotchas New Trade Paper $39.95
  2. Transact-SQL Cookbook New Trade Paper $40.95
  3. Silmarillion, 2nd Edition
    Used Mass Market $4.50
  4. Series of Unfortunate Events #09:...
    Used Hardcover $2.50
  5. Mastering Perl/TK New Trade Paper $50.25
  6. Beginning VB .Net Databases: From... New Trade Paper $49.99

Related Subjects

Computers and Internet » Operating Systems » General
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Databases

Access Database Design & Programming 3RD Edition New Trade Paper
0 stars - 0 reviews
$39.99 In Stock
Product details 450 pages O'Reilly & Associates - English 9780596002732 Reviews:
"Synopsis" by , This volume takes the reader 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.
"Synopsis" by ,
For programmers who prefer content to frills, this guide has succinct and straightforward information for putting Access to its full, individually tailored use.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.