Microsoft Access
The smallest piece of data in a database
A field
Repeated or inaccurate data in database is know as this
Redundant Data
A cell in a table that holds a single item of data
A field
a table of data that stands alone and does not link to other tables
Flat-file Database
A database that contains linked tables using relationships
Relational Database
A Database Management System
Microsoft Acess
Protection of data from loss, wrongful access or modification
Data Security
Used in a database application to display one record at a time on a the screen
A Form
A person who creates databases
Database Engineer
Unauthorised copying of software
Piracy
The tool within Microsoft access that allows you to create a drop down of specific data in a specific field
Lookup Wizard
ownership of intellectual property by its creator
Copyright
Collection of data about one item in a database
Record
A person to maintains a database
Database Administrator
People who deliberately intrude into computer systems without permission
Hackers
an organised collection of related data
Check of the data to see if it is reasonable and leis within a predefined set of values
Data Validation
Presentation of specific data for printing
Report
Look-up wizard, input masks and auto-number are two examples of this
Data Validation Rules
19th August 1992
Ms Poynting's Birthday!
a number that uniquely identifies each record in a table
Primary Key
Manipulation of data in order to present a one sided view
Data bias
a datatype with only two possible answers e.g. Yes/No
Boolean data
Types include one-to-one, one-to-many, many-to-many
Typed of relationships in a Database
The owner of the largest database in the world
Amazon