Exam 15: Access: Introduction to Powerpoint

When forming relationships in a relational data base, the ________ from one table must be joined to the foreign key of another table.

Two users cannot work on the same table in a database.

A(n) ________ is a single characteristic or attribute of a person, place, object, event, or idea contained in a database.

A field that is defined as a primary key in one table is defined as a(n) ________ in a related table.

A database is a collection of one or more related tables.

A group of related tables is called a(n) ________ database.

The ________ tab contains all the tools necessary for producing tables, forms, and queries in Access.

Rather than displaying records based on a question as in a query, a(n) ________ hides records that do not match a set criteria.

The ________ allows you to organize different types of database objects into groups.

A field, or a combination of fields, that has a unique value is a:

Tables, queries, reports, and forms are all examples of ________.

________ a database rearranges data and objects in a database to make its size smaller.

Like Access, Excel can be used to manage large quantities of data.

A relational database is a collection of:

When using Filter by Form, you can use comparison operators in the criteria to evaluate relationships.

You can make a(n) ________ copy of a database file to protect your database against loss or damage.

Database design begins with:

A query cannot be used to add new records or modify existing records.

By selecting the ________ option, you can make sure that data entered into a related table first exists in the primary table.

-In the table pictured above, the last row of data shown ( 2734, Riker, William, 212-566-1701.) is a: