Da
HPB-Red, Dallas, TX, U.S.A.
Valutazione del venditore 5 su 5 stelle
Venditore AbeBooks dal 11 marzo 2019
Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Codice articolo S_423526252
"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 PowerPointAn expansion of the discussion of the VBA language itself, in response to reader requestsA 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.
Contenuti: Dedication; Preface; The Book’s Audience; Organization of This Book; Conventions in This Book; Obtaining Updated Information; Request for Comments; Acknowledgments; Database Design; Chapter 1: Introduction; 1.1 Database Design; 1.2 Database Programming; Chapter 2: The Entity-Relationship Model of a Database; 2.1 What Is a Database?; 2.2 Entities and Their Attributes; 2.3 Keys and Superkeys; 2.4 Relationships Between Entities; Chapter 3: Implementing Entity-Relationship Models: Relational Databases; 3.1 Implementing Entities; 3.2 A Short Glossary; 3.3 Implementing the Relationships in a Relational Database; 3.4 The LIBRARY Relational Database; 3.5 Index Files; 3.6 NULL Values; Chapter 4: Database Design Principles; 4.1 Redundancy; 4.2 Normal Forms; 4.3 First Normal Form; 4.4 Functional Dependencies; 4.5 Second Normal Form; 4.6 Third Normal Form; 4.7 Boyce-Codd Normal Form; 4.8 Normalization; Database Queries; Chapter 5: Query Languages and the Relational Algebra; 5.1 Query Languages; 5.2 Relational Algebra and Relational Calculus; 5.3 Details of the Relational Algebra; Chapter 6: Access Structured Query Language (SQL); 6.1 Introduction to Access SQL; 6.2 Access Query Design; 6.3 Access Query Types; 6.4 Why Use SQL?; 6.5 Access SQL; 6.6 The DDL Component of Access SQL; 6.7 The DML Component of Access SQL; Database Architecture; Chapter 7: Database System Architecture; 7.1 Why Program?; 7.2 Database Systems; 7.3 Database Management Systems; 7.4 The Jet DBMS; 7.5 Data Definition Languages; 7.6 Data Manipulation Languages; 7.7 Host Languages; 7.8 The Client/Server Architecture; Visual Basic for Applications; Chapter 8: The Visual Basic Editor, Part I; 8.1 The Project Window; 8.2 The Properties Window; 8.3 The Code Window; 8.4 The Immediate Window; 8.5 Arranging Windows; Chapter 9: The Visual Basic Editor, Part II; 9.1 Navigating the IDE; 9.2 Getting Help; 9.3 Creating a Procedure; 9.4 Run Time, Design Time, and Break Mode; 9.5 Errors; 9.6 Debugging; Chapter 10: Variables, Data Types, and Constants; 10.1 Comments; 10.2 Line Continuation; 10.3 Constants; 10.4 Variables and Data Types; 10.5 VBA Operators; Chapter 11: Functions and Subroutines; 11.1 Calling Functions; 11.2 Calling Subroutines; 11.3 Parameters and Arguments; 11.4 Exiting a Procedure; 11.5 Public and Private Procedures; 11.6 Fully Qualified Procedure Names; Chapter 12: Built-in Functions and Statements; 12.1 The MsgBox Function; 12.2 The InputBox Function; 12.3 VBA String Functions; 12.4 Miscellaneous Functions and Statements; 12.5 Handling Errors in Code; Chapter 13: Control Statements; 13.1 The If...Then Statement; 13.2 The For Loop; 13.3 Exit For; 13.4 The For Each Loop; 13.5 The Do Loop; 13.6 The Select Case Statement; 13.7 A Final Note on VBA; Data Access Objects; Chapter 14: Programming DAO: Overview; 14.1 Objects; 14.2 The DAO Object Model; 14.3 The Microsoft Access Object Model; 14.4 Referencing Objects; 14.5 Collections Are Objects Too; 14.6 The Properties Collection; 14.7 Closing DAO Objects; 14.8 A Look at the DAO Objects; 14.9 The CurrentDb Function; Chapter 15: Programming DAO: Data Definition Language; 15.1 Creating a Database; 15.2 Opening a Database; 15.3 Creating a Table and Its Fields; 15.4 Creating an Index; 15.5 Creating a Relation; 15.6 Creating a QueryDef; Chapter 16: Programming DAO: Data Manipulation Language; 16.1 Recordset Objects; 16.2 Opening a Recordset; 16.3 Moving Through a Recordset; 16.4 Finding Records in a Recordset; 16.5 Editing Data Using a Recordset; ActiveX Data Objects; Chapter 17: ADO and OLE DB; 17.1 What Is ADO?; 17.2 Installing ADO; 17.3 ADO and OLE DB; 17.4 The ADO Object Model; 17.5 Finding OLE DB Providers; 17.6 A Closer Look at Connection Strings; Appendixes; DAO 3.0/3.5 Collections, Properties, and Methods; DAO Classes; A Collection Object; Connection Object (DAO 3.5 Only); Container Object; Database Object; DBEngine Object; Document Object; Error Object; Field Object; Group Object; Index Object; Parameter Object; Property Object; QueryDef Object; Recordset Object; Relation Object; TableDef Object; User Object; Workspace Object; The Quotient: An Additional Operation of the Relational Algebra; Open Database Connectivity (ODBC); Introduction; The ODBC Driver Manager; The ODBC Driver; Data Sources; Getting ODBC Driver Help; Getting ODBC Information Using Visual Basic; Obtaining or Creating the Sample Database; Creating the Database; Creating the BOOKS Table; Creating the AUTHORS Table; Creating the PUBLISHERS Table; Creating the BOOK/AUTHOR Table; Backing Up the Database; Entering and Running the Sample Programs; Suggestions for Further Reading; Colophon;
Titolo: Access Database Design & Programming (...
Casa editrice: O'REILLY & ASSOCIATES
Data di pubblicazione: 1999
Legatura: paperback
Condizione: Good
Da: HPB-Red, Dallas, TX, U.S.A.
paperback. Condizione: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Codice articolo S_425436633
Quantità: 1 disponibili
Da: WorldofBooks, Goring-By-Sea, WS, Regno Unito
Paperback. Condizione: Good. The book has been read but remains in clean condition. All pages are intact and the cover is intact. Some minor wear to the spine. Codice articolo GOR002768094
Quantità: 2 disponibili
Da: WorldofBooks, Goring-By-Sea, WS, Regno Unito
Paperback. Condizione: Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Codice articolo GOR003234037
Quantità: 1 disponibili
Da: SecondSale, Montgomery, IL, U.S.A.
Condizione: Acceptable. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Codice articolo 00070854109
Quantità: 1 disponibili
Da: SecondSale, Montgomery, IL, U.S.A.
Condizione: Very Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Codice articolo 00072958558
Quantità: 1 disponibili
Da: SecondSale, Montgomery, IL, U.S.A.
Condizione: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Codice articolo 00069572992
Quantità: 1 disponibili
Da: Wonder Book, Frederick, MD, U.S.A.
Condizione: Very Good. Very Good condition. Sorry, CD missing. 2nd edition. A copy that may have a few cosmetic defects. May also contain light spine creasing or a few markings such as an owner's name, short gifter's inscription or light stamp. Codice articolo D01C-02024
Quantità: 1 disponibili
Da: Wonder Book, Frederick, MD, U.S.A.
Condizione: Good. Good condition. Nutshell Handbooks. 2nd edition. A copy that has been read but remains intact. May contain markings such as bookplates, stamps, limited notes and highlighting, or a few light stains. Bundled media such as CDs, DVDs, floppy disks or access codes may not be included. Codice articolo K13D-00080
Quantità: 1 disponibili
Da: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Paperback. Condizione: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 1.6. Codice articolo G1565926269I3N00
Quantità: 1 disponibili
Da: HPB-Emerald, Dallas, TX, U.S.A.
paperback. Condizione: Very Good. Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority! Codice articolo S_447852713
Quantità: 1 disponibili