Teach Yourself Visually Access 2013

Chapter 1 Getting Started with Access An Introduction to Access 4 Start and Exit Access 6 Create a Blank Database 8 Create a Database by Using a Template 10 Open a Database 12 Close a Database 13 Understanding the Access Interface 14 Customize the Quick Access Toolbar 16 Customize the Ribbon 18 Change the Navigation Pane View 20 Open and Close an Object 22 Change an Object's View 23 Chapter 2 Working with Tables Plan Effective Tables 26 Create a Table in the Datasheet View 28 Save a Table 29 Create a Table in the Design View 30 Open a Table in the Design View 32 Rearrange Fields 33 Insert and Delete Fields 34 Understanding Data Types 35 Change a Field's Data Type 36 Understanding Primary and Composite Keys 37 Set the Primary or Composite Key 38 Rename a Table 39 Delete a Table 40 Copy a Table 41 Chapter 3 Entering and Editing Data Enter New Records 44 Navigate between Records 46 Edit Records 47 Attach Files to a Record 48 Open, Save, and Remove File Attachments 50 Insert an OLE Object 52 Open, Edit, and Remove OLE Objects 54 Enter Data in a Multivalued Field 55 Select Records 56 Delete Records 57 Sort Records 58 Resize Datasheet Columns and Rows 60 Print a Datasheet or Form 61 Chapter 4 Working with Fields Understanding Field Properties 64 Understanding Field Sizes 65 Change a Field Size 66 Set a Field Caption 67 Set a Field's Format 68 Set a Default Value 70 Make a Field Required 71 Index a Field 72 Align Data within a Field 73 Create an Input Mask 74 Create a Validation Rule 76 Create a Record-Level Validation Rule 78 Chapter 5 Working with Relationships Understanding Relationships 82 Create a Relationship between Two Tables 84 Edit a Relationship 86 Remove a Relationship 87 Arrange the Relationships Window 88 Print a Relationship Report 89 View Object Dependencies 90 Document the Database 92 Understanding Lookups 94 Create a Table for Use As a Field Lookup 96 Create a Field Lookup Based on a Table 98 Create a Field Lookup with Values That You Specify 102 Set Up a Multivalued Field 104 Chapter 6 Finding and Filtering Data Understanding Find and Replace 108 Find Data 109 Replace Data 110 Filter to Show Only Blank or Nonblank Entries 112 Filter by Selection 113 Filter for Multiple Values 114 Using Text Filters 115 Filter by Form 116 Save a Filter As a Query 118 Chapter 7 Creating Simple Queries Understanding Queries 122 Create a Query with the Simple Query Wizard 124 Start a New Query in the Query Design View 126 Insert, Arrange, and Remove Query Fields 128 Set Field Sorting 130 Add an Alias to a Query Field 131 Understanding Criteria 132 Filter a Query for a Specific Value 134 Specify a Range of Values 135 Specify a List of Values 136 Hide a Field in the Query Results 137 Create Compound Criteria 138 Limit the Records Returned 139 Chapter 8 Creating Complex Queries Understanding Summary Queries 142 Create a Summary Query with the Simple Query Wizard 144 Create a Summary Query in the Query Design View 148 Understanding Calculated Fields 150 Create a Calculated Field 151 Understanding Action Queries 152 Run a Make Table Query 153 Run a Delete Query 154 Run an Append Query 155 Run an Update Query 156 Prompt the User for a Parameter 158 Understanding Parameter Syntax 159 Chapter 9 Creating Forms Understanding Forms 162 Create and Save a Form 164 Create a Form with the Form Wizard 166 Create a Form in the Layout View 170 Create a Form in the Design View 172 Delete a Field from the Design View 173 Arrange Fields on a Form 174 Group Fields Together 176 Define the Tab Order on a Form 177 Chapter 10 Editing Forms Display the Header and Footer 180 Resize Sections of a Form 181 Select Sections of a Form 182 Add a Form Title 183 Apply a Theme 184 Browse for a Theme to Apply 185 Apply a Font Theme or Color Theme 186 Create a Custom Font Theme 187 Create a Custom Color Theme 188 Create a Custom Theme 189 Adjust Internal Margins and Padding 190 Add a Label 191 Format Label Text 192 Change the Background Color 194 Add a Background Image 195 Add a Hyperlink 196 Add a Tabbed Section 198 Insert a Logo or an Image 200 Set Conditional Formatting 202 Chapter 11 Creating Reports Understanding Report Views 206 Create a Simple Report 208 Apply a Theme to a Report 209 Preview and Print a Report 210 Create a Report with the Report Wizard 212 Create a Report in the Layout View 216 Set the Page Size and Orientation 217 Change the Report Layout Type 218 Set Page Margins 220 Set Control Margins and Padding 221 Format Report Text 222 Size and Align Report Fields 224 Insert a Page-Numbering Code 225 Chapter 12 Grouping and Sorting Data Understanding Grouping and Summarizing 228 Group Report Results 230 Group a Numeric Field by Intervals 232 Group a Date Field 233 Group Records Using an Expression 234 Sort Report Results 236 Count Records 237 Add an Aggregate Function 238 Hide the Group Header and Footer 240 Keep a Group Together on a Page 241 Change the Grouping or Sorting Priority 242 Remove a Grouping or Sorting 243 Chapter 13 Creating Mailing Labels Create Labels 246 Add a Field to an Existing Line 250 Add a Field to a Label As a Separate Line 251 Color the Label Background 252 Color the Label Text 253 Apply Font Formatting to the Label Text 254 Export Labels to Word 256 Chapter 14 Performing a Mail Merge Start a Mail Merge 260 Create the Main Document in Word 262 Insert an Address Block 263 Insert a Greeting Line 264 Match Fields 265 Insert Individual Fields 266 Preview the Merge Results 267 Filter the Recipient List 268 Sort the Recipient List 270 Merge to a New Document 271 Merge Directly to a Printer 272 Save the Merge for Later Use 273 Chapter 15 Working with External Data Import an Excel Worksheet 276 Link to an Excel Worksheet 280 Link to an Outlook Folder 282 Manage Linked Tables 284 Import a Table from Another Access Database 286 Import Data from a Delimited Text File 288 Import Data from a Web Page 292 Import Data from an XML File 294 Export Data to Excel 296 Export Data As HTML 297 Export Data to a Plain Text File 298 Save Import or Export Specifications 300 Using Saved Import or Export Specifications 301 Analyze Access Data Using an Excel PivotTable 302 Add Multiple Fields to a PivotTable Area 304 Move a Field to a Different PivotTable Area 306 Group PivotTable Values 308 Apply a PivotTable Filter 310 Chapter 16 Maintaining a Database Set a Trusted Location 314 Save in an Earlier Version Format 316 Convert to the Access 2007-2013 Format 317 Back Up a Database 318 Analyze Database Performance 319 Compact and Repair a Database 320 Password-Protect a Database 322 Create a Switchboard 324 Set Switchboard Startup Options 328 Index 330