What is a record
A row in a table
What is a field
A part of a record that stores a single data item
What is a key field
Uniquely identifies one record
What is a query
Searches and filters data in database that satisfy query criteria
Adavantages of a report
Sorting,filtering and can be printed
What is a macro
Program written to perform a repetitive task automatically
What are the type of checks
Presence, length, type, format,range
Outline big data
Volume which refers to the amount of data stored. Data is stored in terabytes.
Variety refers to the different types of data. Stored in many formats not just text.
Velocity. Refers to the speed at which the data can be processed. Due to large volume of data more powerful computers are neeed
What are data relationships defined as
One to one , one to many or many to many
What is data validation
Carried out by a computer automatically when data is inputted. It ensures the data is reasonable
What are the different type of data validation
Presence check, range check, type check, format check,length check
What is data analytics
Involves analysing large volumes of data to produce useful information e.g data mining used
