{"product_id":"access-2019-for-dummies-isbn-9781119513261","title":"Access 2019 For Dummies","description":"\u003cp\u003e\u003cb\u003eEasy steps to practical databases\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePeople who really know how to build, populate, and simplify databases are few and far between. \u003ci\u003eAccess 2019 For Dummies \u003c\/i\u003eis here to help you join the ranks of office heroes who possess these precious skills.\u003c\/p\u003e \u003cp\u003eThis book offers clear and simple advice on how to build and operate databases as well as create simple forms, import data from outside sources, query databases for information, and share knowledge in reports. In short, it’s the book that holds all the secrets behind the mysteries of Access!\u003c\/p\u003e \u003cul\u003e \u003cli\u003eBuild effective databases from the ground up\u003c\/li\u003e \u003cli\u003eSimplify your data entry with forms and tables\u003c\/li\u003e \u003cli\u003eWrite queries that produce answers to your data questions\u003c\/li\u003e \u003cli\u003eSimplify input with forms\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eThere’s no time like the present to get your hands on the insight that database beginners need to become Access gurus.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eIntroduction\u003c\/b\u003e\u003cb\u003e 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAbout This Book 1\u003c\/p\u003e \u003cp\u003eFoolish Assumptions 2\u003c\/p\u003e \u003cp\u003eIcons Used in This Book 2\u003c\/p\u003e \u003cp\u003eWhere to Go from Here 3\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 1: Basic Training \u003c\/b\u003e\u003cb\u003e5\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Access 2019 Basic Training\u003c\/b\u003e\u003cb\u003e 7\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is Access Good For, Anyway? 8\u003c\/p\u003e \u003cp\u003eBuilding big databases 8\u003c\/p\u003e \u003cp\u003eCreating databases with multiple tables 9\u003c\/p\u003e \u003cp\u003eDatabases with user forms 12\u003c\/p\u003e \u003cp\u003eDatabases that require special reporting 13\u003c\/p\u003e \u003cp\u003eWhat’s New in Access 2019? 16\u003c\/p\u003e \u003cp\u003eReach Out with SharePoint 17\u003c\/p\u003e \u003cp\u003eHow Access Works and How You Work with it 18\u003c\/p\u003e \u003cp\u003eOpening Access 18\u003c\/p\u003e \u003cp\u003eSelecting a starting point 19\u003c\/p\u003e \u003cp\u003eNow What? 23\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Navigating the Access Workspace\u003c\/b\u003e\u003cb\u003e 25\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDiving Right In 27\u003c\/p\u003e \u003cp\u003eWorking with Onscreen Tools in Access 29\u003c\/p\u003e \u003cp\u003eClicking tabs 30\u003c\/p\u003e \u003cp\u003eUsing buttons 31\u003c\/p\u003e \u003cp\u003eThe File tab and Quick Access tools 31\u003c\/p\u003e \u003cp\u003eAccessing panes, panels, and context-sensitive tools 33\u003c\/p\u003e \u003cp\u003eCustomizing the Access Workspace 34\u003c\/p\u003e \u003cp\u003eRepositioning the Quick Access Toolbar 34\u003c\/p\u003e \u003cp\u003eAdding buttons to the Quick Access Toolbar 35\u003c\/p\u003e \u003cp\u003eRemoving buttons from the Quick Access Toolbar 37\u003c\/p\u003e \u003cp\u003eMinimizing the Ribbon 37\u003c\/p\u003e \u003cp\u003eWorking with ScreenTips 38\u003c\/p\u003e \u003cp\u003eMousing Around 41\u003c\/p\u003e \u003cp\u003eNavigating Access with the Alt Key 41\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Database Basics\u003c\/b\u003e\u003cb\u003e 43\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDatabase Lingo 43\u003c\/p\u003e \u003cp\u003eData, no matter how you pronounce it 44\u003c\/p\u003e \u003cp\u003eFields of dreams (or data) 44\u003c\/p\u003e \u003cp\u003eRecords 45\u003c\/p\u003e \u003cp\u003eTables 45\u003c\/p\u003e \u003cp\u003eThe database 45\u003c\/p\u003e \u003cp\u003eField Types and Uses 46\u003c\/p\u003e \u003cp\u003eChoosing Between Flat and Relational Databases 51\u003c\/p\u003e \u003cp\u003eIsolationist tables 51\u003c\/p\u003e \u003cp\u003eTables that mix and mingle 52\u003c\/p\u003e \u003cp\u003eBuilding a Database 53\u003c\/p\u003e \u003cp\u003eAdding and Removing Tables 57\u003c\/p\u003e \u003cp\u003eOne more, please 57\u003c\/p\u003e \u003cp\u003eOops, I didn’t mean to do that 59\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 2: Getting it All on the Table\u003c\/b\u003e\u003cb\u003e 61\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Sounds Like a Plan\u003c\/b\u003e\u003cb\u003e 63\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePlanning Your Database Tables 63\u003c\/p\u003e \u003cp\u003eReviewing fields 64\u003c\/p\u003e \u003cp\u003eDetermining data types 64\u003c\/p\u003e \u003cp\u003eThe new normal 66\u003c\/p\u003e \u003cp\u003eUnderstanding normal forms 66\u003c\/p\u003e \u003cp\u003eNormalizing your tables 67\u003c\/p\u003e \u003cp\u003eBuilding Tables in Design View 70\u003c\/p\u003e \u003cp\u003eCreating fields 70\u003c\/p\u003e \u003cp\u003eSetting data types 72\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Table Tune Ups\u003c\/b\u003e\u003cb\u003e 75\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Primary Key to Success 76\u003c\/p\u003e \u003cp\u003eThe lowdown on primary keys 76\u003c\/p\u003e \u003cp\u003eCreating a primary key 77\u003c\/p\u003e \u003cp\u003eMaking Tables Get Along 79\u003c\/p\u003e \u003cp\u003eRules of relationships 79\u003c\/p\u003e \u003cp\u003eRelationship types 80\u003c\/p\u003e \u003cp\u003eBuilding Table Relationships 82\u003c\/p\u003e \u003cp\u003eThe Relationships window 82\u003c\/p\u003e \u003cp\u003eTable relationships 83\u003c\/p\u003e \u003cp\u003eIndexing for Faster Queries 87\u003c\/p\u003e \u003cp\u003eCreating your own index 88\u003c\/p\u003e \u003cp\u003eAdding and removing indexes 91\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6: Remodeling Your Data\u003c\/b\u003e\u003cb\u003e 93\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOpening a Table for Editing 94\u003c\/p\u003e \u003cp\u003eInserting Records and Fields 97\u003c\/p\u003e \u003cp\u003eAdding a record 97\u003c\/p\u003e \u003cp\u003eInserting a field 98\u003c\/p\u003e \u003cp\u003eDeleting a field 101\u003c\/p\u003e \u003cp\u003eModifying Field Content 102\u003c\/p\u003e \u003cp\u003eName-Calling 103\u003c\/p\u003e \u003cp\u003eRenaming fields 104\u003c\/p\u003e \u003cp\u003eRenaming a table 106\u003c\/p\u003e \u003cp\u003eTurn Uh-Oh! into Yee-Hah! 108\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7: Types, Masks, and Triggers\u003c\/b\u003e\u003cb\u003e 109\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAccess Table Settings 110\u003c\/p\u003e \u003cp\u003eField Data Formats 112\u003c\/p\u003e \u003cp\u003eText fields 113\u003c\/p\u003e \u003cp\u003eNumber and currency fields 115\u003c\/p\u003e \u003cp\u003eDate\/time fields 118\u003c\/p\u003e \u003cp\u003eYes\/No fields 119\u003c\/p\u003e \u003cp\u003eGaining Control of Data Entry 121\u003c\/p\u003e \u003cp\u003eYou really need to put a mask on those fields 121\u003c\/p\u003e \u003cp\u003eTo require or not to require 128\u003c\/p\u003e \u003cp\u003eMaking your data toe the line with validation 129\u003c\/p\u003e \u003cp\u003eGive Your Fingers a Mini Vacation by Default 131\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 3: Data Management Mania\u003c\/b\u003e\u003cb\u003e 133\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8: A Form for All Reasons\u003c\/b\u003e\u003cb\u003e 135\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGenerating Forms 135\u003c\/p\u003e \u003cp\u003eKeeping it simple: Form tools 137\u003c\/p\u003e \u003cp\u003eGranting most wishes: The Form Wizard 139\u003c\/p\u003e \u003cp\u003eCustomizing Form Parts 143\u003c\/p\u003e \u003cp\u003eTaking the Layout view 143\u003c\/p\u003e \u003cp\u003eThe theme’s the thing 145\u003c\/p\u003e \u003cp\u003eManaging form controls 145\u003c\/p\u003e \u003cp\u003eManaging Data in Form View 150\u003c\/p\u003e \u003cp\u003eNavigating and finding records 150\u003c\/p\u003e \u003cp\u003eSaving, clearing, and deleting 151\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9: Importing and Exporting Data\u003c\/b\u003e\u003cb\u003e 153\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRetrieving Data from Other Sources 154\u003c\/p\u003e \u003cp\u003eTranslating data formats 154\u003c\/p\u003e \u003cp\u003eImporting and linking 157\u003c\/p\u003e \u003cp\u003eHit the Road, Data 162\u003c\/p\u003e \u003cp\u003eExport formats 162\u003c\/p\u003e \u003cp\u003eExporting table or query data 163\u003c\/p\u003e \u003cp\u003eExporting a report to PDF 165\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10: Automatically Editing Data\u003c\/b\u003e\u003cb\u003e 167\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePlease Read This First! 167\u003c\/p\u003e \u003cp\u003eCreating Consistent Corrections 170\u003c\/p\u003e \u003cp\u003eUsing Queries to Automate the Editing Process 173\u003c\/p\u003e \u003cp\u003eLooking for duplicate records 173\u003c\/p\u003e \u003cp\u003eRunning the Find Duplicates Query Wizard 174\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11: Access and the Web\u003c\/b\u003e\u003cb\u003e 179\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHow Access Works with the Web 179\u003c\/p\u003e \u003cp\u003eUnderstanding Office 365 180\u003c\/p\u003e \u003cp\u003eConnect Office 365 to Access 2019 181\u003c\/p\u003e \u003cp\u003eYour data and the cloud 182\u003c\/p\u003e \u003cp\u003eUpload your Access desktop data to the cloud 183\u003c\/p\u003e \u003cp\u003eClick! Using Hyperlinks in your desktop Access database 186\u003c\/p\u003e \u003cp\u003eAdding a Hyperlink field to your desktop database table 187\u003c\/p\u003e \u003cp\u003eFine-tuning your hyperlinks 188\u003c\/p\u003e \u003cp\u003eTesting links 190\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 4: The Power of Questions \u003c\/b\u003e\u003cb\u003e191\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12: Finding, Filtering, and Sorting Your Data — Fast\u003c\/b\u003e\u003cb\u003e 193\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing the Find Command 194\u003c\/p\u003e \u003cp\u003eFinding anything fast 194\u003c\/p\u003e \u003cp\u003eShifting Find into high gear 196\u003c\/p\u003e \u003cp\u003eSorting Alphabetically and Numerically 199\u003c\/p\u003e \u003cp\u003eSorting by a single field 199\u003c\/p\u003e \u003cp\u003eSorting on more than one field 200\u003c\/p\u003e \u003cp\u003eFast and Furious Filtering 201\u003c\/p\u003e \u003cp\u003eFiltering by a field’s content 202\u003c\/p\u003e \u003cp\u003eFilter by selection 203\u003c\/p\u003e \u003cp\u003eFilter by Form 204\u003c\/p\u003e \u003cp\u003eUnfiltering Filter by Form 207\u003c\/p\u003e \u003cp\u003eFilter by excluding selection 207\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13: I Was Just Asking for Answers\u003c\/b\u003e\u003cb\u003e 209\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSimple (Yet Potent) Filter and Sort Tools 210\u003c\/p\u003e \u003cp\u003eFilter things first 210\u003c\/p\u003e \u003cp\u003eFact-finding with fun, fast filtering 213\u003c\/p\u003e \u003cp\u003eHere’s the “advanced” part 214\u003c\/p\u003e \u003cp\u003eSelect Queries 220\u003c\/p\u003e \u003cp\u003eSolid relationships are the key to getting it all (from your tables) 221\u003c\/p\u003e \u003cp\u003eRunning the Query Wizard 221\u003c\/p\u003e \u003cp\u003eGetting Your Feet Wet with Ad Hoc Queries 227\u003c\/p\u003e \u003cp\u003eAdding the finishing touches 230\u003c\/p\u003e \u003cp\u003eSaving the query 231\u003c\/p\u003e \u003cp\u003eRunning your query 233\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14: I Want These AND Those OR Them\u003c\/b\u003e\u003cb\u003e 235\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWorking with AND and\/or OR 236\u003c\/p\u003e \u003cp\u003eData from here to there 237\u003c\/p\u003e \u003cp\u003eUsing multiple levels of AND 238\u003c\/p\u003e \u003cp\u003eEstablishing criteria with OR 239\u003c\/p\u003e \u003cp\u003eCombining AND with OR and OR with AND 240\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15: Number Crunching with the Total Row\u003c\/b\u003e\u003cb\u003e 243\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSay Hello to the Total Row 243\u003c\/p\u003e \u003cp\u003eAdding the Total Row to Your Queries 245\u003c\/p\u003e \u003cp\u003eWorking Out the Total Row 246\u003c\/p\u003e \u003cp\u003ePutting it together with Group By 247\u003c\/p\u003e \u003cp\u003eWell, that certainly sums it up 248\u003c\/p\u003e \u003cp\u003eCounting, the easy way 250\u003c\/p\u003e \u003cp\u003eNarrowing the results with Where 251\u003c\/p\u003e \u003cp\u003eCreating Your Own Top-Ten List 252\u003c\/p\u003e \u003cp\u003eChoosing the Right Field for the Summary Instruction 254\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 16: Express Yourself with Formulas\u003c\/b\u003e\u003cb\u003e 255\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA Simple Calculation 256\u003c\/p\u003e \u003cp\u003eComplex Calculations 258\u003c\/p\u003e \u003cp\u003eCalculate ’til you drop! 259\u003c\/p\u003e \u003cp\u003eUsing one calculation in another 259\u003c\/p\u003e \u003cp\u003eUsing parameter queries to ask for help 261\u003c\/p\u003e \u003cp\u003e“Adding” words with text formulas 262\u003c\/p\u003e \u003cp\u003eHooray for Expression Builder 264\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 17: Take Charge with Action Queries\u003c\/b\u003e\u003cb\u003e 269\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEasy Update 270\u003c\/p\u003e \u003cp\u003eAdd Records in a Flash 274\u003c\/p\u003e \u003cp\u003eQuick Cleanup 277\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 5: Simple and Snazzy Reporting\u003c\/b\u003e\u003cb\u003e 281\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 18: Fast and Furious Automatic Reporting\u003c\/b\u003e\u003cb\u003e 283\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eQuick and Not-S0-Dirty Automatic Reporting 284\u003c\/p\u003e \u003cp\u003eCreating a quick, one-table report 285\u003c\/p\u003e \u003cp\u003eStarting the Report Wizard 289\u003c\/p\u003e \u003cp\u003ePreviewing Your Report 294\u003c\/p\u003e \u003cp\u003eZooming in and out and all around 295\u003c\/p\u003e \u003cp\u003ePop goes the menu 297\u003c\/p\u003e \u003cp\u003eBeauty Is Only Skin (Report) Deep 298\u003c\/p\u003e \u003cp\u003eThe Print Options tab 298\u003c\/p\u003e \u003cp\u003eThe Page tab 300\u003c\/p\u003e \u003cp\u003eThe Columns tab 301\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 19: Professionally Designed Reports Made Easy \u003c\/b\u003e\u003cb\u003e303\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eReport Repairs 304\u003c\/p\u003e \u003cp\u003eReport Organization 305\u003c\/p\u003e \u003cp\u003eStructural devices 306\u003c\/p\u003e \u003cp\u003ePage breaks 308\u003c\/p\u003e \u003cp\u003eFormatting Stuff 310\u003c\/p\u003e \u003cp\u003eAdding color 313\u003c\/p\u003e \u003cp\u003eRelocation, relocation, relocation 314\u003c\/p\u003e \u003cp\u003eOne size does not fit all 316\u003c\/p\u003e \u003cp\u003eSpaced-out controls 317\u003c\/p\u003e \u003cp\u003eBorderline beauty 318\u003c\/p\u003e \u003cp\u003eTweaking your text 321\u003c\/p\u003e \u003cp\u003eSneaking a Peek 323\u003c\/p\u003e \u003cp\u003eGetting a Themes Makeover 324\u003c\/p\u003e \u003cp\u003eAdding More Design Elements 325\u003c\/p\u003e \u003cp\u003eDrawing lines 325\u003c\/p\u003e \u003cp\u003ePretty as a picture 326\u003c\/p\u003e \u003cp\u003eAdding a logo 327\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 20: Groups and Page Breaks, Headers and Footers\u003c\/b\u003e\u003cb\u003e 329\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA Place for Everything and Everything in Its Place 330\u003c\/p\u003e \u003cp\u003eLayout basics 330\u003c\/p\u003e \u003cp\u003eSections 332\u003c\/p\u003e \u003cp\u003eGrouping your records 335\u003c\/p\u003e \u003cp\u003eSo you want more? 338\u003c\/p\u003e \u003cp\u003eCustomizing Properties 338\u003c\/p\u003e \u003cp\u003eControlling report and page headings 341\u003c\/p\u003e \u003cp\u003eAdjusting individual sections 343\u003c\/p\u003e \u003cp\u003eItemized adjustments 344\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 21: Mailings to the Masses\u003c\/b\u003e\u003cb\u003e 351\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMassive Mailings with the Label Wizard 351\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 6: The Parts of Tens\u003c\/b\u003e\u003cb\u003e 359\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 22: Ten Common Problems\u003c\/b\u003e\u003cb\u003e 361\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThat’s Just Not Normal 362\u003c\/p\u003e \u003cp\u003eYou Type 73.725, but it Changes to 74 363\u003c\/p\u003e \u003cp\u003eThe Words They Are A-Changing 363\u003c\/p\u003e \u003cp\u003eWas There and Now It’s Gone 364\u003c\/p\u003e \u003cp\u003eUndo 365\u003c\/p\u003e \u003cp\u003eSearch for the missing record 365\u003c\/p\u003e \u003cp\u003eBackup recovery 365\u003c\/p\u003e \u003cp\u003eYou Run a Query, but the Results Aren’t What You Expect 366\u003c\/p\u003e \u003cp\u003eThe Dreaded Parameter Dialog Box 367\u003c\/p\u003e \u003cp\u003eThe Slowest Database in Town 368\u003c\/p\u003e \u003cp\u003eYour Database File Is as Big as a House 369\u003c\/p\u003e \u003cp\u003eYou Get a Mess When Importing Your Spreadsheet 371\u003c\/p\u003e \u003cp\u003eWe’re Sorry; Your Database File Is Corrupt 371\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 23: Ten Uncommon Tips\u003c\/b\u003e\u003cb\u003e 373\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDocument Everything as Though One Day You’ll Be Questioned by the FBI 374\u003c\/p\u003e \u003cp\u003eKeep Your Fields as Small as Possible 375\u003c\/p\u003e \u003cp\u003eUse Number Fields for Real Numbers 376\u003c\/p\u003e \u003cp\u003eValidate Your Data 376\u003c\/p\u003e \u003cp\u003eUse Understandable Names to Keep Things Simple 377\u003c\/p\u003e \u003cp\u003eDelete with Great Caution 377\u003c\/p\u003e \u003cp\u003eBackup, Backup, Backup 377\u003c\/p\u003e \u003cp\u003eThink, Think, and Think Again 378\u003c\/p\u003e \u003cp\u003eGet Organized and Stay Organized 378\u003c\/p\u003e \u003cp\u003eThere’s No Shame in Asking for Help 379\u003c\/p\u003e \u003cp\u003eAppendix A: Getting Help 381\u003c\/p\u003e \u003cp\u003eIndex 383\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eLaurie Ann Ulrich\u003c\/b\u003e has trained more than 20,000 people to make better, more creative use of their computers. She has created online courses and written more than 30 books.\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e\u003cb\u003eKen Cook\u003c\/b\u003e built and manages a computer consulting business that has helped users for over 20 years. He's an expert at creating Microsoft Office and Access database solutions and teaches online Access courses.   \u003c\/p\u003e\u003cul\u003e \u003cli\u003eGet a grasp on database design and functions\u003c\/li\u003e \u003cli\u003eCreate forms that simplify your data entry routine\u003c\/li\u003e \u003cli\u003eBuild reports that answer your data questions\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cb\u003eDiscover the easy way to access your data \u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eAccess is one of the most powerful and least understood elements of the Office suite. With this handy book as your guide, you'll be able to learn its secrets and demystify the world of databases! Look inside and learn how to build, populate, search, and simplify databases. Also discover how to create queries that answer data questions, develop data entry forms, and share your data in targeted reports. \t\u003c\/p\u003e\u003cp\u003e\u003cb\u003eInside…\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003eDatabase basics\u003c\/li\u003e \u003cli\u003eSetting data tables\u003c\/li\u003e \u003cli\u003eDefining data types\u003c\/li\u003e \u003cli\u003eSimplifying input with forms\u003c\/li\u003e \u003cli\u003eGrabbing data from elsewhere\u003c\/li\u003e \u003cli\u003eFinding the data you need\u003c\/li\u003e \u003cli\u003eWriting the right queries\u003c\/li\u003e \u003cli\u003eGenerating reports\u003c\/li\u003e \u003c\/ul\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":47988653097189,"sku":"NP9781119513261","price":29.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119513261.jpg?v=1761781128","url":"https:\/\/k12savings.com\/products\/access-2019-for-dummies-isbn-9781119513261","provider":"K12savings","version":"1.0","type":"link"}