Ms-Access-1

 


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               

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

Post a Comment (0)
Previous Post Next Post

ADS 1

ADS 2