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.
| 251. |
According to Access Help, what’s a good way to design a database? |
| A. | Start from data access pages and work backward |
| B. | Sketch the design of your database using a pencil and paper |
| C. | Use the Table Analyzer to reverse- engineer your flat source data. |
| D. | None of above |
| Answer» C. Use the Table Analyzer to reverse- engineer your flat source data. | |
| 252. |
In Access press to Open the Visual Basic Editor from a selected property in the property sheet for a form or report |
| A. | F6 |
| B. | F7 |
| C. | F8 |
| D. | None of these |
| Answer» C. F8 | |
| 253. |
Press the following keys in Access to Save adatabase object |
| A. | CTRL+P |
| B. | P or CTRL+P |
| C. | CTRL+S or SHIFT+F12 |
| D. | F12 |
| Answer» D. F12 | |
| 254. |
The type of query extract the data and put them into separate table |
| A. | A parameter query |
| B. | A make-table query |
| C. | An update query |
| D. | A crosstab query |
| Answer» C. An update query | |
| 255. |
Which of the following term is least related to database? |
| A. | Attributes |
| B. | Tuples |
| C. | Relationship |
| D. | Columns |
| Answer» E. | |
| 256. |
Which of the following is a standard file format language for web documents? |
| A. | HTML |
| B. | XML |
| C. | XSD |
| D. | XSL |
| Answer» B. XML | |
| 257. |
In Access to find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only) |
| A. | CTRL+F |
| B. | CTRL+H |
| C. | SHIFT+F4 |
| D. | None of these |
| Answer» D. None of these | |
| 258. |
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» B. cob | |
| 259. |
When you select this control, its associated text control is also selected and the two controls will act as one when manipulated. |
| A. | Text |
| B. | Form |
| C. | Label |
| D. | Field |
| Answer» C. Label | |
| 260. |
Which of the following type s of queries are action queries? |
| A. | Update queries. |
| B. | Crosstab Queries |
| C. | Parameter queries |
| D. | Append Queries |
| Answer» E. | |
| 261. |
A collection of related records in database is known as a |
| A. | Table |
| B. | Database |
| C. | File |
| D. | None of above |
| Answer» D. None of above | |
| 262. |
In a query, which row do you need to place wildcards to affect a parameter? |
| A. | Arguments |
| B. | Criteria |
| C. | Fields |
| D. | Tables |
| Answer» C. Fields | |
| 263. |
When entering field name, how many characters you can type in maximum? |
| A. | 60 |
| B. | 64 |
| C. | 68 |
| D. | Any number of character |
| Answer» C. 68 | |
| 264. |
Which tool is used to generate printout of a table\'s structure? |
| A. | Analyzer |
| B. | Designer |
| C. | Documenter |
| D. | Generator |
| Answer» D. Generator | |
| 265. |
Which of the following database object can be used if you need to mail the invoice to customers? |
| A. | A form |
| B. | A query |
| C. | A report |
| D. | A table |
| Answer» D. A table | |
| 266. |
To duplicate a controls formatting you can use___ |
| A. | Manager |
| B. | Wizard |
| C. | Painter |
| D. | Control |
| Answer» D. Control | |
| 267. |
Which of the following query type is best suitable to analyze data? |
| A. | Cross tab queries |
| B. | Parameter queries |
| C. | Action queries |
| D. | None of above |
| Answer» B. Parameter queries | |
| 268. |
A search value can be an exact value or it can be |
| A. | Logical Operator |
| B. | Relationship |
| C. | Wild card character |
| D. | Comparison operation |
| Answer» D. Comparison operation | |
| 269. |
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» D. Select fields | |
| 270. |
The following criterion is NOT written using the proper syntax? |
| A. | “Haris” |
| B. | <500 |
| C. | NO VALUE |
| D. | Between #1/1/2000# and #12/31/2000# |
| Answer» D. Between #1/1/2000# and #12/31/2000# | |
| 271. |
Relationships between tables can be graphically viewed in the _______________ window. |
| A. | Design |
| B. | Joins |
| C. | Relationships |
| D. | Tables |
| Answer» D. Tables | |
| 272. |
What is the use of Cascade Delete Option in MS Access? |
| A. | It makes sure that all the records from the parent table and child table is deleted from selected database |
| B. | It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted |
| C. | It makes sure that all the related records will be deleted automatically from Parent table when the records from child table is deleted |
| D. | None of above |
| Answer» C. It makes sure that all the related records will be deleted automatically from Parent table when the records from child table is deleted | |
| 273. |
In Access to switch between Edit mode (with insertion point displaye(D) |
| A. | F2 |
| B. | F4 |
| C. | F5 |
| D. | F6 |
| Answer» B. F4 | |
| 274. |
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» B. Indexes | |
| 275. |
The key uniquely identifies each record in a table. |
| A. | primary key |
| B. | key word |
| C. | filed name |
| D. | All of above |
| Answer» B. key word | |
| 276. |
In Access 2007, to make changes in the Trust Center, 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 | |
| 277. |
Any report, including a basic report, can be modified in __. |
| A. | Form View |
| B. | Layout View |
| C. | Print Preview |
| D. | Report View |
| Answer» C. Print Preview | |
| 278. |
A primary key in any table has the properties |
| A. | Not Null |
| B. | No Duplicates |
| C. | Both of above |
| D. | None of above |
| Answer» D. None of above | |
| 279. |
Which of the following is not a form style available in the form wizard dialog box. |
| A. | Blends |
| B. | Standard |
| C. | Stone |
| D. | Highlights |
| Answer» E. | |
| 280. |
Press the following keys in Access to Open the Save As dialog box |
| A. | CTRL+P |
| B. | P or CTRL+P |
| C. | CTRL+S or SHIFT+F12 |
| D. | F12 |
| Answer» E. | |
| 281. |
Some rules are set in databases to check and permit only correct values. What is this feature called? |
| A. | Data verification |
| B. | Auditing |
| C. | Data filtering |
| D. | Data validation |
| Answer» E. | |
| 282. |
How can you display Pivot Table reportsummary data in a currency format? |
| A. | Use custom calculation |
| B. | Type in the currency symbol |
| C. | Modify the field settings |
| D. | None of the above |
| Answer» D. None of the above | |
| 283. |
Which of the following methods CANNOT be used to copy a block of text from one part of a table to another? |
| A. | Press [Ctrl]+[C] and [Ctrl]+[V]. |
| B. | Right-click, choose from the shortcut menu Copy and Paste. |
| C. | Press [Ctrl]+[+] and [Ctrl]+[-]. |
| D. | From the ribbon, select Copy and Paste. |
| Answer» D. From the ribbon, select Copy and Paste. | |
| 284. |
What type of text box does the toolbox and to a form? |
| A. | Unbound |
| B. | Bound |
| C. | Rebound |
| D. | Calculated |
| Answer» B. Bound | |
| 285. |
The insertion point looks like a(n) ____. |
| A. | H-pointer |
| B. | I-pointer |
| C. | H-beam |
| D. | I-beam |
| Answer» E. | |
| 286. |
Which action will optimize your database performance? |
| A. | Set the record set type to snapshot |
| B. | Use the compact and repair database tool |
| C. | Create a replica of the database |
| D. | All of the above |
| Answer» C. Create a replica of the database | |
| 287. |
The following database object can you import from one Microsoft Access database to another? |
| A. | Queries |
| B. | Tables |
| C. | Forms |
| D. | All of the above |
| Answer» E. | |
| 288. |
The__ button on the tool box display data from a related table |
| A. | Sub form sub report |
| B. | Relationships |
| C. | Select objects |
| D. | More controls |
| Answer» B. Relationships | |
| 289. |
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» D. Validation Rule | |
| 290. |
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» E. | |
| 291. |
How can you display the related records from other tables in datasheet view? |
| A. | Click on the expand indicator next to the record |
| B. | Double click on the record to expand it |
| C. | Apply filter by command to display related records |
| D. | All of above |
| Answer» B. Double click on the record to expand it | |
| 292. |
A small button with three dots usually displayed at the right of field properties box |
| A. | Make button |
| B. | Expression button |
| C. | Build button |
| D. | None of above |
| Answer» D. None of above | |
| 293. |
Which major database object stores all data? |
| A. | Field |
| B. | Query |
| C. | Record |
| D. | Table |
| Answer» E. | |
| 294. |
In Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box |
| A. | F4 or ALT+DOWN ARROW |
| B. | DOWN ARROW |
| C. | PAGE DOWN |
| D. | F9 |
| Answer» E. | |
| 295. |
__________ are documents that when filled in create records. |
| A. | Forms |
| B. | Reports |
| C. | Tables |
| D. | Queries |
| Answer» B. Reports | |
| 296. |
Which action do you use in a a macro to automatically send a report snapshot in an email message? |
| A. | Use mail |
| B. | Send object |
| C. | Run macro |
| D. | All of the above |
| Answer» C. Run macro | |
| 297. |
Which of the following database object is created first before any other created? |
| A. | Table |
| B. | Form |
| C. | Report |
| D. | Query |
| Answer» B. Form | |
| 298. |
How can you display sales grouped by country, region, and salesperson, all at the same time? |
| A. | Use the Sort Descending command. |
| B. | Use the Pivot table view command |
| C. | Use the find command on specified groups |
| D. | All of above |
| Answer» C. Use the find command on specified groups | |
| 299. |
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» D. Validation Rule | |
| 300. |
A ____ often display summary data such as totals or counts. |
| A. | Group Header |
| B. | Group Footer |
| C. | Report Header |
| D. | Page Footer |
| Answer» C. Report Header | |