Flashcards
Topic 8 - Databases
Flashcards do conjunto (6)
- 1State the type of data for each of the following A) 23 B) Film star C)?@~A) Integer/Number
B) Text/String
C) Text/String - 2Describe ValidationValidation checks to see if the data is sensible & resonable
- 3Identify the type of validation used to check: A) number between 0 and 100 B) Mr, Mrs, Miss, Dr, Rev C) GL19 3ZAA) Range Check
B) List or Lookup
C)Format Check/ Picture Check - 4identify 4 benefits of using a databaseFinding data is much faster than a paper based system
Whenever data needs to be updated it can be easily found
Data in a database can be shared with others on the network
Passwords so no one can read the data - 5Explain what is meant by a wildcard and give an exampleA wildcard is used in a query to stand for any character you do now know exactly
example: ? - 6Number of key fields shown? Give the key field State the purpose of the key field1) 1
2) Unique identity
3) To uniquely Identify people from others.
Informações
- Descrição
- FlashCards sobre Topic 8 - Databases, criado por Abby Debell em 09-02-2015.
- Criado por
- Abby Debell
- Visualizações
- 3
- Avaliação