NEW
Font size
WorksheetsN4/5 Admin - Databases
Total questions: 16
Worksheet time: 7mins
What is a database?
something that holds data
a program on a computer
something that finds data
something that sends data
In a TABLE, a column is known as a...
Record
Field
Row
Data
In a TABLE, a row is known as a...
Information
Column
Data
Record
The best data type to choose for a memberID would be
Number
Date/Time
Text
Currency
The best data type to choose for date of birth would be
Number
Date/Time
Text
Currency
The software that we use to create a database is
Microsoft Publisher
Microsoft Word
Microsoft Excel
Microsoft Access
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
Robert needs to create a database of all his friends. In a table, what is last name considered?
Field
Record
Table
Cell Address
To sort from the smallest to the largest (from A to Z and 0 to 9)
Ascending
Descending
Advanced Sort/Filter
A Primary Key is a code that uniquely identifies a _____________ in a Database.
Record
Field
Text
Number
A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.
Query
Report
Database
Spreadsheet
