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

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: