1
Q
- What is a TIMESTAMP?
A
It is a DATE and TIME field combined. It holds BOTH a date AND a time.
2
Q
- When should you use a TIMESTAMP?
A
When you wish to record when an event occurred, or when it will occur.
3
Q
- What is the benefit of a TIMESTAMP?
A
it can figure out how much time has passed between two timestamp values (end timestamp - start timestamp).
4
Q
- What is a CONTAINER field for?
A
it holds PICTURES, SOUNDS, QUICKTIME MULTIMEDIA files and ORDINARY files.
5
Q
- How much data can a CONTAINER hold?
A
2 gigs
6
Q
- What does a CALCULATION & SUMMARY field hold?
A
NOTHING. They make up their own values based on settings YOU give them.
7
Q
- In a CALCULATION field, you can specify a FORMULA that it uses to determine its value, such as:
A
a person’s age based on their birthdate.
8
Q
- The value of a SUMMARY field depends on:
A
The VALUES OF OTHER FIELDS ACROSS SOME SET OF RECORDS. They are NOT associated with a SINGLE RECORD.
9
Q
- What could you do with a SUMMARY field?
A
It could show the number of people int the db who are form California, or the total dollar value of all outstanding invoices for a customer.
