MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 157 Mcqs, each offering curated multiple-choice questions to sharpen your Microsoft Office knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
Any report, including a basic report, can be modified in _____. |
| A. | Print Preview |
| B. | Report View |
| C. | Layout View |
| D. | All of the above |
| Answer» D. All of the above | |
| 52. |
Which of the following data type is used to store logical value in MS Access ? |
| A. | Yes/No |
| B. | On/Off |
| C. | True/False |
| D. | All of the above |
| Answer» B. On/Off | |
| 53. |
What are the columns in a Microsoft Access table called ? |
| A. | Reports |
| B. | Rows |
| C. | Fields |
| D. | Records |
| Answer» D. Records | |
| 54. |
Which data type is better to use for storing the price of an item? |
| A. | Text |
| B. | AutoNumber |
| C. | Number |
| D. | Currency |
| Answer» E. | |
| 55. |
What does the expression [detail] ! [product] * 1.30 do? |
| A. | multiplies the contents of detail and product fields by 1.3 |
| B. | First divides detail by product and then multiplies by 1.3 |
| C. | multiplies the contents of detail in the product table by 1.3 |
| D. | multiplies the contents of product in the detail table by 1.3 |
| Answer» E. | |
| 56. |
To create relationship between two tables |
| A. | drag any field from parent table and drop on child table |
| B. | drag the foreign key of a table into the primary key of another table |
| C. | drag the primary key of a table into foreign key of another table |
| D. | None of the above |
| Answer» D. None of the above | |
| 57. |
What do you call a primary key field included in another table ? |
| A. | Child key |
| B. | Composite key |
| C. | Parent key |
| D. | Foreign key |
| Answer» E. | |
| 58. |
You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only? |
| A. | By setting required to ‘Yes’ |
| B. | By using default value |
| C. | By defining validation rule |
| D. | By using format |
| Answer» D. By using format | |
| 59. |
This Is The Stage In Database Design Where One Gathers And List All The Necessary Fields For The Database Project. |
| A. | Data Definition |
| B. | Data Refinement |
| C. | Establishing Relationship |
| D. | None Of The Above |
| Answer» B. Data Refinement | |
| 60. |
In MS Access, Text Data type may contain maximum character of |
| A. | 255 Character |
| B. | 256 Character |
| C. | 1064 Character |
| D. | No Limit |
| Answer» B. 256 Character | |
| 61. |
What determines a table’s sort order? |
| A. | AutoNumber field |
| B. | Index field |
| C. | Field order |
| D. | Primary key |
| Answer» C. Field order | |
| 62. |
This Key Uniquely Identifies Each Record |
| A. | Primary Key |
| B. | Key Record |
| C. | Unique Key |
| D. | Field Name |
| Answer» B. Key Record | |
| 63. |
HSAM stands for ________ |
| A. | Hierarchic Standard and Method |
| B. | Hierarchic Sequential and Method |
| C. | Hierarchic Standard Access Method |
| D. | Hierarchic Sequential Access Method |
| Answer» E. | |
| 64. |
What is the result of ‘Select * from customer where CustID>10 and CustID |
| A. | display all customers with CustID from 10 to 100 |
| B. | display all customers with CustID above 10 |
| C. | display all customers with CustID below 100 |
| D. | display all customers with CustID from 11 to 99 |
| Answer» E. | |
| 65. |
Which object is used to create a form? |
| A. | Tables and Queries |
| B. | Tables only |
| C. | Tables and reports |
| D. | Queries and reports |
| Answer» B. Tables only | |
| 66. |
MS-Access is a type of? |
| A. | Utility software |
| B. | Application Software |
| C. | System software |
| D. | None |
| Answer» C. System software | |
| 67. |
Which query do you use to answer the question “What is the average salary of the employees”? |
| A. | Search query |
| B. | Cross tab query |
| C. | Select query |
| D. | Update query |
| Answer» D. Update query | |
| 68. |
A _______ enables you to view data from a table based on a specific criterion |
| A. | Query |
| B. | Report |
| C. | Form |
| D. | All of the above |
| Answer» B. Report | |
| 69. |
Which criteria return only those addresses beginning with the letter “K”? |
| A. | address = “K” |
| B. | address = “K*” |
| C. | address = “K?” |
| D. | address = “K#” |
| Answer» C. address = “K?” | |
| 70. |
MDE file does not contain? |
| A. | Macros |
| B. | Tables |
| C. | Queries |
| D. | Source code |
| Answer» E. | |
| 71. |
Which of the following data type is used to store logical value in MS Access? |
| A. | True/False |
| B. | On/Off |
| C. | Yes/No |
| D. | All of Above |
| Answer» D. All of Above | |
| 72. |
Which of the following the AutoCalc command on the toolbar provides in MS-Access? |
| A. | Sum |
| B. | Count |
| C. | Min |
| D. | All of the above |
| Answer» E. | |
| 73. |
A database makes it unreadable in MS-Access is called? |
| A. | Encode |
| B. | Database |
| C. | Decode |
| D. | None |
| Answer» B. Database | |
| 74. |
In MS-Access the maximum length of validation text is? |
| A. | 126 |
| B. | 129 |
| C. | 234 |
| D. | 255 |
| Answer» E. | |
| 75. |
This is the stage in database design where one gathers and lists all the necessary fields for the database project. |
| A. | data dictionary |
| B. | data refinement |
| C. | data definition |
| D. | none of the above |
| Answer» D. none of the above | |
| 76. |
The______ operator will cause a record to be selected only if two or more conditions are satisfied |
| A. | NOT |
| B. | XOR |
| C. | OR |
| D. | AND |
| Answer» E. | |
| 77. |
Following Is Not A Database Model |
| A. | Network Database Model |
| B. | Relational Database Model |
| C. | Object Oriented Database Model |
| D. | None |
| Answer» E. | |
| 78. |
Which field type can store photos ? |
| A. | Hyperlink |
| B. | OLE |
| C. | Memo |
| D. | Text |
| Answer» C. Memo | |
| 79. |
Which of the following is use to get data from user ? |
| A. | Query |
| B. | Form |
| C. | Report |
| D. | Table |
| Answer» C. Report | |
| 80. |
In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname? |
| A. | zipcode, firstname, lastname |
| B. | firstname, lastname, zipcode |
| C. | zipcode, lastname, firstname |
| D. | can’t sort by multiple fields |
| Answer» D. can’t sort by multiple fields | |
| 81. |
The Third Stage In Designing A Database Is When We Analyze Our Tables More Closely And Create A ___________ Between Tables |
| A. | Relationship |
| B. | Join |
| C. | Query |
| D. | None of these |
| Answer» B. Join | |
| 82. |
Which of the following is not a logical database structure? |
| A. | Chain |
| B. | Network |
| C. | Tree |
| D. | Relational |
| Answer» B. Network | |
| 83. |
Which of the following is not a valid relationship in MS-Access? |
| A. | One to one relationship |
| B. | One to many relationship |
| C. | One to two relationship |
| D. | Many to many relationship |
| Answer» D. Many to many relationship | |
| 84. |
Which data type is better to use for storing the price of an item ? |
| A. | Number |
| B. | Text |
| C. | Currency |
| D. | Hyperlink |
| Answer» D. Hyperlink | |
| 85. |
After right click the field selector button, which do you choose to delete a field in design view? |
| A. | Delete field |
| B. | delete rows |
| C. | remove field |
| D. | remove rows |
| Answer» C. remove field | |
| 86. |
Which of the following is not a data type in MS-Access? |
| A. | Table |
| B. | Number |
| C. | Text |
| D. | OLE object |
| Answer» B. Number | |
| 87. |
_______ is a field property that determines what kind of data a field can store? |
| A. | File type |
| B. | Data type |
| C. | Data select |
| D. | None of these |
| Answer» D. None of these | |
| 88. |
In MS-Access, minimum of _________data types can be assigned to a field? |
| A. | 2 |
| B. | 6 |
| C. | 7 |
| D. | 10 |
| Answer» E. | |
| 89. |
_______ is a component of database such as a table, query, form and macro? |
| A. | Record |
| B. | Object |
| C. | Table |
| D. | None of these |
| Answer» C. Table | |
| 90. |
Which of the following is not a layout in the form design? |
| A. | Autoform Layout |
| B. | Justified Layout |
| C. | Columnar |
| D. | Database |
| Answer» B. Justified Layout | |
| 91. |
Which of the following is not a data base application? |
| A. | Access |
| B. | dBase |
| C. | edit |
| D. | FoxPro |
| Answer» D. FoxPro | |
| 92. |
MS-Access is a |
| A. | Programming Tool |
| B. | Database Tool |
| C. | Web Page Creation Tool |
| D. | None of the Above |
| Answer» C. Web Page Creation Tool | |
| 93. |
MS-Access database files have a default extension? |
| A. | DBM |
| B. | PRG |
| C. | MDE |
| D. | BBE |
| Answer» D. BBE | |
| 94. |
How we save database file in MS Access 2007 for Ms Access 2000? |
| A. | Save As MS Access 2000 Database |
| B. | Save Only |
| C. | Save Object As |
| D. | None of these |
| Answer» B. Save Only | |
| 95. |
In MS-Access, what Are The Different Views To Display a table? |
| A. | Datasheet View |
| B. | Design View |
| C. | Pivot Table and Pivot Chart View |
| D. | All of the above |
| Answer» E. | |
| 96. |
How many save as option in MS Access 2007? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» D. 4 | |
| 97. |
Which of the following is latest version of MS-Access? |
| A. | MS-Access 2002 |
| B. | MS-Access 2000 |
| C. | MS-Access ME |
| D. | MS-Access XP |
| Answer» E. | |
| 98. |
How do you rearrange the date in ascending or descending order? |
| A. | Data, table |
| B. | Data, sort |
| C. | Data, form |
| D. | Data, subtotals |
| Answer» C. Data, form | |
| 99. |
To merge the cells which tab do you use from the format, cells menu? |
| A. | Merge tab |
| B. | Number tab |
| C. | Alignment tab |
| D. | Font tab |
| Answer» D. Font tab | |
| 100. |
An organized collection of logically related data is known as |
| A. | Database |
| B. | Meta data |
| C. | Information |
| D. | None of the above |
| Answer» B. Meta data | |