Access
unbound control
a control that is not linked to a field
forms
allow users to input data through a friendly interface. Easier than entering it directly into a table
lookup field
allows the user to select data from a list of items
variance
calculates the statistical variance for numeric field types only (number, decimal and currency)
macros
collections of programming code usually used within forms and reports
attribute or field
column in Excel
split form
combines convenience of a continuous data sheet with the usability of a single form displaying one record at a time
reports
display database information for printing or viewing on screen
calculated field
displays a value returned by an expression (a formula)
select query
displays data from one or more tables or queries based on the fields that you select, but it does not filter the data
bound control
displays the field data
queries
extract data form a table or related tables
layout view
looks similar to form view, but this view allows you to maniuplate the layout and formatting of the form while viewing "live" data
layout view
looks very similar to report view and allows you to manipulate the layout and formatting of the report while viewing "live data
list box
presents users with a list of options to choose from and can display values from another table or query or values that you enter yourself
form view
provides a user-friendly interface for entering data
command button control
provides a user-friendly way to interact with the form
combo box control
provides users with a combo data entry control; users can type the data in a text box or select from a list of items
record
row in excel
report view
shows a static view of the report
SQL view
shows the code used to build the query
datasheet view
shows the record set that matches the query criteria
tables
store all the database data, basic building blocks of the database
primary key
the field that contains data unique to that record
one-to-many relationship
the primary table contains a primary key field that is included as a field (the foreign key) in the secondary table
navigation form
type of form that allows you to group together all the database objects a user might need within a single form
datasheet view
use when entering data in a table or to sort and filter data
calculated data type
uses an expression to calculate a value
design view
when you want to change the structure or properties of the table
image control
where photograph/illustration/graphic is stored
design view
where you build the query, adding fields and specifying criteria