Chapter 3 - Database applications Flashcards
Whats a query ?
Used to search and extract data from a database
Whats a form ?
Used to enter a new record, modify an existing record and view other records
What is a report ?
Allows tables and results of queries to be presented in a user-friendly way
What are macros ?
A small program written to preform a repetitive task automatically
What is a database relationship ?
They link two or more tables in a database using a relationship type
Name the 6 datatypes
- text
- number
- date/time
- currency
- Autonumber
- yes/no
What is data validation ?
it ensures data entered is sensible in range and the right data type
name three types of data validation
- range check
- length check
- type check
What is the sign for not equal to ?
<>
What is big data ?
Big data refers to large amounts of data that have the potential to be mined for information
What are the three v’s of big data ?
- Volume
- Variety
- Velocity
What is data analytics ?
data analytics involves analysing bug data to extract information
can be useful to find the predicted growth of a company
