000 06751cam a2200637Ii 4500
001 on1054245751
003 OCoLC
005 20220711203208.0
006 m o d
007 cr cnu|||unuuu
008 180926s2018 inu o 001 0 eng d
040 _aN$T
_beng
_erda
_epn
_cN$T
_dN$T
_dEBLCP
_dUIU
_dYDX
_dDG1
_dMERER
_dIDB
_dTEFOD
_dOCLCF
_dOTZ
_dUAB
_dRECBK
_dLVT
019 _a1055263740
_a1055678926
020 _a9781119514732
_q(electronic bk.)
020 _a1119514738
_q(electronic bk.)
020 _a9781119549437
_q(electronic bk.)
020 _a1119549434
_q(electronic bk.)
020 _a9781119514749
_q(electronic bk.)
020 _a1119514746
_q(electronic bk.)
020 _z9781119514756
020 _z1119514754
029 1 _aCHVBK
_b549244794
029 1 _aCHNEW
_b001025669
035 _a(OCoLC)1054245751
_z(OCoLC)1055263740
_z(OCoLC)1055678926
037 _a94867909-E990-466A-B6CE-587267C727D2
_bOverDrive, Inc.
_nhttp://www.overdrive.com
050 4 _aZ699.4.M226
072 7 _aLAN
_x025000
_2bisacsh
082 0 4 _a025/.002855369
_223
049 _aMAIN
100 1 _aAlexander, Michael,
_d1972-
_eauthor.
_95199
245 1 0 _aAccess 2019 Bible /
_cMichael Alexander, Dick Kusleika.
246 1 4 _aMicrosoft Access 2019 Bible
264 1 _aIndianapolis, IN :
_bWiley,
_c[2019]
300 _a1 online resource.
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
500 _aIncludes index.
588 _aOnline resource; title from PDF title page (EBSCO, viewed September 27, 2018).
505 0 _aCover; Title Page; Copyright; About the Authors; About the Technical Editor; Credits; Acknowledgments; Contents; Introduction; Is This Book for You?; Conventions Used in This Book; How This Book Is Organized; How to Use This Book; What's on the Website; Part I: Access Building Blocks; Chapter 1: An Introduction to Database Development; The Database Terminology of Access; Databases; Tables; Records and fields; Values; Relational Databases; Access Database Objects; Tables; Queries; Data-entry and display forms; Reports; Macros and VBA; Planning for database objects; A Five-Step Design Method
505 8 _aStep 1: The overall design-from concept to realityStep 2: Report design; Step 3: Data design; Step 4: Table design; Step 5: Form design; Chapter 2: Getting Started with Access; The Access Welcome Screen; How to Create a Blank Database; The Access 2019 Interface; The Navigation pane; Custom; Object Type; Tables and Related Views; Created Date; Modified Date; The Ribbon; The Quick Access toolbar; Part II: Understanding Access Tables; Chapter 3: Creating Access Tables; Table Types; Object tables; Transaction tables; Join tables; Creating a New Table; Designing tables; Using the Design tab
505 8 _aPrimary KeyInsert Rows; Delete Rows; Property Sheet; Indexes; Working with fields; Naming a field; Specifying a data type; Entering a field description; Specifying data validation rules; Creating tblCustomers; Using AutoNumber fields; Completing tblCustomers; Changing a Table Design; Inserting a new field; Deleting a field; Changing a field location; Changing a field name; Changing a field size; Handling data conversion issues; Assigning field properties; Common properties; Format; Input Mask; Caption; Validation Rule and Validation Text; Required; AllowZeroLength; Indexed
505 8 _aUnderstanding tblCustomers Field PropertiesSetting the Primary Key; Choosing a primary key; Creating the primary key; Creating composite primary keys; Indexing Access Tables; The importance of indexes; Multiple-field indexes; When to index tables; Printing a Table Design; Saving the Completed Table; Manipulating Tables; Renaming tables; Deleting tables; Copying tables in a database; Copying a table to another database; Adding Records to a Database Table; Understanding Attachment Fields; Chapter 4: Understanding Table Relationships; Building Bulletproof Databases
505 8 _aData Normalization and DenormalizationFirst normal form; Second normal form; Identifying entities; Less obvious entities; Breaking the rules; Third normal form; Denormalization; Table Relationships; Connecting the data; One-to-one; One-to-many; Many-to-many; Integrity Rules; No primary key can contain a null value; All foreign key values must be matched by corresponding primary keys; Keys; Deciding on a primary key; Looking at the benefits of a primary key; Designating a primary key; Single-field versus composite primary keys; Natural versus surrogate primary keys; Creating primary keys
520 _aMaster database creation and management Access 2019 Bible is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2019 has to offer. Whether you're new to Access or getting started with Access 2019, you'll find everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way. The companion website features all examples and databases used in the book, plus trial software and a special offer from Database Creations. Start from the beginning for a complete tutorial, or dip in and grab what you need when you need it. Access enables database novices and programmers to store, organize, view, analyze, and share data, as well as build powerful, integrable, custom database solutions-but databases can be complex, and difficult to navigate. This book helps you harness the power of the database with a solid understanding of their purpose, construction, and application. -Understand database objects and design systems objects -Build forms, create tables, manipulate datasheets, and add data validation -Use Visual Basic automation and XML Data Access Page design -Exchange data with other Office applications, including Word, Excel, and more From database fundamentals and terminology to XML and Web services, this book has everything you need to maximize Access 2019 and build the database you need.
630 0 0 _aMicrosoft Access
_vHandbooks, manuals, etc.
_95200
630 0 7 _aMicrosoft Access.
_2fast
_0(OCoLC)fst01371910
_95201
650 7 _aLANGUAGE ARTS & DISCIPLINES / Library & Information Science / General.
_2bisacsh
_95202
655 4 _aElectronic books.
_93294
655 7 _aHandbooks and manuals.
_2fast
_0(OCoLC)fst01423877
_94945
700 1 _aKusleika, Dick,
_eauthor.
_95203
776 0 8 _iPrint version:
_z1119514754
_z9781119514756
_w(OCoLC)1027177846
856 4 0 _uhttps://doi.org/10.1002/9781119549437
_zWiley Online Library
942 _cEBK
994 _a92
_bDG1
999 _c68435
_d68435