Ms Access -1

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

1. Which field type will you select if you need to enter long text in that field?

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               



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

Post a Comment (0)
Previous Post Next Post