An appropriate data type - is attached to the field name in a database, In total there are - 11 data types, Text means - text and data that is a mix of text and numbers e.g. postcode, Number means - numeric data that requires a mathematical calculation, Date/Time - Stores a date or time, Currency - Monetary value such as item price and includes 2 decimal places, Autonumber - Automatically stores a numeric value that is one greater than that in the last record added, Yes/No is also called - Boolean, Yes/No - used to store data that has only two possible values such as yes or no, true or false, and on or off., OLE object - contains an object created by another software package e.g. Excel workbook, Hyperlink - An address that links to another location, such as a website (URL), email address or an external file., Attachment - Files attached to a record, e.g. digital image, Calculated - For the result of a calculation produced from another field in the record, Lookup Wizard - creates a list of values and allows user to select a value from the list and enter into the field, Data validation is - the process of verifying that a program's input data is within the expected range, Data validation guarantees that data is - present, the correct type, range or length, Data that doesn't conform to specified rules - is rejected, The data validation checks are - presence, length, type, format and range, If data is rejected - an error message is displayed and a reason given, A presence check ensures - data is present and does not allow a space to be left blank, Presence checks are mainly used in - online forms, Validation rule for presence requires - "Required" set to "Yes" for the field required, A length check ensures - data entered is the correct number of characters, An example of using length check is - a customer number must contain 6 characters, A type check is used to ensure - data entered is of the correct type, There are several "types" including - numeric, text and date, A format check ensures data entered - matches a predetermined pattern, An example of format check is - a postcode which would have a pattern such as BTXX XXX, A range check ensures data entered - is within a lower and upper limit e.g. between 1-10, Logical operators - compare a value against another e.g. less than (<), less than or equal to (<=), greater than (>) etc,
0%
Database Applications 2
공유
만든이
Atennyson556
CCEA GCSE Digital Tech Software
콘텐츠 편집
퍼가기
더보기
순위표
더 보기
접기
이 순위표는 현재 비공개입니다.
공유
를 클릭하여 공개할 수 있습니다.
자료 소유자가 이 순위표를 비활성화했습니다.
옵션이 자료 소유자와 다르기 때문에 이 순위표가 비활성화됩니다.
옵션 되돌리기
매치업
(은)는 개방형 템플릿입니다. 순위표에 올라가는 점수를 산출하지 않습니다.
로그인이 필요합니다
비주얼 스타일
글꼴
로그인이 필요합니다
옵션
템플릿 전환하기
모두 표시
액티비티를 플레이할 때 더 많은 포맷이 나타납니다.
결과 열기
링크 복사
삭제
자동 저장된
게임을 복구할까요?