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.
| 1. |
Macros can recover from _______ in a controlled manner. |
| A. | events |
| B. | modules |
| C. | arguments |
| D. | errors |
| Answer» B. modules | |
| 2. |
In a module, the VB Name used to display a warning query icon is _______. |
| A. | vbCritical |
| B. | vbInformation |
| C. | vbExclamation |
| D. | vbQuestion |
| Answer» E. | |
| 3. |
By default, what is the name of a new module in the Modules folder of the Project pane called? |
| A. | Bas1 |
| B. | Module |
| C. | New Module |
| D. | Module1 |
| Answer» E. | |
| 4. |
Which of the following statements about option group is incorrect? |
| A. | It is a control object. |
| B. | It is bound to two fields. |
| C. | It is a control to identify a choice. |
| D. | It contains a set of controls representing choices. |
| Answer» C. It is a control to identify a choice. | |
| 5. |
In the form wizard dialog box, the fields from the selected table are displayed in this list box. |
| A. | All fields |
| B. | All records |
| C. | Available records |
| D. | Available fields |
| Answer» E. | |
| 6. |
Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database. |
| A. | queries |
| B. | fields |
| C. | records |
| D. | tables |
| Answer» E. | |
| 7. |
You can keep the sum([Sales]) to calculate the totals for each month in |
| A. | the report footer section |
| B. | the page footer section |
| C. | the month group footer section |
| D. | the summary section |
| Answer» D. the summary section | |
| 8. |
You view the properties of a form |
| A. | Select View>Form properties form the menu |
| B. | Right click anywhere on the form and select properties from the shortcut menu |
| C. | Double click the form selector box in the upper left corner of the form |
| D. | All of the above |
| Answer» C. Double click the form selector box in the upper left corner of the form | |
| 9. |
In Access press to Move to the previous page of the wizard |
| A. | TAB |
| B. | ALT+N |
| C. | ALT+B |
| D. | ALT+F |
| Answer» D. ALT+F | |
| 10. |
What is the difference between ‘Open’ and ‘Open Exclusively’? |
| A. | Open statement opens access database files and Open Exclusively opens database files of other program like Oracle |
| B. | Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed |
| C. | Both Open and Open Exclusively are same |
| D. | Open Exclusive command does not exist in MS Access |
| Answer» C. Both Open and Open Exclusively are same | |
| 11. |
A summary query can be created by adding which row to the design grid of a select query? |
| A. | Arguments |
| B. | Group |
| C. | Summary |
| D. | Total |
| Answer» E. | |
| 12. |
The page count of a report can be determined by clicking the _______ button. |
| A. | First Page |
| B. | Previous |
| C. | Next |
| D. | Last Page |
| Answer» E. | |
| 13. |
According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control? |
| A. | txt |
| B. | txb |
| C. | tbc |
| D. | tex |
| Answer» B. txb | |
| 14. |
A(n) _______ is major object that completes an action or a set of actions. |
| A. | event |
| B. | property |
| C. | procedure |
| D. | macro |
| Answer» E. | |
| 15. |
The option group ____ describes the contents of the entire option group. |
| A. | event |
| B. | frame |
| C. | label |
| D. | value |
| Answer» D. value | |
| 16. |
In access, this view is used to create and modify the structure of a form. |
| A. | Normal |
| B. | Datasheet |
| C. | Form design |
| D. | Control |
| Answer» D. Control | |
| 17. |
A ____ is a major database object used to display information in a printable page format. |
| A. | form |
| B. | query |
| C. | report |
| D. | table |
| Answer» D. table | |
| 18. |
If a color property contains "#336699", how many blue units are in the color? |
| A. | 33 |
| B. | 66 |
| C. | 99 |
| D. | 255 |
| Answer» D. 255 | |
| 19. |
In the Relationship window, related fields from each table are connected by a(n) _______________. |
| A. | default field |
| B. | linking tables |
| C. | index |
| D. | join line |
| Answer» E. | |
| 20. |
what is the corresponding text for the <#1/1/95# validation rule setting? |
| A. | Neter a value less or more than 1,195 |
| B. | Value must be less than 95 characters |
| C. | Enter a date before 1995 |
| D. | All of above |
| Answer» B. Value must be less than 95 characters | |
| 21. |
While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into |
| A. | a doctor’s sign |
| B. | thin + sign |
| C. | outline rectangle |
| D. | None of above |
| Answer» D. None of above | |
| 22. |
SQL stands for __________. |
| A. | Standard Query Language |
| B. | Structured Query Language |
| C. | Simplified Query Language |
| D. | Static Query Language |
| Answer» C. Simplified Query Language | |
| 23. |
A __ name must be unique within a database |
| A. | Table |
| B. | Field |
| C. | Record |
| D. | Character |
| Answer» B. Field | |
| 24. |
How can a user open the Expression Builder dialog box? |
| A. | By clicking the drop-down arrow on the Control Source property |
| B. | By clicking the drop-down arrow of the Input Mask property in the Data tab |
| C. | By clicking the Build button of the Input Mask in the Data tab |
| D. | By clicking the Build button of the Control Source property in the Data tab |
| Answer» E. | |
| 25. |
In a query, using the keyword _______________ will return records in which the field value is between two numbers. |
| A. | Between |
| B. | Is Null |
| C. | Like |
| D. | Not |
| Answer» B. Is Null | |
| 26. |
What does an inner join display? |
| A. | Records from the second recordset and only records from the first recordset where the common fields are equal |
| B. | Records from the first recordset and only records from the second recordset where the common fields are equal |
| C. | Records that have the same value in the common field |
| D. | Records from the first recordset only |
| Answer» D. Records from the first recordset only | |
| 27. |
To enter the input mask wizard |
| A. | Click on the three dots to the right of the caption entry field |
| B. | Click on the three dots to the right of the format entry field |
| C. | Click on the input mask toolbar |
| D. | Click on the three dots to the right of the input mask entry field |
| Answer» E. | |
| 28. |
The ______ is a wild card that represents one or more characters. |
| A. | question mark |
| B. | asterisk |
| C. | exclamation mark |
| D. | dollar sign |
| Answer» C. exclamation mark | |
| 29. |
In access, this operation copies a backup file from the storage medium back onto the computer |
| A. | Recreate |
| B. | Restore |
| C. | Copy |
| D. | Structure |
| Answer» C. Copy | |
| 30. |
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 | |
| 31. |
A DBMS that runs on many different operating systems is said to be __________. |
| A. | scalable |
| B. | robust |
| C. | platform independent |
| D. | distributed |
| Answer» D. distributed | |
| 32. |
Both conditions display on the same row in the design grid when ___operator is in use |
| A. | OR |
| B. | IN |
| C. | AND |
| D. | LIKE |
| Answer» D. LIKE | |
| 33. |
Collection of related records in a database is known as |
| A. | File |
| B. | Bench |
| C. | Table |
| D. | Relationship |
| Answer» D. Relationship | |
| 34. |
In Access press to Complete the wizard |
| A. | TAB |
| B. | ALT+N |
| C. | ALT+B |
| D. | ALT+F |
| Answer» E. | |
| 35. |
In Access press ALT+F4 to |
| A. | Open a new database |
| B. | Open an existing database |
| C. | Exit Office Access 2007Access |
| D. | None of these |
| Answer» D. None of these | |
| 36. |
If you need a calculation in an unbound control, you can create a custom _____. |
| A. | string |
| B. | expression |
| C. | relationship |
| D. | syntax |
| Answer» C. relationship | |
| 37. |
To store your picture in a database requires a(n) __________ field. |
| A. | BLOB |
| B. | text |
| C. | image |
| D. | logical |
| Answer» B. text | |
| 38. |
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. | |
| 39. |
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 displayed in query result or not |
| C. | It indicates whether the field names to be displayed in query result or not |
| D. | None of above |
| Answer» C. It indicates whether the field names to be displayed in query result or not | |
| 40. |
A database object in MS Access that stores a question about the data in database? |
| A. | Table |
| B. | Form |
| C. | Query |
| D. | Report |
| Answer» D. Report | |
| 41. |
Which of the following queries prompts users for input data by displaying dialog boxes? |
| A. | Append |
| B. | Delete |
| C. | Parameter |
| D. | Update |
| Answer» D. Update | |
| 42. |
Which of the following data types automatically generates a consecutive number? |
| A. | Autonumber |
| B. | Memo |
| C. | Number |
| D. | Text |
| Answer» B. Memo | |
| 43. |
A report module includes code for all event _______ triggered by events occurring on a specific report or its controls. |
| A. | properties |
| B. | procedures |
| C. | macros |
| D. | commands |
| Answer» C. macros | |
| 44. |
Which of the following properties identifies the type of information stored in a field? |
| A. | Data type |
| B. | Field description |
| C. | Field name |
| D. | Field properties |
| Answer» B. Field description | |
| 45. |
Which of the following views is used to graphically summarize and analyze data in a recordset? |
| A. | Datasheet |
| B. | Form |
| C. | PivotChart |
| D. | PivotTable |
| Answer» D. PivotTable | |
| 46. |
In Access press CTRL+F6 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» C. Restore the selected minimized window when all windows are minimized | |
| 47. |
In Access press CTRL+O to |
| A. | Open a new database |
| B. | Open an existing database |
| C. | Exit Office Access 2007Access |
| D. | None of these |
| Answer» C. Exit Office Access 2007Access | |
| 48. |
What type of control in a form can display data from database table? |
| A. | Bound control |
| B. | Unbound control |
| C. | Both of above |
| D. | None of above |
| Answer» B. Unbound control | |
| 49. |
What method can you use to add a new table to your database? |
| A. | Use Design View to create a table |
| B. | Enter data directly by using a datasheet |
| C. | Both of above |
| D. | All of the above |
| Answer» D. All of the above | |
| 50. |
If you are creating a cross tab query, what must table you are querying contain? |
| A. | Lots of confusing information |
| B. | More than 100 records |
| C. | At least one field |
| D. | None of the above |
| Answer» D. None of the above | |