Microsoft Access Short Questions - Set 24 - ObjectiveBooks

Microsoft Access Short Questions - Set 24

Practice Test: Question Set - 24

1. This is not one of the sections of the form design window
    (A) Form footer
    (B) Form content
    (C) Form header
    (D) Form detail

2. How can you display the related records from other tables in datasheet view?
    (A) Click on the expand indicator next to the record
    (B) Double click on the record to expand it
    (C) Apply filter by command to display related records
    (D) All of above

3. The executive responsible for the data processing function in an organization is
    (A) Pm
    (B) Dbms
    (C) Dp
    (D) Dpm

4. How do you filter by selection?
    (A) Right click the field value and select filter by selection from the shortcut menu
    (B) Find and double click the value on which you want to base the filter
    (C) Find and select the value on which you want to base the filter and select tools>filter by selection from the menu
    (D) None

5. Which action will optimize your database performance?
    (A) Set the record set type to snapshot
    (B) Use the compact and repair database tool
    (C) Create a replica of the database
    (D) All of the above

6. What happens when you add the asterisk (*) from any field list of a query?
    (A) The table will not include any fields from the table
    (B) The query sorts the table’s record in the order you specify
    (C) The query will include every field from the table
    (D) The query uses the records from the table without displaying them

7. Which of the following is not a selection technique?
    (A) To select a word, double click the word
    (B) To select an entire table click the empty box to the left of the field names
    (C) To select a row, click the record selector box to the left of the row
    (D) To select a column, double click anywhere in the column

8. The two form layout types will display multiple records at one time are tabular and________
    (A) Columnar
    (B) Justified
    (C) Date sheet
    (D) Pivot table

9. To sort records in a table
    (A) Open table, click on the field on which the sorting is to be done, then click Sort button on database toolbar
    (B) Open table, click Sort button on database toolbar, choose field based on which to sort, click OK
    (C) Click the field heading to sort it ascending or descending
    (D) All of above

10. Which of the field has width 8 bytes?
    (A) Memo
    (B) Number
    (C) Date/Time
    (D) Hyperlink

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

12. It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
    (A) Parameter
    (B) Select
    (C) Crosstab
    (D) Append

13. Collection of related records in a database is known as
    (A) File
    (B) Bench
    (C) Table
    (D) Relationship

14. Which object is used to create a form?
    (A) Tables and Queries
    (B) Tables only
    (C) Tables and reports
    (D) Queries and reports

15. Which query do you use to answer the question “What is the average salary of the employees”?
    (A) Search query
    (B) Cross tab query
    (C) Select query
    (D) Update query

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: