MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 496 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Fundamentals knowledge and support exam preparation. Choose a topic below to get started.
| 151. |
What type of controls are text boxes when data from the recordset is visible? |
| A. | Align |
| B. | Bound |
| C. | Calculated |
| D. | Unbound |
| Answer» C. Calculated | |
| 152. |
A collection of related tables is called |
| A. | Row |
| B. | Record |
| C. | Database |
| D. | File |
| Answer» D. File | |
| 153. |
To sort records in a table |
| A. | Open table, click on the field on which the sorting is to be done, then click Sort button on database toolbar |
| B. | Open table, click Sort button on database toolbar, choose field based on which to sort, click OK |
| C. | Click the field heading to sort it ascending or descending |
| D. | All of above |
| Answer» B. Open table, click Sort button on database toolbar, choose field based on which to sort, click OK | |
| 154. |
In order to use dbms, it is important to understand |
| A. | The physical schema |
| B. | All sub schemas that the sytem supports |
| C. | One sub schema |
| D. | Both a and b |
| Answer» D. Both a and b | |
| 155. |
Which field type will you select when creating a new table if you require to enter long text in that field? |
| A. | Text |
| B. | Memo |
| C. | Currency |
| D. | Hyperlink |
| Answer» C. Currency | |
| 156. |
An Access database object that is used to enter, view or edit records |
| A. | Table |
| B. | Form |
| C. | Query |
| D. | Report |
| Answer» C. Query | |
| 157. |
which of the following is not a data type |
| A. | Picture/graphic |
| B. | Data/time |
| C. | Texst |
| D. | Number |
| Answer» B. Data/time | |
| 158. |
In Access press CTRL+N to |
| A. | Open a new database |
| B. | Open an existing database |
| C. | Exit Office Access 2007Access |
| D. | None of these |
| Answer» B. Open an existing database | |
| 159. |
A Smart Tag can be set using the _____ tab in the property sheet. |
| A. | Format |
| B. | Tag |
| C. | View |
| D. | Data |
| Answer» E. | |
| 160. |
In Access press CTRL+W or CTRL+F4 to |
| A. | Display the Control menu |
| B. | Display the shortcut menu |
| C. | Close the active window |
| D. | None of these |
| Answer» D. None of these | |
| 161. |
On the property sheet, which of the following tabs contains the Caption property? |
| A. | Data |
| B. | Event |
| C. | Format |
| D. | Other |
| Answer» D. Other | |
| 162. |
Which of the following views enables users to create and modify the sections of a form? |
| A. | Datasheet |
| B. | Design |
| C. | Form |
| D. | Layout |
| Answer» C. Form | |
| 163. |
In Access press UP ARROW to |
| A. | Move up one line |
| B. | Move up one page |
| C. | Exit the combo box or list box |
| D. | None of these |
| Answer» B. Move up one page | |
| 164. |
How can you display pivot table report summary data in a currency format? |
| A. | Use custom calculation |
| B. | Type in the currency symbol |
| C. | Modify the field settings |
| D. | None of the above |
| Answer» D. None of the above | |
| 165. |
What happens when a user double-clicks an object in the Project pane of the Visual Basic Editor? |
| A. | The associated code is displayed in the Code pane. |
| B. | The associated code is displayed in a new window. |
| C. | The object is deleted from the Project pane. |
| D. | The object\'s property sheet opens. |
| Answer» B. The associated code is displayed in a new window. | |
| 166. |
In Access press …………………….to Copy the selected control to the Clipboard |
| A. | CTRL+C |
| B. | CTRL+X |
| C. | CTRL+V |
| D. | None of these |
| Answer» B. CTRL+X | |
| 167. |
In Access to switch to the property sheet (Design view in forms and reports in both Access databases and Access projects) |
| A. | F2 |
| B. | F4 |
| C. | F5 |
| D. | F6 |
| Answer» C. F5 | |
| 168. |
The two form layout types will display multiple records at one time are tabular and___ |
| A. | columnar |
| B. | justified |
| C. | date sheet |
| D. | pivot table |
| Answer» C. date sheet | |
| 169. |
In Access press CTRL+F8 to |
| A. | Toggle the Navigation Pane |
| B. | Cycle between open windows |
| C. | Restore the selected minimized window when all windows are minimized |
| D. | Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window |
| Answer» B. Cycle between open windows | |
| 170. |
An enterprise solution with data storage, a client interface and a security system is a(n) __________ system. |
| A. | 2-tier |
| B. | 3-tier |
| C. | 4-tier |
| D. | n-tier |
| Answer» C. 4-tier | |
| 171. |
To delete records or perform calculations on a table, the best tool to use is a __________. |
| A. | query |
| B. | filter |
| C. | form |
| D. | report |
| Answer» B. filter | |
| 172. |
Which of the following statements about the Label Wizard is NOT true? |
| A. | Adding groups can help organize the labels. |
| B. | It helps users to create package labels. |
| C. | It allows users to select a label type and size. |
| D. | It allows users to sort the labels. |
| Answer» B. It helps users to create package labels. | |
| 173. |
To insert a graphic of your company’s logo on a report |
| A. | Click the image button on the toolbox and drag on the report to draw a place holder for the graphics |
| B. | You can’t. Microsoft Access won’t let you insert graphics files. |
| C. | Select Insert > Picture from the menu |
| D. | Select Tools > Insert Picture from the menu |
| Answer» B. You can’t. Microsoft Access won’t let you insert graphics files. | |
| 174. |
Which of the following database objects can have more than one Group Header/Footer section? |
| A. | Forms |
| B. | Queries |
| C. | Reports |
| D. | Tables |
| Answer» D. Tables | |
| 175. |
It is a query that when run displays its own dialog box prompting you for information, such as |
| A. | Select |
| B. | crosstab |
| C. | Parameter |
| D. | Append |
| Answer» D. Append | |
| 176. |
To apply an AutoFormat to an entire Form, what must you select first? |
| A. | Form Selector |
| B. | Document tab |
| C. | Detail section |
| D. | Any control |
| Answer» B. Document tab | |
| 177. |
What is the memo data type field used for? |
| A. | To add table |
| B. | To store objects created in other programs |
| C. | For long text entries |
| D. | For shout text entries of no more than 255 characters |
| Answer» D. For shout text entries of no more than 255 characters | |
| 178. |
Which colors are used to define a custom color? |
| A. | Red, Blue, Yellow |
| B. | Red, Green, Blue |
| C. | Blue, Green, Orange |
| D. | Green, Orange, Violet |
| Answer» C. Blue, Green, Orange | |
| 179. |
This database has only one table. |
| A. | relational |
| B. | large |
| C. | flat-file |
| D. | DBMS |
| Answer» D. DBMS | |
| 180. |
This query wizard will create a select query. |
| A. | Crosstab |
| B. | Find duplicates |
| C. | Simple |
| D. | Design view |
| Answer» D. Design view | |
| 181. |
What is the keyboard shortcut to move to the last records in a table? |
| A. | [Tab] |
| B. | [Shift]+[Tab] |
| C. | [Ctrl]+Home] |
| D. | [Ctrl]+[End] |
| Answer» E. | |
| 182. |
Which of the following statements about PivotChart View is NOT true? |
| A. | It is used to graphically summarize and analyze data in a table, query, or form. |
| B. | It can be used to view different levels of detail or to specify custom layout. |
| C. | It displays field values that can be switched for different views of data. |
| D. | It displays the same information as a crosstab query, except for the counts and sums of numeric fields. |
| Answer» E. | |
| 183. |
If you make an invalid entry in the input mask wizard dialog box, this will display to advise you that the entry is not correct |
| A. | Text error |
| B. | Validation error |
| C. | Literal error |
| D. | Entry error |
| Answer» C. Literal error | |
| 184. |
A disadvantage to a ____file is that there is no easy way to tell which fields are numbers, text, dates, or currency. |
| A. | standardized |
| B. | fixed |
| C. | delimited |
| D. | text |
| Answer» E. | |
| 185. |
In Access to reduce the height of the selected control |
| A. | SHIFT+RIGHT ARROW |
| B. | SHIFT+DOWN ARROW |
| C. | DOWN ARROW or CTRL+DOWN ARROW |
| D. | None of these |
| Answer» E. | |
| 186. |
Which of the following can be an example of a database? |
| A. | Address book of all the suppliers of a company |
| B. | Salary sheet of all the employees of a company |
| C. | Records of daily sales transactions of a company |
| D. | All of above |
| Answer» E. | |
| 187. |
How can you display the relationship in a database? |
| A. | Select View > Relationship form the menu |
| B. | Click the Relationship button on the toolbar |
| C. | Select Edit >Relationship from the menu |
| D. | All the above are true |
| Answer» C. Select Edit >Relationship from the menu | |
| 188. |
Which of the following CANNOT be done to data using a Form? |
| A. | Store |
| B. | Sort |
| C. | Edit |
| D. | |
| Answer» B. Sort | |
| 189. |
Which function extracts the name of the month from a date/time value? |
| A. | Month |
| B. | MonthName |
| C. | MonthLabel |
| D. | MonthValue |
| Answer» C. MonthLabel | |
| 190. |
The checking operation performed oninput data is called the |
| A. | Validation of data |
| B. | Verification of data |
| C. | Cross check |
| D. | Control of data |
| Answer» B. Verification of data | |
| 191. |
What happens when a user selects a record in a form and presses [Delete]? |
| A. | The record is deleted in the form and from its source table. |
| B. | The record is deleted in the form, but not from its source table. |
| C. | The record is neither deleted in the form, nor from its source table. |
| D. | The record is not deleted in the form, but is deleted from its source table. |
| Answer» B. The record is deleted in the form, but not from its source table. | |
| 192. |
In a query, what symbol is used to surround a parameter\'s user prompt? |
| A. | [ ] |
| B. | { } |
| C. | " " |
| D. | ( ) |
| Answer» B. { } | |
| 193. |
The _____ Symbol Smart Tag launches Microsoft Explorer and obtains a stock quote. |
| A. | MSN Money |
| B. | Portfolio |
| C. | Financial |
| D. | Stock |
| Answer» D. Stock | |
| 194. |
Which of the following relationship is not valid in MS Access ? |
| A. | Many to Many |
| B. | Many to Null |
| C. | One to One |
| D. | One to Many |
| Answer» C. One to One | |
| 195. |
Which of the following is a condensed form of standard generalized markup language? |
| A. | HTML |
| B. | XML |
| C. | XSD |
| D. | XSL |
| Answer» C. XSD | |
| 196. |
In Datasheet View, new records are added to a table ____. |
| A. | in alphabetical order |
| B. | at the end of the table |
| C. | at the beginning of the table |
| D. | in numerical order |
| Answer» C. at the beginning of the table | |
| 197. |
Press the following keys in Access to Cancel Print Preview or Layout Preview |
| A. | CTRL+P |
| B. | P or CTRL+P |
| C. | S |
| D. | C or ESC |
| Answer» E. | |
| 198. |
__________ is used to build ‘intuitive’ queries. |
| A. | SQL |
| B. | Xbase |
| C. | QBE |
| D. | XML |
| Answer» D. XML | |
| 199. |
In MS Access "Lookup Wizard" is used to |
| A. | to select from previous values |
| B. | to select values from Excel Sheet |
| C. | to select value from another table |
| D. | Not a valid Data Type |
| Answer» D. Not a valid Data Type | |
| 200. |
Print options can be changed in the Print ____. |
| A. | tab |
| B. | layout mode |
| C. | setup routine |
| D. | dialog box |
| Answer» E. | |