Term
|
Definition
| Buttons, check boxes, toggle buttons |
|
|
Term
|
Definition
|
|
Term
|
Definition
| set values of a button, box, or selected option |
|
|
Term
|
Definition
stores the value of the selected option. stores the value to be used later to perform a task. example: total, print, etc. |
|
|
Term
|
Definition
| determine types of controls wanted |
|
|
Term
|
Definition
|
|
Term
|
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
|
Definition
an object that displays data, performs actions, + lets one improve the look + usability of the report/form. - 3 types: bound. unbound. calculated. |
|
|
Term
|
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
|
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
|
Definition
| changes the appearencl or the value in a control when certain conditions are met. |
|
|
Term
|
Definition
alight your controls horizontally and vertically to give your report or form a uniform appearence. two types: tabular + stacked. |
|
|
Term
|
Definition
arranged vertically, with a label on the left + the control on the right. contained in one report or form section. |
|
|
Term
|
Definition
| controls are arranged in rows and columns like a spreadsheet, with labels across the top. |
|
|
Term
|
Definition
| the order in which the selection moves from field to field. |
|
|
Term
|
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
|
Definition
| the most basic type of access query. |
|
|
Term
|
Definition
| teh tables or queries from which a query gets its data. |
|
|
Term
|
Definition
| a rule that identifies the reocrds that you want to include in the query result. |
|
|
Term
|
Definition
| which the user interactively specifies one or more criteria values. |
|
|