Which of the following creates a drop-down list of values to choose from a list?
A. OLE Object
B. Hyperlink
C. Memo
D. Lookup Wizard
Wahab Dashti
It is an association established between common fields of two tables.
A. line
B. relationship
C. primary key
D. records
Referential integrity means in MS Access
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
The default and maximum size of text field in Access
A. 50 and 255 Characters
B. 8 and 1 GB
C. 266 characters & 64000 characters
D. None of above
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 the same field separated with AND
D. Write criteria values in the same field separated with &
A __ name must be unique within a database
A. Table
B. Field
C. Record
D. Character
Which of the following database object produces the final result to present?
A. Forms
B. Reports
C. Queries
D. Tables
It is a database object to view, change, and analyze data in different ways
A. query
B. form
C. report
D. None of the above
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
It is a sign or symbol that specifies, operator, and values that produce a result
A. operator
B. query
C. expression
D. None of the above