Databases Flashcards
Database is…
A record of fields with different criteria e.g. names, addresses, contact details, etc.
A record is…
An individual account for a specific person or company
Field is…
The title of the type of information you’re gathering
Data type is…
How to field is recorded to keep formatting consistent e.g. short text, date/time
Primary key allows…
Tables to be connected and links them together
Query is…
When you’re finding information on a specific type e,g. Paid their balance yes/no
Sort is…
When fields are organised in ascending or descending in alphabetical order
Report is made…
By making a query first
Name fields are…
Title, first name, surname
Address fields…
Correct format
Include postcode
Telephone number…
Number only
Uses for databases are…x5
Name
Date of birth
Contact details
Medical info
Address inc postcode
Advantages of databases are…x4
Sort info easily- date, alphabetical and can allow searches to be made
Can create reports from info, choose info that’s included
Used for mail merge
Easy to update- forms allow users to change records and add new records
Disadvantages of databases are…x3
Set up must be clearly planned and consistently formatted
Needs a back up to prevent information from getting lost
Training for staff to ensure it’s used correctly .
