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.
| 301. |
The checking operation performed on input data is called the |
| A. | Validation of data |
| B. | Verification of data |
| C. | Cross check |
| D. | Control of data |
| Answer» B. Verification of data | |
| 302. |
What is the type of query that extracts data from a table and puts them into separate table? |
| A. | Parameter query |
| B. | Make table query |
| C. | Update query |
| D. | Put table query |
| Answer» C. Update query | |
| 303. |
You can set a controls border type to make the border invisible. |
| A. | Transparent |
| B. | Invisible |
| C. | Do not display |
| D. | No border |
| Answer» D. No border | |
| 304. |
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum, |
| A. | Parameter |
| B. | Select |
| C. | crosstab |
| D. | Append |
| Answer» D. Append | |
| 305. |
The VB Name used to display the warning message icon is _______. |
| A. | vbCritical |
| B. | vbInformation |
| C. | vbExclamation |
| D. | vbQuestion |
| Answer» D. vbQuestion | |
| 306. |
In the Field List of a table, the primary key appears _______________. |
| A. | bold |
| B. | italicized |
| C. | underlined |
| D. | with key icon |
| Answer» E. | |
| 307. |
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?" | |
| 308. |
In Access press to Toggle the focus forwardbetween controls in the wizard |
| A. | TAB |
| B. | ALT+N |
| C. | ALT+B |
| D. | ALT+F |
| Answer» B. ALT+N | |
| 309. |
Which of the following Format supports for Data Type Yes/No? |
| A. | Yes/No |
| B. | True/False |
| C. | On/Off |
| D. | All of Above |
| Answer» E. | |
| 310. |
The Allow _____ property controls whether new records can be added through the form. |
| A. | Additions |
| B. | Edits |
| C. | Deletions |
| D. | Data Entry |
| Answer» B. Edits | |
| 311. |
Which of the following statements does NOT hold true for the Top Values property? |
| A. | The Top Values property displays only the highest values from the query. |
| B. | The Top Values property requires the fields to have a defined sort order. |
| C. | The Top Values property finds a specified number of records. |
| D. | The Top Values property finds a specified percentage of records. |
| Answer» B. The Top Values property requires the fields to have a defined sort order. | |
| 312. |
Which report section prints once at the bottom of every printed page? |
| A. | Detail |
| B. | Page Header |
| C. | Page Footer |
| D. | Report Header |
| Answer» D. Report Header | |
| 313. |
In Access to open the Replace tab in the Find and Replace dialog box (Datasheet view and Form view only) |
| A. | CTRL+F |
| B. | CTRL+H |
| C. | SHIFT+F4 |
| D. | None of these |
| Answer» B. CTRL+H | |
| 314. |
In a query\'s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what? |
| A. | The join line but not the relationship between the two tables |
| B. | The relationship between the two tables locally |
| C. | The relationship between the two tables globally |
| D. | The primary key of the first table |
| Answer» C. The relationship between the two tables globally | |
| 315. |
A- Press DOWN ARROW or CTRL+DOWN ARROW , B- Press SHIFT+LEFT ARROW: 1- Move the selected control down, 2- Reduce the width of the selected control. |
| A. | A-1, B-2 |
| B. | A-2, B-2 |
| C. | A-1, B-1 |
| D. | A-2, B-1 |
| Answer» B. A-2, B-2 | |
| 316. |
The ability of a database to grow as the data tracking needs grow is its __________. |
| A. | scalability |
| B. | expandability |
| C. | maintainability |
| D. | platform-independence |
| Answer» B. expandability | |
| 317. |
In Datasheet View, what appears at the top of each column? |
| A. | Data type |
| B. | Description |
| C. | Field name |
| D. | Primary key |
| Answer» D. Primary key | |
| 318. |
Which of the following views displays the field name, description, and properties of a table? |
| A. | Datasheet View |
| B. | Design View |
| C. | Layout View |
| D. | Table View |
| Answer» C. Layout View | |
| 319. |
In Access to increase the width of the selected control |
| A. | SHIFT+RIGHT ARROW |
| B. | SHIFT+DOWN ARROW |
| C. | DOWN ARROW or CTRL+DOWN ARROW |
| D. | None of these |
| Answer» B. SHIFT+DOWN ARROW | |
| 320. |
Which part of the IIF expression is the action performed if the true condition exists? |
| A. | inner |
| B. | first |
| C. | second |
| D. | third |
| Answer» D. third | |
| 321. |
How can you define a field so that when entering data for that field it will display ****** instead of actual typed text |
| A. | Input mask |
| B. | Validation Rule |
| C. | Indexed |
| D. | IME Mode |
| Answer» B. Validation Rule | |
| 322. |
In Access 2007, to set a table to open as a document tab, you need to go to the ____. |
| A. | Microsoft Office button |
| B. | Navigation Pane |
| C. | Quick Access toolbar |
| D. | Database Tools command tab |
| Answer» B. Navigation Pane | |
| 323. |
______ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report. |
| A. | Design View |
| B. | Layout View |
| C. | Print Preview |
| D. | Report View |
| Answer» C. Print Preview | |
| 324. |
In Access press …………………….to Move the selected control to the right (except controls that are part of a layout) |
| A. | CTRL+C |
| B. | CTRL+X |
| C. | CTRL+V |
| D. | None of these |
| Answer» E. | |
| 325. |
Unlike text data type, this can store up to maximum of 65, 535 characters. |
| A. | memo |
| B. | data/time |
| C. | number |
| D. | All of above |
| Answer» B. data/time | |
| 326. |
In Access to switch between the upper andlower portions of a window (Design view of queries, and the Advanced Filter/Sort window) |
| A. | F2 |
| B. | F4 |
| C. | F5 |
| D. | F6 |
| Answer» E. | |
| 327. |
Which of the following best describes the grouped report? |
| A. | A part of report that can be generated by the report wizard |
| B. | A report that displays data that has been sorted in ascending or descending order |
| C. | A report that displays data grouped by fields you specify |
| D. | None of a the above |
| Answer» D. None of a the above | |
| 328. |
What it is called to present information in a particular order based on numeric or alphabetical value? |
| A. | Sorting |
| B. | Searching |
| C. | Arranging |
| D. | Cropping |
| Answer» B. Searching | |
| 329. |
You can display a database object in design view by |
| A. | Opening the database object and clicking the view button on the toolbar |
| B. | Selecting the database object and clicking the design button on the database window |
| C. | Selecting the database object and press Ctrl + V |
| D. | Opening the database object and selecting Tools>Design view |
| Answer» C. Selecting the database object and press Ctrl + V | |
| 330. |
What happens when you add the asterisk (*) from any field list ot a query? |
| A. | The table will not include any fields from the table |
| B. | The query sorts the table’s record in the order you specify |
| C. | The query will include every field from the table |
| D. | The query uses the records from the table without displaying them |
| Answer» D. The query uses the records from the table without displaying them | |
| 331. |
Which is not a view to display a table in Access? |
| A. | Datasheet View |
| B. | Design View |
| C. | Pivot Table & Pivot Chart View |
| D. | None of above |
| Answer» E. | |
| 332. |
Which of the following is the DBMS type |
| A. | Flat File System |
| B. | Hierarchical DBMS |
| C. | Relational DMBS |
| D. | All of the Above |
| Answer» E. | |
| 333. |
In Access press RIGHT ARROW or CTRL+RIGHT ARROW |
| A. | Move the selected control to the right (except controls that are part of a layout) |
| B. | Move the selected control to the left (except controls that are part of a layout) |
| C. | Move the selected control up |
| D. | None of these |
| Answer» B. Move the selected control to the left (except controls that are part of a layout) | |
| 334. |
In a table to insert User\'s Voice, Data field should be |
| A. | OLE Object |
| B. | SoundField |
| C. | VoiceField |
| D. | Memo |
| Answer» B. SoundField | |
| 335. |
Where can you find the undo command in Access? |
| A. | Office button |
| B. | Home command tab |
| C. | Status bar |
| D. | Quick Access toolbar |
| Answer» E. | |
| 336. |
Which of the following queries can create a table? |
| A. | Append |
| B. | Delete |
| C. | Make-Table |
| D. | Update |
| Answer» D. Update | |
| 337. |
(IF [Age]>65, “Senior”,”Adult”) This expression is an example of: |
| A. | A conditional expression |
| B. | Algebraic expression |
| C. | Something that belongs in a Microsoft Excel book |
| D. | A financial expression |
| Answer» B. Algebraic expression | |
| 338. |
Database access levels are specified so as to define who can access what in a database. It is identified through |
| A. | User id |
| B. | Password |
| C. | Status |
| D. | None of above |
| Answer» B. Password | |
| 339. |
__________ is the clear leader for personal databases. |
| A. | Microsoft Access |
| B. | Microsoft FoxPro |
| C. | Borland dBase |
| D. | MySQL |
| Answer» B. Microsoft FoxPro | |
| 340. |
Which of the following statements regarding charts is incorrect? |
| A. | It can be inserted into a form only. |
| B. | It can be designed as a stand-alone object. |
| C. | It can be linked to the object in which it is plac |
| Answer» B. It can be designed as a stand-alone object. | |
| 341. |
Switch from the Visual Basic Editor back to form or report Design view in Access press |
| A. | ALT+F11 |
| B. | SHIFT+F7 |
| C. | A and B both are true |
| D. | None is true |
| Answer» D. None is true | |
| 342. |
To create this, you enter an expression in the design grid that instructs access to perform a calculation using the current field values. |
| A. | Formulated field |
| B. | Numeric field |
| C. | Formula field |
| D. | Calculated field |
| Answer» E. | |
| 343. |
Which of the following statements about a tab control in a form is incorrect? |
| A. | It can contain only one object. |
| B. | It defines a layered space. |
| C. | It is a control object. |
| D. | It is created in multipage forms. |
| Answer» B. It defines a layered space. | |
| 344. |
What field type is used to store picture in a table? |
| A. | Memo |
| B. | OLE |
| C. | Hyperlink |
| D. | None |
| Answer» C. Hyperlink | |
| 345. |
In Access press to Switch from the Visual Basic Editor back to form or report Design view |
| A. | F6 |
| B. | F7 |
| C. | F8 |
| D. | None of these |
| Answer» E. | |
| 346. |
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: Whole Field |
| C. | Match: Start of Field |
| D. | Match: Any Part of Field |
| Answer» D. Match: Any Part of Field | |
| 347. |
To remove all Sorts in a table you can click the ______ command. |
| A. | Clear All Sorts |
| B. | Delete All Sorts |
| C. | Eliminate All Sorts |
| D. | Remove All Sorts |
| Answer» B. Delete All Sorts | |
| 348. |
Database properties do NOT include ___________. |
| A. | title |
| B. | author |
| C. | company |
| D. | size |
| Answer» E. | |
| 349. |
In Access press TAB |
| A. | Move up one line |
| B. | Move up one page |
| C. | Exit the combo box or list box |
| D. | None of these |
| Answer» D. None of these | |
| 350. |
When increasing the Control Padding, space is added where? |
| A. | Between the content of the controls and the outside edge of then controls |
| B. | Between all controls |
| C. | Between the control and the Form\'s edge |
| D. | Between controls and gridlines |
| Answer» C. Between the control and the Form\'s edge | |