Microsoft® Office Access™ 2007 Plain & Simple

Assigning Required Fields and Requiring Data Entry

Some data is more important than other data. For example, a salesperson might need to know a contact’s phone number, but not necessarily the contact’s address. You can tell Access to prevent someone from moving beyond a required field without entering a value. For text and memo fields, you can require users to enter at least one character of text.

Require Data Entry

1. Open a table in Design view.

2. Click the field for which you want to require data entry.

3. Click in the Required property box.

4. Click the down ...