Shared Flashcard Set

Details

Lesson 7 + Lesson 8
Vocabulary Words
20
Business
03/01/2009

Additional Business Flashcards

 


 

Cards

Term
Name Screen
Definition
Buttons, check boxes, toggle buttons
Term
option group wizard
Definition
contains sets of option
Term
values screen
Definition
set values of a button, box, or selected option
Term
store value screen
Definition

stores the value of the selected option.

 

stores the value to be used later to perform a task.

 

example: total, print, etc.

Term
options screen
Definition
determine types of controls wanted
Term
caption screen
Definition
can apple a title/header
Term
unbound controls
Definition

does not have a data source.

 

displays info such as lines, shapes, pictures.

 

example: titles, page #'s, logos.

 

not connected to a field.

 

displays important info in reports + forms.

 

example: titles, page #'s, dates.

Term
control
Definition

an object that displays data, performs actions, + lets one improve the look + usability of the report/form.

 

- 3 types:

bound.

unbound.

calculated.

Term
calculated controls
Definition

display calculated/values.

 

example: amounts ( $ ], totals, pricing ( $ ].

 

displays results of an expression or calculation.

 

expressions: ( + ], ( - ], *, sum, AVG ( average ], etc.

 

text boxes are most popular ways to use.

Term
Control Wizards
Definition

helps create controls:

 

command buttons.

list boxes.

combo boxes.

option groups.

 

ask questions about how you want the control to look + operate.

 

*controls wizards button - toggle used to activate ( start ], or deactivate ( stop ] wizards on controls that use them.

Term
conditional formatting
Definition
changes the appearencl or the value in a control when certain conditions are met.
Term
control layouts
Definition

alight your controls horizontally and vertically to give your report or form a uniform appearence.

 

two types:

tabular + stacked.

Term
stacked layout
Definition

arranged vertically, with a label on the left + the control on the right.

 

contained in one report or form section.

Term
tabular
Definition
controls are arranged in rows and columns like a spreadsheet, with labels across the top.
Term
control tab order
Definition
the order in which the selection moves from field to field.
Term

LESSON EIGHT

Query

Definition
a set of instructions used for working with data. Creating a query is like asking the database a question. Running a query performs these instructions and provides the answers. The results that a query returns can be sorted, grouped, or filtered. A query can also creat, copy, delete, or change data.
Term
select query
Definition
the most basic type of access query.
Term
recordsource
Definition
teh tables or queries from which a query gets its data.
Term
query criterion
Definition
a rule that identifies the reocrds that you want to include in the query result.
Term
parameter query
Definition
which the user interactively specifies one or more criteria values.