This class was exactly what I needed for my job.”

Online Learner

Creating Opportunities For A Better Life.®

Access 2013

Single page view print copy

Modifying Tables

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 then 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.
1 2 3 4 5