Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Best Books of the Year | December 9, 2014

    Aubrey: IMG Best YA Fiction of 2014



    So what is with all the hullabaloo about young adult literature these days? Do we have John Green to blame for getting us sucked in to the tragic... Continue »

    spacer
Qualifying orders ship free.
$39.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Personal Computers- Desktop Applications- Databases

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

Preface Part 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
Author:
Steven Roman,, PhD
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
Subject:
Data Modeling & Design
Subject:
CourseSmart Subject Description
Edition Number:
3
Edition Description:
Print PDF
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.95
  4. Series of Unfortunate Events #09:...
    Used Book Club Paperback $2.95
  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.