.jpg)
MS Access is a desktop database management system (DBMS) which was first released in 1992. Earlier,
the extension of a MS Access file was .mdb (Access 97-2003). The default file format has changed from .mdb to .accdb with the introduction of MS Access 2007. MS Access databases can be uploaded in web
servers to create database driven web applications
A. Text
B. Memo
C. Currency
D. Hyperlink
2.The expression builder is
an access tool that controls an expression___ for entering an expression
A. Table
B. Box
C. Cell
D. Palette
Which of the following is
not a type of MS Access database object?
A. Table
B. Form
C. Worksheets
D. Modules
3. In which method we don't
need to specify the field type and size while creating a new Table?
A. Design View
B. While using Wizard
C. Create Table by Entering Data
D. All of Above
4. The size of yes/no field
is always ________
A. 1 Bit
B. 1 Byte
C. 1 Character
D. 1 KB
The size of a field with
number data type can not be _____
A. 2
B. 4
C. 8
D. 16
5. Which of the following option creates a Drop Down List of values ?
A. Ole Object
B. Hyperlink
C. Memo
D. Lookup
Wizard
6. What can be the maximum
length of a text field ?
A. 120
B. 255
C. 265
D. 75
7. Which kind of query that
displays its own dialog box prompting you for entering information before executing ?
A. Select Query
B. Crosstab Query
C. Parameter Query
D. Dialog Query
8. Which operator is used to
filter and display rows when all (two or more) conditions are satisfied ?
A. RANGE
B. IN
C. ALL
D. AND
9. The_____________ button on
the tool box display data from a related table
A. Sub form sub report
B. Relationships
C. Select objects
D. More controls
10. The command center of
Access File that appears when we create or open the MS Access database File.
A. Database Window
B. Query Window
C. Design View Window
D. Switchboard
11. While creating
relationship using mouse, how the the mouse pointer looks like?
A. A thick plus sign
B. A thin plus sign
C. An outlined rectangle
D. Arrow with Plus sign
12. The columns in a microsoft
access table are also called _______
A. Rows
B. Records
C. Fields
D. Columns
13. How can you define a field
so that when entering data ##### is displayed?
A. Input Mask
B. Validation Rule
C. Indexed
D. Ime Mode
14. Which of the following is not
a field type in Microsoft Access ?
A. Memo
B. Hyperlink
C. Ole Object
D. Lookup
Wizard
15. Which feature is used to
duplicate a control's formatting ?
A. Manager
B. Wizard
C. Painter
D. Control
16. Which of the following is
not a type of relationship that can be applied in Access database?
A. One to One
B. One to Many
C. Many to Many
D. All of above
17. In MS Access, OLE
objects Data type can store
(A) Microsoft Excel
Spreadsheets
(B) Microsoft Word
documents
(C) Sounds
(D) All of the above
18. A part of database
that stores complete information about an entity such as employee, sales, orders etc.
(A) Record
(B) File
(C) Field
(D) Query
19. In table design view,
which key can be used to switch between the field names and properties panels?
(A) F1
(B) F6
(C) F10
(D) F12
20. To create queries in
Access
(A) You can drag and
drop fields on query builders
(B) You can type the
SQL command in SQL view
(C) You can use query
wizard or design view
(D) All of the above
21. Which of the following
is not a selection technique?
(A) To select a row,
click the record selector box to the left of the row
(B) To select a column,
double click anywhere in the column
(C) To select a word,
double click the word
(D) To select an
entire table click the empty box to the left of the field names
22. Which program do you
use to edit code for data access pages?
(A) Microsoft script
editor
(B) Microsoft data
access pages editor
(C) Microsoft code
editor
(D) All of these
23. In how many views, you
can create a table in Access?
(A) 2
(B) 4
(C) 6
(D) 8
24. Which of the following
is not a field type in access?
(A) Ole object
(B) Hyperlink
(C) Memo
(D) Lookup wizard
25. To switch between to
Form view from design view, press ____
(A) F5
(B) F8
(C) F9
(D) F11