Cargando…
Access 2019 Bible /
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autores principales: | , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
John Wiley & Sons, Inc.,
[2019]
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | OR_on1054245751 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu|||unuuu | ||
| 008 | 180926s2019 inua of 001 0 eng d | ||
| 040 | |a N$T |b eng |e rda |e pn |c N$T |d N$T |d EBLCP |d UIU |d YDX |d DG1 |d MERER |d IDB |d TEFOD |d OCLCF |d OTZ |d UAB |d RECBK |d LVT |d UKMGB |d U3W |d SOI |d OCLCQ |d ESU |d AU@ |d UKAHL |d K6U |d OCL |d OCLCQ |d S2H |d OCLCO |d OCLCQ |d OCLCO |d ORMDA |d OCLCQ |d FTB |d OCL |d OCLCQ |d OCLCO | ||
| 016 | 7 | |a 019079419 |2 Uk | |
| 019 | |a 1055263740 |a 1055678926 | ||
| 020 | |a 9781119514732 |q (electronic book) | ||
| 020 | |a 1119514738 |q (electronic book) | ||
| 020 | |a 9781119549437 |q (electronic book) | ||
| 020 | |a 1119549434 |q (electronic book) | ||
| 020 | |a 9781119514749 |q (electronic book) | ||
| 020 | |a 1119514746 |q (electronic book) | ||
| 020 | |z 9781119514756 | ||
| 020 | |z 1119514754 | ||
| 029 | 1 | |a AU@ |b 000064325474 | |
| 029 | 1 | |a AU@ |b 000068175618 | |
| 029 | 1 | |a CHNEW |b 001025669 | |
| 029 | 1 | |a CHVBK |b 549244794 | |
| 029 | 1 | |a GBVCP |b 1048687465 | |
| 029 | 1 | |a UKMGB |b 019079419 | |
| 035 | |a (OCoLC)1054245751 |z (OCoLC)1055263740 |z (OCoLC)1055678926 | ||
| 037 | |a 94867909-E990-466A-B6CE-587267C727D2 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 037 | |a 9781119514756 |b O'Reilly Media | ||
| 050 | 4 | |a QA76.9.D3 |b A493 2019 | |
| 050 | 4 | |a Z699.4.M226 | |
| 072 | 7 | |a LAN |x 025000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.75/65 |2 23 |
| 082 | 0 | 4 | |a 025/.002855369 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Alexander, Michael, |d 1972- |e author. | |
| 245 | 1 | 0 | |a Access 2019 Bible / |c Michael Alexander, Dick Kusleika. |
| 246 | 1 | 4 | |a Microsoft Access 2019 Bible |
| 264 | 1 | |a Indianapolis, IN : |b John Wiley & Sons, Inc., |c [2019] | |
| 300 | |a 1 online resource (xlii, 1091 pages) : |b color illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a data file | ||
| 500 | |a Includes index. | ||
| 500 | |a "The comprehensive tutorial resource"--Cover | ||
| 505 | 8 | |a 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 | |a 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 | |a 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 | |a 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 | |a 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 | |a 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. | ||
| 588 | 0 | |a Online resource; title from digital title page (viewed on July 05, 2023). | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Microsoft Access |v Handbooks, manuals, etc. |
| 630 | 0 | 7 | |a Microsoft Access |2 fast |
| 650 | 0 | |a Database management |v Handbooks, manuals, etc. | |
| 650 | 6 | |a Bases de données |x Gestion |v Guides, manuels, etc. | |
| 650 | 7 | |a LANGUAGE ARTS & DISCIPLINES |x Library & Information Science |x General. |2 bisacsh | |
| 650 | 7 | |a Database management |2 fast | |
| 655 | 2 | |a Handbook | |
| 655 | 7 | |a handbooks. |2 aat | |
| 655 | 7 | |a Handbooks and manuals |2 fast | |
| 655 | 7 | |a Handbooks and manuals. |2 lcgft | |
| 655 | 7 | |a Guides et manuels. |2 rvmgf | |
| 700 | 1 | |a Kusleika, Dick, |e author. | |
| 776 | 0 | 8 | |i Print version: |z 1119514754 |z 9781119514756 |w (OCoLC)1027177846 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781119514756/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH35259660 | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH35195118 | ||
| 938 | |a EBSCOhost |b EBSC |n 1901887 | ||
| 938 | |a Recorded Books, LLC |b RECE |n rbeEB00741694 | ||
| 938 | |a YBP Library Services |b YANK |n 15746032 | ||
| 938 | |a YBP Library Services |b YANK |n 15726947 | ||
| 994 | |a 92 |b IZTAP | ||