Access 2019 Bible. ([2019])

• Record Type: Book
• Other Titles: Microsoft Access 2019 Bible
• Further Information: Note: Michael Alexander, Dick Kusleika.
• Authors: Alexander, Michael, 1972-; Kusleika, Dick
• Contents: 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 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 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 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 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
• Publisher Details: Indianapolis, IN : Wiley
• Publication Date: 2019
• Extent: 1 online resource
• Subjects: 025/.002855369; LANGUAGE ARTS & DISCIPLINES / Library & Information Science / General; Electronic books
• Languages: English
• ISBNs: 9781119514732; 1119514738; 9781119549437; 1119549434; 9781119514749; 1119514746
• Related ISBNs: 9781119514756; 1119514754
• Notes: Note: Online resource; title from PDF title page (EBSCO, viewed September 27, 2018).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.