Details Title: Access 2007 Description: chapters 5,6,7,8,9 Total Flash Cards: 33 Created: 03/12/2009 14:36:41		New Users: To study from this flashcard set, or to create your own your own study flash cards, REGISTER HERE. Existing Users: CLICK HERE. Additional Business Flashcards
Cards in this set: 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