COPA MS Access MCQ computer database most important questions and answers for ITI exam Paper Preparation Microsoft Office Topic COPA MS Ac...
COPA MS Access MCQ computer database most important questions and answers for ITI exam Paper Preparation Microsoft Office Topic
COPA MS Access MCQ
1. What is the maximum length of the field name in Access?
A 16 characters
B 32 characters
C 64 characters
D 128 characters
Ans. c
2. Which view is used to arrange table data in different graphical layouts to summarize data?
A Table view
B Design view
C Data sheet view
D Pivot chart view
Ans. d
3. Which view allows to modify table’s structure in Access?
A Design view
B Datasheet view
C Pivot table view
D Pivot shart view
Ans. a
4. Which object stores information about related data?
A Document
B Table
C Page
D Screen
Ans. b
5. Which key
stoke moves the active cell towards left in Access table?
A F2
B F5
C Tab
D Shift +
Tab
Ans. d
6. Which
combination of key zooms the content of active cell in Access table?
A Ctrl + F2
B Ctrl + F5
C Shift + F2
D Shift + F5
Ans. c
7. Which
technique prevents invalid data being saved in Access table?
A Index
B Filter
C Validation
rule
D Input mark
Ans. c
8. Which
validation rule accepts only a - z letters for fields in Access?
A Is null or
NOT like “*[! a - z]*”
B Is null or
NOT like “*[a - z ]*”
C Is null or
NOT like “*![a - z]*”
D Is null or
NOT like “[! a - z]”
Ans. a
9. Which validation rule allows only 0 - 9 for fields in Access?
A Is Null or Not Like “*[ ! 0 - 9 ]*”
B Is Null or Not Like “[! 0 - 9]”
C Is Null or Not Like “*[0 - 9]*”
D Is Null or Not Like “*[!0-9]*”
Ans. d
10. Which validation rule allows only positive numbers for fields in?
A Is Null or > = 0
B Is Null or Positive
C Is Null or < 0
D Is Null or = “+”
Ans. a
11. What is allowed the input mark symbol # in Access?
A Letter or digit
B Letter A through Z
C A digit 0 - 9 with +/- sign
D A digit 0 - 9 without +/- sign
Ans. c
12. Which validation rule allows exactly digits for number fields in Access?
A Is Null or Between 100000 and 99999
B Is Null or Like “????”
C Is Null or >= 0 AND< = 99999
D Is Null or < = 99999
Ans. c
13. What is the output when the data ‘1678.95’ is set to the number format ‘###0.00’ in Access?
A 1670.00
B 1670.95
C 1678.00
D 1678.95
Ans.
d
14. Which of the following is a valid time format is Access?
A hh:mm:ss AM/PM
B hh.mm.ss AM/PM
C hh-mm-ss AM/PM
D hh/mm/ss AM/PM
Ans. a
15. Write the output when the data ‘Primary Key’ is set to the text < in Access?
A Primary key
B primary key
C PRIMARY KEY
D Primary Key
Ans.
b
16. What is the output when the data “FOREIGN key’ is set to the text format > in Access?
A foreign key
B FOREIGN KEY
C Foreign Key
D Foreign key
Ans.
b
17. What is the reason for not accepting zero in the fields of Access tables?
A Fields is set with is Null or > 0
B Fields is set with is Null or < = 0
C Fields is set with is Null or! [0]
D Fields is set with is Null or like “?”
Ans. a
18. Which key stoke is used to move the active cell towards right, in access table?
A Ctrl + Tab
B Alt + Tab
C Tab
D Shift +
Tab
Ans. c
19. Which
combination of key allows user to move to the first field in the first record
in Access table?
A Ctrl + Tab
B Shift +Tab
C Shift +
Home
D Ctrl +
Home
Ans. d
20. Which
command quickly locates the data is Access table?
A Find
B Locate
C Search
D Edit
Ans. a
21. OODBMS stands
for_______.
a) object oriented database management system.
b)
order data base management system
c) order base management system
d)
office data base management system
Ans. a
22. How can you edit
a relationship already established between two tables?
a) Right click the
relationship line and choose edit relationship
b) Double click the
relationship line
c) Both the above
d) None of the above
Ans. c