Microsoft Office Tutorials and References
In Depth Information
Book II: Tables for Storing Your Data
Contents at a Glance
Contents at a Glance
Chapter 1: Creating and Modifying Tables .......................67
Viewing Your Tables ..................................................................................... 68
Creating the First Table for Your Data ........................................................ 70
Working with Tables and Fields in Your Database ................................... 74
Creating Fields ............................................................................................... 76
Working with a Datasheet Full of Data ........................................................ 80
Adding and Editing Records ......................................................................... 82
Checking Your Spelling ................................................................................. 92
Using AutoCorrect for Faster Data Entry .................................................... 94
Formatting a Datasheet ................................................................................. 96
Taking Advantage of Subdatasheets ......................................................... 101
Adding a Total Row to the Datasheet ....................................................... 103
Chapter 2: Refining Your Table in Design View ..................105
Creating Tables in Design View ................................................................. 105
Refining Your Table in Design View .......................................................... 107
Formatting Fields with Field Properties ................................................... 113
Defining the Primary Key ............................................................................ 117
Indexing Fields ............................................................................................. 118
Printing Table Designs ................................................................................ 119
Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet .....121
Sorting the Rows of a Datasheet ................................................................ 121
Finding (and Replacing) Data ..................................................................... 123
Filtering a Datasheet ................................................................................... 125
Chapter 4: Importing and Exporting Data ........................137
Cutting, Copying, and Pasting .................................................................... 137
Importing or Linking to Data ...................................................................... 142
Getting Data from Another Access Database ........................................... 153
Getting Data Out of Access ......................................................................... 154
Using Access Data in a Word Mail Merge ................................................. 156
Chapter 5: Avoiding “Garbage In, Garbage Out” .................157
Finding the Right Tool to Keep Garbage Out ........................................... 158
Using Input Masks to Validate and Format Data ..................................... 159
Creating a Lookup Field .............................................................................. 164
Validating Data As It’s Entered .................................................................. 170
Chapter 6: Relating Your Tables and Protecting Your Data ........175
Creating Relationships and Protecting Your Data with
Referential Integrity ................................................................................. 177
Creating Referential Integrity with Many-to-Many Relationships ......... 182
Printing the Relationships Window ........................................................... 184
 
Search JabSto ::




Custom Search