data types Flashcards
what is short text/string used for? and give two examples
used for text fields e.g names and address
what is number used for?
used for number files
what is date/time used for? give one example
used for date fields e.g DOB
what is currency used for?
used for monetary values
what are autonumbers used for?
used for ID’s or automatically generated volumes
what is look up wizard used for?
used to select files from only a select list. (prevents user error)
what do forms do? (long question)
made to be USER FRIENDLY, collects DATA, enter NEW RECORDS, MODIFIES EXISTING RECORD and VIEWS already STORED RECORDS
what can the designer of form do?
can control type and format ensuring form kept accurate.
state 3 features that should be included in an onscreen form design
logo, interactive buttons and text boxes