Exam 19: Implementing a Database With Microsoft Access

The easiest way to create a query is to use a query-by-example tool.

Access defaults to identifying the first field in a relation as the foreign key.

When you drag and drop a foreign key onto a primary key,Microsoft Access assumes that the relationship is ____.

When entering text into the Criteria box,you must be careful that you have the right letters (and digits and spaces,if applicable)in the right places.

A(n)_____ key consists of the primary key fields from intersecting relations.

When you drag and drop a primary key onto a foreign key,Microsoft Access assumes that the relationship is ____.

One of Microsoft's Access's biggest advantages is that you can start typing information immediately into a database.

A query-by-example tool helps you graphically design the answer to a question.

To populate an Access table,you simply double-click on the table name in the list of tables on the far left side the screen.