Qbe 2

How does Access save the criterion in the query grid of query design view?

"Consulting"

one to many relationships, how can you tell which table is the "many" table?

An infinity symbol identifies the Many table

what default field name does Access use for the column with the calculations?

AvgOfBonus

how can you omit the rating field from the query results but use it to set a criterion for the query

Clear the checkmark from the field ratings field's show check box.

how do you add the total row to the query in design grid?

Click the totals button on the query tools design tab

when you can determine the value of a field using information from existing field in a record in a query, you would create a ____?

Compute field

A ______ in a record is a result of a calculation using data from the rest of the record.

Computed field

which of the following access functions can you use to return the number of records in a group of records

Count

which calculates the numbers of days between todays date and a field name DueDate?

Date()-[DueDate]

____ query removes all the records from the selected tables that satisfy the criteria entered in the query

Delete

which of the following is a technique for increasing the speed of Access queries?

Delete field lists that are not needed for the query

what type of query could you run to remove records with a product ID of 702 from the products table?

Delete query

which of the following fields would be the best candidate for a primary key field in a table of employee data

EmployeeID

in the Access QBE, where do you specify criteria for the query =

In the criteria row of the query design grid

How are aggregate function diff from other types of functions?

Make calculations on groups of records.

Create a computed field name MonthlySalary using a value from the salary field

MontlySalary: [Salary]/12

if you want to be able to enter different criteria each time you run a query, create a _____ query.

Parameter

In access, what uniquely identifies a row in a table?

Primary Key

if u are sorting records by more than one field, which field is the first field that is evaluated for the sorting purposes?

Primary sort key

arrange field left to right

ProductID, Category, Description

Which command is used to identify certain columns?

Project

which creates a new table name CustState containing the field CustomerNum and State?

Project Customer Over(CustomerNum, State) Giving CustState

A ______ is a question about the data structured in a way that DBMS can recognize and process

Query

which command would list all information from the table using the customer with numeric CustomerNum 260

SELECT customer Where CustomerNum=260 GIVING answer

which command retrieves rows from a table based on specified criteria

Select

in a Access query, how can you lists all records in A-Z order by lastname?

Set in ascending sort order on the LastName field

which aggregate function do you use to total the values in a numeric field in a group of records?

Sum

which database term refers to a row in a table?

Tuple

which of the following is NOT true about a relation, otherwise known as a two-dimensional table

Two or more columns can share the same name

what type of Access query creates a new table using the query results?

make-table

the field you use to sort records is called the ____

sort key

what type of Access query changes data?

update

if you use _________ criteria, each criterion must be true for a record to be selected

AND

you can create a compound criteria (conditions) in a query by using which of the following two keywords?

AND, OR

what happens when you run a select query in Access?

Access selects current data from underlying tables

what do you call the field used to join two tables on the "many" side of a one-to-many relationship?

foreign key field

which of the following criteria selects all records containing a value greater than 250

>250

what should be in place before you select fields from more than one table in Access query design view?

The tables should be related in a proper one-to-many relationships.

adds 10 percent to the UnitPrice field, how do you enter the UnitPrice field name in the expression?

[UnitPrice]

what type of functions are count, sum, avg, max, and min?

aggregate