1.9 - Information Handling (Databases) (WJEC) 0.0 / 5 ? ICTSpreadsheets and DatabasesGCSEWJEC Created by: daynayumeCreated on: 17-05-16 18:13 What are Databases used for? To store and organise large amounts of data. 1 of 21 What are queries? You can use queries to search databases. 2 of 21 What form are queries written in? Field-Operator-Criteria 3 of 21 What are the different Operators? =, , >, 4 of 21 Name the different data types used in databases? Number, Text, Date, Time, Currency, Boolean, Lists, Picture, Sound, Video. 5 of 21 What are Number data types? Data that stores numbers only. 6 of 21 What are Text data types? Data that stores letters, numbers and spaces. 7 of 21 What are Date data types? Data that allows only dates to be entered. 8 of 21 What are Time data types? Data that allows only times to be entered. 9 of 21 What are Currency data types? Data that must begin with a currency sign like $ or £. 10 of 21 What are Boolean data types? Used where only two choices are available. E.g. Yes/No, True/False. 11 of 21 What are Lists data types? Used where the user is given a list of choices they can pick from a drop-down menu. 12 of 21 What are Picture data types? Pictures of products or people. 13 of 21 What are Sound data types? Used to organise sound or music. 14 of 21 What are Video data types? Organises video files. 15 of 21 What are Fields? Fields are columns of a particular item of data. 16 of 21 What are Records? Records are rows - a collection of fields. 17 of 21 What are Files/Tables? A collection of records. 18 of 21 What Key Fields? Fields that are unique, such as car registration numbers and national insurance numbers. 19 of 21 What are Reports? Reports is a way to present information gathered from searchers or queries. 20 of 21 What should reports contain? Relevant information that is appropriately formatted, a sensible title data and page numbering, Calculated fields. 21 of 21
Comments
No comments have yet been made