5. Working with Tables

What You’ll Do

Work with Tables

Repair Renaming Errors

Manage Linked Tables

Work with the Clipboard

Edit Text

Enter Data Accurately with AutoCorrect

Use Smart Tags

Find and Replace Text

Check Spelling

Use Custom Dictionaries

Format a Datasheet

Arrange Columns

Change the Size of Rows and Columns

Manage Columns in Datasheet View

Sort Records

View a Subdatasheet

Filter Out Records

Create Complex Filters Using Forms

Introduction

Tables are the storage containers of your data. To help you work effectively with tables, Microsoft Office Access 2007 provides features that assist you not only in entering and editing the data in your tables but also in locating the information you need.

  • You can locate records based on the text ...

Get Microsoft® Office Access 2007 on Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.