Exam 16: Access: Presentation Development

You cannot add a missing field to a table once the table has been designed.

A field can store a web site address or the path to a file if the ________ data type is applied to the field

It is more efficient to copy and use an existing query for a new query when

________ is the value used to describe a blank field in an Access table.

Which of the following is true regarding the running of queries and the size of a database?

A ________ relationship consists of a primary key value in a primary table many foreign key values in a related table.

A mathematical symbol such as an addition or subtraction sign is called a(n) ________.

________ is duplication of data stored in two or more tables.

Which of the following is true about the NOT operator?

A(n) database ________ holds related information and is made up of records.

If a user selects the ________ option while creating a relationship, Access will automatically modify all foreign key values in a related table to match any modifications made to the primary key.

Marla is working in a database that stores customer purchases. She needs to find customers in the New York area that have purchased over $5000 worth of goods. Which query operator would Marla use in a query to find this information?

A blank field is also known as Null.

A query is a question asked about the data in a database.

A one-to-many relationship is established when the foreign key in the first table matches multiple primary key values in the second table.

A ________ relationship exists when records in two different tables are related by the same primary key.

When designing a database, it is important to consider future data needs.

When defining a field, the field ________ property determines how much physical storage space the field requires.

A relationship cannot be established between two tables unless a primary key has been set in the first table.

Which statement accurately describes the function of a query?