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
Next Tests: