Transcript JEOPARDY

This is Access
JEOPARDY
Database
Concepts
Filters and Forms and
Pot Pourri
Queries
Reports
Tables
100
100
100
100
100
200
200
200
200
200
300
300
300
300
300
400
400
400
400
400
500
500
500
500
500
This is an object that Access
uses to store information and is
comprised of a group of
records.
This is the database object that
provides an easy-to-use data
entry screen.
Reports are created from either
a table or this.
This is a particular type of field
that uniquely
identifies/distinguishes each
record in the table.
There are two main types of
database systems. If a
database is not a Flat File, then
it must be this. (Also, what
Access is.)
These are the two types of table
views.
When you are in Table Design
View, this is a fast way of setting
a primary key.
This is the button you click on to
insert or add a new record to the
table.
This is how you resize a column
or row in a table.
In Table Design View, this is how
you control what type of data will
be entered in a field.
This is the type of filter that is
able to be saved as a query.
This is the main difference
between a filter and a query.
This is how you would quickly
include all fields in a query’s
results.
This is an example of a
comparison operator used in a
query.
When searching for data items,
this is what you use if you are
not sure of the spelling of a
word, or name.
This is the fastest way of
creating a basic, standard, Form
or Report that automatically
includes all fields from a table or
query.
These are the characteristics of
a control on a form or report.
When entering a calculated field
in a form or report (or query),
these are what you must have
around each field name.
This is what a Lookup field/dropdown list is called in a form or a
report.
This is what an object on a form
or report is if it is tied back to a
field in a table or query.
This is why you use
relationships in a database.
This is the name of the toolbar
button that you use to export a
selected table to Microsoft Word
or Excel.
This is an internet form created
to input and/or view data in an
Access table query.
When a primary key references
a field of the same name or
containing the same data, the
field being referred to is called
this.
This is the colour of your
instructor’s pants.