access
microsoft access
DBMS
count records
a calculation option
between
a comparison operator in an expression
unbound
a form that contain no data but has buttons that perform different actions is referred to as
property sheet
a place to change a control width or height
template
a pre-designed database that contains various pre-built objects is called a
tables
access is a relational database, which means that the data are organized into a collection of related
functions
access provides a variety of pre-built procedures that perform specific tasks and are called
field
access, a collection of numbers and/or characters that describes one aspect of a business onject or activity is called a
form
an access object you can use to create an interafce to easily view, add, update, and delete data in a database is called a
caption
an alternative to a field name
report
an object you can use to create an organized and professional output of the data is called a
arrange
click this tab to move a control in a report from one part of teh layout to another
long text
data type with > 255 characters
macro
database object that allows you to write and attach code to objects and controls
datasheet
default view for a new access database
compact and repair
deletes temporary data objects and removes corrupted data
metadata
descriptions of data fields and their formats
lookup field
display a list of data values from which the user can choose
table
each major subject or grouping of information you will store in your database should have a seperate
blank report button
enables you to create a new report from scratch using layout view
input mask
enforces data format data integrity rules
referential integrity
ensures records in assocaited tables have consistent data
64 characters
field name limit
count
finds the total number of records with a value in the field
total row
found in a summary query
gridlines
frames for rows and columns
row selector
gray box to the left of the field name in design view
-1
how does access store a "yes" response for the yes/no data type
widen the column
if any of your database columns display the ##### symbols, you need to
columns
if the fields of a report take up less than half of teh page width, select this button in the page layout group to print teh report in multiple columns
warns that data integrity rules have changed
if you change the required property of a field from no to yes, access
compund criteria
if you need to find both a particular type and a price, you can do this through
primary key
in a database, the special field that contains a unique value for each record is the
controls
in access, the fields, labels, buttons, and so forth are all known as
select query
in access, the most common type of query is a
query design
in access, the most common way to create queries is with
layout view
in this view, you can alter the design of a form and see the effects of teh changes in real time
design grid
indicates which fields have been included in the query
bound forms
object that links with a data source
stacked
on eof two primary control layouts
external data
one of five main ribbon tabs
F12
opens save as dialog box
F12
opens save as document
Ctrl+F2
opens the expression builder dialog box
AND or OR
operators that allow you to create a query using multiple criteria
application parts
pre-built components that can be added to an existing database
functions
pre-built procedures that perform a specific task
template
pre-designed database
move all fields button
quickly include all of the fields of a form
ctrl+spacebar
selects current column
unique values
set the following property in order to have access evaluate the fields in the query and avoid including duplicated values
F5
switched to form view
objects
tables and forms are examples of database
field name: expression
teh formula calculated field is in which of the following formats
foreign key
the field in common between two tables is called the
append row
the last row in an access table is called the
255 characters
the maximumm size of a short text field is
metadata
the overall descriptions about what the different data fields represent and their formats is called
required
the property which specifies that a user must enter a value in a field is called
command button
this control is used to perform an action such as close form, open form, delete record, etc.
report wizard
this convienient access feature steps you through the process of quickly creating a report
split form
this form option lets you view data in two layouts on the same form by combining both a columnar display and a datasheet layout
like comparison
this operator can help you find records containing data that is similar to the criterion value
tabular
this report layout displays the fields in a table (row and column) format
header/ footer
to add a date and time to your report, go to
print preview
to ensure that your report prints as desired, review it in
conditional formatting
to help focus your viewer's attention to certain records in a report, use
sorting
to make the data contained in a report easier to read and understand, a good option is
run
to see the results of a newly created query, you need to click
intelli sense
tools that suggests a list of possible values
many-to-many
type of relationship between tables
new values
use this property for an autonumber field to select either sequential or random
preview
used to see how a table will print
insert a new row in the field list
using design view, which of the following must you do before adding a field between existing fields
data validation
verifies teh accuracy of the data
intelli sense
when entering a citerion expression, which of the following tools suggests a list of possible values
the first row of the excel file must contain the field names from the access table
when importing data records from excel, which of these must be true
wildcard character
when used in an expression, the asterick (*) represents any string of characters and is also called a
in ascending order
when you first open a table in datasheet view, access uses the first field to sort the data records
field validation rules
when you limit entries to a certain range of values or make sure entries match a specified format, you use
design view
when you need to change field properties in an existing table, open
form
when you need to create an interface to view, add, update, and delete data in access, you should use a
field data type
when you set properties, the available properties vary based on the
design grid
when you want to add fields to a query that you have created, put the fields into the
design view
when you want to create a new table from scratch in your database and change field and table properties, use
filter
when you want to view only certain database fields such as product type, use this function
append row
where a new record is added
datasheet view
where the query results are displayed
primary key
which of the following contains a unique vlaue for each record
text box
which of the following displays the contents of a field and also allows the user to type a value into that field
query
which of the following finds data in your database by allowing you to ask a question
rich text
which of the following is a special text format applied to a long text data type that allows you to store formatted text
datasheet view
which of the following is used to enter records into a table
format property
which of the following properties indicates the way a field displays in a table
parameter query
which of the following requires you to enter the specific criteria value when you run the query
[ ]
which of the following symbols must you see when definign a parameter query
create
which of the following tabs do you use to create a query
expression
which of these should be used to write a criterion for a query
hierarchy of data
you need to design a new access database. the first step is to organize the smallest to largest data, also called