Font size
WorksheetsIT mid-year revision LN-1 grade - 8
Total questions: 21
Worksheet time: 11mins
Primary key allows only values which are _________ and __________.
(a)
A (a) can have only one primary key.
There can be up to ________ fields in a table in MS Access 2010.
254
255
155
555
A (a) is a data storage format that contains a specific type or range of
values.
1. A key symbol will not appear before the field name making it as primary key.(True or False)
(a)
We can duplicate the records in the Primary key column.(True or False)
(a)
Changing the data type of a field may not result in loss of data.(True or False)
(a)
Press alt and Tab keys together to move to the previous field.(True or false)
(a)
We can modify any data, once it is saved.(True or False)
(a)
The data type that can be used to store for long blocks of text for description
is
Text
OLE
Memo
Number
The data type that is used to store web addresses is
Attachment
Memo
OLE
Hyperlink
This command is used to arrange data in a table in descending order.
Sort A to Z
Sort Z to A
Edit
View
This view allows the user to set the fields with its data types and
descriptions.
Datasheet View
Navigation pane
Design View
Backstage view
Name the data type to store the data with value 278.
Currency
Number
Text
Currency
What data type can store Text or combinations of text and numbers that can
be formatted using colour and font controls?
Text
Rich Text
Memo
Number
Name the data type that stores long blocks of text for description.
(a)
Which view allows the user to set the fields with its data types and
descriptions?
(a)
Which view allows the user to create a table by entering data into it?
(a)
What happens when we change the data type of a field with stored data?
(a)
What kind of data does a field with Text data type have?
The Text data can store and have short, alphanumeric values, such as, a
last name or a street address.
The Text data can't store and have short, alphanumeric values, such as, a
last name or a street address.
Study the table given above and identify the Primary key.
Grade is the primary key.
Name is the primary key.
Roll no is the primary key
None of the above
