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 .
| 351. |
Which report section prints once at the bottom of every printed page? |
| A. | Detail |
| B. | Page Header |
| C. | Page Footer |
| D. | Report Header |
| Answer» C. Page Footer | |
| 352. |
Which report section only prints one time at the end of the report? |
| A. | Report Header |
| B. | Page Header |
| C. | Report Footer |
| D. | Page Footer |
| Answer» C. Report Footer | |
| 353. |
Which of the following database objects can have more than one Group Header/Footer section? |
| A. | Forms |
| B. | Queries |
| C. | Reports |
| D. | Tables |
| Answer» C. Reports | |
| 354. |
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» A. Adding groups can help organize the labels. | |
| 355. |
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» B. Design | |
| 356. |
To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used? |
| A. | Datasheet |
| B. | Justified |
| C. | Stacked |
| D. | Tabular |
| Answer» D. Tabular | |
| 357. |
Which Form tool creates a new form that show both a form and datasheet views? |
| A. | Form |
| B. | Form Wizard |
| C. | Multiple Item Form |
| D. | Split Form |
| Answer» D. Split Form | |
| 358. |
Which of the following statements about tab order setting is NOT true? |
| A. | The actual tab order setting for a form can be used in the Form View. |
| B. | The tab order setting determines the movement of the insertion point through a form. |
| C. | The tab order setting is usually right-to-left and top-to-bottom. |
| D. | The default tab order setting can be altered by moving the controls in the Design View. |
| Answer» C. The tab order setting is usually right-to-left and top-to-bottom. | |
| 359. |
What type of controls are text boxes when data from the recordset is visible? |
| A. | Align |
| B. | Bound |
| C. | Calculated |
| D. | Unbound |
| Answer» B. Bound | |
| 360. |
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» B. Between all controls | |
| 361. |
Which of the following is NOT possible when printing Forms? |
| A. | Print page 1, 3, and 5 |
| B. | Print pages 1 through 5 |
| C. | Print selected records |
| D. | Print only the third record |
| Answer» A. Print page 1, 3, and 5 | |
| 362. |
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» A. Form Selector | |
| 363. |
Which is NOT an option of the Picture Size Mode property? |
| A. | Clip |
| B. | Fit |
| C. | Stretch |
| D. | Zoom |
| Answer» B. Fit | |
| 364. |
Which mode sizes an image to fit the control while maintaining the proportions of the original image? |
| A. | Clip |
| B. | Fit |
| C. | Stretch |
| D. | Zoom |
| Answer» D. Zoom | |
| 365. |
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» C. PivotChart | |
| 366. |
Which of the following statements about criteria in a query is NOT true? |
| A. | Criteria can contain wildcard characters. |
| B. | Criteria in a query selects or excludes certain records. |
| C. | Criteria cannot be specified as an expression. |
| D. | Multiple criteria can be specified using AND, OR, and relational operators. |
| Answer» C. Criteria cannot be specified as an expression. | |
| 367. |
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» A. The Top Values property displays only the highest values from the query. | |
| 368. |
Which of the following statements about calculated fields is NOT true? |
| A. | A calculated field does not store data in a recordset. |
| B. | Calculated fields use an expression or formula as its data source. |
| C. | Data contained in a calculated field is created the first time a query is run. |
| D. | A calculated field can be created using the Expression Builder dialog box. |
| Answer» C. Data contained in a calculated field is created the first time a query is run. | |
| 369. |
Using the keyword _______________ will return records in which the field value equals a defined text. |
| A. | Between |
| B. | Is Null |
| C. | Like |
| D. | Not |
| Answer» C. Like | |
| 370. |
What is the process of eliminating redundant fields by separating data into tables called? |
| A. | Renormalizations |
| B. | Filtering |
| C. | Normalization |
| D. | Sorting |
| Answer» C. Normalization | |
| 371. |
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» D. It displays the same information as a crosstab query, except for the counts and sums of numeric fields. | |
| 372. |
Which of the following search criteria is invalid? |
| A. | $45* |
| B. | *cal* |
| C. | D*m?? |
| D. | AS150* |
| Answer» A. $45* | |
| 373. |
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» A. Between | |
| 374. |
Which of the following database objects extracts information from one or more tables or queries? |
| A. | Forms |
| B. | Queries |
| C. | Reports |
| D. | Tables |
| Answer» B. Queries | |
| 375. |
Referential integrity cannot be set for _______________ relationships. |
| A. | One-To-One |
| B. | Indeterminate |
| C. | One-To-Many |
| D. | Many-To-Many |
| Answer» B. Indeterminate | |
| 376. |
A relationship is created between how many tables? |
| A. | One |
| B. | Two |
| C. | Three |
| D. | Any number |
| Answer» B. Two | |
| 377. |
The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet. |
| A. | primary, foreign |
| B. | primary, common |
| C. | foreign, primary |
| D. | foreign, common |
| Answer» A. primary, foreign | |
| 378. |
Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database. |
| A. | queries |
| B. | fields |
| C. | records |
| D. | tables |
| Answer» D. tables | |
| 379. |
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» D. join line | |
| 380. |
Relationships between tables can be graphically viewed in the _______________ window. |
| A. | Design |
| B. | Joins |
| C. | Relationships |
| D. | Tables |
| Answer» C. Relationships | |
| 381. |
A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field? |
| A. | 1 |
| B. | ? |
| C. | r |
| D. | None |
| Answer» D. None | |
| 382. |
In the Field List of a table, the primary key appears _______________. |
| A. | bold |
| B. | italicized |
| C. | underlined |
| D. | with key icon |
| Answer» D. with key icon | |
| 383. |
What type of relationship is created when you select a primary key in both related tables? |
| A. | One-To-One |
| B. | Indeterminate |
| C. | One-To-Many |
| D. | Many-To-Many |
| Answer» A. One-To-One | |
| 384. |
The Table _______________ Wizard analyzes a database and recommends changes for normalization. |
| A. | Analyzer |
| B. | Documenter |
| C. | Cleanup |
| D. | Normalization |
| Answer» A. Analyzer | |
| 385. |
The Input Mask wizard does NOT include the ability to do which of the following? |
| A. | Force all uppercase |
| B. | Define placeholder |
| C. | Store symbols with data |
| D. | Use preset masks |
| Answer» A. Force all uppercase | |
| 386. |
Which of the following field properties enforces the use of parentheses when keying an area code? |
| A. | Field Size |
| B. | Format |
| C. | Input Mask |
| D. | Validation Rule |
| Answer» C. Input Mask | |
| 387. |
Which of the following field properties is an expression that specifies criteria or requirements for entering data? |
| A. | Field Size |
| B. | Format |
| C. | Input Mask |
| D. | Validation Rule |
| Answer» D. Validation Rule | |
| 388. |
In Datasheet View, what appears at the top of each column? |
| A. | Data type |
| B. | Description |
| C. | Field name |
| D. | Primary key |
| Answer» C. Field name | |
| 389. |
Which is NOT a method of creating a table? |
| A. | Datasheet View |
| B. | Design View |
| C. | Layout View |
| D. | Template |
| Answer» C. Layout View | |
| 390. |
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» B. Design View | |
| 391. |
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» A. Data type | |
| 392. |
Which of the following field properties displays a model or pattern for entering data? |
| A. | Field Size |
| B. | Format |
| C. | Input Mask |
| D. | Validation Rule |
| Answer» C. Input Mask | |
| 393. |
Which of the following data types automatically generates a consecutive number? |
| A. | Autonumber |
| B. | Memo |
| C. | Number |
| D. | Text |
| Answer» A. Autonumber | |
| 394. |
Database properties do NOT include ___________. |
| A. | title |
| B. | author |
| C. | company |
| D. | size |
| Answer» D. size | |
| 395. |
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» A. Clear All Sorts | |
| 396. |
A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field. |
| A. | format row |
| B. | criteria row |
| C. | aggregate function |
| D. | format layout |
| Answer» C. aggregate function | |
| 397. |
The content and application of the Search tool CANNOT be retained when you ______. |
| A. | format an object |
| B. | resize a column |
| C. | use Datasheet View |
| D. | close an object |
| Answer» D. close an object | |
| 398. |
The Search tool CANNOT be used on which major Access object? |
| A. | Forms |
| B. | Queries |
| C. | Reports |
| D. | Tables |
| Answer» C. Reports | |
| 399. |
In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful. |
| A. | formula |
| B. | format |
| C. | layout |
| D. | record |
| Answer» D. record | |
| 400. |
The ______ is a wild card that represents one or more characters. |
| A. | question mark |
| B. | asterisk |
| C. | exclamation mark |
| D. | dollar sign |
| Answer» B. asterisk | |
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.