Practice Test: Question Set - 02
1. Which of the following is not an action query?
- (A) Add
- (B) Delete
- (C) Make-table
- (D) Update
2. 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
3. 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
4. In MS Access, Field Value may contain
- (A) Text
- (B) Date &
Time
- (C) Picture
- (D) All of the
Above
5. 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
6. 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
7. 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
8. 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 standalone-object
- (C) It can be
linked to the object in which it is placed
- (D) It is a
control linked to a data source
9. Which of the following is the file extension for an Extensible Markup Language?
- (A) EML
- (B) HTML
- (C) XML
- (D) XSD
10. Which part of the IIF expression is the action performed if the true condition exists?
- (A) Inner
- (B) First
- (C) Second
- (D) Third
11. The three parts of an IIF function are separated by ________.
- (A) Dashes
- (B) Asterisks
- (C) Semicolons
- (D) Commas
12. The Allow ________ property controls whether new records can be added through the form.
- (A) Additions
- (B) Edits
- (C) Deletions
- (D) Data Entry
13. 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 printed
- (D) They can be
inserted on a form or a report
14. A(n) _________ query makes changes to or moves records in a dynaset, in a single operation.
- (A) Select
- (B) Summary
- (C) Parameter
- (D) Action
15. In a query, which row do you need to place wildcards to affect a parameter?
- (A) Arguments
- (B) Criteria
- (C) Fields
- (D) Tables
Next Tests: