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.
| 1. |
A ________ is a unit of information in a ________ |
| A. | record, field |
| B. | field, record |
| C. | data source, field |
| D. | record, data source |
| Answer» C. data source, field | |
| 2. |
In a query, using the keyword ______ will return records in which the field value is between two numbers. |
| A. | And |
| B. | Like |
| C. | Is Null |
| D. | Between |
| Answer» E. | |
| 3. |
Which leads you through the process of creating a table? |
| A. | wizard |
| B. | assistant |
| C. | relation |
| D. | coach |
| Answer» B. assistant | |
| 4. |
Which query do you use to answer the question “Which employees earn more than $5000 a month”? |
| A. | Search query |
| B. | Cross tab query |
| C. | Select query |
| D. | Update query |
| Answer» D. Update query | |
| 5. |
Which data type is better to use for storing phone number in the following format “977-1-1234567”? |
| A. | Text |
| B. | AutoNumber |
| C. | Number |
| D. | Currency |
| Answer» B. AutoNumber | |
| 6. |
In an application created using the database wizard, the main menu is presented as a: |
| A. | form, called a switchboard |
| B. | report, called a menu |
| C. | table, called a switchboard |
| D. | query, called a menu |
| Answer» B. report, called a menu | |
| 7. |
Which is the valid data type in Access? |
| A. | Number |
| B. | Text |
| C. | Currency |
| D. | All of the above |
| Answer» E. | |
| 8. |
How to make a date field DOB store the dates like “2002/10/17” ? |
| A. | By setting the input mask property to “yyyy/mm/dd” |
| B. | By setting the format property to “yyyy/mm/dd” |
| C. | By entering dates in yyyy, mm, dd order |
| D. | none of the above |
| Answer» C. By entering dates in yyyy, mm, dd order | |
| 9. |
Which of the following is not an action query? |
| A. | add |
| B. | delete |
| C. | make-table |
| D. | update |
| Answer» B. delete | |
| 10. |
Which tool is used to generate printout of a table’s structure? |
| A. | Analyzer |
| B. | Designer |
| C. | Documenter |
| D. | Generator |
| Answer» D. Generator | |
| 11. |
In databases, Locking level is also called as |
| A. | Granularity |
| B. | S lock |
| C. | X lock |
| D. | Dead lock |
| Answer» B. S lock | |
| 12. |
Validation Rule in a field will |
| A. | Defines the appearance for the text |
| B. | Displays the value in specified format when user leaves the field |
| C. | Checks the value entered when user leaves the field |
| D. | None of the above |
| Answer» D. None of the above | |
| 13. |
Queries can be created in Access by |
| A. | Using Query Wizard |
| B. | Typing Queries in SQL View |
| C. | Drag and Drop fields on Query Builder |
| D. | All of the Above |
| Answer» B. Typing Queries in SQL View | |
| 14. |
What is an intersection of a row and a column? |
| A. | Form |
| B. | Cursor |
| C. | Cell |
| D. | Record |
| Answer» D. Record | |
| 15. |
Which setting you must modify to print a report using letterhead? |
| A. | Group |
| B. | Margin |
| C. | Section |
| D. | Orientation |
| Answer» C. Section | |
| 16. |
Which of the following is the default join between two recordsets ? |
| A. | Inner join |
| B. | Outer join |
| C. | Right outer join |
| D. | None of the above |
| Answer» B. Outer join | |
| 17. |
Which control types is most often associated with a bound control? |
| A. | command button |
| B. | label |
| C. | text box |
| D. | list box |
| Answer» D. list box | |
| 18. |
Data can be import into Access Database from |
| A. | Notepad Files |
| B. | PowerPoint Files |
| C. | Word Files |
| D. | Excel Files |
| Answer» E. | |
| 19. |
Which of the field has width 8 bytes ? |
| A. | Currency |
| B. | Memo |
| C. | Hyperlink |
| D. | Date/Time |
| Answer» E. | |
| 20. |
Which of the following is a/are view/views to display a table in Access ? |
| A. | Datasheet View |
| B. | Design View |
| C. | Both a and b |
| D. | None of the above |
| Answer» D. None of the above | |
| 21. |
The size of a field with Number data type can not be |
| A. | 2 |
| B. | 4 |
| C. | 8 |
| D. | 16 |
| Answer» E. | |
| 22. |
The Command Center Of Access File That Appears When You Create Or Open The Ms Access Database File. |
| A. | Database Window |
| B. | Query Window |
| C. | Design View Window |
| D. | Switchboard |
| Answer» B. Query Window | |
| 23. |
What Are The Columns In A Microsoft Access Table Called? |
| A. | Rows |
| B. | Records |
| C. | Fields |
| D. | Columns |
| Answer» D. Columns | |
| 24. |
Which of the following is not a database object ? |
| A. | Form |
| B. | Tables |
| C. | Reports |
| D. | Relationships |
| Answer» E. | |
| 25. |
It Is An Association Established Between Common |
| A. | Line |
| B. | Relationship |
| C. | Primary Key |
| D. | Records |
| Answer» C. Primary Key | |
| 26. |
What Is The Maximum Length A Text Field Can Be? |
| A. | 120 |
| B. | 255 |
| C. | 265 |
| D. | 75 |
| Answer» C. 265 | |
| 27. |
Which Of The Following Creates A Drop Down List Of Values To Choose From? |
| A. | Ole Object |
| B. | Hyperlink |
| C. | Memo |
| D. | Lookup Wizard |
| Answer» E. | |
| 28. |
The complete information about an entity in a database is called |
| A. | Field |
| B. | Record |
| C. | Information |
| D. | All of the above |
| Answer» C. Information | |
| 29. |
MS-Access is used to develop a? |
| A. | Database design |
| B. | XLS file |
| C. | TXT file |
| D. | None of these |
| Answer» B. XLS file | |
| 30. |
A database can be best described as |
| A. | Useful presentation of data |
| B. | Organized collection of data |
| C. | Graphical representation of data |
| D. | None of the above |
| Answer» C. Graphical representation of data | |
| 31. |
Which of the following store command to retrieve data from database ? |
| A. | Queries |
| B. | Forms |
| C. | Record |
| D. | Reports |
| Answer» B. Forms | |
| 32. |
The appropriate Data Type to store Time in MS Access? |
| A. | Date/Time |
| B. | Time Only |
| C. | Time |
| D. | Time cannot be stored |
| Answer» B. Time Only | |
| 33. |
Which type of field is incremented automatically? |
| A. | Auto Elevate |
| B. | AutoNumber |
| C. | Auto Increment |
| D. | Auto Value |
| Answer» C. Auto Increment | |
| 34. |
Which of the following is not a database application? |
| A. | dBase |
| B. | Flash |
| C. | FoxPro |
| D. | Access |
| Answer» C. FoxPro | |
| 35. |
Which do you click to display the table’s primary key and indexes in a separate window? |
| A. | indexes button |
| B. | primary key button |
| C. | view datasheet button |
| D. | view design button |
| Answer» B. primary key button | |
| 36. |
What is the maximum length a text field can be ? |
| A. | 255 |
| B. | 256 |
| C. | 257 |
| D. | 355 |
| Answer» B. 256 | |
| 37. |
Which of the following is not a legitimate section for form objects? |
| A. | Form detail |
| B. | Group header |
| C. | Form header |
| D. | Page footer |
| Answer» C. Form header | |
| 38. |
Which criteria do not return the position “Officer” as a match? |
| A. | position = “*ff*” |
| B. | position = “O??icer” |
| C. | position = “ ?ff*” |
| D. | position = “O#r” |
| Answer» E. | |
| 39. |
In a datasheet, what does each row represent? |
| A. | Record |
| B. | Field |
| C. | Database |
| D. | Table |
| Answer» B. Field | |
| 40. |
Which function can not be used for calculated controls in a report? |
| A. | SUM |
| B. | AVG |
| C. | MPT |
| D. | COUNT |
| Answer» D. COUNT | |
| 41. |
MS-Access is a component of? |
| A. | Microsoft Office |
| B. | Windows XP |
| C. | Windows |
| D. | None of these |
| Answer» B. Windows XP | |
| 42. |
DCL Provides Commands To Perform Actions Like |
| A. | Change The Structure Of Tables |
| B. | Insert, Update Or Delete Records And Data Values |
| C. | Authorizing Access And Other Control Over Database |
| D. | None Of Above |
| Answer» D. None Of Above | |
| 43. |
How many relations may exist between tables in databases? |
| A. | 4 |
| B. | 3 |
| C. | 2 |
| D. | 1 |
| Answer» C. 2 | |
| 44. |
Which key is used to join the two table in MS-Access? |
| A. | Primary key |
| B. | Special key |
| C. | Foreign key |
| D. | None of these |
| Answer» D. None of these | |
| 45. |
What Are The Different Views To Display A Table |
| A. | Datasheet View |
| B. | Design View |
| C. | Pivote Table and Pivot Chart View |
| D. | All of the above |
| Answer» E. | |
| 46. |
The report footer section is most useful for displaying: |
| A. | grand totals |
| B. | Column headings |
| C. | subtotals |
| D. | page numbers |
| Answer» B. Column headings | |
| 47. |
Which of the following database object hold data ? |
| A. | Reports |
| B. | Tables |
| C. | Forms |
| D. | All of the above |
| Answer» C. Forms | |
| 48. |
What is the full form of SQL ? |
| A. | Structured Query Language |
| B. | Structured Question List |
| C. | Sophisticated Question List |
| D. | None of the above |
| Answer» B. Structured Question List | |
| 49. |
In MS Access “Lookup Wizard” is used to |
| A. | to select value from another table |
| B. | to select values from Excel Sheet |
| C. | to select from previous values |
| D. | None of the above |
| Answer» B. to select values from Excel Sheet | |
| 50. |
The basic elements of a form or a report are called: |
| A. | Windows |
| B. | Controls |
| C. | Objects |
| D. | Table |
| Answer» C. Objects | |