Databases 0.0 / 5 ? ICTDatabasesASOCR Created by: missagentpotterCreated on: 18-01-16 14:53 Databases A collection of data or information stored electronicallu in an organsied/ logical way. 1 of 11 Records All of the data or information about 1 person or thing 2 of 11 Fields One piece of data it information about a person or thing 3 of 11 Data type- Text This is for data saved in alphabetical order or a mixture of letters and numbers 4 of 11 Data Type- Number This is for data saved in numeric format 5 of 11 Data Type- Currency this is for data saved in monetary values 6 of 11 Data type- Date and Time this is saved in date format 7 of 11 Data Type- yes/no can be one of two answers 8 of 11 Data type- Auto number this is for data that would have a unique number 9 of 11 Primary Key field in a table which is unique and enables you to identify every record in that table. 10 of 11 Composite Key a combination of two or more columns in a table 11 of 11
Comments
No comments have yet been made