Practice Test: Question Set - 09
1. Cascade update option
- (A) Means do not
change the value in the primary key field if that record has related records in
another table
- (B) Means change
all the related records in child tables if the record in parent table is
changed
- (C) Both of
above
- (D) None of
above
2. You can automatically include all of the field in a table in a query by________ a strike that appear list box in query design view
- (A) Clicking
- (B) Right
clicking
- (C) Double
clicking
- (D) None of the
above
3. The key uniquely identifies each record in a table.
- (A) Primary key
- (B) Key word
- (C) Filed name
- (D) All of above
4. This type of database contains multiple tables that are connected to produce combined output from all tables.
- (A) Bound
- (B) Linked
- (C) Relational
- (D) Joined
5. A collection of related records in database is known as a
- (A) Table
- (B) Database
- (C) File
- (D) None of
above
6. When creating an input mask this character does not require an entry, but if an entry is made it must be a letter from a-z
- (A) ?
- (B) !
- (C) #
- (D) \
7. This form displays data in a table layout with field name labels across the top of the page and the corresponding data in rows and columns under each heading.
- (A) Columnar
- (B) Justified
- (C) Datasheet
- (D) Tabular
8. This type of query summarizes large amounts of data in easy-to-read, row-and-column format.
- (A) Crosstab
- (B) Columnar
- (C) Select
- (D) Action
9. The result of a query is displayed in a
- (A) Record
- (B) Query
datasheet
- (C) Query table
- (D) Form
10. To set a password for the database, select __________ in the Microsoft Access open window.
- (A) Open read
only
- (B) Open write
only
- (C) Open
explicit
- (D) Open
exclusive
11. Which of the following query type is best suitable to analyze data?
- (A) Cross tab
queries
- (B) Parameter
queries
- (C) Action
queries
- (D) None of
above
12. What type of control in a form can display data from database table?
- (A) Bound
control
- (B) Unbound
control
- (C) Both of
above
- (D) None of
above
13. Which program do you use to edit code for data access pages?
- (A) Microsoft
script editor
- (B) Microsoft
code editor
- (C) Microsoft
data access pages editor
- (D) None of
above
14. When a picture or other graphic image is placed in the report header section it will appear_________
- (A) Once in the
beginning of the report
- (B) At the top
of every page
- (C) Every after
record break
- (D) On the 1st
and last pages of the report
15. To create a new table, in which method you don’t need to specify the field type and size?
- (A) Create table
in Design View
- (B) Create Table
using wizard
- (C) Create Table
by Entering data
- (D) All of above
Next Tests: