Shared Flashcard Set

Details

Access 2007
chapters 5,6,7,8,9
33
Business
10th Grade
03/12/2009

Additional Business Flashcards

 


 

Cards

Term
form
Definition
a database object you can use to enter, edit, or display data from a table or query.
Term
filter
Definition
displays data that have met the criteria that you have specified.
Term
Report wizard
Definition
guides you through a series of questions and then generates a report based on your answers.
Term
sort
Definition
organizes data in a particular order
Term
clear all sorts
Definition
removes all sort orders
Term
report
Definition
a database object that is used to organize and display data from tables and queries.
Term
record source
Definition
the table or query that provides the data used to generate a report.
Term
Auto format
Definition
a predefined format that you can apply to any report in layout view.
Term
Detail
Definition
section of a report that includes the body of the report
Term
field list pane
Definition
a list of available fields for adding to a report
Term
design grid
Definition
the way a report is displayed in design view
Term
Control layouts
Definition
layouts that align controls horizontally and vertically to give your report or form a unique appearance
Term
stacked layout
Definition
controls that are arranged vertically with a label on the left and the control on the right
Term
tabular layout
Definition
a layout in which the controls are arranged in rows and columns, with labels across the top.
Term
conditional formatting
Definition
means to change the appearance of a control or the value in a control when certain conditions are met.
Term
calculated control
Definition
a control that displays the result of a calculation or expression
Term
Expression builder
Definition
provides the names of the fields and controls in a database, lists the operators available, and has built-in functions to help you create an expression
Term
bound control
Definition
a control that uses a field as the data source
Term
control wizard
Definition
helps you create controls such as command buttons, list boxes, combo boxes, option groups.
Term
controls
Definition
an object that displays data, performs actions, and lets you improve the look and usability of a form or report
Term
unbound control
Definition
a control that doesn't have a source; it displays information such as lines, shapes, or pictures
Term
query criteria
Definition
a rule that identifies the records that you want to include in the query result.
Term
recordsource
Definition
the tables or queries from which a query gets its data
Term
field list
Definition
a window that lists all the fields in the underlying record source or database object.
Term
parameter query
Definition
the user interactively specifies one or more criteria values
Term
table analyzer
Definition
a wizard that performs normalization process for you by examining a table and suggesting a way to divide the table for maximum efficiency
Term
Aggregate functions
Definition
functions that calculate values across a range of data, such as in a column
Term
Totals row
Definition
a row inserted at the bottom of a table that provides a menu of functions for each column
Term
select query
Definition
most basic type of access query. creates subsets of data you can use to answer specific questions or to supply data to other database objects.
Term
form tool
Definition
tool used to create a simple form
Term
filter by form
Definition
filter you use in a form when trying to find a specific record
Term
form design button
Definition
button used to create a new blank form in the design view
Term
Common Filters
Definition
built into every views that displays data
Supporting users have an ad free experience!