Microsoft Office Access 2007 All-in-One Desk Reference For Dummies
xvi
Entering and Editing Hyperlinks ................................................................117
Entering hyperlinks ............................................................................117
Editing hyperlinks ..............................................................................119
Using the Attachment Data Type ...............................................................120
Deleting records .................................................................................121
Entering special characters ..............................................................122
Checking Your Spelling ................................................................................123
Using AutoCorrect for Faster Data Entry ..................................................124
Formatting a Datasheet ...............................................................................127
Formatting a field ...............................................................................127
Changing the font ...............................................................................127
Taking advantage of rich text............................................................128
Changing gridlines and background color ......................................129
Rearranging columns in a datasheet ...............................................130
Changing column width .....................................................................130
Changing row height ..........................................................................130
Inserting and deleting columns ........................................................131
Hiding columns ...................................................................................131
Freezing columns................................................................................132
Changing default formatting for new tables....................................132
Taking Advantage of Subdatasheets ..........................................................132
Adding a Totals Row to the Datasheet ......................................................134
Chapter 3: Sorting, Finding, and Filtering Data . . . . . . . . . . . . . . . . . .137
Sorting the Rows of a Datasheet ................................................................137
Finding (and Replacing) Data .....................................................................139
The Find and Replace dialog box and its options ..........................140
Replacing the data you find ..............................................................141
Filtering a Datasheet ....................................................................................141
Filtering basics....................................................................................142
Filtering by selection .........................................................................144
Common filters ...................................................................................145
Filtering using criteria on multiple fields ........................................145
Filtering Using Advanced Filter/Sort .........................................................148
Chapter 4: Importing and Exporting Data . . . . . . . . . . . . . . . . . . . . . . .151
Cutting, Copying, and Pasting ....................................................................151
The Office Clipboard ..........................................................................152
Cutting and pasting small to medium-ish amounts of data ..........153
Moving data from Excel to Access ...................................................155
Importing or Linking to Data .....................................................................155
What applications are compatible with Access.............................156
To link or to import, that is the question ........................................156
Getting external data .........................................................................157
Importing text or spreadsheet data .................................................160
The Import Spreadsheet and Link Spreadsheet Wizards ..............163
02_036494 ftoc.qxp 11/17/06 8:16 AM Page xvi
|
|