1) Which of the following is not a field type in Microsoft Access ? a. Memo b. Hyperlink c. Ole Object d. Lookup Wizard
|
||||
2) The upper part of the query design window in MS Access has two parts shows ____________ a. Fields name with field size b. Fields name with relationships c. Fields and Criteria d. Sorting Options
|
||||
3) To define AND condition while entering criteria in a query design window we write _______ a. Criteria values vertically one in a row b. Criteria values horizontally c. Write criteria values separated by AND d. Write criteria values using & ( anchor and ) sign
|
||||
4) Which feature is used to duplicate a control's formatting ? a. Manager b. Wizard c. Painter d. Control
|
||||
5) Which of the following is not a type of relationship that can be applied inAccess database? a. One to One b. One to Many c. Many to Many d. All of above
|
||||
6) While creating relationship, what happens when you releasemousepointer after you drop the primary key of a table into foreign key of another table? a. A relationship is created b. Edit relationship dialog boxappears c. A connector symbol is created d. A connecting Line is visible
|
||||
7) What is the role of Cascade Update option ? a. It says do not change the value in the primary key field if that record has related records in another table b. It means change all the related records in child tables if the record in parent table is changed c. Both A and B d. None of these
|
||||
8) Which of the following is a method tocreatea new table inMS Access? a. Using Design View b. CreateTable Wizard c. Directly Entering Data d. All of Above
|
||||
9) If you write criteria values one in a row in query design window, that means you are specifying _____ a. OR conditions b. AND conditions c. NOT condition d. ALL conditions
|
||||
10) How can we create a query in Microsoft Access ? a. Drag and drop fields b. Type the SQL c. Use query wizard d. All of above
|