• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Working with Jet Databases an... > Altering Fields and Relationships

Altering Fields and Relationships

When you're designing a database, you often discover that you must alter the original choices you made for the sequence of fields in a table, data types, or relationships between tables. One reason for adding substantial numbers of records to tables during the testing process is to discover any necessary changes before putting the database into daily use.

You can change formats, validation rules and text, lengths of Text fields, and other minor items in the table by changing to design mode, selecting the field to modify, and making the changes in the property boxes. Changing data types can cause a loss of data, however, so be sure to read the later “Changing Field Data Types and Sizes” section before you attempt to make such changes. Changing the data type of a field that participates in a relationship with another table requires that you delete and, if possible, recreate the relationship. Changing relationships between tables is considered a drastic action if you have entered a substantial amount of data, so this subject is also covered later in “Changing Relationships Between Tables.”


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint