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

Chapter 4. Working with Access Databases... > Altering Fields and Relationships

Altering Fields and Relationships

When you are designing your own database, you often discover that you must alter the original choices that 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 section Changing Field Data Types and Sizes before you attempt to make such changes. Changing relationships between tables is considered a drastic action if you have entered a substantial amount of data, so this subject also is 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