Define it 2
Friendly reminders
Don't get aggregated
Hello? Operator?
Puzzle Pieces
100
This gets information through asking questions
What is a query?
100
True or false: Changes to the structure are auto-saved
What is false
100
This element updates primary keys on related tables
What is cascade update related fields?
100
This operator finds criteria between two values
What is between... and
100
Use this to connect two tables by their like fields
What is join
200
This organizes data in a table
What is a report?
200
How many bytes in an integer?
What is 4?
200
Do this to avoid parallel conditions in aggregate functions?
What is repeating the conditions for each object?
200
This operator combines conditions
What is In()
200
A combination of items from one table with another
What is Cartesian Product
300
This view looks at and changes the data
What is datasheet view?
300
How many bytes in a long integer?
What is 8?
300
This function combines information into a unit
What is the aggregate function
300
Which operator holds single quotes around strings?
What is In()
300
I forgot this, so a Cartesian product gave me back EVERYTHING.
What is a relationship?
400
This view looks at and changes the structure
What is design
400
This element connects data
What is a relationship?
400
This option makes subtotals possible in aggregate functions
What is group by
400
Which operator matches a pattern that includes wildcards?
What is Like
400
This allows you to specify which item you wan when you are running a query
What is a parameter
500
This is an embedded link to a webpage
What is a hyperlink
500
This element keeps a product from pointing to a nonexistent vendor
What is referential integrity?
500
In aggregate functions, each line contains this type of condition
What is "or"?
500
This operator returns the opposite of the results
What is not
500
This prevents new data from being bad
What is an input mask?
M
e
n
u