Microsoft Access 1 Mark Questions & Answers - Set 25 - ObjectiveBooks

Microsoft Access 1 Mark Questions & Answers - Set 25

Practice Test: Question Set - 25

1. Which setting you must modify to print a report using letterhead?
    (A) Group
    (B) Margin
    (C) Section
    (D) Orientation

2. In a table to insert User\’s Voice, Data field should be
    (A) OLE Object
    (B) SoundField
    (C) VoiceField
    (D) Memo

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

4. A(n) _________ is an Extensible Scheme Standard file that is an approved W3C standard design as a basic infrastructure.
    (A) HTML
    (B) XML
    (C) XSD
    (D) XSL

5. The ________ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar.
    (A) Date
    (B) Time
    (C) Calendar
    (D) Appointment

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

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

8. What is the process of eliminating redundant fields by separating data into tables called?
    (A) Renormalizations
    (B) Filtering
    (C) Normalization
    (D) Sorting

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

10. Which of the following CANNOT be done to data using a Form?
    (A) Store
    (B) Sort
    (C) Edit
    (D) Print

11. ________ is used to build ‘intuitive’ queries.
    (A) SQL
    (B) Xbase
    (C) QBE
    (D) XML

12. When entering field name, how many characters you can type in maximum?
    (A) 60
    (B) 64
    (C) 68
    (D) Any number of characters

13. The________ operator will cause a record to be selected only if two or more conditions are satisfied
    (A) Or
    (B) If or
    (C) Range
    (D) And

14. In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _________
    (A) Child, Parent
    (B) Parent, Child
    (C) Brother, Sister
    (D) Father, Son

15. To create queries in Access
    (A) You can drag and drop fields on query builders
    (B) You can type the SQL command in SQL view
    (C) You can use query wizard or design view
    (D) All of above

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: