HIDE
FALSE

Search This Blog

COPA MS Access MCQ [Most Important] Question

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


No comments