Shared Flashcard Set

Details

Lesson 7 + Lesson 8
Vocabulary Words
20
Business
10th Grade
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.
Supporting users have an ad free experience!