NEW
Font size
WorksheetsDatabase
Total questions: 12
Worksheet time: 6mins
What is a database?
A software package used to store information
Something that has a list
A spreadsheet
A table of data
Which software program do we use to create a database
Microsoft Excel
Microsoft Word
Microsoft Access
Microsoft Publisher
Who might use a database?
School
Police
Employer
All of the above
In school, what kind of data might be stored in a database?
Favourite colour
Emergency contact details
Favourite food
Your mobile phone number
What is an advanage of a database?
You can input information
Its different to Excel
It saves files
Can search through and find information quickly
What is a unique identifying field called?
Field
Primary Key
Record
Query
Short text, date, long text and number are all examples of what?
Data types
Headings
Fields
Records
A column in a database is better known as a...
Record
Query
Field
Form
A row in a database is better known as
Record
Query
Field
Form
True or false - it is important to check our literacy (spelling, capital letters, etc) when inputting data into a database
True
False
A query is used to
Sort the database in alphabetical order
Search the database
Delete records
Create a form
If we are running a query and looking for all records with a date before 1999, we type what into the criteria?
>1999
>01/01/1999
<01/01/1999
<1999
