Microsoft Access Quiz Questions and Answers - Set 10 - ObjectiveBooks

Microsoft Access Quiz Questions and Answers - Set 10

Practice Test: Question Set - 10

1. This is the stage in database design where one gathers and lists all the necessary fields for the database project.
    (A) Data definition
    (B) Data refinement
    (C) Establishing relationship
    (D) None of the above

2. When creating a new table which method can be used to choose fields from standard databases and tables?
    (A) Create table in Design View
    (B) Create Table using wizard
    (C) Create Table by Entering data
    (D) None of above

3. What does the show check box in query design window indicate?
    (A) It indicates whether the field is to be used or not
    (B) It indicates whether the field is to be displayed in query result or not
    (C) It indicates whether the field names to be displayed in query result or not
    (D) None of above

4. Which of the following database object hold data?
    (A) Forms
    (B) Reports
    (C) Queries
    (D) Tables

5. You can set a controls border type to make the border invisible.
    (A) Transparent
    (B) Invisible
    (C) Do not display
    (D) No border

6. To achieve AND effect when you are entering criteria in a query design window
    (A) Write criteria values vertically one in a row
    (B) Write criteria values horizontally
    (C) Write criteria values in same field separated with AND
    (D) Write criteria values in same field separated with &

7. We can remove a relationship defined between two tables by
    (A) From Edit menu choose Delete Relationship
    (B) Select the relationship line and press Delete
    (C) Choose Delete option from Relationship menu
    (D) All of above

8. Which of the following statement is true?
    (A) Reports can be used to retrieve data from tables and calculate
    (B) Queries can be printed in well formatted manner and presented as the information
    (C) Queries can include calculated fields that do not exist in table
    (D) Reports and forms are similar but forms are use to print but reports to display on screen only

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

10. The task of arranging data in order is called
    (A) Searching
    (B) Sorting
    (C) Ordering
    (D) Shorting

11. Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called
    (A) Foreign key
    (B) Native key
    (C) Composite key
    (D) Primary key

12. HSAM stands for ________
    (A) Hierarchic Sequential Access Method
    (B) Hierarchic Standard Access Method
    (C) Hierarchic Sequential and Method
    (D) Hierarchic Standard and Method

13. What is an intersection of a row and a column?
    (A) Form
    (B) Cursor
    (C) Cell
    (D) Record

14. In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
    (A) zipcode, firstname, lastname
    (B) firstname, lastname, zipcode
    (C) zipcode, lastname, firstname
    (D) Can’t sort by multiple fields

15. In an application created using the database wizard, the main menu is presented as a:
    (A) Form, called a switchboard
    (B) Report, called a menu
    (C) Table, called a switchboard
    (D) Query, called a menu

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: