Database Concepts 4

1. A field that is a primary key in another table is called a ____________________

Special key

Foreign key

Simple key

Composite key

2. _________________ controls are used to display a calulated value based on one or more fields in a table.

Bound

Unbound

Boundary

Calulated

3. Ronald Billing wants to search for duplicate records in a table or query of a Microsoft Access database. Which of the following wizards will Ronald use to perform this operation?

Simple Query Wizard

Crosstab Query Wizard

Finding Duplicates Query Wizard

Finding Unmatched Query Wizard

4. _________________ controls are linked to a field in a table.

Bound

Unbound

Boundary

Calulated

5. _______________ controls on a form are not linked to the fields in a table.

Bound

Unbound

Boundary

Calulated

6. Which of the following is not a function of a form?

Allows you to change the data type of a field

Browse the contents of a table

Enter data in a table

Modify data in a table

Delete data from a table

7. John Smith sells computer parts. He maintains a database of inventory items with their respective names and prices. A customer wants to know the most expensive sound speakers in Smith's store. Which query wizard can John Smith run to answer the customer's query?

Simple Query Wizard

Crosstab Query Wizard

Finding Duplicates Query Wizard

Finding Unmatched Query Wizard

8. Which of the following measuring unit is used to measure the font size in the forms of Access database?

Points

Picas

Pixels

Meters

9. Mary has created a database which has two tables, a categories table and a products table. For a particular category there can be many products. She wants to find out for which category there are no products. Which type of query should she use?

Simple Query Wizard

Crosstab Query Wizard

Finding Duplicates Query Wizard

Finding Unmatched Query Wizard

Database Concepts 4

1. A field that is a primary key in another table is called a ____________________

2.

What first name or nickname would you like us to use?

2. _________________ controls are used to display a calulated value based on one or more fields in a table.

3. Ronald Billing wants to search for duplicate records in a table or query of a Microsoft Access database. Which of the following wizards will Ronald use to perform this operation?

4. _________________ controls are linked to a field in a table.

5. _______________ controls on a form are not linked to the fields in a table.

6. Which of the following is not a function of a form?

7. John Smith sells computer parts. He maintains a database of inventory items with their respective names and prices. A customer wants to know the most expensive sound speakers in Smith's store. Which query wizard can John Smith run to answer the customer's query?

8. Which of the following measuring unit is used to measure the font size in the forms of Access database?

9. Mary has created a database which has two tables, a categories table and a products table. For a particular category there can be many products. She wants to find out for which category there are no products. Which type of query should she use?