.jpg)
Ms Access-3
MS-Access lets users link to data in its current location and use the information for viewing, querying, updating, and reporting. It's simple to install and easy to understand. It lets users create tables, forms, queries, and reports and connect with the aid of Macros.
1. It is a query that
when run displays its own dialog box prompting you for information, such as
(A) Append
(B) Parameter
(C) Crosstab
(D) Select
2. Row in an Access
table is also known as ____
(A) Type
(B) Data
(C) Record
(D) Field
3. The appropriate
Data Type to store Time in MS Access?
(A) Time cannot be
stored
(B) Time
(C) Time Only
(D) Date/Time
4. Which of the
following data type stores text or a combination of text and numbers?
(A) Ole
(B) Text
(C) Currency
(D) Number
5. Unlike text data
type, this can store up to maximum of 65,535 characters.
(A) Date/time
(B) Number
(C) Memo
(D) All of above
6. In MS Access,
AutoNumber Data Type
(A) Can be Sequential
(B) Can be Random
(C) Only A & B
(D) Can be Edited
7. In MS Access, which data type is
appropriate to store large text and numbers?
(A) Large Text
(B) OLE
(C) Memo
(D) Text
8. Which is the valid data type in
Access?
(A) Currency
(B) Text
(C) Number
(D) All of the above
9. Which type of terminal is entirely dependent for all its
capabilities in the computer system to which it is connected?
(A) Intelligent terminal
(B) CRT Display
(C) Smart terminal
(D) Dumb terminal
10. The default data type for a field is
(A) Varchar
(B) AutoNumber
(C) Number
(D) Text
11. This data type allows alphanumeric characters and
special symbols.
(A)
Auto number
(B)
Memo
(C)
Text
(D)
All of the above
12.
Access is a
(A) RDBMS (Relational
DBMS)
(B) DDBMS (Distributed
DBMS)
(C) OODBMS (object
Oriented DBMS)
(D) All of the above
13.
To open a new database,
press
(A) Ctrl + O
(B) Ctrl + N
(C) Ctrl + M
(D) Ctrl + S
14.
A ______ is the
collection of data items of all the fields pertaining to one entity.
(A) Field
(B) Form
(C) Record
(D) Report
15.
It is used to
calculate and restructure data for easier analysis of your data. It calculates
the sum
(A) Append
(B) Crosstab
(C) Parameter
(D) Select
16.
Which is not a view to
create a table in Access?
(A) Pivot Table and
Pivot Chart view
(B) Database view
(C) Design view
(D) All of the above
17. Which of the following creates a
drop down list of values to choose from?
(A) ID
(B) Hyperlink
(C) Lookup wizard
(D) Clip object
18. A ____ enables you to view data from a table based on a
specific criterion.
(A) Query
(B) Modules
(C) Form
(D) Report
19. In MS Access “ Hyperlink” Data Type can store
(A) Web Address
(B) Email Address
(C) Path of a File
(D) All of Above
20. It is a database object to view, change, and analyze data in
different ways
(A) Form
(B) Report
(C) Query
(D) All of the above
21. The executive responsible for the data processing
function in an organization is
(A)
PMC
(B)
DBMS
(C)
DPMT
(D)
DPE
22.
_____ button helps to search quickly for every occurrence of a specific word or
phrase.
(A)
Justify
(B)
Find
(C)
Bullet
(D)
Sort
23.
In access, this
displays the results of a calculation in a query
(A) Child field
(B) Calculated field
(C) Source field
(D) Lookup field
24.
Data items groped
together for storage purposes are called a
(A) Record
(B) List
(C) String
(D) Title
25.Which of the following is database management
system software?
(A) Firefox
(B) MS Access
(C) MS PowerPoint
(D) MS Word