data types Flashcards

1
Q

what is short text/string used for? and give two examples

A

used for text fields e.g names and address

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

what is number used for?

A

used for number files

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

what is date/time used for? give one example

A

used for date fields e.g DOB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

what is currency used for?

A

used for monetary values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

what are autonumbers used for?

A

used for ID’s or automatically generated volumes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

what is look up wizard used for?

A

used to select files from only a select list. (prevents user error)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

what do forms do? (long question)

A

made to be USER FRIENDLY, collects DATA, enter NEW RECORDS, MODIFIES EXISTING RECORD and VIEWS already STORED RECORDS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

what can the designer of form do?

A

can control type and format ensuring form kept accurate.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

state 3 features that should be included in an onscreen form design

A

logo, interactive buttons and text boxes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly