DATABASE CONCEPTS

Question 1

query

Answer 1

used to search and extract data from a databaseto find the answer to a question

Question 2

form

Answer 2

used to enter a new record,modify a record and view records already stored in a table

Question 3

macro

Answer 3

small progoram written to perform a repititive task

Question 4

table

Answer 4

consists of number of records

Question 5

key field

Answer 5

uniquely indetitifies one record

Question 6

query

Answer 6

searches and filters data in dattabase that satisfies query criteria

Question 7

report

Answer 7

used topresent results from queries in an effective manner

Question 8

database relationships

Answer 8

link two or more table in a data base using a relationship type

Question 9

lookup wizard

Answer 9

a value that can be selected from a predefined listan entered into the field

Question 10

OLE

Answer 10

object linking and embedding

Question 11

data validation

Answer 11

involves automatic checking of data at the input stage to ensure its reasonable, sensible and acceptable

Question 12

prescence check

Answer 12

ensures data is present

Question 13

length check

Answer 13

ensures data is correct number of character

Question 14

type check

Answer 14

ensures data is of the correct type

Question 15

format check

Answer 15

ensures data matches a predetermined pattern

Question 16

range check

Answer 16

ensures data is within a lower and upper limit

Question 17

volume

Answer 17

amount of data stored by organisations

Question 18

variety

Answer 18

different types and variety of data

Question 19

velocity

Answer 19

refers to speed at which data can be processed