| Description |
1 online resource (xx, 409 pages) : illustrations |
|
data file |
| Series |
In a Nutshell Ser. |
|
In a Nutshell Ser.
|
| Note |
"What you really need to know to develop with Access"--Cover |
| Bibliography |
Includes bibliographical references (page 395) and index. |
| Contents |
I. Database Design -- 1. Introduction -- 2. The Entity-Relationship Model of a Database -- 3. Implementing Entity-Relationship Models: Relational Databases -- 4. Database Design Principles -- II. Database Queries -- 5. Query Languages and the Relational Algebra -- 6. Access Structured Query Language (SQL) -- III. Database Architecture -- 7. Database System Architecture -- IV. Visual Basic for Applications -- 8. The Visual Basic Editor, Part I -- 9. The Visual Basic Editor, Part II -- 10. Variables, Data Types, and Constants -- 11. Functions and Subroutines -- 12. Built-in Functions and Statements -- 13. Control Statements -- V. Data Access Objects -- 14. Programming DAO: Overview -- 15. Programming DAO: Data Definition Language -- 16. Programming DAO: Data Manipulation Language -- VI. ActiveX Data Objects -- 17. ADO and OLE DB -- App. A. DAO 3.0/3.5 Collections, Properties, and Methods -- App. B. The Quotient: An Additional Operation of the Relational Algebra -- App. C. Open Database Connectivity (ODBC) -- App. D. Obtaining or Creating the Sample Database. |
| Summary |
When using software products with graphical interfaces, we frequently focus so much on the details of how to use the interface that we forget about the more general concepts that allow us to understand and put the software to effective use. This is particularly true of a powerful database product like Microsoft Access. Novice, and sometimes even experienced, programmers are so concerned with how something is done in Access that they often lose sight of the general principles that underlie their database applications. Access Database Design & Programming, 2nd Edition, an update to the bestselling first edition, features: A discussion of Access' new VBA Integrated Development Environment, which, for the first time, is the one used by Word, Excel, and PowerPoint An expansion of the discussion of the VBA language itself, in response to reader requests A discussion of Microsoft's latest data access technology, called Active Data Objects (or ADO), along with a discussion of Open Database Connectivity(ODBC), which is intimately connected with ADO Unlike other Access books that take the long, detailed approach to every topic of concern to Access programmers, this book focuses instead on the core concepts, enabling programmers to develop solid, effective database applications. As a result, important topics such as designing forms and reports, database security, database replication, and programming for multiuser applications are simply not discussed. This book is a kind of "second course" in Access that provides a relatively experienced Access user who is new to programming with the frequently overlooked techniques necessary to successfully develop in the Microsoft Access environment. Anyone interested in learning Access in-depth, rather than just scraping the surface, will enjoy and immensely benefit from reading this book. Although this book is really an introduction directed to intermediate Microsoft Access users who are novice programmers, it should appeal to all levels of Access developers. For novice programmers, it focuses on a key body of knowledge that is typically neglected, but is nevertheless essential for developing effective database applications. For intermediate and advanced developers, its treatment of database design and queries provides a handy treatment that otherwise has to be gleaned from relatively uninteresting textbooks, while its programming chapters constitute a handy reference to some basic operations that can be performed using DAO or the Access object model |
| Language |
English. |
| Subject |
Microsoft Access.
|
|
Microsoft Access |
|
Database management.
|
|
Database design.
|
|
Bases de données -- Gestion. |
|
Bases de données -- Conception. |
|
Database design |
|
Database management |
| Added Title |
Access database design and programming |
| Other Form: |
Print version: Roman, Steven. Access database design & programming. 2nd ed. Sebastopol, CA : O'Reilly, 1999 1565926269 (OCoLC)43501728 |
| ISBN |
1565928725 (electronic bk.) |
|
9781565928725 (electronic bk.) |
|
1565926269 |
|
9781565926264 |
| Standard No. |
9781565926264 |
|
More Resources