How can we help?

You can also find more resources in our Help Center.

63 terms

Access

STUDY
PLAY
backup
or copy
button
a graphic icon that can be clicked to perform a specific task
command
controls that tell the computer to perform a particular task
criteria
conditions
database
an organized way to store info so that it is easy for the computer to search for information
default
a setting that a program automatically selects if you do not specify a substitute.
dialog box
used to enter specific information to perform a task
field
one peice of data,such as a customers name in a database
folder
help you organize various databases so you can find them quickly
group
an organized set of commands that relates to a specific activity
pointer
the arrow used to select on screen items,
query
asks access to find data from one or more tables
QAT
a toolbar that allows users to quickly find commands
record
made up of fields related to one particular item in the table
ribbon
a panal in microsoft office that organizes commands into tabs
scroll bar
allow you to see all the data in a table
shared access
..., a shared page
tab
a clickable area of the ribbon that displays menu options
table
contains columns and rows
title bar
ther bar at the top of the screen that displays the name of the current window
compare
or measure
control
`an object opn a form or report that displays data
data
factual info used as a basis for reasoning, discussion, or calculation
function
a lists of preset formulas tht are used to solve equations
database template
you can search both access and online to find the appropriate styl
design view
to design tables
property
as the number of characters
data type
whether it represents a date/time
primary key
ensures that each record is unique
totals row
function offers and quik and simple way top summerize columns of data in a tble to get totals, averages, maximums, minimums, and other calculations
control
or object that displays data or performs an action
property sheet
the field properties in a list
table analyzer wizard
the wizard can analyz, the info. in a tble and them make changes to streamline the data
caption
or column reading
lookup field
which will contain all the possible data choices for the field
attachment field
useful for linking to a database files and other objects that might not fit into one field
input mask
allows you to specify how you want information such as zip codes and phone numbers to be formatted in your database
relationship
is a link between two tables based on a common field
referntial integrity
makes sure taht the related data in two tables always exists and is complete
crosstaquery
shows summary data for data grouped by two fields
unmatched query
finds records without matching related data
duplicatequery
finds multiple records that contain the same data in a field
split form
contains a datasheet in one half and a form in the other
subform
is a form that is inserted into another form
pivottable
can display much more data and present it in several different ways
layout view
to see how your data will look when printed
group header
helps further refine reports by sorting information into helpful groups
aggregate functions
gunctions that can be gathered together
autoformat
formats other existing databases like the one you copied from
normalize
make sure it is structured correctly and that there are no repeated groups of info
parameter
value
inner join
tells the query to return only those rows from one tabnle and only the rows from the othre table that match
left-outer join
inbcludes all the rows from the first table
right outer join
includes all the rows from the second table
alias
is an alternative name givin to a table or field in an expression
chart
a graphic that organizes data visually
documenter
a tool that reports the characteristics of database objects and their parts
encrypt
to use a password to add security to your data
object dependency
refers to the fact that a database object that uses second database object is dependent on the second object
password
a string of characters used to encrypt a database
preview
an onscreen sample of a page from a form or report
quick print
a print options that prints the report right away without opening the print dialog box
union query
a query that merges data from seperate queries into one query