In Microsoft Access,standard SQL Table Creation Syntax Items Not Supported

question 45

Multiple Choice

In Microsoft Access,standard SQL table creation syntax items not supported by Access SQL can generally be implemented by ________.

• A) setting the Data Types in Access table Design View
• B) setting the field properties in Access table Design View
• C) setting the relationship properties in the Edit Relationship dialog box
• D) setting the referential integrity properties in the Edit Relationship dialog box
• E) running an ALTER TABLE query in Access SQL

---

Definitions:

Fixed Overhead Variance

The difference between actual fixed overhead costs and the expected (or budgeted) fixed overhead costs.

Volume Variance

A financial term that represents the difference between the expected (budgeted) volume of production or sales and the actual volume achieved.

Spending Variance

The difference between the budgeted or planned amount of expense and the actual amount spent.

Variable Overhead Spending Variance

The difference between the actual costs incurred for variable overheads and the expected costs of variable overheads based on standard cost.