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 .
251. |
The appropriate Data Type to store Time in MS Access? |
A. | Date/Time |
B. | Time Only |
C. | Time |
D. | Time cannot be stored |
Answer» A. Date/Time |
252. |
In MS Access "Lookup Wizard" is used to |
A. | to select from previous values |
B. | to select values from Excel Sheet |
C. | to select value from another table |
D. | Not a valid Data Type |
Answer» C. to select value from another table |
253. |
Which of the following Data Type is used to store picture in MS Access |
A. | Picture |
B. | OLE Object |
C. | Memo |
D. | Picture cannot be stored |
Answer» B. OLE Object |
254. |
in MS Access, which data type is appropriate to store large text and numbers? |
A. | Text |
B. | Memo |
C. | OLE |
D. | Large Text |
Answer» B. Memo |
255. |
in MS Access, OLE Object Data type can store |
A. | Microsoft Word documents |
B. | Microsoft Excel spreadsheets |
C. | Sounds |
D. | All of the Above |
Answer» D. All of the Above |
256. |
in MS Access, AutoNumber Data Type |
A. | Can be Sequential |
B. | Can be Random |
C. | Can be Edited |
D. | Only A & B |
Answer» D. Only A & B |
257. |
Which of the following is use to get data from user? |
A. | Query |
B. | Pages |
C. | Form |
D. | Report |
Answer» C. Form |
258. |
Which of the following is invalid field name? |
A. | Student.Address |
B. | Student\'sAddress |
C. | Student_Address |
D. | Student Address |
Answer» A. Student.Address |
259. |
Primary key is |
A. | Uniquely identifies each record |
B. | Cannot be repeated |
C. | AutoNumber is example of Primary key |
D. | All of the above |
Answer» D. All of the above |
260. |
To create a table in Access |
A. | Database should be created before create table |
B. | Table can be created using Table Templates |
C. | There must be at least one Primary key in a table |
D. | All of the above |
Answer» D. All of the above |
261. |
Which of the following is use to view or print the data in organized manner? |
A. | Query |
B. | Report |
C. | Table |
D. | Form |
Answer» B. Report |
262. |
In a table to insert User\'s Voice, Data field should be |
A. | OLE Object |
B. | SoundField |
C. | VoiceField |
D. | Memo |
Answer» A. OLE Object |
263. |
After creating the table which of the following is correct? |
A. | Fields cannot be added |
B. | Fields cannot be deleted |
C. | Fields can added but only once |
D. | Fields can added and deleted as needed |
Answer» D. Fields can added and deleted as needed |
264. |
Validation Rule in a field will |
A. | Checks the value entered when user leaves the field |
B. | Displays the value in specified format when user leaves the field |
C. | Defines the appearance for the text |
D. | There is no option of Validation Rule |
Answer» A. Checks the value entered when user leaves the field |
265. |
Query can be use to select data from |
A. | Single Table |
B. | Multiple Tables |
C. | Both A & B |
D. | None of above |
Answer» C. Both A & B |
266. |
Data can be import into Access Database from |
A. | Word Files |
B. | Excel Files |
C. | PowerPoint Files |
D. | HTML Files |
Answer» B. Excel Files |
267. |
What is the use of Referential Integrity in MS Access? |
A. | It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table |
B. | It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table |
C. | It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table |
D. | None of above |
Answer» A. It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table |
268. |
In MS Access, Field Value may contain |
A. | Text |
B. | Date & Time |
C. | Picture |
D. | All of the Above |
Answer» D. All of the Above |
269. |
Which of the following is the DBMS type |
A. | Flat File System |
B. | Hierarchical DBMS |
C. | Relational DMBS |
D. | All of the Above |
Answer» D. All of the Above |
270. |
Which of the following relationship is not valid in MS Access ? |
A. | Many to Many |
B. | Many to Null |
C. | One to One |
D. | One to Many |
Answer» B. Many to Null |
271. |
A collection of related tables is called |
A. | Row |
B. | Record |
C. | Database |
D. | File |
Answer» C. Database |
272. |
Which of the following Format supports for Data Type Yes/No? |
A. | Yes/No |
B. | True/False |
C. | On/Off |
D. | All of Above |
Answer» D. All of Above |
273. |
Queries can be created in Access by |
A. | Typing Queries in SQL View |
B. | Drag and Drop fields on Query Builder |
C. | Using Query Wizard |
D. | All of the Above |
Answer» D. All of the Above |
274. |
Relationship can be establish between two tables by |
A. | Drag Primary key of a table into Foreign key of another table |
B. | Drag Foreign key of a table into Primary key of another table |
C. | Drag any key of a table into any key of another table |
D. | All of the above |
Answer» A. Drag Primary key of a table into Foreign key of another table |
275. |
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» B. It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted |
276. |
Macros can recover from _______ in a controlled manner. |
A. | events |
B. | modules |
C. | arguments |
D. | errors |
Answer» A. events |
277. |
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» B. procedures |
278. |
The VB Name used to display the warning message icon is _______. |
A. | vbCritical |
B. | vbInformation |
C. | vbExclamation |
D. | vbQuestion |
Answer» C. vbExclamation |
279. |
What happens when a user double-clicks an object in the Project pane of the Visual Basic Editor? |
A. | The associated code is displayed in the Code pane. |
B. | The associated code is displayed in a new window. |
C. | The object is deleted from the Project pane. |
D. | The object\'s property sheet opens. |
Answer» A. The associated code is displayed in the Code pane. |
280. |
A(n) _______ is major object that completes an action or a set of actions. |
A. | event |
B. | property |
C. | procedure |
D. | macro |
Answer» D. macro |
281. |
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» D. Module1 |
282. |
To assign a macro to an event, users need to open the form in Design View. |
A. | event |
B. | property |
C. | title |
D. | macro |
Answer» A. event |
283. |
In a module, the VB Name used to display a warning query icon is _______. |
A. | vbCritical |
B. | vbInformation |
C. | vbExclamation |
D. | vbQuestion |
Answer» D. vbQuestion |
284. |
In a module, a(n) _______ is a series of commands and properties that perform a specific task. |
A. | event |
B. | property |
C. | procedure |
D. | macro |
Answer» C. procedure |
285. |
A(n)_______ is a major object that can run independent of a control. |
A. | event |
B. | property |
C. | procedure |
D. | macro |
Answer» D. macro |
286. |
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» B. It is bound to two fields. |
287. |
The option button ____ identifies each button or check box in an option group. |
A. | event |
B. | frame |
C. | label |
D. | value |
Answer» C. label |
288. |
Which of the following statements about a tab control in a form is incorrect? |
A. | It can contain only one object. |
B. | It defines a layered space. |
C. | It is a control object. |
D. | It is created in multipage forms. |
Answer» A. It can contain only one object. |
289. |
The option group ____ describes the contents of the entire option group. |
A. | event |
B. | frame |
C. | label |
D. | value |
Answer» C. label |
290. |
A(n) ____ is the default control for a Yes/No field. |
A. | check box |
B. | option button |
C. | toggle button |
D. | list box |
Answer» A. check box |
291. |
Which of the following components has a property sheet that includes settings for the frame and the option group? |
A. | Option group label |
B. | Option group frame |
C. | Option button |
D. | Option button labels |
Answer» B. Option group frame |
292. |
Which control lets a user create multiple pages in a form? |
A. | Check box control |
B. | Combo box control |
C. | Option group control |
D. | Tab control |
Answer» D. Tab control |
293. |
On the property sheet, which of the following tabs contains the Caption property? |
A. | Data |
B. | Event |
C. | Format |
D. | Other |
Answer» C. Format |
294. |
Which of the following statements regarding charts is incorrect? |
A. | It can be inserted into a form only. |
B. | It can be designed as a stand-alone object. |
C. | It can be linked to the object in which it is plac |
Answer» A. It can be inserted into a form only. |
295. |
Which of the following options is NOT a part of an option group? |
A. | Option button label |
B. | Option group frame |
C. | Option group label |
D. | Option group button |
Answer» D. Option group button |
296. |
Which of the following is a condensed form of standard generalized markup language? |
A. | HTML |
B. | XML |
C. | XSD |
D. | XSL |
Answer» B. XML |
297. |
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» A. Microsoft Office button |
298. |
For _________ data to be useful, both the sender and the receiver need to be able to read and use the data. |
A. | standardized |
B. | fixed |
C. | delimited |
D. | shared |
Answer» D. shared |
299. |
Which of the following is a standard file format language for web documents? |
A. | HTML |
B. | XML |
C. | XSD |
D. | XSL |
Answer» A. HTML |
300. |
HTML stands for ____. |
A. | High Text Mail List |
B. | Hyperlink Markup Language |
C. | HyperText Markup Language |
D. | Hyperlink Transfer Markup Language |
Answer» C. HyperText Markup Language |
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.