000 | 04845nam a22003735 4500 | ||
---|---|---|---|
001 | bk 03357024 | ||
005 | 20240430143905.0 | ||
007 | ta | ||
008 | 050915s1999 xx eng d | ||
020 |
_a1565926269 (pbk.) : _c32.95 |
||
040 | _aBaker & Taylor | ||
069 | _a09092491 | ||
090 | _aQA 76.9 .D3 R65 1999 | ||
100 | 1 |
_aRoman, Steve. _969185 |
|
245 | 1 | 0 |
_aAccess database design & programming / _cSteven Roman. |
246 | 3 | _aAccess database design and programming | |
250 | _a2nd ed. | ||
260 |
_aSebastopol, CA : _bO'reilly, _c1999. |
||
300 |
_axx, 409 p. : _bill. ; _c24 cm |
||
500 | _a"What you really need to know to develop with Access"--Cover | ||
504 | _aIncludes bibliographical references (p. 395) and index | ||
505 | 0 | _aDatabase 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). | |
520 | 0 | _aDirected 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. | |
630 | 0 | 0 |
_aMicrosoft Access. _969186 |
650 | 0 |
_aDatabase management. _969187 |
|
650 | 0 |
_aDatabase design. _969188 |
|
852 |
_9p32.95 _y02-10-2000 |
||
907 |
_a12018 _b08-06-10 _c08-06-10 |
||
942 |
_cBOOK _00 |
||
998 |
_aaudmc _b02-10-00 _cm _da _e- _feng _gxx _h0 |
||
935 | _a1999-2000#2 /C | ||
945 |
_g0 _i613885 _j0 _laudmc _nCopy Type:01 - Books _o- _p121.09 _q- _r- _s- _t1 _u0 _v0 _w0 _x0 _yi10172117 _z08-06-10 |
||
999 |
_c12018 _d12018 |