Access 2019 Bible / (Record no. 648833)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 06383cam a2200529Ii 4500 |
| 001 - CONTROL NUMBER | |
| control field | on1054245751 |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20250919141832.0 |
| 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS | |
| fixed length control field | m o d |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | cr cnu|||unuuu |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 180926s2018 inu o 001 0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781119514732 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 1119514738 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781119549437 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 1119549434 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781119514749 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 1119514746 |
| Qualifying information | (electronic bk.) |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | CHVBK |
| System control number | 549244794 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | CHNEW |
| System control number | 001025669 |
| 037 ## - SOURCE OF ACQUISITION | |
| Stock number | 94867909-E990-466A-B6CE-587267C727D2 |
| Source of stock number/acquisition | OverDrive, Inc. |
| Note | http://www.overdrive.com |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | NST |
| Language of cataloging | eng |
| Description conventions | rda |
| -- | pn |
| Transcribing agency | NST |
| Modifying agency | NST |
| -- | EBLCP |
| -- | UIU |
| -- | YDX |
| -- | DG1 |
| -- | MERER |
| -- | IDB |
| -- | TEFOD |
| -- | OCLCF |
| -- | OTZ |
| -- | UAB |
| -- | RECBK |
| -- | LVT |
| 049 ## - LOCAL HOLDINGS (OCLC) | |
| Holding library | MAIN |
| 090 ## - LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN) | |
| Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR) | Z699.4 |
| Local cutter number (OCLC) ; Book number/undivided call number, CALL (RLIN) | .M226 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Alexander, Michael, |
| Dates associated with a name | 1972-, |
| Relator term | author. |
| 245 10 - TITLE STATEMENT | |
| Title | Access 2019 Bible / |
| Statement of responsibility, etc. | Michael Alexander, Dick Kusleika. |
| 246 14 - VARYING FORM OF TITLE | |
| Title proper/short title | Microsoft Access 2019 Bible |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Place of production, publication, distribution, manufacture | Indianapolis, IN : |
| Name of producer, publisher, distributor, manufacturer | Wiley, |
| Date of production, publication, distribution, manufacture, or copyright notice | [2019] |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 1 online resource. |
| 336 ## - CONTENT TYPE | |
| Content type term | text |
| Source | rdacontent |
| 337 ## - MEDIA TYPE | |
| Media type term | computer |
| Source | rdamedia |
| 338 ## - CARRIER TYPE | |
| Carrier type term | online resource |
| Source | rdacarrier |
| 500 ## - GENERAL NOTE | |
| General note | Includes index. |
| 588 ## - SOURCE OF DESCRIPTION NOTE | |
| Source of description note | Online resource; title from PDF title page (EBSCO, viewed September 27, 2018). |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Cover; 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# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Step 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# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Primary 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# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Understanding 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# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Data 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 ## - SUMMARY, ETC. | |
| Summary, etc. | Master 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 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE | |
| Uniform title | Microsoft Access |
| Form subdivision | Handbooks, manuals, etc. |
| 655 #4 - INDEX TERM--GENRE/FORM | |
| Genre/form data or focus term | Electronic books. |
| 700 1# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Kusleika, Dick, |
| Relator term | author. |
| 776 08 - ADDITIONAL PHYSICAL FORM ENTRY | |
| Relationship information | Print version: |
| International Standard Book Number | 1119514754 |
| -- | 9781119514756 |
| Record control number | (OCoLC)1027177846 |
| 856 40 - ELECTRONIC LOCATION AND ACCESS | |
| Uniform Resource Identifier | <a href="https://eresourcesptsl.ukm.remotexs.co/user/login?url=https://doi.org/10.1002/9781119549437">https://eresourcesptsl.ukm.remotexs.co/user/login?url=https://doi.org/10.1002/9781119549437</a> |
| Public note | Wiley Online Library |
| 907 ## - LOCAL DATA ELEMENT G, LDG (RLIN) | |
| a | .b1681423x |
| b | 2022-11-03 |
| c | 2020-07-17 |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Suppress in OPAC | No |
| Call number prefix | Z699.4 .M226 |
| 998 ## - LOCAL CONTROL INFORMATION (RLIN) | |
| Library | |
| Operator's initials, OID (RLIN) | 2020-07-17 |
| Cataloger's initials, CIN (RLIN) | m |
| Material Type (Sierra) | E-Book |
| Language | English |
| Country | |
| -- | 0 |
| -- | .b1681423x |
No items available.