Microsoft Access Computer Based Test Questions - Set 18 - ObjectiveBooks

Microsoft Access Computer Based Test Questions - Set 18

Practice Test: Question Set - 18

1. Which of the following is a condensed form of standard generalized markup language?
    (A) HTML
    (B) XML
    (C) XSD
    (D) XSL

2. A(n) _________ is an image control that displays in the background of a page on a form or report.
    (A) Legend
    (B) Icon
    (C) Logo
    (D) Watermark

3. A Smart Tag can be set using the ________ tab in the property sheet.
    (A) Format
    (B) Tag
    (C) View
    (D) Data

4. A summary query can be created by adding which row to the design grid of a select query?
    (A) Arguments
    (B) Group
    (C) Summary
    (D) Total

5. What does an inner join display?
    (A) Records from the second recordset and only records from the first recordset where the common fields are equal
    (B) Records from the first recordset and only records from the second recordset where the common fields are equal
    (C) Records that have the same value in the common field
    (D) Records from the first recordset only

6. To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used?
    (A) Datasheet
    (B) Justified
    (C) Stacked
    (D) Tabular

7. Which of the following search criteria is invalid?
    (A) $45*
    (B) *cal*
    (C) D*m??
    (D) AS150*

8. What type of relationship is created when you select a primary key in both related tables?
    (A) One-To-One
    (B) Indeterminate
    (C) One-To-Many
    (D) Many-To-Many

9. Which of the following field properties displays a model or pattern for entering data?
    (A) Field Size
    (B) Format
    (C) Input Mask
    (D) Validation Rule

10. Which of the following functions CANNOT be used in the Totals row?
    (A) Average
    (B) Count
    (C) Maximum
    (D) Round

11. Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?
    (A) Press [Ctrl]+[C] and [Ctrl]+[V]
    (B) Right-click, choose from the shortcut menu Copy and Paste
    (C) Press [Ctrl]+[+] and [Ctrl]+[-]
    (D) From the ribbon, select Copy and Paste

12. ________ is the clear leader for personal databases.
    (A) Microsoft Access
    (B) Microsoft FoxProv
    (C) Borland dBase
    (D) MySQL

13. The command center of access file that appears when you create or open the MS Access database file.
    (A) Database window
    (B) Query window
    (C) Design view window
    (D) Switchboard

14. What are the columns in a Microsoft Access table called?
    (A) Rows
    (B) Records
    (C) Fields
    (D) Columns

15. After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
    (A) You need to delete the whole table. There is no method to remove a particular field only
    (B) Delete all the fields from third downwards and reenter the required fields again
    (C) Select the third column in datasheet view then delete
    (D) Select the third row in table design view then delete

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: