Microsoft Access Quiz Questions and Answers pdf - Set 12 - ObjectiveBooks

Microsoft Access Quiz Questions and Answers pdf - Set 12

Practice Test: Question Set - 12

1. A relationship is created between how many tables?
    (A) One
    (B) Two
    (C) Three
    (D) Any number

2. The Input Mask wizard does NOT include the ability to do which of the following?
    (A) Force all uppercase
    (B) Define placeholder
    (C) Store symbols with data
    (D) Use preset masks

3. Which of the following data types automatically generates a consecutive number?
    (A) Autonumber
    (B) Memo
    (C) Number
    (D) Text

4. Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry?
    (A) Match Case
    (B) Match: Whole Field
    (C) Match: Start of Field
    (D) Match: Any Part of Field

5. What happens when a user selects a record in a form and presses [Delete]?
    (A) The record is deleted in the form and from its source table
    (B) The record is deleted in the form, but not from its source table
    (C) The record is neither deleted in the form, nor from its source table
    (D) The record is not deleted in the form, but is deleted from its source table

6. The most popular commercial DBMS.
    (A) Microsoft SQL Server
    (B) Microsoft Access
    (C) MySQL
    (D) Oracle

7. What are the different views to display a table?
    (A) Datasheet view
    (B) Design view
    (C) Pivote table & pivot chart view
    (D) All of above

8. Dcl provides commands to perform actions like
    (A) Change the structure of tables
    (B) Insert, update or delete records and data values
    (C) Authorizing access and other control over database
    (D) None of above

9. Which of the following database object produces the final result to present?
    (A) Forms
    (B) Reports
    (C) Queries
    (D) Tables

10. Queries in access can be used as
    (A) View, change and analyze data in different ways
    (B) A source of records for forms and reports
    (C) Only 'a'
    (D) Both ‘a’ and ‘b’

11. Cascade delete option
    (A) Is used to delete all the records of all tables in a database
    (B) Will repeat the recent delete operation to all the records of current table
    (C) Is available in edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record parent table is deleted
    (D) None of above

12. Both conditions display on the same row in the design grid when ________operator is in use
    (A) Or
    (B) In
    (C) And
    (D) Like

13. The expression builder is an access tool that controls an expression________ for entering an expression
    (A) Table
    (B) Box
    (C) Cell
    (D) Palette

14. The ‘filter by selection’ allows you to filter those records
    (A) That match the selected field
    (B) That match the criteria specified
    (C) That meet any of several criteria specified
    (D) All of above

15. Which of the following database object can be used if you need to mail the invoice to customers?
    (A) A form
    (B) A query
    (C) A report
    (D) A table

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: