| 000 -LEADER | |
|---|---|
| fixed length control field | 04845nam a22003735 4500 |
| 001 - CONTROL NUMBER | |
| control field | bk 03357024 |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20240430143905.0 |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | ta |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 050915s1999 xx eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 1565926269 (pbk.) : |
| Terms of availability | 32.95 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | Baker & Taylor |
| 069 ## - | |
| -- | 09092491 |
| 090 ## - LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC) | |
| Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR) | QA 76.9 .D3 R65 1999 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Roman, Steve. |
| 9 (RLIN) | 69185 |
| 245 10 - TITLE STATEMENT | |
| Title | Access database design & programming / |
| Statement of responsibility, etc | Steven Roman. |
| 246 3# - VARYING FORM OF TITLE | |
| Title proper/short title | Access database design and programming |
| 250 ## - EDITION STATEMENT | |
| Edition statement | 2nd ed. |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Place of publication, distribution, etc | Sebastopol, CA : |
| Name of publisher, distributor, etc | O'reilly, |
| Date of publication, distribution, etc | 1999. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | xx, 409 p. : |
| Other physical details | ill. ; |
| Dimensions | 24 cm |
| 500 ## - GENERAL NOTE | |
| General note | "What you really need to know to develop with Access"--Cover |
| 504 ## - BIBLIOGRAPHY, ETC. NOTE | |
| Bibliography, etc | Includes bibliographical references (p. 395) and index |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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). |
| 520 #0 - SUMMARY, ETC. | |
| Summary, etc | 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. |
| 630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE | |
| Uniform title | Microsoft Access. |
| 9 (RLIN) | 69186 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Database management. |
| 9 (RLIN) | 69187 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Database design. |
| 9 (RLIN) | 69188 |
| 852 ## - LOCATION/CALL NUMBER | |
| -- | p32.95 |
| -- | 02-10-2000 |
| 907 ## - LOCAL DATA ELEMENT G, LDG (RLIN) | |
| a | |
| b | 08-06-10 |
| c | 08-06-10 |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Koha item type | Books |
| 998 ## - LOCAL CONTROL INFORMATION (RLIN) | |
| -- | audmc |
| Operator's initials, OID (RLIN) | 02-10-00 |
| Cataloger's initials, CIN (RLIN) | m |
| First Date, FD (RLIN) | a |
| -- | - |
| -- | eng |
| -- | xx |
| -- | 0 |
| 935 ## - | |
| -- | 1999-2000#2 /C |
| 945 ## - LOCAL PROCESSING INFORMATION (OCLC) | |
| g | 0 |
| i | 613885 |
| j | 0 |
| l | audmc |
| n | Copy Type:01 - Books |
| o | - |
| p | 121.09 |
| q | - |
| r | - |
| s | - |
| t | 1 |
| u | 0 |
| v | 0 |
| w | 0 |
| x | 0 |
| y | i10172117 |
| z | 08-06-10 |
| Lost status | Source of classification or shelving scheme | Materials specified (bound volume or other part) | Damaged status | Not for loan | Home library | Current library | Shelving location | Date acquired | Cost, normal purchase price | Total Checkouts | Full call number | Barcode | Date last seen | Cost, replacement price | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Library of Congress Classification | Copy Type:01 - Books | American University in Dubai | American University in Dubai | Main Collection | 2010-08-06 | 121.09 | QA 76.9 .D3 R65 1999 | 613885 | 2023-12-01 | 121.09 | 2015-07-25 | Books |