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
