Multiple Choice Question for Microsoft Access || 3
Read multiple choice questions for computer operator training as well as IT Training. Improve your computer skills.
21 How can you define a field so that when entering data for that
field it will display ****** instead of actual typed text
A. Input mask
B. Validation Rule
C. Indexed
D. IME Mode
22 To
sort records in a table
A. Open table, click on the field on which the sorting is to
be done, then click Sort button on database toolbar
B. Open table, click Sort button
on database toolbar, choose field based on which to sort, click OK
C. Click the
field heading to sort it ascending or descending
D. All of above
23 To create relationship between two tables
A. drag the primary key
of a table into foreign key of another table
B. drag the foreign key of a table into
the primary key of another table
C. drag any field from parent table and drop on
child table
D. Any of above can be done to create relationship
24 After entering all fields required for a table, if you realize that
the third field is not needed, how will you remove?
A. You need to delete the whole
table
B. There is no method to remove a particular field only. Delete all the fields
from third downwards and re enter the required fields again.
C. select the third
column in datasheet view then Delete
D. select the third row in table design view
then Delete
25 To duplicate a controls formatting
you can use
A. Manager
B. Wizard
C. Painter
D. Control
26 Which field type will you select when creating a new table if you
require to enter long text in that field?
A. Text
B. Memo
C. Currency
D. Hyperlink
27 In table design view what are the
first column of buttons used for
A. Indicate Primary Key
B. Indicate Current Row
C. Both of above
D. None of above
28 What does the
show check box in query design window indicate
A. It indicates whether the field is
to be used or not
B. It indicates whether the field is to be displayed in query
result or not
C. It indicates whether the field names to be displayed in query
result or not
D. None of above
29 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 can be applied
30 This option allows you to build a new table by entering
data directly into the datasheet.
A. datasheet view
B. design view
C. link table
D. None of the above