"What you really need to know to develop with Access"--Cover

Includes bibliographical references (p. 395) and index

Database Design -- Database Programming -- The Entity-Relationship Model of a Database -- What Is a Database? -- Entities and Their Attributes -- Keys and Superkeys -- Relationships Between Entities -- Implementing Entity-Relationship Models: Relational Databases -- Implementing Entities -- A Short Glossary -- Implementing the Relationships in a Relational Database -- The Library Relational Database -- Index Files -- Null Values -- Database Design Principles -- Redundancy -- Normal Forms -- First Normal Form -- Functional Dependencies -- Second Normal Form -- Third Normal Form -- Boyce-Codd Normal Form -- Normalization -- Database Queries -- Query Languages and the Relational Algebra -- Query Languages -- Relational Algebra and Relational Calculus -- Details of the Relational Algebra -- Access Structured Query Language (SQL) -- Introduction to Access SQL -- Access Query Design -- Access Query Types -- Why Use SQL? -- Access SQL -- The DDL Component of Access SQL -- The DML Component of Access SQL -- Database Architecture -- Database System Architecture -- Why Program? -- Database Systems -- Database Management Systems -- The Jet DBMS -- Data Definition Languages -- Data Manipulation Languages -- Host Languages -- The Client/Server Architecture -- Visual Basic for Applications -- The Visual Basic Editor, Part I -- The Project Window -- The Properties Window -- The Code Window -- The Immediate Window -- Arranging Windows -- The Visual Basic Editor, Part II -- Navigating the IDE -- Getting Help -- Creating a Procedure -- Run Time, Design Time, and Break Mode -- Errors -- Debugging -- Variables, Data Types, and Constants -- Line Continuation -- Constants -- Variables and Data Types -- VBA Operators -- Functions and Subroutines -- Calling Functions -- Calling Subroutines -- Parameters and Arguments -- Exiting a Procedure -- Public and Private Procedures -- Fully Qualified Procedure Names -- Built-in Functions and Statements -- The MsgBox Function -- The InputBox Function -- VBA String Functions -- Miscellaneous Functions and Statements -- Handling Errors in Code -- Control Statements -- The If...Then Statement -- The For Loop -- Exit For -- The For Each Loop -- The Do Loop -- The Select Case Statement -- A Final Note on VBA -- Data Access Objects -- Programming DAO: Overview -- Objects -- The DAO Object Model -- The Microsoft Access Object Model -- Referencing Objects -- Collections Are Objects Too -- The Properties Collection -- Closing DAO Objects -- A Look at the DAO Objects -- The CurrentDb Function -- Programming DAO: Data Definition Language -- Creating a Database -- Opening a Database -- Creating a Table and Its Fields -- Creating an Index -- Creating a Relation -- Creating a QueryDef -- Programming DAO: Data Manipulation Language -- Recordset Objects -- Opening a Recordset -- Moving Through a Recordset -- Finding Records in a Recordset -- Editing Data Using a Recordset -- ActiveX Data Objects -- ADO and OLE DB -- What Is ADO? -- Installing ADO -- ADO and OLE DB -- The ADO Object Model -- Finding OLE DB Providers -- A Closer Look at Connection Strings -- DAO 3.0/3.5 Collections, Properties, and Methods -- The Quotient: An Additional Operation of the Relational Algebra -- Open Database Connectivity (ODBC).

Directed at Access developers of all levels, this second edition covers the new VBA Integrated Development Environment used by Word, Excell, and PowerPoint; the VBA language itself; Microsoft's latest data access technology, Active DataObjects; plus Open Database Connectivity.