{"product_id":"access-2016-bible-isbn-9781119086543","title":"Access 2016 Bible","description":"\u003cb\u003eMaster database creation and management\u003c\/b\u003e \u003cp\u003e\u003ci\u003eAccess 2016 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 2016 has to offer. Whether you're new to Access or getting started with Access 2016, 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 2016 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 10\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Getting Started with Access 19\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Access Welcome Screen 19\u003c\/p\u003e \u003cp\u003eHow to Create a Blank Desktop Database 21\u003c\/p\u003e \u003cp\u003eThe Access 2016 Interface 23\u003c\/p\u003e \u003cp\u003eThe Ribbon 26\u003c\/p\u003e \u003cp\u003eThe Quick Access toolbar 28\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II: Understanding Access Tables 31\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Creating Access Tables 33\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTable Types 33\u003c\/p\u003e \u003cp\u003eCreating a New Table 34\u003c\/p\u003e \u003cp\u003eCreating tblCustomers 51\u003c\/p\u003e \u003cp\u003eChanging a Table Design 52\u003c\/p\u003e \u003cp\u003eUnderstanding tblCustomers Field Properties 70\u003c\/p\u003e \u003cp\u003eSetting the Primary Key 73\u003c\/p\u003e \u003cp\u003eIndexing Access Tables 75\u003c\/p\u003e \u003cp\u003ePrinting a Table Design 81\u003c\/p\u003e \u003cp\u003eSaving the Completed Table 83\u003c\/p\u003e \u003cp\u003eManipulating Tables 83\u003c\/p\u003e \u003cp\u003eAdding Records to a Database Table 85\u003c\/p\u003e \u003cp\u003eUnderstanding Attachment Fields 86\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Understanding Table Relationships 89\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBuilding Bulletproof Databases 90\u003c\/p\u003e \u003cp\u003eData Normalization and Denormalization 92\u003c\/p\u003e \u003cp\u003eTable Relationships 104\u003c\/p\u003e \u003cp\u003eIntegrity Rules 113\u003c\/p\u003e \u003cp\u003eKeys 116\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Working with Access Tables 131\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Datasheets 132\u003c\/p\u003e \u003cp\u003eLooking at the Datasheet Window 134\u003c\/p\u003e \u003cp\u003eOpening a Datasheet 138\u003c\/p\u003e \u003cp\u003eEntering New Data 138\u003c\/p\u003e \u003cp\u003eNavigating Records in a Datasheet 145\u003c\/p\u003e \u003cp\u003eChanging Values in a Datasheet 148\u003c\/p\u003e \u003cp\u003eUsing the Undo Feature 150\u003c\/p\u003e \u003cp\u003eCopying and Pasting Values 151\u003c\/p\u003e \u003cp\u003eReplacing Values 152\u003c\/p\u003e \u003cp\u003eAdding New Records 153\u003c\/p\u003e \u003cp\u003eDeleting Records 153\u003c\/p\u003e \u003cp\u003eDisplaying Records 154\u003c\/p\u003e \u003cp\u003eSorting and Filtering Records in a Datasheet 163\u003c\/p\u003e \u003cp\u003eAggregating Data 168\u003c\/p\u003e \u003cp\u003ePrinting Records 169\u003c\/p\u003e \u003cp\u003ePreviewing Records 170\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6: Importing and Exporting Data 171\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHow Access Works with External Data 171\u003c\/p\u003e \u003cp\u003eOptions for Importing and Exporting 175\u003c\/p\u003e \u003cp\u003eImporting External Data 177\u003c\/p\u003e \u003cp\u003eExporting to External Formats 200\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 224\u003c\/p\u003e \u003cp\u003eSplitting a Database 228\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: Working with Access Queries 235\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8: Selecting Data with Queries 237\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Queries 238\u003c\/p\u003e \u003cp\u003eCreating a Query 240\u003c\/p\u003e \u003cp\u003eWorking with Query Fields 246\u003c\/p\u003e \u003cp\u003eAdding Criteria to Your Queries 250\u003c\/p\u003e \u003cp\u003ePrinting a Query’s Recordset 254\u003c\/p\u003e \u003cp\u003eSaving a Query 254\u003c\/p\u003e \u003cp\u003eCreating Multi-Table Queries 254\u003c\/p\u003e \u003cp\u003eWorking with the Table Pane 259\u003c\/p\u003e \u003cp\u003eCreating and Working with Query Joins 261\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9: Using Operators and Expressions in Access 267\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Operators 267\u003c\/p\u003e \u003cp\u003eUsing Operators and Expressions in Queries 282\u003c\/p\u003e \u003cp\u003eEntering Single-Value Field Criteria 288\u003c\/p\u003e \u003cp\u003eUsing Multiple Criteria in a Query 296\u003c\/p\u003e \u003cp\u003eEntering Criteria in Multiple Fields 302\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10: Going Beyond Select Queries 309\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAggregate Queries 309\u003c\/p\u003e \u003cp\u003eAction Queries 318\u003c\/p\u003e \u003cp\u003eCrosstab Queries 333\u003c\/p\u003e \u003cp\u003eOptimizing Query Performance 345\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: Analyzing Data in Access 349\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11: Transforming Data in Access 351\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFinding and Removing Duplicate Records 351\u003c\/p\u003e \u003cp\u003eCommon Transformation Tasks 359\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12: Working with Calculations and Dates 375\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing Calculations in Your Analyses 375\u003c\/p\u003e \u003cp\u003eUsing Dates in Your Analyses 388\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13: Performing Conditional Analyses 401\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing Parameter Queries 401\u003c\/p\u003e \u003cp\u003eUsing Conditional Functions 410\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14: The Fundamentals of Using SQL 421\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Basic SQL 421\u003c\/p\u003e \u003cp\u003eGetting Fancy with Advanced SQL Statements 426\u003c\/p\u003e \u003cp\u003eUsing SQL-Specific Queries 433\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15: Subqueries and Domain Aggregate Functions 441\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEnhancing Your Analyses with Subqueries 442\u003c\/p\u003e \u003cp\u003eDomain Aggregate Functions 455\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 16: Running Descriptive Statistics in Access 467\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBasic Descriptive Statistics 468\u003c\/p\u003e \u003cp\u003eAdvanced Descriptive Statistics 476\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Working with Access Forms and Reports 483\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 17: Creating Basic Access Forms 485\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFormulating Forms 486\u003c\/p\u003e \u003cp\u003eWorking with Controls 498\u003c\/p\u003e \u003cp\u003eIntroducing Properties 517\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 18: Working with Data on Access Forms 525\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing Form View 526\u003c\/p\u003e \u003cp\u003eChanging Values in a Form 531\u003c\/p\u003e \u003cp\u003ePrinting a Form 538\u003c\/p\u003e \u003cp\u003eWorking with Form Properties 539\u003c\/p\u003e \u003cp\u003eAdding a Form Header or Footer 550\u003c\/p\u003e \u003cp\u003eWorking with Section Properties 550\u003c\/p\u003e \u003cp\u003eChanging the Layout 552\u003c\/p\u003e \u003cp\u003eConverting a Form to a Report 556\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 19: Working with Form Controls 557\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSetting Control Properties 558\u003c\/p\u003e \u003cp\u003eCreating a Calculated Control 565\u003c\/p\u003e \u003cp\u003eWorking with Subforms 565\u003c\/p\u003e \u003cp\u003eForm Design Tips 567\u003c\/p\u003e \u003cp\u003eTackling Advanced Forms Techniques 570\u003c\/p\u003e \u003cp\u003eUsing the Tab Control 577\u003c\/p\u003e \u003cp\u003eUsing Dialog Boxes to Collect Information579\u003c\/p\u003e \u003cp\u003eDesigning a Form from Scratch 582\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 20: Presenting Data with Access Reports 591\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Reports 592\u003c\/p\u003e \u003cp\u003eCreating a Report, from Beginning to End 596\u003c\/p\u003e \u003cp\u003eBanded Report Design Concepts 614\u003c\/p\u003e \u003cp\u003eCreating a Report from Scratch 620\u003c\/p\u003e \u003cp\u003eImproving the Report’s Appearance 642\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 21: Advanced Access Report Techniques 649\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGrouping and Sorting Data 650\u003c\/p\u003e \u003cp\u003eFormatting Data 662\u003c\/p\u003e \u003cp\u003eAdding Data 680\u003c\/p\u003e \u003cp\u003eAdding Even More Flexibility 682\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI: Access Programming Fundamentals 695\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 22: Using Access Macros 697\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAn Introduction to Macros 698\u003c\/p\u003e \u003cp\u003eUnderstanding Macro Security 702\u003c\/p\u003e \u003cp\u003eMulti-Action Macros 706\u003c\/p\u003e \u003cp\u003eSubmacros 709\u003c\/p\u003e \u003cp\u003eConditions 713\u003c\/p\u003e \u003cp\u003eTemporary Variables 716\u003c\/p\u003e \u003cp\u003eError Handling and Macro Debugging 721\u003c\/p\u003e \u003cp\u003eEmbedded Macros 727\u003c\/p\u003e \u003cp\u003eMacros versus VBA Statements 729\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 23: Using Access Data Macros 733\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Data Macros 734\u003c\/p\u003e \u003cp\u003eUnderstanding Table Events 735\u003c\/p\u003e \u003cp\u003eUsing the Macro Designer for Data Macros 738\u003c\/p\u003e \u003cp\u003eUnderstanding the Action Catalog 740\u003c\/p\u003e \u003cp\u003eCreating Your First Data Macro 743\u003c\/p\u003e \u003cp\u003eManaging Macro Objects 747\u003c\/p\u003e \u003cp\u003eRecognizing the Limitations of Data Macros 749\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 24: Getting Started with Access VBA 751\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Visual Basic for Applications 752\u003c\/p\u003e \u003cp\u003eUnderstanding VBA Terminology 754\u003c\/p\u003e \u003cp\u003eStarting with VBA Code Basics 755\u003c\/p\u003e \u003cp\u003eCreating VBA Programs 755\u003c\/p\u003e \u003cp\u003eUnderstanding VBA Branching Constructs 770\u003c\/p\u003e \u003cp\u003eWorking with Objects and Collections 780\u003c\/p\u003e \u003cp\u003eExploring the Visual Basic Editor 785\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 25: Mastering VBA Data Types and Procedures 795\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing Variables 796\u003c\/p\u003e \u003cp\u003eWorking with Data Types 803\u003c\/p\u003e \u003cp\u003eUnderstanding Subs and Functions824\u003c\/p\u003e \u003cp\u003eCreating Functions 830\u003c\/p\u003e \u003cp\u003eSimplifying Code with Named Arguments 836\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 26: Understanding the Access Event Model 839\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eProgramming Events 840\u003c\/p\u003e \u003cp\u003eIdentifying Common Events 843\u003c\/p\u003e \u003cp\u003ePaying Attention to Event Sequence 852\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 27: Debugging Your Access Applications 861\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOrganizing VBA Code 862\u003c\/p\u003e \u003cp\u003eTesting Your Applications 863\u003c\/p\u003e \u003cp\u003eTraditional Debugging Techniques 870\u003c\/p\u003e \u003cp\u003eUsing the Access Debugging Tools 876\u003c\/p\u003e \u003cp\u003eTrapping Errors in Your Code 889\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VII: Advanced Access Programming Techniques 895\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 28: Accessing Data with VBA Code 897\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWorking with Data 897\u003c\/p\u003e \u003cp\u003eUnderstanding ADO Objects 901\u003c\/p\u003e \u003cp\u003eUnderstanding DAO Objects 914\u003c\/p\u003e \u003cp\u003eWriting VBA Code to Update a Table 924\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 29: Advanced Data Access with VBA 941\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAdding an Unbound Combo Box to a Form to Find Data 941\u003c\/p\u003e \u003cp\u003eFiltering a Form 949\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 30: Customizing the Ribbon 959\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Ribbon Hierarchy 959\u003c\/p\u003e \u003cp\u003eEditing the Default Ribbon 965\u003c\/p\u003e \u003cp\u003eWorking with the Quick Access Toolbar 968\u003c\/p\u003e \u003cp\u003eDeveloping Custom Ribbons 971\u003c\/p\u003e \u003cp\u003eCreating a Custom Ribbon 974\u003c\/p\u003e \u003cp\u003eThe Basic Ribbon XML 983\u003c\/p\u003e \u003cp\u003eAdding Ribbon Controls 985\u003c\/p\u003e \u003cp\u003eAttaching Ribbons to Forms and Reports 994\u003c\/p\u003e \u003cp\u003eRemoving the Ribbon Completely 996\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 31: Preparing Your Access Application for Distribution 999\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDefining the Current Database Options 1000\u003c\/p\u003e \u003cp\u003eDeveloping the Application 1009\u003c\/p\u003e \u003cp\u003ePolishing Your Application 1015\u003c\/p\u003e \u003cp\u003eBulletproofing an Application 1029\u003c\/p\u003e \u003cp\u003eSecuring the Environment 1040\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VIII: Access and Windows SharePoint Services 1045\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 32: Integrating Access with SharePoint 1047\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing SharePoint 1047\u003c\/p\u003e \u003cp\u003eUnderstanding SharePoint Sites 1048\u003c\/p\u003e \u003cp\u003eSharing Data between Access and SharePoint 1051\u003c\/p\u003e \u003cp\u003eUsing SharePoint Templates 1060\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 33: Deploying Access Applications to SharePoint 1063\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Web Publishing with Access 1064\u003c\/p\u003e \u003cp\u003eExamining the Limitations of Access Web Applications 1067\u003c\/p\u003e \u003cp\u003ePublishing a Custom Access Application to SharePoint 1070\u003c\/p\u003e \u003cp\u003eIndex 1091\u003c\/p\u003e   \u003cp\u003e\u003cb\u003eMichael Alexander\u003c\/b\u003e is a Microsoft Certified Application Developer. For more than 15 years, he has been consulting and developing Microsoft Office solutions. Michael is a Microsoft MVP and runs a free tutorial website at www.datapigtechnologies.com. \u003cb\u003eDick Kusleika\u003c\/b\u003e has been named a Microsoft MVP for 12 consecutive years. He develops Access- and Excel-based solutions for clients, and has worked with Microsoft Office for more than 20 years. Dick writes a popular Excel-related blog at www.dailydoseofexcel.com.       \u003c\/p\u003e\u003cp\u003e\u003cb\u003eTap into the power of Access 2016\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\u003eAccess 2016 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\u003eAccess 2016 Bible\u003c\/i\u003e is an invaluable resource for users of all skill levels.  \u003c\/p\u003e\u003cul\u003e \u003cli\u003e Get a solid grounding in database fundamentals\u003c\/li\u003e \u003cli\u003e Use Access to analyze large amounts of data\u003c\/li\u003e \u003cli\u003e Turn your data into attractive PDF-style reports and outputs\u003c\/li\u003e \u003cli\u003e Automate redundant reporting and analysis using Access macros\u003c\/li\u003e \u003cli\u003e Build powerful departmental applications with Access forms\u003c\/li\u003e \u003cli\u003e Save time and increase productivity with Access VBA\u003c\/li\u003e \u003cli\u003e Integrate or publish your data on SharePoint sites\u003c\/li\u003e \u003c\/ul\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47988652835045,"sku":"NP9781119086543","price":54.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119086543.jpg?v=1761781127","url":"https:\/\/k12savings.com\/products\/access-2016-bible-isbn-9781119086543","provider":"K12savings","version":"1.0","type":"link"}