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
编辑内容
嵌入
更多
排行榜
显示更多
显示更少
此排行榜当前是私人享有。单击
,共享
使其公开。
资源所有者已禁用此排行榜。
此排行榜被禁用,因为您的选择与资源所有者不同。
还原选项
匹配游戏
是一个开放式模板。它不会为排行榜生成分数。
需要登录
视觉风格
字体
需要登录
选项
切换模板
显示所有
播放活动时将显示更多格式。
打开结果
复制链接
删除
恢复自动保存:
?