|
1) Which option allows us to build a new table by entering data directly into a tabular grid ? a. Datasheet View b. Design View c. LinkedTable d. Grid View
|
||||
|
2) What is the shortcut key to switch between the field names and properties panels in table design view? a. F3 Key b. F4 Key c. F5 Key d. F6 Key
|
||||
|
3) Which field type can store photos? a. Hyperlink b. OLE Object c. Both can be used d. It is not possible
|
||||
|
4) Which data type should we use if we are planning to store a couple of paragraph or detailed description in a field? a. Text b. Para c. Memo d. Desc
|
||||
|
5) Which of the following database object hold data? a. Forms b. Reports c. Queries d. Tables
|
||||
|
6) When creating a new table which method can be used to choose fields from standard databases and tables a. CreateTable In Design View b. CreateTable Using Wizard c. CreateTable by entering data d. None of Above
|
||||
|
7) Which one of these is the most common type of query that retrieves records from one or more tables and then displays the result in tabular form ? a. Tabular Query b. Crosstab Query c. Select Query d. Pivot Query
|
||||
|
8) Microsoft Access is a ______ kind of application ? a. RDBMS b. OODBMS c. ORDBMS d. Network Database Model
|
||||
|
9) Queries in MS Access can be used ____________ a. To view data b. As source for Forms c. As source for Reports d. All of These
|
||||
|
10) How many characters you can type in maximum while writing the field name? a. 60 b. 64 c. 68 d. Any Number Of Character
|
||||
|
11) The small button with three dots displayed at the right of field properties box is called : a. Make Button b. Expression Button c. Build Button d. None Of Above
|
||||
|
12) Which of the following shows the final result in a presentable way ? a. Forms b. Reports c. Queries d. Tables
|
||||
|
13) In MS Access, how can we create relationship between two tables in the GUI ? a. Drag the foreign key of a table into the primary key of another table b. Drag any field from parent table and drop on child table c. Drag the primary key of a table into foreign key of another table d. Any of these can be done to create relationship
|
||||
|
14) Which of the following storecommandto gather data from database? a. Forms b. Reports c. Queries d. Tables
|
||||
|
15) A search value in SQL query can be a specific value or it can be ________ a. Logical Operator b. Relationship c. Wild card character d. Comparison operation
|
||||
|
16) What is the default and maximum size of text field in MS Access? a. 50 And 255 Characters b. 8 And 1 Gb c. 266 & 64000 Characters d. 8KB and 1.5 MB
|
||||
|
17) How can we remove a relationship defined between two tables ? a. From Edit menu (by chosing Delete Relationship) b. Select the relationship line and press Delete c. Choose Delete option from Relationship menu d. Choose Remove option from Relationship menu
|
||||
