MS Access Objectives

1. There are types of Tabular and ______ form layouts that display more than one record at the same time ? a) Columnar b) justified c) data sheet d) Pivot table 2. How many forms are there ? a) 2 b) 6 c) 3 d) 4 3. Which of these statements is true ? a) […]

1. You can use query in Access- a) To view ,modify and analyze data in different ways b) A source of record for form and reports c) Just a d) Both a and b 2. To create query in Ms-Access– a) You can drag and drop a field on query builders b) You can type

1. Operations are in Relationship– a) Define relationships b) Save relationship c) Delete relationship d) All of the above 2. Why Append Query is used? a) To copy a table data to another table b) To delete the Query c) To save the Query d) To update Query 3. Find duplicate record query is used-

46. How many objects are there in Ms Access ? a) 4 b) 3 c) 7 d) 6 Correct Ans: (c) 7 47. Which of these database objects is not a) Tables b) Querise c) Relationships d) Reports Correct Ans: (c) Relationships 48. There is a third stage in the preparation of databases, when we

31. Database Management System (DBMS) is: a) Collection of interrelated data (collection of interlinked data) b) Collection of programs to access data (collection of programs for using data) c) Collection of data describing one particular enterprise (description of a particular enterprise, collection of data) d) All of the above (all) Correct Ans: (d) All of