Modifying Tables

Modifying Access tables is simple. Use these tips to modify tables in Access to suit your database's needs.


  1. If you haven't already, download our sample database and open it.
  2. Open the Products Table, and change the data type for the description field to Memo.
  3. Open the Customers Table, and then add a new field that uses the Memo data type. Name the new field Credit Card.
  4. Add the following Field Validation Rule to the Credit Card field: "VS" Or "MC" Or "AMX".
  5. Set a field validation message for the same field. It should say Enter a valid Credit Card Type: Must be VS, MC, or AMX.
  6. Test your field validation rule by typing Visa into a cell in the Credit Card field. If you've added the rule correctly, a dialog box should appear with the message you added above.