MS Access - Computer Science Questions & Answers - Set 27 - ObjectiveBooks

MS Access - Computer Science Questions & Answers - Set 27

Practice Test: Question Set - 27

1. A part of database that stores complete information about an entity such as employee, sales, orders etc.
    (A) File
    (B) Record
    (C) Field
    (D) Query

2. Changing the order of this in the query datasheet does not affect the field order in the table.
    (A) Record
    (B) Row
    (C) Column
    (D) Sort

3. The size of a field with Number data type cannot be
    (A) 2
    (B) 4
    (C) 8
    (D) 16

4. Following is not a database model
    (A) Network database model
    (B) Relational database model
    (C) Object oriented database model
    (D) None

5. Which of the following creates a drop down list of values to choose from a list?
    (A) OLE Object
    (B) Hyperlink
    (C) Memo
    (D) Lookup Wizard

6. If you need to edit a relationship
    (A) Right click the relationship line and choose Edit Relationship
    (B) Double click the relationship line
    (C) Both of above
    (D) None of above

7. An organized collection of logically related data is known as
    (A) Data
    (B) Meta data
    (C) Database
    (D) Information

8. The report footer section is most useful for displaying:
    (A) Grand totals
    (B) Column headings
    (C) Subtotals
    (D) Page numbers

9. 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

10. 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

11. 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

12. Which report section prints once at the bottom of every printed page?
    (A) Detail
    (B) Page Header
    (C) Page Footer
    (D) Report Header

13. 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

14. What is the keyboard shortcut to move to the last records in a table?
    (A) [Tab]
    (B) [Shift]+[Tab]
    (C) [Ctrl]+Home]
    (D) [Ctrl]+[End]

15. An enterprise solution with data storage, a client interface and a security system is a(n) ________ system.
    (A) 2-tier
    (B) 3-tier
    (C) 4-tier
    (D) n-tier

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: