NEW
Font size
WorksheetsDatabases
Total questions: 19
Worksheet time: 10mins
What is a row in database called?
Record
Field
Entity
Table
What is one piece of information in a database called?
Field
Record
Entity
Validation
Text, Number and Date/Time are all examples of...
Data Types
Filters
Sorts
Validations
A method of only displaying records in a table that match specific criteria...
Search/Filter
Validation
Sort
Verification
A collection of fields and records in a specific category
Record
Table
Field
Spreadsheet
Everything in one row is a record.
True
False
Which of the following is an example of a record?
347
ChannelType
351, Nature, Documentary, Bling, False
What is a database?
A piece of software to do calculations
A device to load information onto the computer.
A structured collection of records
A calculator
A health club wants to find all the members who use the club 3 days or more a week. What will the search criteria for 'days' be?
>3
<3
<=3
>=3
The school wants to sort the data in alphabetical order by staff Surname. How will they sort it?
Ascending order
Descending order
What program do we use in class for Databases?
Word
Excel
Access
Powerpoint
What is the main purpose of sorting/searching data?
Makes it nicer to look at
Makes it easier to input new data
Helps to find specific information quickly
Gives me something to do when I'm bored
if you wanted to show only people who are older than 10, what would the search criteria for age be?
=10
<10
=>10
>10
What is a query?
Table
Question
Spreadsheet
Report
Andrew needs to create a database of all his friends. In a table, what is all the information about one friend considered?
Field
Record
Table
Entry
Ted is creating a database for several customers. What is the data type for the field customer name?
Date/Time
Text
Number
Currency
You want to add a field for Pictures in your database. What datatype would the field Photos be?
Text
Number
Memo
Attachment
