Working with Forms

In Access forms ensure you're entering the right data in the right location. Use forms in Access to keep your Access database accurate.

Challenge!

  1. If you haven't already, download our sample database and open it.
  2. Open the Orders Form.
  3. Create a new record with the following data:
    • Customer: Eric Oglesby
    • Pickup date: February 14, 2011
    • Order items: Cakes: Coconut (1)
    • Notes: Write "Happy Valentine's Day!" with pink frosting.
    • Pre Order: Yes
    • Paid: Yes
  4. Open the Customers Form.
  5. Find the record for customer Dwight Parker and make the following changes:
    • Street Address: 190 Cook Street
    • City: Chapel Hill
    • Zip Code: 27514
    • Email: dwightp@email.com