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.
| 101. |
A composite key is |
| A. | The primary key with AutoNumber as the field type |
| B. | Is a foreign key that uniquely identifies records |
| C. | Made up of two or more fields to uniquely identify records |
| D. | None of the above |
| Answer» D. None of the above | |
| 102. |
In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box? |
| A. | datasheet border |
| B. | datasheet underline |
| C. | Column Header underline |
| D. | vertical gridline |
| Answer» D. vertical gridline | |
| 103. |
What do you call a primary key field included in another table? |
| A. | Foreign key |
| B. | Parent key |
| C. | Child key |
| D. | Index |
| Answer» B. Parent key | |
| 104. |
Which control type do you use to create a calculated control? |
| A. | command button |
| B. | combo box |
| C. | text box |
| D. | list box |
| Answer» D. list box | |
| 105. |
_______shows multiple records at a time on a page with fields in columns and records in rows? |
| A. | Database |
| B. | Justified |
| C. | Tabular |
| D. | Database |
| Answer» D. Database | |
| 106. |
A __________ Enables You To View Data From A Table Based On A Specific Criterion |
| A. | Form |
| B. | Query |
| C. | Macro |
| D. | Report |
| Answer» C. Macro | |
| 107. |
_____ property is used to set the maximum size for data stored in a field? |
| A. | Data entry |
| B. | Field size |
| C. | Format |
| D. | Rows |
| Answer» C. Format | |
| 108. |
Which Of The Following Statement Is True? |
| A. | Foreign Key Fields Don't Allow Duplicate Values |
| B. | In Primary Key Field You Can Enter Duplicate Value |
| C. | In An Indexed Field You May Or May Not Enter Duplicate Value Depending Upon Setting |
| D. | All Statements Are True |
| Answer» D. All Statements Are True | |
| 109. |
Collection of rlated records in a database is known as |
| A. | Record |
| B. | Relationship |
| C. | File |
| D. | Table |
| Answer» E. | |
| 110. |
Query can be use to select data from |
| A. | Single Table |
| B. | Multiple Tables |
| C. | Both Single and Multiple Tables |
| D. | None of the above |
| Answer» D. None of the above | |
| 111. |
_______ defines a data type for a set of values in a table? |
| A. | Field |
| B. | File |
| C. | Record |
| D. | None of these |
| Answer» B. File | |
| 112. |
In a datasheet, what does each row represent ? |
| A. | Field |
| B. | Database |
| C. | Record |
| D. | All of the above |
| Answer» D. All of the above | |
| 113. |
In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______ |
| A. | Parent , Child |
| B. | Child , Parent |
| C. | Row , Column |
| D. | None of the above |
| Answer» B. Child , Parent | |
| 114. |
Which field type will you select when creating a new table if you require to enter long text in that field ? |
| A. | Text |
| B. | Currency |
| C. | Memo |
| D. | All of the above |
| Answer» D. All of the above | |
| 115. |
______shows a single record at a time? |
| A. | Datasheet |
| B. | Tabular |
| C. | Columnar |
| D. | None of these |
| Answer» B. Tabular | |
| 116. |
Which of the following is not a valid Data Type in MS Access? |
| A. | Memo |
| B. | Picture |
| C. | Currency |
| D. | AutoNumber |
| Answer» C. Currency | |
| 117. |
In MS Access “Hyperlink” Data Type can store |
| A. | Web Address |
| B. | email Address |
| C. | Path of a File |
| D. | All of Above |
| Answer» E. | |
| 118. |
What do you call a collection of records matching parameters of a query? |
| A. | Field |
| B. | Record |
| C. | Query |
| D. | Dynaset |
| Answer» E. | |
| 119. |
Query design window has two parts. The upper part shows |
| A. | Name of fields, field type and size |
| B. | Sorting check boxes |
| C. | Tables with fields and relationships between tables |
| D. | None of the above |
| Answer» D. None of the above | |
| 120. |
Which of the following is valid text and memo format in MS-Access? |
| A. | @ |
| B. | < |
| C. | & |
| D. | All of the above |
| Answer» E. | |
| 121. |
There are three types of data found in a spreadsheet: |
| A. | Numbers, formulas, labels |
| B. | Data, words, numbers |
| C. | Words, numbers, labels |
| D. | Equations, data, numbers |
| Answer» B. Data, words, numbers | |
| 122. |
Which of the following is use to view or print the data in organized manner? |
| A. | Query |
| B. | Report |
| C. | Table |
| D. | Form |
| Answer» C. Table | |
| 123. |
Using the keyword ______ will return records in which the field value equals a defined text. |
| A. | Like |
| B. | Between |
| C. | Is Null |
| D. | Equal |
| Answer» B. Between | |
| 124. |
Which tool do you use to create a query object? |
| A. | Database wizard |
| B. | Simple filter wizard |
| C. | Simple query wizard |
| D. | Table query wizard |
| Answer» D. Table query wizard | |
| 125. |
In a table to insert User’s Voice, Data field should be |
| A. | OLE Object |
| B. | SoundField |
| C. | VoiceField |
| D. | Memo |
| Answer» B. SoundField | |
| 126. |
Which of the following is use to get data from user? |
| A. | Query |
| B. | Pages |
| C. | Form |
| D. | Report |
| Answer» D. Report | |
| 127. |
In MS Access, AutoNumber Data Type |
| A. | Can be Sequential |
| B. | Can be Random |
| C. | Can be Edited |
| D. | Only a and b |
| Answer» E. | |
| 128. |
Primary key is |
| A. | Uniquely identifies each record |
| B. | Cannot be repeated |
| C. | AutoNumber is example of Primary key |
| D. | All of the above |
| Answer» E. | |
| 129. |
Which of the following is invalid field name? |
| A. | Student.Address |
| B. | Student’sAddress |
| C. | Student_Address |
| D. | Student Address |
| Answer» B. Student’sAddress | |
| 130. |
Which of the following Data Type is used to store picture in MS Access |
| A. | Picture |
| B. | OLE Object |
| C. | Memo |
| D. | Picture cannot be stored |
| Answer» C. Memo | |
| 131. |
In MS Access, which data type is appropriate to store large text and numbers? |
| A. | Text |
| B. | Memo |
| C. | OLE |
| D. | Large Text |
| Answer» C. OLE | |
| 132. |
_____ property is used to specify requirements for data entered into a record, field or control? |
| A. | Validation text |
| B. | Validation rule |
| C. | Both a and b |
| D. | None of these |
| Answer» C. Both a and b | |
| 133. |
Microsoft Access is a |
| A. | OODBMS |
| B. | ORDBMS |
| C. | RDBMS |
| D. | None of the above |
| Answer» D. None of the above | |
| 134. |
A ______ name must be unique within a database |
| A. | Table |
| B. | Record |
| C. | Field |
| D. | All of the above |
| Answer» B. Record | |
| 135. |
Caption is a string that can contain up to _________ characters in MS-Access? |
| A. | 2025 |
| B. | 2031 |
| C. | 2037 |
| D. | 2048 |
| Answer» E. | |
| 136. |
Which of the following database object produces the final result to present ? |
| A. | Tables |
| B. | Reports |
| C. | Reports |
| D. | None of the above |
| Answer» C. Reports | |
| 137. |
_______ a series of lines and data appear in the form in Design view? |
| A. | Order of tabs |
| B. | Grid lines |
| C. | Label |
| D. | None of these |
| Answer» C. Label | |
| 138. |
MDE file is a |
| A. | Memory Database Encrypt |
| B. | Memory Database Encode |
| C. | Microsoft Database Encrypt |
| D. | Microsoft Access Database |
| Answer» E. | |
| 139. |
Which of the following is not a type of relationship that can be applied in Access database |
| A. | One to One |
| B. | One to Many |
| C. | Many to Many |
| D. | All of the above |
| Answer» E. | |
| 140. |
In A Database Table, The Category Of Information Is Called __________ |
| A. | Tuple |
| B. | Field |
| C. | Record |
| D. | All of the above |
| Answer» C. Record | |
| 141. |
Which Of The Following Is Not A Database Object? |
| A. | Tables |
| B. | Queries |
| C. | Relationships |
| D. | Reports |
| Answer» D. Reports | |
| 142. |
Which Of The Field Has Width 8 Bytes? |
| A. | Memo |
| B. | Number |
| C. | Date/time |
| D. | Hyperlink |
| Answer» D. Hyperlink | |
| 143. |
In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean? |
| A. | Referential integrity is enforced |
| B. | Referential integrity isn’t enforced |
| C. | An inner join is set |
| D. | An outer join is set |
| Answer» B. Referential integrity isn’t enforced | |
| 144. |
Which is not a command that is selectable from right click menu of a field column? |
| A. | Hide columns |
| B. | Unhide columns |
| C. | freeze columns |
| D. | sort descending |
| Answer» C. freeze columns | |
| 145. |
What do you call the process of restricting the display of records in a table to those matching a particular criterion? |
| A. | filtering |
| B. | restricting |
| C. | sorting |
| D. | sifting |
| Answer» B. restricting | |
| 146. |
_________ provides the tools for creating fields in a table? |
| A. | Drawing View |
| B. | Table View |
| C. | Both a and b |
| D. | Design View |
| Answer» E. | |
| 147. |
What is the purpose of indexing? |
| A. | To reduce table size |
| B. | To speedup data search |
| C. | both a and b |
| D. | none of the above |
| Answer» C. both a and b | |
| 148. |
Which of the following is not a view for interacting with a form object? |
| A. | Datasheet view |
| B. | Design view |
| C. | Form view |
| D. | Layout view |
| Answer» E. | |
| 149. |
This data type allows alphanumeric characters and special symbols. |
| A. | memo |
| B. | text |
| C. | auto number |
| D. | currency |
| Answer» C. auto number | |
| 150. |
In MS-Access to Open a combo box |
| A. | F4 or ALT+DOWN ARROW |
| B. | DOWN ARROW |
| C. | PAGE DOWN |
| D. | F9 |
| Answer» B. DOWN ARROW | |