{"product_id":"access-2019-bible-isbn-9781119514756","title":"Access 2019 Bible","description":"\u003cb\u003eMaster database creation and management\u003c\/b\u003e \u003cp\u003e\u003ci\u003eAccess 2019 Bible\u003c\/i\u003e 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.\u003c\/p\u003e \u003cp\u003eAccess 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.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eUnderstand database objects and design systems objects\u003c\/li\u003e \u003cli\u003eBuild forms, create tables, manipulate datasheets, and add data validation\u003c\/li\u003e \u003cli\u003eUse Visual Basic automation and XML Data Access Page design\u003c\/li\u003e \u003cli\u003eExchange data with other Office applications, including Word, Excel, and more\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eFrom 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.\u003c\/p\u003e \u003cp\u003eIntroduction xxxix\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I: Access Building Blocks 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: An Introduction to Database Development 3\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Database Terminology of Access 3\u003c\/p\u003e \u003cp\u003eRelational Databases 6\u003c\/p\u003e \u003cp\u003eAccess Database Objects 7\u003c\/p\u003e \u003cp\u003eA Five-Step Design Method 9\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Getting Started with Access 17\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Access Welcome Screen 17\u003c\/p\u003e \u003cp\u003eHow to Create a Blank Database 18\u003c\/p\u003e \u003cp\u003eThe Access 2019 Interface 20\u003c\/p\u003e \u003cp\u003eThe Ribbon 24\u003c\/p\u003e \u003cp\u003eThe Quick Access toolbar 25\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II: Understanding Access Tables 29\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Creating Access Tables 31\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTable Types 31\u003c\/p\u003e \u003cp\u003eCreating a New Table 32\u003c\/p\u003e \u003cp\u003eCreating tblCustomers 49\u003c\/p\u003e \u003cp\u003eChanging a Table Design 50\u003c\/p\u003e \u003cp\u003eUnderstanding tblCustomers Field Properties 68\u003c\/p\u003e \u003cp\u003eSetting the Primary Key 71\u003c\/p\u003e \u003cp\u003eIndexing Access Tables 73\u003c\/p\u003e \u003cp\u003ePrinting a Table Design 79\u003c\/p\u003e \u003cp\u003eSaving the Completed Table 81\u003c\/p\u003e \u003cp\u003eManipulating Tables 81\u003c\/p\u003e \u003cp\u003eAdding Records to a Database Table 84\u003c\/p\u003e \u003cp\u003eUnderstanding Attachment Fields 84\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Understanding Table Relationships 87\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBuilding Bulletproof Databases 88\u003c\/p\u003e \u003cp\u003eData Normalization and Denormalization 90\u003c\/p\u003e \u003cp\u003eTable Relationships 102\u003c\/p\u003e \u003cp\u003eIntegrity Rules 110\u003c\/p\u003e \u003cp\u003eKeys 113\u003c\/p\u003e \u003cp\u003eCreating relationships and enforcing referential integrity 119\u003c\/p\u003e \u003cp\u003eViewing all relationships 125\u003c\/p\u003e \u003cp\u003eDeleting relationships 126\u003c\/p\u003e \u003cp\u003eFollowing application-specific integrity rules 126\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Working with Access Tables 129\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Datasheets 130\u003c\/p\u003e \u003cp\u003eLooking at the Datasheet Window 131\u003c\/p\u003e \u003cp\u003eOpening a Datasheet 135\u003c\/p\u003e \u003cp\u003eEntering New Data 135\u003c\/p\u003e \u003cp\u003eNavigating Records in a Datasheet 142\u003c\/p\u003e \u003cp\u003eChanging Values in a Datasheet 146\u003c\/p\u003e \u003cp\u003eUsing the Undo Feature 148\u003c\/p\u003e \u003cp\u003eCopying and Pasting Values 148\u003c\/p\u003e \u003cp\u003eReplacing Values 149\u003c\/p\u003e \u003cp\u003eAdding New Records 150\u003c\/p\u003e \u003cp\u003eDeleting Records 150\u003c\/p\u003e \u003cp\u003eDisplaying Records 152\u003c\/p\u003e \u003cp\u003eSorting and Filtering Records in a Datasheet 160\u003c\/p\u003e \u003cp\u003eAggregating Data 165\u003c\/p\u003e \u003cp\u003ePrinting Records 166\u003c\/p\u003e \u003cp\u003ePreviewing Records 167\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6: Importing and Exporting Data 169\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHow Access Works with External Data 169\u003c\/p\u003e \u003cp\u003eOptions for Importing and Exporting 173\u003c\/p\u003e \u003cp\u003eExporting to External Formats 202\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7: Linking to External Data 209\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eLinking External Data 210\u003c\/p\u003e \u003cp\u003eWorking with Linked Tables 225\u003c\/p\u003e \u003cp\u003eSplitting a Database 229\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: Working with Access Queries 237\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8: Selecting Data with Queries 239\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Queries 240\u003c\/p\u003e \u003cp\u003eCreating a Query 241\u003c\/p\u003e \u003cp\u003eWorking with Query Fields 247\u003c\/p\u003e \u003cp\u003eAdding Criteria to Your Queries 252\u003c\/p\u003e \u003cp\u003ePrinting a Query’s Recordset 255\u003c\/p\u003e \u003cp\u003eSaving a Query 256\u003c\/p\u003e \u003cp\u003eCreating Multi-table Queries 256\u003c\/p\u003e \u003cp\u003eWorking with the Table Pane 261\u003c\/p\u003e \u003cp\u003eCreating and Working with Query Joins 262\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9: Using Operators and Expressions in Access 269\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Operators 269\u003c\/p\u003e \u003cp\u003eUsing Operators and Expressions in Queries 283\u003c\/p\u003e \u003cp\u003eEntering Single-Value Field Criteria 289\u003c\/p\u003e \u003cp\u003eUsing Multiple Criteria in a Query 297\u003c\/p\u003e \u003cp\u003eEntering Criteria in Multiple Fields 304\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10: Going Beyond Select Queries 311\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAggregate Queries 311\u003c\/p\u003e \u003cp\u003eAction Queries 320\u003c\/p\u003e \u003cp\u003eCrosstab Queries 336\u003c\/p\u003e \u003cp\u003eOptimizing Query Performance 348\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: Analyzing Data in Microsoft Access 353\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11: Transforming Data in Access 355\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFinding and Removing Duplicate Records 355\u003c\/p\u003e \u003cp\u003eCommon Transformation Tasks 363\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12: Working with Calculations and Dates 379\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing Calculations in Your Analyses 379\u003c\/p\u003e \u003cp\u003eUsing Dates in Your Analyses 392\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13: Performing Conditional Analyses 405\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing Parameter Queries 405\u003c\/p\u003e \u003cp\u003eUsing Conditional Functions 414\u003c\/p\u003e \u003cp\u003eThe Switch function 420\u003c\/p\u003e \u003cp\u003eComparing the IIf and Switch functions 421\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14: The Fundamentals of Using SQL 425\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Basic SQL 425\u003c\/p\u003e \u003cp\u003eGetting Fancy with Advanced SQL Statements 430\u003c\/p\u003e \u003cp\u003eShowing only the SELECT TOP or SELECT TOP PERCENT 433\u003c\/p\u003e \u003cp\u003ePerforming action queries via SQL statements 436\u003c\/p\u003e \u003cp\u003eUsing SQL-Specific Queries 438\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15: Subqueries and Domain Aggregate Functions 445\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEnhancing Your Analyses with Subqueries 446\u003c\/p\u003e \u003cp\u003eDomain Aggregate Functions 459\u003c\/p\u003e \u003cp\u003eExamining the syntax of domain aggregate functions 461\u003c\/p\u003e \u003cp\u003eUsing domain aggregate functions 463\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 16: Running Descriptive Statistics in Access 469\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBasic Descriptive Statistics 470\u003c\/p\u003e \u003cp\u003eAdvanced Descriptive Statistics 479\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Working with Access Forms and Reports 487\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 17: Creating Basic Access Forms 489\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWorking with Form Views 489\u003c\/p\u003e \u003cp\u003eUnderstanding Different Types of Forms 490\u003c\/p\u003e \u003cp\u003eWorking with Controls 503\u003c\/p\u003e \u003cp\u003eIntroducing Properties 524\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 18: Working with Data on Access Forms 531\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing Form View 532\u003c\/p\u003e \u003cp\u003eChanging Values in a Form 537\u003c\/p\u003e \u003cp\u003ePrinting a Form 544\u003c\/p\u003e \u003cp\u003eWorking with Form Properties 545\u003c\/p\u003e \u003cp\u003eAdding a Form Header or Footer 556\u003c\/p\u003e \u003cp\u003eWorking with Section Properties 556\u003c\/p\u003e \u003cp\u003eChanging the Layout 558\u003c\/p\u003e \u003cp\u003eConverting a Form to a Report 562\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 19: Working with Form Controls 563\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSetting Control Properties 563\u003c\/p\u003e \u003cp\u003eCreating a Calculated Control 571\u003c\/p\u003e \u003cp\u003eWorking with Subforms 572\u003c\/p\u003e \u003cp\u003eForm Design Tips 573\u003c\/p\u003e \u003cp\u003eTackling Advanced Forms Techniques 576\u003c\/p\u003e \u003cp\u003eUsing the Tab Control 583\u003c\/p\u003e \u003cp\u003eUsing Dialog Boxes to Collect Information 586\u003c\/p\u003e \u003cp\u003eDesigning a Form from Scratch 589\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 20: Presenting Data with Access Reports 599\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Reports 599\u003c\/p\u003e \u003cp\u003eCreating a Report, from Beginning to End 604\u003c\/p\u003e \u003cp\u003eCreating a report with the Report Wizard 605\u003c\/p\u003e \u003cp\u003eBanded Report Design Concepts 622\u003c\/p\u003e \u003cp\u003eCreating a Report from Scratch 628\u003c\/p\u003e \u003cp\u003eImproving the Report’s Appearance 651\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 21: Advanced Access Report Techniques 657\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGrouping and Sorting Data 658\u003c\/p\u003e \u003cp\u003eFormatting Data 670\u003c\/p\u003e \u003cp\u003eAdding Data 688\u003c\/p\u003e \u003cp\u003eAdding Even More Flexibility 690\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI: Microsoft Access Programming Fundamentals 703\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 22: Using Access Macros 705\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAn Introduction to Macros 705\u003c\/p\u003e \u003cp\u003eUnderstanding Macro Security 709\u003c\/p\u003e \u003cp\u003eMulti-action Macros 713\u003c\/p\u003e \u003cp\u003eSubmacros 716\u003c\/p\u003e \u003cp\u003eConditions 720\u003c\/p\u003e \u003cp\u003eTemporary Variables 723\u003c\/p\u003e \u003cp\u003eError Handling and Macro Debugging 728\u003c\/p\u003e \u003cp\u003eEmbedded Macros 734\u003c\/p\u003e \u003cp\u003eMacros versus VBA Statements 736\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 23: Using Access Data Macros 741\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Data Macros 742\u003c\/p\u003e \u003cp\u003eUnderstanding Table Events 742\u003c\/p\u003e \u003cp\u003eUsing the Macro Builder for Data Macros 745\u003c\/p\u003e \u003cp\u003eUnderstanding the Action Catalog 747\u003c\/p\u003e \u003cp\u003eCreating Your First Data Macro 751\u003c\/p\u003e \u003cp\u003eManaging Macro Objects 755\u003c\/p\u003e \u003cp\u003eRecognizing the Limitations of Data Macros 757\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 24: Getting Started with Access VBA 759\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Visual Basic for Applications 760\u003c\/p\u003e \u003cp\u003eUnderstanding VBA Terminology 761\u003c\/p\u003e \u003cp\u003eStarting with VBA Code Basics 762\u003c\/p\u003e \u003cp\u003eCreating VBA Programs 763\u003c\/p\u003e \u003cp\u003eModules and procedures 763\u003c\/p\u003e \u003cp\u003eWorking in the code window 770\u003c\/p\u003e \u003cp\u003eUnderstanding VBA Branching Constructs 777\u003c\/p\u003e \u003cp\u003eWorking with Objects and Collections 786\u003c\/p\u003e \u003cp\u003eExploring the Visual Basic Editor 792\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 25: Mastering VBA Data Types and Procedures 801\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing Variables 802\u003c\/p\u003e \u003cp\u003eWorking with Data Types 809\u003c\/p\u003e \u003cp\u003eUnderstanding Subs and Functions 829\u003c\/p\u003e \u003cp\u003eCreating Functions 835\u003c\/p\u003e \u003cp\u003eSimplifying Code with Named Arguments 840\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 26: Understanding the Access Event Model 843\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eProgramming Events 844\u003c\/p\u003e \u003cp\u003eIdentifying Common Events 847\u003c\/p\u003e \u003cp\u003ePaying Attention to Event Sequence 856\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 27: Debugging Your Access Applications 865\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOrganizing VBA Code 866\u003c\/p\u003e \u003cp\u003eTesting Your Applications 867\u003c\/p\u003e \u003cp\u003eTraditional Debugging Techniques 873\u003c\/p\u003e \u003cp\u003eUsing the Access Debugging Tools 879\u003c\/p\u003e \u003cp\u003eTrapping Errors in Your Code 893\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VII: Advanced Access Programming Techniques 899\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 28: Accessing Data with VBA 901\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWorking with Data 901\u003c\/p\u003e \u003cp\u003eUnderstanding DAO Objects 904\u003c\/p\u003e \u003cp\u003eUnderstanding ADO Objects 917\u003c\/p\u003e \u003cp\u003eWriting VBA Code to Update a Table 923\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 29: Advanced Data Access with VBA 937\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAdding an Unbound Combo Box to a Form to Find Data 937\u003c\/p\u003e \u003cp\u003eFiltering a Form 945\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 30: Customizing the Ribbon 955\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Ribbon Hierarchy 955\u003c\/p\u003e \u003cp\u003eControls for Access Ribbons 956\u003c\/p\u003e \u003cp\u003eEditing the Default Ribbon 961\u003c\/p\u003e \u003cp\u003eWorking with the Quick Access Toolbar 964\u003c\/p\u003e \u003cp\u003eDeveloping Custom Ribbons 966\u003c\/p\u003e \u003cp\u003eCreating a Custom Ribbon 969\u003c\/p\u003e \u003cp\u003eThe Basic Ribbon XML 977\u003c\/p\u003e \u003cp\u003eAdding Ribbon Controls 979\u003c\/p\u003e \u003cp\u003eAttaching Ribbons to Forms and Reports 989\u003c\/p\u003e \u003cp\u003eRemoving the Ribbon Completely 990\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 31: Preparing Your Access Application for Distribution 993\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDefining the Current Database Options 994\u003c\/p\u003e \u003cp\u003ePolishing Your Application 1009\u003c\/p\u003e \u003cp\u003eBulletproofing an Application 1022\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 32: Integrating Access with SharePoint 1039\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing SharePoint 1039\u003c\/p\u003e \u003cp\u003eUnderstanding SharePoint Sites 1040\u003c\/p\u003e \u003cp\u003eSharing Data between Access and SharePoint 1043\u003c\/p\u003e \u003cp\u003eUsing SharePoint Templates 1052\u003c\/p\u003e \u003cp\u003eIndex 1055\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eMichael Alexander\u003c\/b\u003e is a Microsoft Certified Application Developer (MCAD) and a Microsoft MVP with over 15 years of experience developing reporting solutions for a variety of industries. He is also the principal contributor at datapigtechnologies.com, where he shares video tutorials with the Microsoft Access and Excel communities. Mike has authored several books on advanced business analysis.\u003cb\u003e Dick Kusleika\u003c\/b\u003e is a 12-time Microsoft Excel MVP, and the principal contributor at the Daily Dose of Excel blog.   \u003c\/p\u003e\u003cp\u003e\u003cb\u003eThe definitive guide to Access database creation and management\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eLearn the essentials of using Microsoft Access to store data, analyze information, build reports, create applications and much more! With \u003ci\u003eMicrosoft\u003csup\u003e®\u003c\/sup\u003eAccess\u003csup\u003e®\u003c\/sup\u003e 2019 Bible\u003c\/i\u003e, you'll gain a solid understanding of how Access works from the ground up. \u003c\/p\u003e\u003cp\u003eStarting with basic database concepts, you'll work your way through detailed instruction on building effective tables, creating powerful analytical queries, creating robust applications with Access forms, and building attractive Access reports. With additional topics covering SharePoint integration and Visual Basic programming, \u003ci\u003eMicrosoft\u003csup\u003e®\u003c\/sup\u003e Access\u003csup\u003e®\u003c\/sup\u003e 2019 Bible\u003c\/i\u003e is an invaluable resource for users of all skill levels. \u003c\/p\u003e\u003cul\u003e \u003cli\u003eGet a solid grounding in database fundamentals\u003c\/li\u003e \u003cli\u003eUse Access to analyze large amounts of data\u003c\/li\u003e \u003cli\u003eTurn your data into attractive PDF-style reports and outputs\u003c\/li\u003e \u003cli\u003eAutomate redundant reporting and analysis using Access Macros\u003c\/li\u003e \u003cli\u003eBuild powerful departmental applications with Access Forms\u003c\/li\u003e \u003cli\u003eSave time and increase productivity with Access VBA\u003c\/li\u003e \u003cli\u003eIntegrate or publish your data on SharePoint sites\u003c\/li\u003e \u003cli\u003eFollow along with downloadable examples and database files  from the book\u003c\/li\u003e \u003cli\u003eCheck out trial software, demos, and other bonus material  on the  book's site\u003c\/li\u003e \u003c\/ul\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47988652966117,"sku":"NP9781119514756","price":58.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119514756.jpg?v=1761781128","url":"https:\/\/k12savings.com\/es\/products\/access-2019-bible-isbn-9781119514756","provider":"K12savings","version":"1.0","type":"link"}