Karteikarten
ICT- Topic 8
Karten in diesem Stapel (33)
- 1What is a field?A field is a single item of data within a record.
- 2What is a record?A record consists of a collection of related fields.
- 3What is a file?A file (or table in access) is a collection of related fields.
- 4Name 3 examples of a field.Surname: text
Date of birth: Date and time
Selling pricing: currency - 5Name an example of a record.A pupil's record in a school database only has the fields related to that pupil and no other pupil's.
- 6Name an example of a file/table.The table of records of all pupils in the school.
- 7What is a number/integer data type?A whole number but no fractions. For example 43.
- 8What is a number real data type?Any number, including whole numbers and fractions. For example 435.256
- 9What is a text or string data type?Letters, numbers or other characters such as punctuation marks. For example John Smith.
- 10What is a currency data type?Money £ (including foreign currency such as $)
- 11What is a Boolean data type?Two opposing states e.g. true or false, male or female, yes or no.
- 12What is a date/time data type?Any time or date; the way the time or date is displayed depends on how it is formatted. For example 04/10/12 12:15:45
- 13How do passwords keep data secure?-Authorised users are given a username. Each user also has a password that proves the user is really the one whose username is given.
-Using passwords is a method of authentication. - 14Name some benefits of using a database.-Using a database to find data is much faster compared to paper in a filling cabinet.
-A database allows for data to be easily updated and changed.
-Validation
-Reports
-Sharing - 15How do back-ups help keep data secure?A backup is a second copy of the data. If a problem arises with the data file, then the back up copy is used. Can be saved on removable media.
- 16How do access rights help keep data secure?-No right to access the file
-Read access
-Write/edit access - 17Name some security issues with databases.-It cannot be destroyed
-It cannot be accidently or maliciously altered
-It cannot fall into the hands of unauthorised people. - 18What is sorting data?Results of queries can be presented in a sorted order e.g. A-Z.
- 19Why do we sort data?-Easier if lists are printed such as reports
-You can identify best customer by amount they have spent, sort them according to total amount spent. - 20What physical security methods are used to protect data?-Locks on doors
-Alarms
-ID cards
-Biometric system - 21What are some consequences of business' where data is not secure?-Loss of customers
-Payments for goods not being received
-Bad publicity - 22What are some uses of databases?-Add, change or delete records
-Search for a particular record
-Sort the records into a given order - 23What is a calculated field?A calculated field is one where something like an age is always changing and so it cannot be just a field, it must be made a calculated field.
- 24What is a wildcard character?You use wildcard searches in a query for data that you only know part of. For example find all the surnames beginning with 's' you might write Surname LIKE "s*"
- 25What are reports?A report is a printed document that contains data from the database, organised and analysed in a certain way.
- 26What are forms?Forms are used to make data entry more attractive and secure rather than entering data into raw tables.
- 27What is a presence check?It checks to make sure that there is something entered into the fields.
- 28What is a length check?The length of the input is checked for the number of characters used.
- 29What is a look-up list?If data entered consists of a limited number of possible entries then the computer can compare the entry with a list of allowed answers.
- 30What is a range check?The data entered must be in a sensible range.
- 31What is a type check?To make sure that the data entered is of the correct type.
- 32What is a format check?If the data entered has a particular pattern such as a postcode.
- 33What is validation?Data entered into a database must be sensible or we get GIGO. Validation methods insure we only get sensible data.
Informationen
- Beschreibung
- Karteikarten am ICT- Topic 8, erstellt von alexc008 am 15/01/2015.
- Erstellt von
- alexc008
- Aufrufe
- 0
- Bewertung