Microsoft Access Objective Quiz Questions & Answers - Set 13 - ObjectiveBooks

Microsoft Access Objective Quiz Questions & Answers - Set 13

Practice Test: Question Set - 13


1. This form displays the field name labels down the left side of the column, with the data for each field just to the right of its corresponding label.
    (A) Tabular
    (B) Justified
    (C) Columnar
    (D) Datasheet

2. This query wizard will create a select query.
    (A) Crosstab
    (B) Find duplicates
    (C) Simple
    (D) Design view

3. In access, this view is used to create and modify the structure of a form.
    (A) Normal
    (B) Datasheet
    (C) Form design
    (D) Control

4. What is the use of description field in table design window?
    (A) The description will be displayed on status bar when entering data in datasheet view
    (B) The description will be displayed on status bar when entering data in form
    (C) Both of above
    (D) None of a the above

5. Which of the following is not a section in report design window?
    (A) Report header section
    (B) Page header section
    (C) Summary section
    (D) Report footer section

6. Which of the following is not a data type?
    (A) Picture/graphic
    (B) Data/time
    (C) Text
    (D) Number

7. Data items groped together for storage purposes are called a
    (A) Record
    (B) Title
    (C) List
    (D) String

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

9. According to access help, what’s a good way to design a database?
    (A) Start from data access pages and work backward
    (B) Sketch the design of your database using a pencil and paper
    (C) Use the table analyzer to reverse-engineer your flat source data
    (D) None of above

10. What data type should you choose for a zip code field in a table?
    (A) Text
    (B) Number
    (C) Memo
    (D) All of above

11. What is the purpose of the description column in table design view?
    (A) To define the data type applied to each field within the table
    (B) To describe the data that should be entered in each field
    (C) To enter lookup data that the field should refer to
    (D) None of the above

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

13. The third stage in designing a database is when we analyze our tables more closely and create a _________ between tables
    (A) Relationship
    (B) Join
    (C) Query
    (D) None of these

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

15. To duplicate a controls formatting you can use________
    (A) Manager
    (B) Wizard
    (C) Painter
    (D) Control

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests:


    Blogger Comment
    Facebook Comment