Database 0.0 / 5 ? ICTSpreadsheets and DatabasesGCSEAQA Created by: oliviamillsCreated on: 12-02-15 11:22 What is a FIELD? Column heading 1 of 16 What is a RECORD? A row, holding data 2 of 16 What is a TABLE? Collection of records 3 of 16 What is a KEY FIELD? Unique Identifier, that individually identifies a record. 4 of 16 What is a database with more than one table known as? Relational database 5 of 16 What does a QUERY icon do? Asks questions, extracts data and performs searches 6 of 16 What does a TABLE icon do? Creates a database, to set up fields and validations. 7 of 16 What does a REPORT icon do? Improving the presentation the output database and gives a neat/professional print 8 of 16 What does the software use to make a link/relationship between tables? Foreign key 9 of 16 What is the data type for 'first name'? Text 10 of 16 What is the data type for 'surname'? Text 11 of 16 What is the data type for 'mobile number'? Text 12 of 16 What is the data type for 'gender'? Look up list 13 of 16 What is the data type for 'date of birth'? Date/Time 14 of 16 Name two additional data types. Currency and Autonumber 15 of 16 What are the benefits of encoding data on a database? Less to type in, fewer chance of getting a typing error because you are typing less. Also it takes up less storage, for there is less data needed. 16 of 16
Comments
No comments have yet been made