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