Field properties- characteristics of a field that determine how long an entry can be.

Caption- friendly name for a field.

Input Mask- a field template to validate how each character is entered into the field

Validation Rule- rule that defines what data may be entered into a field

Index- a predefined sort on a particular field.

What is the purpose of design view?
will aim to solve some if not all of these issues, by providing plugins for the most popular













What does the field properties do?
Text or combinations of text and numbers in the field, such as addresses. Numbers that do not require calculations, such as phone numbers, part numbers, or postal codes.

How do you insert a new field in design view?
You use Design view when you need to add a Memo field to a new or existing table, and then set the field to support rich-text formatting







What is the field size?
THe feild size determins how many rows and coloms you have.

Provide one example of date/time format using the date April 21, 2009.
myformat[Date.today] > => "21st April 2009"

What is a caption?
a term describing several systems developed to display text on a television or viodeo screen to provide additional or interpretive information to viewers who wish to access it. Closed captions typically display of the audio portion of a program as it occurs (either verbatim or in edited form), sometimes including non-speech elements.

What is a default value?
In any situation where a value has to be supplied by the user, the user may be saved this trouble by having the software supply a particular fixed value. That is, if the user does not explicitly specify a value, the program-supplied value is used, and is known as a "default value" — it is used in default of the user explicitly supplying a different value. This is useful if there is a particular value which users are expected to want to use on a large proportion of occasions.
"loicrogha" (TR 110, for "default option").

How do you create an input mask?
is a special pattern that controls what the user can type into a MaskedInput dialog or edit field control at run time.

What is a validation rule?
a rule that states that if you break it the access wont work properley

What is the purpose of using an index?
The purpose of the Index is/was to explore methods of collecting and providing access to freely available electronic serials and organizing them into some sort of meaningful scheme. Electronic serials, as produced by scholars themselves and not for-profit publishers, have had a number of implementation problems since their inception early this decade