Modifying Access tables is simple. Use these tips to modify tables in Access to suit your database's needs.
On the previous page, you learned about setting the data type for new fields. When you set field data type, you are really setting a rule for that field. Databases often include rules because they are a way of guaranteeing that users enter the correct type of data.
Why is this important? Computers aren't as smart as humans about certain things. While you might recognize that two and 2 or NC and North Carolina are the same thing, Access will not, and therefore it won't group these things together. Making sure to enter your data in a standard format will help you better organize, count, and understand it.
Rules can also determine the options you have for working with that data. For example, you can only do math with data entered in number or currency fields, and you can only format text entered in memo fields.
There are three main types of rules you can set for a field: data type, character limit, and validation rules.
You shouldn't change field data type unless you are certain your field data is in the correct format for the new data type. Changing a field containing only text to the Number type, for instance, will delete all of your field data. This process is often irreversible.