Modifying Tables

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

Challenge!

  1. Open an existing Access database. If you want, you can use our Access 2013 sample database.
  2. Open the Products Table, and change the data type for the description field to Long Text.
  3. Open the Customers Table and add a new field that uses the Short Text 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.