LEADER 05418nam 22007214a 450 001 9910455477403321 005 20200520144314.0 010 $a1-280-35404-6 010 $a9786610354047 010 $a0-7645-5705-X 035 $a(CKB)111087027802648 035 $a(EBL)176792 035 $a(OCoLC)53898572 035 $a(SSID)ssj0001686005 035 $a(PQKBManifestationID)16520321 035 $a(PQKBTitleCode)TC0001686005 035 $a(PQKBWorkID)15047882 035 $a(PQKB)10412654 035 $a(SSID)ssj0000096411 035 $a(PQKBManifestationID)11121853 035 $a(PQKBTitleCode)TC0000096411 035 $a(PQKBWorkID)10082392 035 $a(PQKB)11278670 035 $a(MiAaPQ)EBC176792 035 $a(Au-PeEL)EBL176792 035 $a(CaPaEBR)ebr10113927 035 $a(CaONFJC)MIL35404 035 $a(EXLCZ)99111087027802648 100 $a20030205d2004 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aAccess 2003 bible$b[electronic resource] /$fCary N. Prague, Michael R. Irwin, and Jennifer Reardon 205 $a1st ed. 210 $aHoboken, NJ $cWiley Pub.$dc2004 215 $a1 online resource (1466 p.) 225 1 $aBible 300 $aIncludes index. 311 $a0-7645-3986-8 327 $aAccess 2003 Bible; About the Author; Credits; Preface; Is This Book for You?; Conventions Used in This Book; Icons and Alerts; How This Book Is Organized; Guide to the Examples; Acknowledgments; Contents at a Glance; Contents; Part I: Creating Desktop Applications; Section I: Working with Data Tables and Queries; Chapter 1: Understanding Data; The Database Terminology of Access; Using More Than One Table; Access Database Objects and Views; The Seven-Step Design Method; Chapter 2: Creating and Building Tables; Creating Database Tables; Creating a Database; The Database Window 327 $aCreating a New TableThe Table Design Window; Creating the tblContacts Table; Changing a Table Design; Understanding Field Properties; Determining the Primary Key; Printing a Table Design; Saving the Completed Table; Manipulating Tables in a Database Window; Adding Records to a Database Table; Chapter 3: Entering Data into Tables and Forms; Understanding Datasheets; The Datasheet Window; Opening a Datasheet; Entering New Data; Navigating Records in a Datasheet; Changing Values in a Datasheet; Using the Undo Feature; Copying and Pasting Values; Replacing Values; Adding New Records 327 $aDeleting RecordsAdding, Changing, and Deleting Columns; Displaying Records; Sorting and Filtering Records in a Datasheet; Printing Records; Chapter 4: Creating and Understanding Relationships; Tables Used in the Access Auto Auctions Database; Understanding Keys; Understanding Relations between Tables; Understanding Referential Integrity; Creating Relationships; Using Subdatasheets; Chapter 5: Displaying Selected Data with Queries; Understanding Queries; Creating a Query; Selecting Fields; Displaying the Dynaset; Working with Fields; Changing the Sort Order; Displaying Only Selected Records 327 $aPrinting a Query DynasetSaving a Query; Adding More than One Table to a Query; Working with the Table/Query Pane; Adding Fields from More than One Table; Understanding the Limitations of Multiple-Table Queries; Creating and Working with Query Joins; Understanding Types of Table Joins; Chapter 6: Using Operators and Expressions in Multi-table Select Queries; What Are Operators?; Moving beyond Simple Queries; Entering Single-Value Field Criteria; Entering Multiple Criteria in One Field; Entering Criteria in Multiple Fields; Creating a New Calculated Field in a Query 327 $aChapter 7: Working with External DataAccess and External Data; Linking External Data; Working with Linked Tables; Importing External Data; Exporting to External Formats; Section II: Building Forms and Reports; Chapter 8: Understanding the Many Uses of Forms and Controls; Understanding Forms; Understanding Form Controls; What Is a Control?; Standards for Using Controls; Chapter 9: Building and Manipulating Forms and Controls; Creating a Form with Form Wizards; Changing the Design; Using the Form Window; Displaying Your Data with a Form; Saving a Record and the Form; Printing a Form 327 $aCreating New Controls 330 $aThe most comprehensive reference on this popular database management tool, fully updated with the new features of Access ""X"" including increased use of XML and Web servicesExplores the new, tighter integration with SharePoint and BizTalk in Office ""X"" that enables greater flexibility for gathering and manipulating dataWritten by an international bestselling author team with several books to their credit, including previous editions of Access BibleGets Access beginners started with hundreds of examples, tips, and techniques for getting the most from AccessOffers adva 410 0$aBible 606 $aDatabase management 608 $aElectronic books. 615 0$aDatabase management. 676 $a005.7565 700 $aPrague$b Cary N$0271538 701 $aIrwin$b Michael R$0271539 701 $aReardon$b Jennifer$01028701 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910455477403321 996 $aAccess 2003 bible$92444768 997 $aUNINA