The _____ determines what field values are allowed and what other properties the field will have. DATA TYPE
You can specify a name for a table after you click the ___button on the Table Design toolbar. SAVE

The final step in the creation of a table is to save the table ___ to disk. STRUCTURE
A primary key ___. UNIQUELY IDENTIFIES EACH RECORD IN A TABLE
When designing a database, you need to identify the ___that will be required. FIELDS
Storing the same data field in multiple tables is called data ___. REDUNDANCY
A primary key that consists of more than one field is called a ____ key. COMPOSITE
When designing a new database, it is a good idea to ____. AVOID DATA REDUNDANCY
When defining a database, the name given to a table or other object should reflect its ___. CONTENTS
The ___determines what type of values can be entered for a field. DATA TYPE
When defining a field, the field ____determines how much physical storage space the field requires. SIZE

A field that consists of integer values that are controlled by Access is a ___type field.  AUTO NUMBER

You can include a graphic file in an Access database by defining a field of type ____. OLE OBJECT
Which view would you select if you wanted to define a table yourself from start to finish? DESIGN VIEW
To begin creating a new table, click the ___tab on the Ribbon. CREATE
Values for field properties other than Field Name, Data Type, and Description are entered in the ____portion of the Table window in Design View. FIELD PROPERTIES PANE
After all primary key fields have been selected, you must click the ___to complete the key definition. PRIMARY KEY BUTTON IN THE TOOLS GROUP ON THE TABLE TOOLS DESIGN TAB

You can modify an existing table's structure in _____. DESIGN VIEW
In design view, you can change the order of defined fields in a table by using the ____ to drag the field to a new location. MOUSE When you change a field's property in Design view, you can use this button to update the corresponding property on forms and reports that include the field you've modified. UPDATE & PROPAGATE
Tom is debating with himself about the format for the Donation Value field. What is the best reason to change the default currency data type format? ALL OF THE ABOVE
Emma is setting up referential integrity in the database. Why would she not include the cascade delete option? ALL OF THE ABOVE
Using _____, you give Access an example of the information you are requesting; Access then retrieves the information that precisely matches your example. QBE
___ tables are separate tables but you can use the data in them as if they were one table. JOINED
___ fields can be unique or non-unique. FOREIGN KEY
Operators used in selection criteria in a query, such as equal, not equal, or greater than, are known as __ operators. COMPARISON

Generalized queries that specify fields and records to be selected are called __ queries. SELECT