|
- navigation bar
-
 Toolbar
with buttons for navigating records. Datasheets, forms, and
records use the same bar. Data access pages use a bar with
buttons for editing records.
- nested
- One inside the other.
- Expressions: One function can be nested inside
another function.
Example of IIf inside another IIf:
IIf([Date]>#1/1/2006#,[Date],IIf([Date]<#1/1/1999#,"<1999","Between"))
- Forms/Reports: A main form or report contains a
subform/subreport which itself contains another. Access allows
up to 7 levels of nesting.
- normalized
- A database that meets certain design criteria is called
normalized to a certain Form number. These criteria are intended
to help keep the database speedy, logically organizes, and
without errors. Normal Form
- null
- A field that has no value is said to be null. It has never
been touched. This is different from a field that contains an
empty string. Both kinds of fields look the same in all views.
- number field
- A field that can contain some kind of number. There are
several variations:
-
 Number
- A general number comes in several number field sizes
including: Byte, Integer, and Long Integer.
- Date/Time - A date is actually a number based on the
number of days from December 30, 1899. Earlier dates are
negative numbers. To calculate with dates it is important to use
this format and not text.
- Currency - Use for high accuracy and for money.
Avoids rounding. Can hold 15 digits to the left and 4 digits to
the right of the decimal point.
- AutoNumber - Automatically assigns a unique number to
each record. Great to use for an primary key.
|