Practice Test: Question Set - 16
1. This is the stage in database design where one gathers and list all the necessary fields for the database project.
- (A) Data
definition
- (B) Data
refinement
- (C) Establishing
relationship
- (D) None
of the above
2. Which of the following is not a type of Microsoft Access database object?
- (A) Table
- (B) Form
- (C) Worksheets
- (D) Modules
3. Which of the following is not a field type in access?
- (A) Memo
- (B) Hyperlink
- (C) Ole object
- (D) Lookup
wizard
4. Referential integrity means
- (A) Do not enter
a value in the foreign key field of a child table if that value does not exist
in the primary key of the parent table
- (B) Do not enter
a value in the primary key field of child table if that value does not exist in
the primary key of the parent table
- (C) Do not enter
a value in the foreign key field of a parent table if that value does not exist
in the primary key of the child table
- (D) All of above
5. The________ button on the tool box display data from a related table
- (A) Sub form sub
report
- (B) Relationships
- (C) Select
objects
- (D) More
controls
6. Which of the following database object is created first before any other created?
- (A) Table
- (B) Form
- (C) Report
- (D) Query
7. In access, this displays the results of a calculation in a query
- (A) Lookup field
- (B) Calculated
field
- (C) Source field
- (D) Child field
8. Queries are based on this, allowing you to use a query as the source for forms and reports
- (A) Filters
- (B) Tables
- (C) Records
- (D) Fields
9. To enter the input mask wizard
- (A) Click on the
three dots to the right of the caption entry field
- (B) Click on the
three dots to the right of the format entry field
- (C) Click on the
input mask toolbar
- (D) Click on the
three dots to the right of the input mask entry field
10. Which of the following is a database management system?
- (A) Ms word
- (B) Ms excel
- (C) Oracle
- (D) Lotus 1-2-3
11. To display value from table for a label control
- (A) Set the
control source and record source prom property panel
- (B) Choose the
database, table, field and select data value to display
- (C) Look at the
table and type value in the caption
- (D) Set the
record source property and then control source
12. What is the name of the visual basic editor utility that allows you to view the Microsoft Access type library’s available objects and members?
- (A) Object
viewer
- (B) Object
browser
- (C) Type library
spy
- (D) None of
above
13. This data type allows alphanumeric characters and special symbols.
- (A) Text
- (B) Memo
- (C) Auto number
- (D) None of the
above
14. To create relationship between two tables
- (A) Drag the
primary key of a table into foreign key of another table
- (B) Drag the
foreign key of a table into the primary key of another table
- (C) Drag any
field from parent table and drop on child table
- (D) Any of above
can be done to create relationship
15. The expression builder is an access tool that controls an expression________ for entering an expression
- (A) Table
- (B) Box
- (C) Cell
- (D) Palette
Next Tests: