Font size
WorksheetsY6 Unit111
Total questions: 22
Worksheet time: 11mins
What are databases mainly used for?
To store archived data
To store and organise data
To analyse data
The rows in a database are called:
Records
Fields
Attribute
Coloum
The columns in a database are called:
Records
Fields
Primary key
Foreign key
A library has a database and wants to add people's Emails. What will they do?
Add a row
Add a Field
Edit a record
Make a new database
To sort the smallest to the largest in a field?
Descending
Ascending
Auto Sort
Advanced Sort/Filter
What is a database?
A software package used to store information
Something that has a list
A spreadsheet
A table of data
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
The best data type to choose for date of birth would be
Number
Date/Time
Text
Currency
This table has ___________ records.
2
4
5
6
This table has ___________ fields.
2
4
5
6
___________, ___________ & ___________ are fields.
S. No, Product Code & Description
1021, Beverages & Soft drinks, coffees, teas
Dairy Products, Beverages & Seafood.
All of these are fields.
______________ datatype you'd select for entering "Address".
Number
Date
Text
Time
The structure of database is made up of _________ and _________.
Frame, Form
Form, Fields
Fields, Records
Records. Form
