Details

Access 2019 For Dummies


Access 2019 For Dummies


1. Aufl.

von: Laurie A. Ulrich, Ken Cook

22,99 €

Verlag: Wiley
Format: EPUB
Veröffentl.: 08.10.2018
ISBN/EAN: 9781119513285
Sprache: englisch
Anzahl Seiten: 432

DRM-geschütztes eBook, Sie benötigen z.B. Adobe Digital Editions und eine Adobe ID zum Lesen.

Beschreibungen

<p><b>Easy steps to practical databases</b></p> <p>People who really know how to build, populate, and simplify databases are few and far between. <i>Access 2019 For Dummies </i>is here to help you join the ranks of office heroes who possess these precious skills.</p> <p>This 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!</p> <ul> <li>Build effective databases from the ground up</li> <li>Simplify your data entry with forms and tables</li> <li>Write queries that produce answers to your data questions</li> <li>Simplify input with forms</li> </ul> <p>There’s no time like the present to get your hands on the insight that database beginners need to become Access gurus.</p>
<p><b>Introduction</b><b> 1</b></p> <p>About This Book 1</p> <p>Foolish Assumptions 2</p> <p>Icons Used in This Book 2</p> <p>Where to Go from Here 3</p> <p><b>Part 1: Basic Training </b><b>5</b></p> <p><b>Chapter 1: Access 2019 Basic Training</b><b> 7</b></p> <p>What Is Access Good For, Anyway? 8</p> <p>Building big databases 8</p> <p>Creating databases with multiple tables 9</p> <p>Databases with user forms 12</p> <p>Databases that require special reporting 13</p> <p>What’s New in Access 2019? 16</p> <p>Reach Out with SharePoint 17</p> <p>How Access Works and How You Work with it 18</p> <p>Opening Access 18</p> <p>Selecting a starting point 19</p> <p>Now What? 23</p> <p><b>Chapter 2: Navigating the Access Workspace</b><b> 25</b></p> <p>Diving Right In 27</p> <p>Working with Onscreen Tools in Access 29</p> <p>Clicking tabs 30</p> <p>Using buttons 31</p> <p>The File tab and Quick Access tools 31</p> <p>Accessing panes, panels, and context-sensitive tools 33</p> <p>Customizing the Access Workspace 34</p> <p>Repositioning the Quick Access Toolbar 34</p> <p>Adding buttons to the Quick Access Toolbar 35</p> <p>Removing buttons from the Quick Access Toolbar 37</p> <p>Minimizing the Ribbon 37</p> <p>Working with ScreenTips 38</p> <p>Mousing Around 41</p> <p>Navigating Access with the Alt Key 41</p> <p><b>Chapter 3: Database Basics</b><b> 43</b></p> <p>Database Lingo 43</p> <p>Data, no matter how you pronounce it 44</p> <p>Fields of dreams (or data) 44</p> <p>Records 45</p> <p>Tables 45</p> <p>The database 45</p> <p>Field Types and Uses 46</p> <p>Choosing Between Flat and Relational Databases 51</p> <p>Isolationist tables 51</p> <p>Tables that mix and mingle 52</p> <p>Building a Database 53</p> <p>Adding and Removing Tables 57</p> <p>One more, please 57</p> <p>Oops, I didn’t mean to do that 59</p> <p><b>Part 2: Getting it All on the Table</b><b> 61</b></p> <p><b>Chapter 4: Sounds Like a Plan</b><b> 63</b></p> <p>Planning Your Database Tables 63</p> <p>Reviewing fields 64</p> <p>Determining data types 64</p> <p>The new normal 66</p> <p>Understanding normal forms 66</p> <p>Normalizing your tables 67</p> <p>Building Tables in Design View 70</p> <p>Creating fields 70</p> <p>Setting data types 72</p> <p><b>Chapter 5: Table Tune Ups</b><b> 75</b></p> <p>The Primary Key to Success 76</p> <p>The lowdown on primary keys 76</p> <p>Creating a primary key 77</p> <p>Making Tables Get Along 79</p> <p>Rules of relationships 79</p> <p>Relationship types 80</p> <p>Building Table Relationships 82</p> <p>The Relationships window 82</p> <p>Table relationships 83</p> <p>Indexing for Faster Queries 87</p> <p>Creating your own index 88</p> <p>Adding and removing indexes 91</p> <p><b>Chapter 6: Remodeling Your Data</b><b> 93</b></p> <p>Opening a Table for Editing 94</p> <p>Inserting Records and Fields 97</p> <p>Adding a record 97</p> <p>Inserting a field 98</p> <p>Deleting a field 101</p> <p>Modifying Field Content 102</p> <p>Name-Calling 103</p> <p>Renaming fields 104</p> <p>Renaming a table 106</p> <p>Turn Uh-Oh! into Yee-Hah! 108</p> <p><b>Chapter 7: Types, Masks, and Triggers</b><b> 109</b></p> <p>Access Table Settings 110</p> <p>Field Data Formats 112</p> <p>Text fields 113</p> <p>Number and currency fields 115</p> <p>Date/time fields 118</p> <p>Yes/No fields 119</p> <p>Gaining Control of Data Entry 121</p> <p>You really need to put a mask on those fields 121</p> <p>To require or not to require 128</p> <p>Making your data toe the line with validation 129</p> <p>Give Your Fingers a Mini Vacation by Default 131</p> <p><b>Part 3: Data Management Mania</b><b> 133</b></p> <p><b>Chapter 8: A Form for All Reasons</b><b> 135</b></p> <p>Generating Forms 135</p> <p>Keeping it simple: Form tools 137</p> <p>Granting most wishes: The Form Wizard 139</p> <p>Customizing Form Parts 143</p> <p>Taking the Layout view 143</p> <p>The theme’s the thing 145</p> <p>Managing form controls 145</p> <p>Managing Data in Form View 150</p> <p>Navigating and finding records 150</p> <p>Saving, clearing, and deleting 151</p> <p><b>Chapter 9: Importing and Exporting Data</b><b> 153</b></p> <p>Retrieving Data from Other Sources 154</p> <p>Translating data formats 154</p> <p>Importing and linking 157</p> <p>Hit the Road, Data 162</p> <p>Export formats 162</p> <p>Exporting table or query data 163</p> <p>Exporting a report to PDF 165</p> <p><b>Chapter 10: Automatically Editing Data</b><b> 167</b></p> <p>Please Read This First! 167</p> <p>Creating Consistent Corrections 170</p> <p>Using Queries to Automate the Editing Process 173</p> <p>Looking for duplicate records 173</p> <p>Running the Find Duplicates Query Wizard 174</p> <p><b>Chapter 11: Access and the Web</b><b> 179</b></p> <p>How Access Works with the Web 179</p> <p>Understanding Office 365 180</p> <p>Connect Office 365 to Access 2019 181</p> <p>Your data and the cloud 182</p> <p>Upload your Access desktop data to the cloud 183</p> <p>Click! Using Hyperlinks in your desktop Access database 186</p> <p>Adding a Hyperlink field to your desktop database table 187</p> <p>Fine-tuning your hyperlinks 188</p> <p>Testing links 190</p> <p><b>Part 4: The Power of Questions </b><b>191</b></p> <p><b>Chapter 12: Finding, Filtering, and Sorting Your Data — Fast</b><b> 193</b></p> <p>Using the Find Command 194</p> <p>Finding anything fast 194</p> <p>Shifting Find into high gear 196</p> <p>Sorting Alphabetically and Numerically 199</p> <p>Sorting by a single field 199</p> <p>Sorting on more than one field 200</p> <p>Fast and Furious Filtering 201</p> <p>Filtering by a field’s content 202</p> <p>Filter by selection 203</p> <p>Filter by Form 204</p> <p>Unfiltering Filter by Form 207</p> <p>Filter by excluding selection 207</p> <p><b>Chapter 13: I Was Just Asking for Answers</b><b> 209</b></p> <p>Simple (Yet Potent) Filter and Sort Tools 210</p> <p>Filter things first 210</p> <p>Fact-finding with fun, fast filtering 213</p> <p>Here’s the “advanced” part 214</p> <p>Select Queries 220</p> <p>Solid relationships are the key to getting it all (from your tables) 221</p> <p>Running the Query Wizard 221</p> <p>Getting Your Feet Wet with Ad Hoc Queries 227</p> <p>Adding the finishing touches 230</p> <p>Saving the query 231</p> <p>Running your query 233</p> <p><b>Chapter 14: I Want These AND Those OR Them</b><b> 235</b></p> <p>Working with AND and/or OR 236</p> <p>Data from here to there 237</p> <p>Using multiple levels of AND 238</p> <p>Establishing criteria with OR 239</p> <p>Combining AND with OR and OR with AND 240</p> <p><b>Chapter 15: Number Crunching with the Total Row</b><b> 243</b></p> <p>Say Hello to the Total Row 243</p> <p>Adding the Total Row to Your Queries 245</p> <p>Working Out the Total Row 246</p> <p>Putting it together with Group By 247</p> <p>Well, that certainly sums it up 248</p> <p>Counting, the easy way 250</p> <p>Narrowing the results with Where 251</p> <p>Creating Your Own Top-Ten List 252</p> <p>Choosing the Right Field for the Summary Instruction 254</p> <p><b>Chapter 16: Express Yourself with Formulas</b><b> 255</b></p> <p>A Simple Calculation 256</p> <p>Complex Calculations 258</p> <p>Calculate ’til you drop! 259</p> <p>Using one calculation in another 259</p> <p>Using parameter queries to ask for help 261</p> <p>“Adding” words with text formulas 262</p> <p>Hooray for Expression Builder 264</p> <p><b>Chapter 17: Take Charge with Action Queries</b><b> 269</b></p> <p>Easy Update 270</p> <p>Add Records in a Flash 274</p> <p>Quick Cleanup 277</p> <p><b>Part 5: Simple and Snazzy Reporting</b><b> 281</b></p> <p><b>Chapter 18: Fast and Furious Automatic Reporting</b><b> 283</b></p> <p>Quick and Not-S0-Dirty Automatic Reporting 284</p> <p>Creating a quick, one-table report 285</p> <p>Starting the Report Wizard 289</p> <p>Previewing Your Report 294</p> <p>Zooming in and out and all around 295</p> <p>Pop goes the menu 297</p> <p>Beauty Is Only Skin (Report) Deep 298</p> <p>The Print Options tab 298</p> <p>The Page tab 300</p> <p>The Columns tab 301</p> <p><b>Chapter 19: Professionally Designed Reports Made Easy </b><b>303</b></p> <p>Report Repairs 304</p> <p>Report Organization 305</p> <p>Structural devices 306</p> <p>Page breaks 308</p> <p>Formatting Stuff 310</p> <p>Adding color 313</p> <p>Relocation, relocation, relocation 314</p> <p>One size does not fit all 316</p> <p>Spaced-out controls 317</p> <p>Borderline beauty 318</p> <p>Tweaking your text 321</p> <p>Sneaking a Peek 323</p> <p>Getting a Themes Makeover 324</p> <p>Adding More Design Elements 325</p> <p>Drawing lines 325</p> <p>Pretty as a picture 326</p> <p>Adding a logo 327</p> <p><b>Chapter 20: Groups and Page Breaks, Headers and Footers</b><b> 329</b></p> <p>A Place for Everything and Everything in Its Place 330</p> <p>Layout basics 330</p> <p>Sections 332</p> <p>Grouping your records 335</p> <p>So you want more? 338</p> <p>Customizing Properties 338</p> <p>Controlling report and page headings 341</p> <p>Adjusting individual sections 343</p> <p>Itemized adjustments 344</p> <p><b>Chapter 21: Mailings to the Masses</b><b> 351</b></p> <p>Massive Mailings with the Label Wizard 351</p> <p><b>Part 6: The Parts of Tens</b><b> 359</b></p> <p><b>Chapter 22: Ten Common Problems</b><b> 361</b></p> <p>That’s Just Not Normal 362</p> <p>You Type 73.725, but it Changes to 74 363</p> <p>The Words They Are A-Changing 363</p> <p>Was There and Now It’s Gone 364</p> <p>Undo 365</p> <p>Search for the missing record 365</p> <p>Backup recovery 365</p> <p>You Run a Query, but the Results Aren’t What You Expect 366</p> <p>The Dreaded Parameter Dialog Box 367</p> <p>The Slowest Database in Town 368</p> <p>Your Database File Is as Big as a House 369</p> <p>You Get a Mess When Importing Your Spreadsheet 371</p> <p>We’re Sorry; Your Database File Is Corrupt 371</p> <p><b>Chapter 23: Ten Uncommon Tips</b><b> 373</b></p> <p>Document Everything as Though One Day You’ll Be Questioned by the FBI 374</p> <p>Keep Your Fields as Small as Possible 375</p> <p>Use Number Fields for Real Numbers 376</p> <p>Validate Your Data 376</p> <p>Use Understandable Names to Keep Things Simple 377</p> <p>Delete with Great Caution 377</p> <p>Backup, Backup, Backup 377</p> <p>Think, Think, and Think Again 378</p> <p>Get Organized and Stay Organized 378</p> <p>There’s No Shame in Asking for Help 379</p> <p>Appendix A: Getting Help 381</p> <p>Index 383</p>
<p><b>Laurie Ann Ulrich</b> 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.<p> <p><b>Ken Cook</b> 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.</b>
<ul> <li>Get a grasp on database design and functions</li> <li>Create forms that simplify your data entry routine</li> <li>Build reports that answer your data questions</li> </ul> <p><b>Discover the easy way to access your data </b> <p>Access 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. <p><b>Inside…</b> <ul> <li>Database basics</li> <li>Setting data tables</li> <li>Defining data types</li> <li>Simplifying input with forms</li> <li>Grabbing data from elsewhere</li> <li>Finding the data you need</li> <li>Writing the right queries</li> <li>Generating reports</li> </ul>

Diese Produkte könnten Sie auch interessieren:

AutoCAD 2013 For Dummies
AutoCAD 2013 For Dummies
von: Bill Fane, David Byrnes
PDF ebook
23,99 €
IBM Workplace Services Express For Dummies
IBM Workplace Services Express For Dummies
von: Stephen R. Londergan, Michael Loria
PDF ebook
16,99 €
Building Flash Web Sites For Dummies
Building Flash Web Sites For Dummies
von: Doug Sahlin
PDF ebook
18,99 €