Access Database Design and Programming
Résumé
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.
Contents
Preface
Pt. I Database Design
1 Introduction 3
2 The Entity-Relationship Model of a Database 11
3 Implementing Entity-Relationship Models: Relational
Databases 18
4 Database Design Principles 35
Pt. II Database Queries
5 Query Languages and the Relational Algebra 51
6 Access Structured Query Language (SQL) 81
Pt. III Database Architecture
7 Database System Architecture 115
Pt. IV Visual Basic for Applications
8 The Visual Basic Editor, Part I 129
9 The Visual Basic Editor, Part II 137
10 Variables, Data Types, and Constants 146
11 Functions and Subroutines 165
12 Built-in Functions and Statements 173
13 Control Statements 191
Pt. V Data Access Objects
14 Programming DAO : Overview 201
15 Programming DAO : Data Definition Language 241
16 Programming DAO : Data Manipulation Language 254
Pt. VI ActiveX Data Objects
17 ADO and OLE DB 269
18 ADOX: Jet Data Definition in ADO 326
Pt. VII Programming Problems
19 Some Common Data Manipulation Problems 337
App. A DAO 3.0/3.5 Collections, Properties, and Methods
361
App. B The Quotient: An Additional Operation of the
Relational Algebra 378
App. C Open Database Connectivity (ODBC) 381
App. D Obtaining or Creating the Sample Database 401
App. E: Suggestions for Further Reading 411
Index 413
L'auteur - Steven Roman
Steven Roman is Professor Emeritus of mathematics at the California State University, Fullerton. 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 a series of 15 small books entitled Modules in Mathematics, designed for thegeneral college-level liberal arts student.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | O'Reilly |
| Auteur(s) | Steven Roman |
| Parution | 26/04/2001 |
| Édition | 3eme édition |
| Nb. de pages | 426 |
| Format | 18 x 23,5 |
| Couverture | Broché |
| Poids | 710g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780596002732 |
| ISBN13 | 978-0-59600-273-2 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
