Access ch 2-6 review

lookup

A ___ field allows the user to select from a list of values.

focus

A control is said to have the ____ when it becomes active; that is, when it becomes able to receive user input through mouse, touch, or keyboard actions.

Required field

A field in which the user actually must enter data.

True

A foreign key is a field in one table whose values are required to match a primary key in another table. T/F?

/

A mathematical operator for division.

False, A multivalue field is a field that contains more than one value.

A multilookup field is a field that contains more than one value. T/F?

False, A query that prompts for input whenever it is run is a Perimeter Query.

A query that prompts for input whenever it is run is a dialog query. T/F?

True

A table in first normal form (1NF) may not contain repeating groups. t/f?

candidate

A university can use either the student's Social Security Number or the Student ID as the primary key for a table. These two fields are considered ____ keys.

calculated

A(n) ____ field is a field that can be computed from other fields.

attribute

A(n) ____ is a property of an entity.

entity

A(n) ____ is like a noun: It is a person, place, thing, or event

foreign

A(n) ____ key is a field in one table whose values are required to match the primary key of another table.

append

A(n) ____ query adds a group of records from one table to the end of another table.

make-table

A(n) ____ query adds records from an existing table to a new table, that is, a table that has not yet been created.

database management system

Access is a ____.

Delete query

Allows you to delete all the records satisfying some criterion.

multivalued

An attribute that can have many values for a single entity is called a ________ attribute.

AND criterion

Each individual criterion must be true in order for the compound criterion to be true.

OR criterion

Either individual criterion must be true in order for the compound criterion to be true.

Calculated field

Field that can be computed from other fields.

True

Grouping means creating groups of records that share some common characteristic. T/F?

determines

If Customer Name is functionally dependent on Customer Number, then Customer Number ____ Customer Name.

many-to-many

If a customer can be offered many seminars and each seminar is offered to many customers, there is a(n) ____ relationship between customers and seminars.

true

If a table is in first normal form (1NF) and its primary key contains only a single field, the table is automatically in second normal form (2NF). t/f?

$0.00

If the criterion for Current Due field is 0, the query results for this query will display ____ in the Current Due field.

many-to-many

If the primary key of the Seminar Offerings table contains the primary key for both the Customer table and Seminar table, there is a ____ relationship between customers and seminars.

true

If you want to list all the rows in the tables, you do not need to include the word WHERE in a SQL statement. tf

report

In Access, mailing labels are a special type of _______

False

In Access, the columns in a table are called records. T/F?

Entities

In ER diagrams, rectangles are used to denote ______ .

relational

In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.

Input Mask

In the Bavant Publishing Database, the Book Rep table has a Phone Number field. The _______ property of the Phone Number field is used to specify how data is to be entered and how it will appear.

True

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose. T/F?

• filtering records • changing the appearance of a datasheet • adding new records • changing the data for existing records

Maintaining a database can include ____.

False

Many-to-many relationships are implemented through an additional table that contains matching fields for both of the related tables. t/f?

True

Redundancy means storing the same fact in more than one place. T/F?

*

Represents any collection of characters.

?

Represents any individual character.

Validation rules

Rules that a user must follow when entering data.

true

SQL has built-in functions, also called aggregate functions, to calculate the number of entries, the sum or average of all entries in a given column, and the largest or smallest of the entries in a given column. tf

MAX

The ____ aggregate function finds the largest value.

primary

The ____ key of a table is the field or minimum collection of fields that uniquely identifies a given row in that table.

DISTINCT

The ____ operator eliminates duplicate values in the results of a query.

qualify

The accompanying figure shows a SQL query to join two tables. In the query, it is necessary to ____ the Book Rep Number because it appears in more than one table.

alias

The accompanying figure shows a SQL query to join two tables. When tables appear in the FROM clause, you can give each table a(n) ____, or an alternative name, that you can use in the rest of the statement.

*education*

The condition, ____, entered in the Criteria row of a long text field in a query window would retrieve all records where the long text field had any mention of education.

False

The data in a report can come from one or more tables but the data in a form can only come from one table. t/f?

Validation text

The message that will appear if a user violates the validation rule.

true

The primary key of a table is the field or minimum collection of fields that uniquely identifies a given row in that table. T/F?

True

The process of combining two or more text data items into a single expression is called concatenation. tf

padding

The term, ____, refers to the amount of space between a control's border and its contents.

one-to-many

There is a ____ relationship between book reps and customers because one book rep is associated with many customers but each customer is associated with only one book rep.

Where

To calculate statistics for only those records that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.

SUM

To calculate the total of a field, such as Amount Paid, use the ____ aggregate function.

OR

To combine criteria with ____________________, each criterion must go on separate rows in the Criteria area of the grid.

square brackets [ ]

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

GROUP BY

To create a query that groups all customers with the same rep number, include the ____ clause in the SQL command.

COUNT

To determine the number of customers assigned to a particular book rep, use the ____ aggregate function.

On Click

To display a pop-up form for a control, such as Customer Number in a datasheet form, create a user interface (UI) macro that is associated with the ____ event for the control.

False

To find all customers whose names begin with S, enter S? in the Criteria row of the design grid. T/F?

True

To find all customers whose returns are greater than $0.00 AND whose book rep is book rep number 42, enter each criterion on the same row. T/F?

Rob?n

To find all individuals whose name is Robin or Robyn, enter ____ in the Criteria row of the appropriate column.

asterisk (*)

To include all fields in the results of a SQL query, use the ____ symbol after the word SELECT.

Group By

To indicate grouping in Access, select ____ as the entry in the Total row for the field to be used for grouping.

=HS or =COM or =UNI

To indicate that the only allowable values for the Customer Type field are HS, COM, and UNI, enter ____ in the Validation Rule property box.

AS

To name a computed field, follow the computation with the word ____ and then the name you wish to assign to the field.

HAVING

To restrict groups that appear in a SQL query, use the ____ clause.

DESC

To sort data in descending order, follow a sort key with the word ____.

ORDER BY

To sort the output of a SQL query, include the ____ clause in the SQL query statement.

square brackets [ ]

To use an item name that contains spaces, such as Amount Paid in a function, enclose the item name in ____.

true

When a name containing a space appears in SQL, it must be enclosed in square brackets. tf

entity

When creating a database, a(n) ____ is represented as a table.

caption

When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.

False

When you create a basic SELECT-FROM-WHERE expression in SQL, a list of table names follows the word SELECT.

ID

When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.

False

When you insert data in an OLE field, you always have to create a new object. You cannot insert an already created object in the field. t/f?

False

When you sort data, duplicates are not included. T/F?

Yes/No

Which of the following data types is the most appropriate for a field that indicates whether the customer participates in the preferred customer program?

True

Wildcards are symbols that represent any character or combination of characters. T/F?

combo box

With a(n) ____, you can enter a value either by typing the value or by selecting it from a list.

IN

You can use a(n) ____ clause with a list as an alternative to an OR criterion when the OR criterion involves a single field.

True

You can use forms to add records, delete records, or change records t/f?

primary key

the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.