McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: MCQ on Computer Softwares , Common Topics in Competitive and Entrance exams , Microsoft Office .
| 301. |
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» A. Microsoft Office button | |
| 302. |
Which of the following is the file extension for an Extensible Markup Language? |
| A. | EML |
| B. | HTML |
| C. | XML |
| D. | XSD |
| Answer» C. XML | |
| 303. |
A(n) __________ is an Extensible Scheme Standard file that is an approved W3C standard design as a basic infrastructure. |
| A. | HTML |
| B. | XML |
| C. | XSD |
| D. | XSL |
| Answer» C. XSD | |
| 304. |
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» D. text | |
| 305. |
A(n) _____ is an image control that displays in the background of a page on a form or report. |
| A. | legend |
| B. | icon |
| C. | logo |
| D. | watermark |
| Answer» D. watermark | |
| 306. |
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» B. Red, Green, Blue | |
| 307. |
If a color property contains "#336699", how many blue units are in the color? |
| A. | 33 |
| B. | 66 |
| C. | 99 |
| D. | 255 |
| Answer» C. 99 | |
| 308. |
The _____ function returns a string that has been converted to uppercase text. |
| A. | AllCap |
| B. | UCase |
| C. | UpCase |
| D. | Upper |
| Answer» B. UCase | |
| 309. |
Which part of the IIF expression is the action performed if the true condition exists? |
| A. | inner |
| B. | first |
| C. | second |
| D. | third |
| Answer» C. second | |
| 310. |
If you need a calculation in an unbound control, you can create a custom _____. |
| A. | string |
| B. | expression |
| C. | relationship |
| D. | syntax |
| Answer» B. expression | |
| 311. |
The _____ Builder is an Access tool for selecting colors from a palette or creating custom colors. |
| A. | Color |
| B. | Expression |
| C. | Palette |
| D. | Property |
| Answer» A. Color | |
| 312. |
Which function evaluates a "true/false" expression and then performs one of two actions? |
| A. | Case |
| B. | IF |
| C. | IIF |
| D. | IsTrue |
| Answer» C. IIF | |
| 313. |
When adding an image, which size mode will change the height or width of the image fit the control? |
| A. | Clip |
| B. | Stretch |
| C. | Zoom |
| D. | Crop |
| Answer» B. Stretch | |
| 314. |
The three parts of an IIF function are separated by _____. |
| A. | dashes |
| B. | asterisks |
| C. | semicolons |
| D. | commas |
| Answer» D. commas | |
| 315. |
A Smart Tag can be set using the _____ tab in the property sheet. |
| A. | Format |
| B. | Tag |
| C. | View |
| D. | Data |
| Answer» D. Data | |
| 316. |
A(n) _____ is a control that, when clicked, executes an action or series of actions. |
| A. | combo box control |
| B. | AutoFormat |
| C. | Conditional Format |
| D. | command button |
| Answer» D. command button | |
| 317. |
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» A. txt | |
| 318. |
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» D. By clicking the Build button of the Control Source property in the Data tab | |
| 319. |
According to the Leszynski Naming Conventions, which of the following is the prefix for a combo box control? |
| A. | cbo |
| B. | cob |
| C. | cmb |
| D. | cbx |
| Answer» A. cbo | |
| 320. |
You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section? |
| A. | Detail |
| B. | Form Footer |
| C. | Form Header |
| D. | Page Header |
| Answer» C. Form Header | |
| 321. |
The Allow _____ property controls whether new records can be added through the form. |
| A. | Additions |
| B. | Edits |
| C. | Deletions |
| D. | Data Entry |
| Answer» A. Additions | |
| 322. |
The _____ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar. |
| A. | Date |
| B. | Time |
| C. | Calendar |
| D. | Appointment |
| Answer» A. Date | |
| 323. |
The _____ Symbol Smart Tag launches Microsoft Explorer and obtains a stock quote. |
| A. | MSN Money |
| B. | Portfolio |
| C. | Financial |
| D. | Stock |
| Answer» C. Financial | |
| 324. |
Which of the following is NOT true about background images? |
| A. | They are similar to watermarks in Word. |
| B. | They are displayed behind the controls in a form. |
| C. | They do not print when a form or a report is print |
| Answer» C. They do not print when a form or a report is print | |
| 325. |
In a query, what symbol is used to surround a parameter\'s user prompt? |
| A. | [ ] |
| B. | { } |
| C. | " " |
| D. | ( ) |
| Answer» A. [ ] | |
| 326. |
A(n) _______________ query locates data from one or more tables. |
| A. | select |
| B. | summary |
| C. | parameter |
| D. | action |
| Answer» A. select | |
| 327. |
Which function extracts the name of the month from a date/time value? |
| A. | Month |
| B. | MonthName |
| C. | MonthLabel |
| D. | MonthValue |
| Answer» B. MonthName | |
| 328. |
Which of the following queries prompts users for input data by displaying dialog boxes? |
| A. | Append |
| B. | Delete |
| C. | Parameter |
| D. | Update |
| Answer» C. Parameter | |
| 329. |
A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation. |
| A. | select |
| B. | summary |
| C. | parameter |
| D. | action |
| Answer» D. action | |
| 330. |
Which of the following queries modifies fields not records? |
| A. | Append |
| B. | Delete |
| C. | Make-Table |
| D. | Update |
| Answer» D. Update | |
| 331. |
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» D. Total | |
| 332. |
Which of the following functions is used to all the values in a numeric field? |
| A. | Num |
| B. | Count |
| C. | Sum |
| D. | Total |
| Answer» B. Count | |
| 333. |
Which of the following queries can create a table? |
| A. | Append |
| B. | Delete |
| C. | Make-Table |
| D. | Update |
| Answer» C. Make-Table | |
| 334. |
In a query, which row do you need to place wildcards to affect a parameter? |
| A. | Arguments |
| B. | Criteria |
| C. | Fields |
| D. | Tables |
| Answer» B. Criteria | |
| 335. |
You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have? |
| A. | 5 |
| B. | 8 |
| C. | 24 |
| D. | Not enough information to tell |
| Answer» C. 24 | |
| 336. |
Which of the following types of joins displays records with the same value in the common field? |
| A. | Inner join |
| B. | Left outer join |
| C. | Right outer join |
| D. | Self join |
| Answer» A. Inner join | |
| 337. |
A global join will be created automatically when using tables in a(n) _____. |
| A. | form |
| B. | report |
| C. | query |
| D. | field |
| Answer» B. report | |
| 338. |
Which of the following is the default join between two recordsets? |
| A. | Inner join |
| B. | Left outer join |
| C. | Right outer join |
| D. | Self join |
| Answer» A. Inner join | |
| 339. |
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» B. The relationship between the two tables locally | |
| 340. |
What is an index? |
| A. | A wizard that creates a functional database structure based on the user\'s selections |
| B. | A widely recognized naming convention for database objects |
| C. | A sort order for records, which is identified in the table design |
| D. | A set of relationship rules that enforce defined database relationships |
| Answer» C. A sort order for records, which is identified in the table design | |
| 341. |
You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records? |
| A. | 7 |
| B. | 17 |
| C. | 60 |
| D. | Not enough information to tell |
| Answer» C. 60 | |
| 342. |
Which of the following dialog boxes enables users to enforce referential integrity in a One-To-Many relationship? |
| A. | Edit Relationships |
| B. | Indexes |
| C. | Option |
| D. | Show Table |
| Answer» A. Edit Relationships | |
| 343. |
In a junction table, the _____ field consists of the foreign key from both the linked tables. |
| A. | first defined |
| B. | last defined |
| C. | foreign key |
| D. | primary key |
| Answer» C. foreign key | |
| 344. |
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» C. Records that have the same value in the common field | |
| 345. |
The page count of a report can be determined by clicking the _______ button. |
| A. | First Page |
| B. | Previous |
| C. | Next |
| D. | Last Page |
| Answer» D. Last Page | |
| 346. |
When you add fields in ____, a Field List pane displays. |
| A. | Design View |
| B. | Layout View |
| C. | Print Preview |
| D. | Report View |
| Answer» B. Layout View | |
| 347. |
Any report, including a basic report, can be modified in __. |
| A. | Form View |
| B. | Layout View |
| C. | Print Preview |
| D. | Report View |
| Answer» B. Layout View | |
| 348. |
A ____ often display summary data such as totals or counts. |
| A. | Group Header |
| B. | Group Footer |
| C. | Report Header |
| D. | Page Footer |
| Answer» B. Group Footer | |
| 349. |
Which of the following can a Report Wizard NOT do? |
| A. | Add summary functions |
| B. | Create groups |
| C. | Group fields into more than one Control Layout |
| D. | Select fields |
| Answer» C. Group fields into more than one Control Layout | |
| 350. |
______ 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» B. Layout View | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.