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

Online Learner

Creating Opportunities For A Better Life.®

Access 2010

Single page view print copy

Modifying Tables

Challenge!

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