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 2a
共享
共享
由
Atennyson556
KS3
Computing
Databases
编辑内容
保存
喜欢
打印
嵌入
更多
需要登录
视觉风格
显示所有
字体
活动设置
排行榜
作业
需要订阅
活动设置
排行榜
此排行榜当前是私人享有。单击
,共享
使其公开。
资源所有者已禁用此排行榜。
此排行榜被禁用,因为您的选择与资源所有者不同。
还原选项
显示更多
显示更少
匹配游戏
是一个开放式模板。它不会为排行榜生成分数。
作业
您尚未与学生分享任何活动。
要开始收集结果,请转到任何活动页面,然后选择
Set assignment(设置分配
)。
确认您的设置并与学生共享生成的链接。
设置作业
切换模板
显示所有
打开成绩
复制链接
QR 代码
删除
恢复自动保存:
?