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 |