Access 2.12(B) Review

A query within a query is called a(n)

• Simple Query
• Detailed Query
• Subquery
• Crosstab query

A Crosstab query displays the calculated results of two types of information: one going down the _____ and the other going across the _________.

• leftside, bottom
• rightside, top
• leftside, top
• rightside, bottom

SELECT[OpeningDate] FROM [Sales]
In the above SELECT statement, Sales represents a(n):

• Field
• Table
• Record

SELECT[OpeningDate] FROM [Sales]
In the above SELECT statement, OpeningDate represents a(n):

• Field
• Table
• Record

There are 2 parts to building an expression:
_____________:_______________

• Expression: FieldName
• FieldName: Record
• FieldName: Function
• FieldName: Expression

Discount: [Total]*.10
In the expression above, Discount is the ________

• Expression
• Record
• FieldName
• Formula

Discount: [Total]*.10
In the expression above, Total is a(n)________

• Field
• Expression
• Record

Discount: [Total]*.10
In the expression above, [Total]*.10 is the ________

• Expression
• Field
• Record
• FieldName

SELECT * FROM [Sales]
The * represents _____________

• All the records in a table
• All the fields in a table