Details

Teach Yourself VISUALLY Access 2013


Teach Yourself VISUALLY Access 2013


Teach Yourself VISUALLY (Tech), Band 146 1. Aufl.

von: Paul McFedries

18,99 €

Verlag: Wiley
Format: PDF
Veröffentl.: 14.03.2013
ISBN/EAN: 9781118674710
Sprache: englisch
Anzahl Seiten: 352

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

Beschreibungen

<p><b>The easy, visual way to learn this popular database program</b></p> <p>Part of the Office 2013 productivity suite, Access enables you to organize, present, analyze, and share data on a network or over the web. With this Visual guide to show you how, you'll master the fundamentals of this robust database application in no time. Clear, step-by-step instructions are illustrated with full-color screen shots that show exactly what you should see on your screen. Learn to enter new records; create, edit, and design tables and forms; develop queries that generate specific reports; add smart tags to your tables; and much more.</p> <ul> <li>While it is the most widely used database application, Access is not particularly intuitive; the Visual system's two-page lessons and full-color screen shots make this complex software easier to learn</li> <li>Concise, step-by-step instructions and clear illustrations show you exactly what to expect</li> <li>Covers scores of tasks, including entering and setting up new records, organizing and sharing data, designing tables and forms, and generating reports</li> <li>Shows how to perform more complex operations, such as finding dependencies between database objects and adding smart tags to tables</li> </ul> <p><i>Teach Yourself VISUALLY Access 2013</i> uses clear steps and high-resolution screen images to get you up and running with this popular database program.</p>
<b>Chapter 1 Getting Started with Access</b> <p>An Introduction to Access 4</p> <p>Start and Exit Access 6</p> <p>Create a Blank Database 8</p> <p>Create a Database by Using a Template 10</p> <p>Open a Database 12</p> <p>Close a Database 13</p> <p>Understanding the Access Interface 14</p> <p>Customize the Quick Access Toolbar 16</p> <p>Customize the Ribbon 18</p> <p>Change the Navigation Pane View 20</p> <p>Open and Close an Object 22</p> <p>Change an Object’s View 23</p> <p><b>Chapter 2 Working with Tables</b></p> <p>Plan Effective Tables 26</p> <p>Create a Table in the Datasheet View 28</p> <p>Save a Table 29</p> <p>Create a Table in the Design View 30</p> <p>Open a Table in the Design View 32</p> <p>Rearrange Fields 33</p> <p>Insert and Delete Fields 34</p> <p>Understanding Data Types 35</p> <p>Change a Field’s Data Type 36</p> <p>Understanding Primary and Composite Keys 37</p> <p>Set the Primary or Composite Key 38</p> <p>Rename a Table 39</p> <p>Delete a Table 40</p> <p>Copy a Table 41</p> <p><b>Chapter 3 Entering and Editing Data</b></p> <p>Enter New Records 44</p> <p>Navigate between Records 46</p> <p>Edit Records 47</p> <p>Attach Files to a Record 48</p> <p>Open, Save, and Remove File Attachments 50</p> <p>Insert an OLE Object 52</p> <p>Open, Edit, and Remove OLE Objects 54</p> <p>Enter Data in a Multivalued Field 55</p> <p>Select Records 56</p> <p>Delete Records 57</p> <p>Sort Records 58</p> <p>Resize Datasheet Columns and Rows 60</p> <p>Print a Datasheet or Form 61</p> <p><b>Chapter 4 Working with Fields</b></p> <p>Understanding Field Properties 64</p> <p>Understanding Field Sizes 65</p> <p>Change a Field Size 66</p> <p>Set a Field Caption 67</p> <p>Set a Field’s Format 68</p> <p>Set a Default Value 70</p> <p>Make a Field Required 71</p> <p>Index a Field 72</p> <p>Align Data within a Field 73</p> <p>Create an Input Mask 74</p> <p>Create a Validation Rule 76</p> <p>Create a Record-Level Validation Rule 78</p> <p><b>Chapter 5 Working with Relationships</b></p> <p>Understanding Relationships 82</p> <p>Create a Relationship between Two Tables 84</p> <p>Edit a Relationship 86</p> <p>Remove a Relationship 87</p> <p>Arrange the Relationships Window 88</p> <p>Print a Relationship Report 89</p> <p>View Object Dependencies 90</p> <p>Document the Database 92</p> <p>Understanding Lookups 94</p> <p>Create a Table for Use As a Field Lookup 96</p> <p>Create a Field Lookup Based on a Table 98</p> <p>Create a Field Lookup with Values That You Specify 102</p> <p>Set Up a Multivalued Field 104</p> <p><b>Chapter 6 Finding and Filtering Data</b></p> <p>Understanding Find and Replace 108</p> <p>Find Data 109</p> <p>Replace Data 110</p> <p>Filter to Show Only Blank or Nonblank Entries 112</p> <p>Filter by Selection 113</p> <p>Filter for Multiple Values 114</p> <p>Using Text Filters 115</p> <p>Filter by Form 116</p> <p>Save a Filter As a Query 118</p> <p><b>Chapter 7 Creating Simple Queries</b></p> <p>Understanding Queries 122</p> <p>Create a Query with the Simple Query Wizard 124</p> <p>Start a New Query in the Query Design View 126</p> <p>Insert, Arrange, and Remove Query Fields 128</p> <p>Set Field Sorting 130</p> <p>Add an Alias to a Query Field 131</p> <p>Understanding Criteria 132</p> <p>Filter a Query for a Specific Value 134</p> <p>Specify a Range of Values 135</p> <p>Specify a List of Values 136</p> <p>Hide a Field in the Query Results 137</p> <p>Create Compound Criteria 138</p> <p>Limit the Records Returned 139</p> <p><b>Chapter 8 Creating Complex Queries</b></p> <p>Understanding Summary Queries 142</p> <p>Create a Summary Query with the</p> <p>Simple Query Wizard 144</p> <p>Create a Summary Query in the Query Design View 148</p> <p>Understanding Calculated Fields 150</p> <p>Create a Calculated Field 151</p> <p>Understanding Action Queries 152</p> <p>Run a Make Table Query 153</p> <p>Run a Delete Query 154</p> <p>Run an Append Query 155</p> <p>Run an Update Query 156</p> <p>Prompt the User for a Parameter 158</p> <p>Understanding Parameter Syntax 159</p> <p><b>Chapter 9 Creating Forms</b></p> <p>Understanding Forms 162</p> <p>Create and Save a Form 164</p> <p>Create a Form with the Form Wizard 166</p> <p>Create a Form in the Layout View 170</p> <p>Create a Form in the Design View 172</p> <p>Delete a Field from the Design View 173</p> <p>Arrange Fields on a Form 174</p> <p>Group Fields Together 176</p> <p>Define the Tab Order on a Form 177</p> <p><b>Chapter 10 Editing Forms</b></p> <p>Display the Header and Footer 180</p> <p>Resize Sections of a Form 181</p> <p>Select Sections of a Form 182</p> <p>Add a Form Title 183</p> <p>Apply a Theme 184</p> <p>Browse for a Theme to Apply 185</p> <p>Apply a Font Theme or Color Theme 186</p> <p>Create a Custom Font Theme 187</p> <p>Create a Custom Color Theme 188</p> <p>Create a Custom Theme 189</p> <p>Adjust Internal Margins and Padding 190</p> <p>Add a Label 191</p> <p>Format Label Text 192</p> <p>Change the Background Color 194</p> <p>Add a Background Image 195</p> <p>Add a Hyperlink 196</p> <p>Add a Tabbed Section 198</p> <p>Insert a Logo or an Image 200</p> <p>Set Conditional Formatting 202</p> <p><b>Chapter 11 Creating Reports</b></p> <p>Understanding Report Views 206</p> <p>Create a Simple Report 208</p> <p>Apply a Theme to a Report 209</p> <p>Preview and Print a Report 210</p> <p>Create a Report with the Report Wizard 212</p> <p>Create a Report in the Layout View 216</p> <p>Set the Page Size and Orientation 217</p> <p>Change the Report Layout Type 218</p> <p>Set Page Margins 220</p> <p>Set Control Margins and Padding 221</p> <p>Format Report Text 222</p> <p>Size and Align Report Fields 224</p> <p>Insert a Page-Numbering Code 225</p> <p><b>Chapter 12 Grouping and Sorting Data</b></p> <p>Understanding Grouping and Summarizing 228</p> <p>Group Report Results 230</p> <p>Group a Numeric Field by Intervals 232</p> <p>Group a Date Field 233</p> <p>Group Records Using an Expression 234</p> <p>Sort Report Results 236</p> <p>Count Records 237</p> <p>Add an Aggregate Function 238</p> <p>Hide the Group Header and Footer 240</p> <p>Keep a Group Together on a Page 241</p> <p>Change the Grouping or Sorting Priority 242</p> <p>Remove a Grouping or Sorting 243</p> <p><b>Chapter 13 Creating Mailing Labels</b></p> <p>Create Labels 246</p> <p>Add a Field to an Existing Line 250</p> <p>Add a Field to a Label As a Separate Line 251</p> <p>Color the Label Background 252</p> <p>Color the Label Text 253</p> <p>Apply Font Formatting to the Label Text 254</p> <p>Export Labels to Word 256</p> <p><b>Chapter 14 Performing a Mail Merge</b></p> <p>Start a Mail Merge 260</p> <p>Create the Main Document in Word 262</p> <p>Insert an Address Block 263</p> <p>Insert a Greeting Line 264</p> <p>Match Fields 265</p> <p>Insert Individual Fields 266</p> <p>Preview the Merge Results 267</p> <p>Filter the Recipient List 268</p> <p>Sort the Recipient List 270</p> <p>Merge to a New Document 271</p> <p>Merge Directly to a Printer 272</p> <p>Save the Merge for Later Use 273</p> <p><b>Chapter 15 Working with External Data</b></p> <p>Import an Excel Worksheet 276</p> <p>Link to an Excel Worksheet 280</p> <p>Link to an Outlook Folder 282</p> <p>Manage Linked Tables 284</p> <p>Import a Table from Another Access Database 286</p> <p>Import Data from a Delimited Text File 288</p> <p>Import Data from a Web Page 292</p> <p>Import Data from an XML File 294</p> <p>Export Data to Excel 296</p> <p>Export Data As HTML 297</p> <p>Export Data to a Plain Text File 298</p> <p>Save Import or Export Specifications 300</p> <p>Using Saved Import or Export Specifications 301</p> <p>Analyze Access Data Using an Excel PivotTable 302</p> <p>Add Multiple Fields to a PivotTable Area 304</p> <p>Move a Field to a Different PivotTable Area 306</p> <p>Group PivotTable Values 308</p> <p>Apply a PivotTable Filter 310</p> <p><b>Chapter 16 Maintaining a Database</b><br /> <br /> Set a Trusted Location 314</p> <p>Save in an Earlier Version Format 316</p> <p>Convert to the Access 2007-2013 Format 317</p> <p>Back Up a Database 318</p> <p>Analyze Database Performance 319</p> <p>Compact and Repair a Database 320</p> <p>Password-Protect a Database 322</p> <p>Create a Switchboard 324</p> <p>Set Switchboard Startup Options 328</p> <p>Index 330</p>
<p><b>Paul McFedries</b> (Toronto, Ontario) is the president of Logophilia Limited, a technical writing company. He has been programming since he was a teenager in the mid-1970s and has programmed everything from mainframes to desktops to bar code scanners. He has worked with many different languages, including Fortran, assembly language, C++, and, JavaScript. Paul has written more than three dozen books that have sold more than three million copies worldwide, including: <i>Windows Vista Simplified, Teach Yourself Visually Windows Vista, Macs Portable Genius, Office 2007 Visual Quick Tips,</i> and <i>Teach Yourself VISUALLY Macs.</i> Paul encourages all readers to drop by his Web site, www.mcfedries.com.</p>
<p>Are you a visual learner? Do you prefer instructions that show you how to do something — and skip the long-winded explanations? If so, then this book is for you. Open it up, and you'll find clear, step-by-step screen shots that show you how to tackle more than 190 Access 2013 tasks. Each task-based spread covers a single technique, sure to help you get up and running on Access 2013 in no time.</p> <p>You'll learn to:</p> <ul> <li>Create databases and enter data</li> <li>Work with tables and fields</li> <li>Develop simple and complex queries</li> <li>Group and summarize data</li> <li>Produce reports</li> </ul> <p>Designed for visual learners</p> <ul> <li>Two-page lessons break big topics into bite-sized modules</li> <li>Succinct explanations walk you through step by step</li> <li>Full-color screen shots demonstrate each task</li> <li>Helpful sidebars offer practical tips and tricks</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 €