MS Access| Set-1 MS-Access April 22, 2022April 22, 2022GyanBazarLeave a Comment on MS Access| Set-1 You can practice in this section operating system MCQ which is important for exam point of view. 1 Created on April 22, 2022 By GyanBazarMS-Access MS Access Set-1 You can practice in this section operating system MCQ which is important for exam point of view. 1 / 50 Category: MS-Access 1. Which of the following term is least related to database? a. Attributes b. Relationship c. Columns d. Tuples 2 / 50 Category: MS-Access 2. Which of the following database object hold data? a. Forms b. Tables c. Queries d. Reports 3 / 50 Category: MS-Access 3. Which operator is used to filter and display rows when all (two or more) conditions are satisficed ? a. RANGE b. AND c. IN d. OR 4 / 50 Category: MS-Access 4. The size of yes/no field is always ________ a. 1 Bit b. 1 KB c. 1 Character d. 1 Byte 5 / 50 Category: MS-Access 5. In MS Access, how can we create relationship between two tables ? a. Drag the primary key of a table into foreign key of another table b. Drag the foreign key of a table into the primary key of another table c. Drag any field from parent table and drop on child table d. All of the above 6 / 50 Category: MS-Access 6. In the context of Microsoft Access, which of the following statement is true? a. Queries can include calculated fields that do not exist in table b. Reports and forms are similar but forms are use to print but reports to display on screen only c. Reports are used to retrieve and calculate data from tables d. Queries can be printed and presented as the information 7 / 50 Category: MS-Access 7. How many characters you can type in maximum while writing the field name? a. 60 b. 68 c. 64 d. None of the above 8 / 50 Category: MS-Access 8. What is a form that we can create in MS Access ? a. It is an input screen for viewing and entering data. b. It is used to take printout of a form from Access Tables c. It is optional. We can use Report instead of Form d. It is used for storing special data other than text 9 / 50 Category: MS-Access 9. Which of the following is not a type of MS Access database object? a. Table b. Modules c. Worksheets d. Form 10 / 50 Category: MS-Access 10. Which kind of query that displays its own dialog box prompting you for entering information before executing ? a. Select Query b. Dialog Query c. Parameter Query d. Crosstab Query 11 / 50 Category: MS-Access 11. Which field type will you select if you need to enter long text in that field? a. Text b. Hyperlink c. Currency d. Memo 12 / 50 Category: MS-Access 12. The expression builder is an access tool that controls an expression___ for entering an expression a. Table b. Palette c. Cell d. Box 13 / 50 Category: MS-Access 13. Which of the following data types automatically generates a consecutive number? a. Auto-number b. Text c. Number d. Memo 14 / 50 Category: MS-Access 14. Which of the following is not a type of relationship that can be applied in Access database? a. One to One b. Many to Many c. One to Many d. All of above 15 / 50 Category: MS-Access 15. You define a field so that when entering data ##### is displayed? a. Input Mask b. Indexed c. Username Mode d. Validation Rule 16 / 50 Category: MS-Access 16. The filter by selection allows you to filter those records a. That match the selected field b. That match the criteria specified c. That meet any of several criteria specified d. All of above 17 / 50 Category: MS-Access 17. What is the role of Cascade Update option ? a. It means change all the related records in child tables if the record in parent table is changed b. It says do not change the value in the primary key field if that record has related records in another table c. Both of the above d. None of these 18 / 50 Category: MS-Access 18. Which feature is used to duplicate a control's formatting ? a. Manager b. Control c. Painter d. Wizard 19 / 50 Category: MS-Access 19. Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry? a. Match Case b. Match: Any Part of Field c. Match: Start of Field d. Match: Whole Field 20 / 50 Category: MS-Access 20. Ho can you edit a relationship already established between two tables? a. Right click the relationship line and choose Edit Relationship b. Double click the relationship line c. Both of above d. None of above 21 / 50 Category: MS-Access 21. The columns in a micro-soft access table are also called _______ a. Rows b. Columns c. Fields d. Records 22 / 50 Category: MS-Access 22. A database object in MS Access that stores a question about the data in database? a. Table b. Report c. Query d. Form 23 / 50 Category: MS-Access 23. Which of the following database object can be used if you need to mail the invoice to customers? a. A form b. A table c. A report d. A query 24 / 50 Category: MS-Access 24. While creating relationship using mouse, how the the mousepointer looks like? a. A thick plus sign b. Arrow with Plus sign c. An outlined rectangle d. A thin plus sign 25 / 50 Category: MS-Access 25. Which of the following is a method to create a new table in MS Access? a. Using Design View b. Directly Entering Data c. Create Table Wizard d. All of Above 26 / 50 Category: MS-Access 26. Which of the following option creates a Drop Down List of values ? a. Ole Object b. Lookup Wizard c. Memo d. Hyperlink 27 / 50 Category: MS-Access 27. The Input Mask wizard does NOT include the ability to do which of the following? a. Force all uppercase b. Store symbols with data c. Use preset masks d. Define placeholder 28 / 50 Category: MS-Access 28. What does the show check box in query design window indicate ? a. It indicates whether the field is to be used or not. b. It indicates whether the field is to be used for grouping result or not. c. It indicates whether the field is to be displayed in query result or not d. It indicates whether the field names to be displayed in query result or not. 29 / 50 Category: MS-Access 29. While creating relationship, what happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table? a. A relationship is created b. A relationship Line is visible c. Edit relationship dialog box appears d. A connector symbol is created 30 / 50 Category: MS-Access 30. Which of the following expresses correct order? a. Characters, Fields, Records, Tables, Files, Databases b. Files, Databases, Tables, Records, Fields, Characters c. Databases, Tables, Files, Records, Field, Character d. Characters, Fields, Records, Tables, Database, Files 31 / 50 Category: MS-Access 31. Which of the following is not a field type in Microsoft Access ? a. Memo b. Ole Object c. Lookup Wizard d. Hyperlink 32 / 50 Category: MS-Access 32. 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. Select Query c. Pivot Query d. Crosstab Query 33 / 50 Category: MS-Access 33. Which option allows us to build a new table by entering data directly into a tabular grid ? a. Datasheet View b. Grid View c. Design View d. None of the above 34 / 50 Category: MS-Access 34. In which method we don't need to specify the field type and size while creating a new Table? a. Design View b. CreateTable By Entering Data c. While using Wizard d. All of Above 35 / 50 Category: MS-Access 35. How can we remove a relationship defined between two tables ? a. Select the relationship line and press Delete b. From Edit menu c. Choose Remove option from Relationship menu d. Choose Delete option from Relationship menu 36 / 50 Category: MS-Access 36. A search value in SQL query can be a specific value or it can be _______ a. Logical Operator b. Wild card character c. Comparison operation d. Relationship 37 / 50 Category: MS-Access 37. When creating a new table which method can be used to choose fields from standard databases and tables a. Create Table In Design View b. CreateTable Using Wizard c. CreateTable by entering data d. None of Above 38 / 50 Category: MS-Access 38. The small button with three dots displayed at the right of field properties box is called... a. Make Button b. Build Button c. Expression Button d. None Of Above 39 / 50 Category: MS-Access 39. Which field type can store photos? a. Hyperlink b. OLE Object c. LookUp Wizard d. None of the above 40 / 50 Category: MS-Access 40. The_____________ button on the tool box display data from a related table a. Sub form sub report b. More controls c. Select objects d. Relationships 41 / 50 Category: MS-Access 41. The most popular commercial DBMS. a. Microsoft SQL Server b. MySQL c. Oracle d. Microsoft Access 42 / 50 Category: MS-Access 42. What Cascade Delete option is used for ? a. It ensures that all the related records will be deleted automatically when the record from parent table is deleted. b. It is used to delete all the records of all tables in a database c. It is used to delete all the records of related tables in a database d. It repeats the recent delete operation to all the records of current table 43 / 50 Category: MS-Access 43. What is the shortcut key to switch between the field names and properties panels in table design view? a. F3 Key b. F6 Key c. F5 Key d. F4 Key 44 / 50 Category: MS-Access 44. what is the maximum length of a text field ? a. 120 b. 75 c. 265 d. 255 45 / 50 Category: MS-Access 45. The size of a field with number data type can not be _____ a. 2 b. 16 c. 8 d. 4 46 / 50 Category: MS-Access 46. Microsoft Access is a ______application ? a. RDBMS b. Network Database Model c. ORDBMS d. OODBMS 47 / 50 Category: MS-Access 47. Which of the following shows the final result ? a. Forms b. Tables c. Queries d. Reports 48 / 50 Category: MS-Access 48. 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 49 / 50 Category: MS-Access 49. Both conditions display on the same row in the design grid when ________operator is in use a. Or b. Like c. And d. In 50 / 50 Category: MS-Access 50. What is the default and maximum size of text field in MS Access? a. 50 And 255 Characters b. 266 and 600 Characters c. 64 and 255 Characters d. 55 And 200 Characters Your score is The average score is 2% 0% Restart quiz
