Font size
WorksheetsDatabase Review
Total questions: 42
Worksheet time: 21mins
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
In a database, Multiple _________ can be created.
Tables
Documents
Primary Key
All of these
___________________ Key uniquely identifies each record in table.
Fields
Record
Row
Primary
____________ option allows you to design the table.
Table Data View
Table Design
Properties
Create
In a Database, each row is called a _____________
Field
Data
Record
Table
In a Database, each column is called a _____________
Field
Data
Record
Table
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.
Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?
Name
ID
City
All of these
Which one of the following attributes cannot be taken as a primary key?
ID
RegistrationNo
DepartmentID
Street
Which of the following are common database program?
MS Access
Excel
InDesign
OpenOffice Database
Which of the following is an example of a DBMS
MS Word
Microsoft Office
Java
Oracle
Database if the collection of information or group of facts in a structured way.
Maybe
No
Yes
Not Always
______________ datatype you'd select for entering "Address".
Number
Date
Text
Time
You have to enter Sam's DOB, What datatype would you use for this field.
Time
Date
Text
Number
Information corresponding to each field is called (a) .
______________ symbol indicates that a field is the Primary Key of the table.
What is a primary key?
A field
A record
Two fields
A unique reference
Celestial High maintains a database containing tables related to its students and subjects offered. Which of the following represents a table within the database?
A student's name
A set of student scores
A subject teacher's name
Scores for multiple students
A school has a database with all their staff and students, now that learning is online they want to include email addresses in the database, what must they do?
