Font size
WorksheetsGrade 5 III Term Revision
Total questions: 47
Worksheet time: 32mins
_______________________are a collection of completed fields about one object.
Fields
Table
Database
A ____________________is a document that is stored in a computer.
Folder
Record
Database
Each table is made up of lots of pieces of information that are organized in _______________.
Rows
records
Table
Fields
(a) is a number or words that have no meaning on their own.
(a) is a data that has meaning.
A __________________ is a system that stores data in a structured, organized way.
Table
Fields
Records
Computer knows about the type of data stored by giving its (a) .
(a) is the arrangement of items.
In design view of query, Text data appears in criteria within ____________________.
Speech marks
Hashtags
no symbols
Formula is a datatype in MS-Access database.
True
False
Boolean data has many options to choose from.
True
False
The query returns a subset of data from the group of cells.
True
False
In Design view of query, Date data appears appears in criteria with # symbols.
True
False
A table is divided into _____________________________.
Fields and forms
Fields and records
Record and form
None
The horizontal data of a table are stored in _________________
Rows
Columns
Cells
None
There are seven types of data type in MS-Access.
True
False
Click on the “Design view” option in View tab to edit the query.
True
False
5486 is an example of currency data type.
True
False
The ________________ is a database tool that lets you search for specific data.
Query
Table
Form
Fields
Text datatype is used to store only letters.
True
False
You can double click the table to open it in a database.
True
False
In Microsoft Access, a field labelled “Price” must be created as _______________ datatype.
Text
Number
Date
Currency
The only datatype that allows letters is Text.
True
False
Which of these is not an example of data type?
Picture
Yes/no
Short text
Date and Time
An Aestrisk ‘*’ in searches is also know as (a)
To (a) means to put something in an order.
__________________is a database command that returns data items that include letters and numbers that come after it
INCLUDES
AND
OR
NOT
A statement with _______________in it means one or both options.
AND
OR
NOT
INCLUDES
_____________is a database command used if you want both elements of a query to be true.
AND
OR
NOT
INCLUDES
____________ is a database command that searches for data that does not match with the statement.
AND
OR
NOT
INCLUDES
The Query Design button is located on the ______________ tab.
File
Home
Insert
Create
The Asterisk symbol ‘*’ means (a) in a query.
The data can be sorted in (a) or Descending order
'Like’ keyword can be used only for TEXT datatype
True
False
You can use > and < in searches for Boolean datatype.
True
False
There are speech marks for number field.
True
False
AND queries are used if you want both elements to be true
True
False
Text is not case sensitive in a query.
True
False
We can create a Query that has more than one criteria
True
False
The results of a Query can be sorted
True
False
We can use only one OR command in a single query
True
False
Queries are structured according to the data field
True
False
Sorting from A-Z is called descending sort
True
False
To see the result of the Query in a database, you have to click on ________________ at the top of the screen.
Run
show
design
add
To Save a query, Click on ___________________________.
File and save
file and close
create and save
file and view
EQUALS query is used to find the _______________ value in a query.
greater than
less than
exact same
approximately
Identify the extension of Access database file.
.docx
.jpg
.accdb
.xlsx
