Adding, Deleting, and Moving Fields

Table of Contents

This Book

Microsoft® Office 2003 All in One

Search

About the Author

Acknowledgments

We Want to Hear from You!

Introduction

Office Introduction and Shared Features

Migrating to Office 2003

Ch. 1. Working in Access

Ch. 2. Creating a New Database

Ch. 3. Creating a Table with the Table Wizard

Ch. 4. Creating a Table from Scratch

Ch. 5. Editing a Table's Structure

Editing Fields and Their Properties

Adding, Deleting, and Moving Fields

Deleting a Table

Ch. 6. Entering Data into a Table

Ch. 7. Editing Data in a Table

Ch. 8. Formatting Access Tables

Ch. 9. Creating Relationships Between Tables

Ch. 10. Creating a Simple Form

Ch. 11. Modifying a Form

Ch. 12. Adding Special Controls to Forms

Ch. 13. Searching for Information in Your Database

Ch. 14. Sorting, Filtering, and Indexing Data

Ch. 15. Creating a Simple Query

Ch. 16. Creating Queries from Scratch

Ch. 17. Creating a Simple Report

Ch. 18. Customizing a Report

Ch. 19. Taking Advantage of Database Relationships

Ch. 20. Printing Access Objects

PowerPoint

Publisher

Index

Adding, Deleting, and Moving Fields

You can also add additional fields to your table's structure. All you have to do is add a new row to the field list and then enter the new field name and data type. Follow these steps:

1.	Click the field selector (the gray square to the left of the field name) to select the field that will follow the new field that you create (in the field list).
2.	Select Insert, Row (or click the Insert Rows button on the toolbar). A blank row appears in the Field Name list.
3.	Enter a name, a data type, a description, and so on for the new field.

PREVIEW

Not a subscriber?

Start A Free Trial

This Book

Search

Contents

Chapter 5. Editing a Table's Structure > Adding, Deleting, and Moving Fields

Adding, Deleting, and Moving Fields