McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Glossary
Data Files
Buzz in IT
Feedback
Help Center


Advantage Series MS Office XP Access 2002
Advantage Series: Microsoft® Access 2002
Sarah Hutchinson-Clifford
Glen Coulthard


Glossary

Access data project  A special type of Access database file that enables you to work with data stored in a server-side database engine such as the Microsoft Data Engine (MSDE) or SQL Server. An Access project contains the front-end components (including forms, reports, macros, and modules) of a client/server database application.
action query  An Access query object that performs mass changes to the data it retrieves from one or more tables. There are four types of action queries: update, delete, append, and make table.
actions   In defining a macro, the command activities that you perform such as opening and closing forms.
ActiveX controls   Re-usable program components or objects that provide some functionality; for example, calendar applications, Internet connectivity, and interface elements.
ActiveX Data Objects (ADO) models   The recommended data architecture for Microsoft Access; provides common objects for accessing data stored in a variety of database engines including JET and SQL Server.
Application window  In Windows, each running application program appears in its own application window. These windows may be sized and moved anywhere on the Windows desktop.
arguments   In the Macro window, the properties or parameters that you enter to control how a macro action executes.
AutoExec macro  A special macro object that Access executes automatically when a database is first opened. To stop the AutoExec macro from running, hold down the Shift key as the database opens.
AutoFormat  A software feature that applies professionally designed formatting styles to your documents.
AutoForm Wizard  An Access wizard that creates a form automatically, using all of the fields from the selected table object in the Database window. There are three types of AutoForm Wizards: Columnar, Tabular, and Datasheet.
AutoLookup query   A type of query object that fetches data automatically from the "one" side of a table relationship for display with data from the "many" side.
AutoNumber  A field data type that provides a unique value for each record automatically. The three types of AutoNumber fields include sequential (incremented by 1), random, and replication. You cannot delete or modify the values generated for an AutoNumber field.
AutoPage Wizard  An Access wizard that creates a columnar data access page automatically based on the data stored in the selected table or query.
AutoReport Wizard  An Access wizard that creates a columnar or tabular report automatically, using all of the fields from the selected table or query object in the Database window. There are two types of AutoReport Wizards: Columnar and Tabular.
bitmap   Created by a painting program, a raster graphic file that is created and stored as a series of individual pixels or dots. Raster (bitmap) files are typically larger than vector (metafile) files. Some popular bitmap formats include BMP, GIF, JPG, PCX, and TIF.
bound controls  A control whose source of data is a field in a table or query. Bound controls are used to retrieve, store, edit, and display data.
breakpoint   In VBA code, a user-defined stopping point that interrupts a procedure's execution and displays the Visual Basic Editor.
business rules  Guidelines for how data is used by people in the real world. Business rules include the constraints, restrictions, or limitations imposed on a table or field when working with and using data. In Access, these rules are specified and enforced using field properties.
calculated controls  In a form or report, a control that evaluates an expression and displays a result.
calculated field  In a query, a field that evaluates an expression and displays a result in a dynaset Datasheet window.
Cell  In a datasheet, the intersection of a column (field) and a row (record).
child table  In a one-to-many relationship, the table containing foreign key values that match the values stored in the primary key field of the parent table.
class module   A collection of event procedures and code associated with a particular form or report object in Microsoft Access. General procedures and functions are stored in standard modules.
Code window  In the Visual Basic Editor, the window containing the procedure code; used for coding and debugging program statements.
coding   Developing and writing code manually from scratch.
collection   Object type that acts as a container for a set of similar objects.
column chart   A chart that compares one data element with another data element and can show variations over a period of time.
compound control  In a form or report, a bound text box control and its associated label control. These two controls are inserted and manipulated together as a single control.
concatenate  In Access, joining together data from separate fields using the ampersand “&” operator; combining characters, usually in a calculated field, to form a new string.
conditional formatting  The ability to format an object automatically based on whether an expression evaluates to true or false.
conditional logic  The method by which criteria statements are joined and executed in a query statement.
constants  Variables that do not change; typically used to reference values in your code using English-language terms, such as TAXRATE.
controls  Objects or elements of a form or report. Access supplies three types of controls: bound controls, unbound controls, and calculated controls. Typical controls include labels, text boxes, and command buttons.
control structures   Group of program statements that allows you to make decisions and direct the flow of executed instructions; two common control structures are "branching" and "looping."
crosstab query  An Access query object that summarizes a field’s values and presents the results in a spreadsheet-like table display.
Data Access Object (DAO) model   An older and firmly established data architecture; provides specific objects for accessing data stored in the Microsoft Access JET database engine.
data access page  A special type of Web page that is connected to a database and allows you to work with data through the Microsoft Internet Explorer Web browser.
Database  A collection of related data. In Access, a database includes a collection of objects—tables, queries, reports, forms, and other objects.
database management system (DBMS)  A software tool that lets you create and maintain an information database.
Database Splitter Wizard   In Access, a software feature that separates a database file into two databases-one containing table objects and the other containing everything else. The "data only" database is typically placed on a shared network server. The "interface only" database resides locally and uses linked tables to access data stored on the network server.
Database window  The control center for an Access database. Using the Objects bar, categorizes and lists the objects stored in a database.
Database Wizard  In Access, a software feature for creating a complete database application based on professionally designed database templates.
Datasheet  A window used for displaying multiple records from a table using an electronic spreadsheet layout of horizontal rows and vertical columns.
Datasheet view  The method or mode of displaying table data using a datasheet.
data source  In a mail merge, the variable data that is fed into a main document during the merge process.
debugging   A programming term that means locating errors in your VBA code and correcting those errors.
decrypting   The process of deciphering and returning an encrypted database to its original form.
delimiter   A symbol or character, such as a tab or quotation mark, that is used to separate fields or columns of information in a text file.
Design Master  In replication, the master database file that you use to create new replicas and to modify the database objects for a replica set.
Design view  Each database object in Access may be opened in display mode or Design view mode. You use Design view to define table structures, construct queries, build forms, and design reports.
Documenter  In Access, a tool for documenting and printing the design characteristics of a database object.
Dynaset  In Access, the result of a query. A dynaset is displayed as a table in Datasheet view of the records matching the query parameters.
embedding   A way of sharing data and exchanging information; refers to the process of inserting a source object into a destination container object, such as an Access form or report.
encrypting   The process of scrambling visually the contents of a database so that other software programs cannot view the data. The database is still accessible to Access, although usually at lesser speeds.
entity integrity  A general integrity rule for database design that requires primary key fields to contain unique values. Also, primary key values must not be empty, that is, contain null values or zero-length strings.
event   An action or reaction that occurs in Windows programming. You can code unique responses to events such as performing a macro or procedure whenever a button is clicked.
event-driven programming  Coding a program to respond to events that may occur such as clicking a button; uses objects, properties, and methods to describe elements, attributes, and actions.
event procedures   The macro or procedure code that is executed when a particular event occurs.
Exclusive mode   Describes the state of opening an Access database exclusively; other users on the network are prevented from opening the database at the same time.
expression  A combination of field names, mathematical operators, comparison operators, logical operators, and constants that produce a calculated result.
Expression Builder  In Access, a software feature that helps you build expressions by providing pick lists of table and field names, operators, and constants.
Field  A single item, or column, of information in a record.
Field Grid pane  In table Design view, the top portion of the window where you specify field names, data types, and descriptions.
Field header area  In an Access Datasheet window, the top frame or border area that contains the field names as column headings.
Field List window  In form Design view and report Design view, a window that displays the field names from the underlying table or query. Use the Field List window to drag bound text box controls for placement in a Form or Report window.
Field Properties pane  In table Design view, the bottom portion of the window where you specify field properties and characteristics..
field validation rule  An expression that evaluates to “True” or “False” when the user inputs or modifies a field value and then attempts to leave the field. If the entry violates the rule (result is “False”), the user is returned to the field and forced to correct the entry or cancel the operation. See also record validation rule and validation text.
Filter  The process or method of temporarily restricting the display of records in a table to those that match a particular search criterion or pattern.
Filter By Form  In Access, a command that returns a subset of records from a table matching a filter specification.
Filter By Selection  In Access, a command that returns a subset of records from a table matching the selected value in a datasheet.
Filter Excluding Selection  In Access, a command that returns a subset of records from a table not matching the selected value in a datasheet.
Filter For Input  In Access, a command that returns a subset of records from a table matching a filter specification that you enter in a right-click menu's text box.
flat-file database  A database system that is unable to meet the objectives of normalization and to successfully relate tables of records.
focus  The state of a control when it is selected. Focus refers to the active control on a form that will accept input or commands from the user.
foreign-key  A field that refers to the primary key field in another table.
Form  A database object used for displaying table data one record at a time.
Form Detail  In a form, the section that contains the bound controls for displaying data from a table or query.
Form Footer  In a form, the section that contains the items you want to display at the bottom of each form.
Form Header  In a form, the section that contains the items you want to display at the top of each form.
Form window  In Access, a window that displays a form object.
Form wizards  Access tools that simplify the process of creating a form.
Function procedure   In VBA, a procedure that typically performs a calculation and returns a value to the calling program.
Group Footer  In a report, the section that organizes a set of items for display and typically contains subtotals for printing after the group’s Detail section.
Group Header  In a report, the section that organizes a set of items for display and typically contains column headings for printing before the group’s Detail section.
Groups bar  The icon buttons appearing in the Database window that allow you to create custom groups and organize object shortcuts for managing a database.
HTML  An acronym for Hypertext Markup Language, which is the standardized markup language used in creating documents for display on the World Wide Web.
hyperlink  In terms of Internet technologies, a text string or graphic that when clicked takes you to another location, either within the same document or to a separate document stored on your computer, an intranet, or onto the Internet.
Immediate window  In the Visual Basic Editor, the window that you use to enter expressions for immediate calculation; you can also use the debug.print statement to send output from a procedure to the Immediate window.
Index  A feature of a table object that allows you to pre-sort a table based on key values. Indexes speed up searching, sorting, and other database operations. (Note: The primary key is indexed automatically.)
input mask  A combination of characters and symbols that are used to designate formatting placeholders for making data entry easier and less susceptible to error. Selecting or building an input mask is facilitated by the Input Mask Wizard.
Internet  A worldwide network of computer networks that are interconnected by standard telephone lines, fiber optics, and satellites.
keywords   Reserved words that hold special meaning for the VBA compiler and, therefore, cannot be used as a variable or constant name.
Label Wizard  An Access wizard that creates a mailing labels report based on the size, shape, and formatting of standard mailing labels.
Layout Wizard   In Access, a software feature that handles the connection parameters and other technical information required for creating a data access page.
line chart   A chart that plots trends or shows changes over a period of time.
Linked Table Manager   In Access, a software feature that enables you to verify and refresh the storage locations of linked tables in a database.
linking   A way of sharing data and exchanging information; refers to the process of establishing a dynamic link between a source object or database file that is stored on the disk and a destination container object such as an Access table, form, or report.
linking table  In a many-to-many relationship, the table that contains the primary keys from more than one primary table in order to establish a table relationship.
lookup field  A field that displays a drop-down list of acceptable values. A lookup field is populated by data stored in a list (Value List) or in a table (Lookup List). Creating a lookup field is facilitated by the Lookup Wizard.
macro   A set of actions that you store in a database object to automate repetitive procedures.
Macro Builder   In Access, a software feature that enables you to define a macro from an object's event procedure property text box.
macro group   The combination of two or more macros stored in a single database object.
mail merge  In word processing software, the process of combining main documents with data sources to generate form letters, mailing labels, envelopes, and lists.
Mail Merge Wizard   A series of dialog boxes that provide helpful tips for setting up a mail merge.
main document  In a mail merge, the document that contains the static information that remains the same for all merged documents.
main form  A form that acts as a container for a subform. A main form typically displays a single record (the one side in a one-to-many relationship) in a columnar or justified form layout.
main report  A report that acts as a container for a subreport. A main report typically provides the report header, footer, and summary information, while the subreport provides the details.
many-to-many relationship  In relational database design, the table relationship that exists when one record in table A is related to multiple records in table B, and vice versa.
margins  Space between the edge of the paper and the top, bottom, left, and right edges of the printed document.
MDE file   An alternative file format for saving Microsoft Access (MDB) database files. Saving a database as an MDE file compiles and then removes all VBA code in order to compact and protect the database.
metafile   Created by a drawing program, a vector or object-oriented graphic file that can be stretched and resized without loss of quality. Some popular metafile formats, which store graphics as dimensions and formulas, include CGM (computer graphics metafile) and WMF (Windows metafile format).
method   The actions that can be performed on or by an object, such as activate, open, and close.
Microsoft Data Engine (MSDE)  A fully SQL Server-compatible database engine for desktop database applications. The MSDE is primarily used with Access data projects in creating small-scale client/server applications.
Microsoft Office Web Components   Component objects of executable program code that allow you to view and interact with Microsoft Office XP data using the Microsoft Internet Explorer Web browser software.
normalization  In relational database design, the process of organizing fields and tables to reduce the duplication of data.
Null value  Nothing; an empty or zero-length string.
object model   A conceptual map for the hierarchical chain of objects that are exposed by an application.
Objects bar  The strip of icon buttons appearing in the Database window that allows you to display a particular category of database objects.
Office Clipboard  A program, in Microsoft Office, that allows you to copy and move information within or among Office applications. Unlike the Windows Clipboard, the Office Clipboard can store up to twenty-four items and then paste them all at once.
Office Links   In Office XP, automation tools that facilitate sharing data with other Office XP applications.
one-to-many relationship  In relational database design, the table relationship that exists when one record in table A is related to multiple records in table B, but one record in table B is related to only one record in table A.
one-to-one relationship  In relational database design, the table relationship that exists when one record in table A is related to one record in table B, and vice versa.
orientation  Describes how a page is printed. Letter-size paper with a portrait orientation measures 8.5 inches wide by 11 inches high, while a landscape orientation is rotated to measure 11 inches wide by 8.5 inches high.
Page Footer  In a form or report, the descriptive information (such as page number and date) that appears at the bottom of each printed page.
Page Header  In a form or report, the descriptive information (such as column headings and border lines) that appears at the top of each printed page.
Page View  The method or mode of displaying data using a data access page.
Page Wizard  An Access wizard that helps you create a data access page by selecting fields and then specifying grouping, sorting, and titling options.
parameter query  An Access query object that displays a dialog box and accepts input from a user prior to performing an operation. Parameter queries may be used to accept last-minute or runtime criteria entries for retrieving data.
parent table  In a one-to-many relationship, the table containing the primary key field that is used to establish and control the table relationship.
Partial Replica Wizard   In Access, a software feature that you use to create a replica containing only a portion of the complete data set.
password   A series of characters that you can use as a lock and key to restrict access to a database file. The best passwords combine letters, numbers, and special symbols, which makes them difficult to guess.
Performance Analyzer Wizard   In Access, a software feature that you use to analyze and optimize the performance of database objects.
pie chart   A chart that shows the proportions of individual components compared to the whole.
PivotChart view   A view mode that enables you to analyze and summarize large amounts of data using an interactive chart format.
PivotTable view   A view mode that enables you to analyze and summarize large amounts of data using an interactive table format.
Places bar  The strip of icon buttons appearing in the Open and Save As dialog boxes that allow you to display the most common areas for retrieving and storing files using a single mouse click.
Preview  The act of displaying on-screen a document, worksheet, or report prior to sending it to the printer. An on-screen preview window displays a soft copy of a document, while the printer prepares the hard copy.
Primary key  A field whose values uniquely identify each record in a table. The primary key provides the default sort order for a table and is used to establish connections to and relationships with other tables.
program statement   A line of code combining objects, properties, methods, variables, constants, symbols, and/or other elements to perform a task.
Project Explorer window  In the Visual Basic Editor, the window that displays the open project files, including form, report, and independent modules.
project file  In the Visual Basic Editor, a project file is a container for storing and organizing related or associated module objects.
Properties window   In the Visual Basic Editor, the window that displays property settings for the selected object(s); you can change an object's properties at design time using this window.
property  A characteristic or attribute of an object.
property   A characteristic or attribute of an object such as its name or color.
Query  A database object that you use to ask a question of your data. The results from a query are typically displayed using a datasheet.
query-by-example (QBE)  The process of querying a database in a visual mode by selecting field columns, choosing sort orders, and specifying record criteria.
Query Design grid  In query Design view, the bottom portion of the window where you specify the fields to display, enter criteria expressions, and specify sort orders.
Record  An individual entry, or row, in a table. A record contains one or more fields.
Record selection area  The row frame area located to the left of the first column in a datasheet. Used for selecting records.
record validation rule  An expression that evaluates to “True” or “False” when the user inputs or modifies field data and then attempts to leave the record. If an entry violates the rule (result is “False”), the user is returned to the record and forced to correct the entries or cancel the operation. See also field validation rule and validation text.
referential integrity  The rules that must be followed to preserve the validity of a table relationship. When enforced, these rules prevent you from entering a foreign key value until a primary key value already exists in the primary table. Furthermore, you may not delete or update a primary key value that has foreign key values in related tables.
relational database(s)  A database that is comprised of normalized tables linked via common fields.
replicas  In replication, a single copy of the Design Master database that can be used independently to add and modify data. A replica can be synchronized with other members in the replica set.
replica set  In replication, a group of replicas that share and synchronize to the same Design Master.
replication  The process of creating copies of a database for the purpose of working independently and to facilitate exchanging and synchronizing updates and database objects with other members in the replica set.
Report(s)  A database object used for viewing, compiling, summarizing, and printing information.
Report Detail  In a report, the section that contains the bound controls for printing data from a table or query.
Report Footer  In a report, the section that contains the items you want to display at the end of a report.
Report Header  In a report, the section that contains the items you want to display at the beginning of a report.
Report snapshot  A Windows graphic metafile that stores an accurate representation, including fonts, graphics, and colors, of each page in a report. You do not need Access installed on your computer to view a report snapshot. Instead, you can use the free Microsoft Snapshot Viewer to open, view, and print snapshots.
Report wizards  Access tools that simplify the process of creating a report.
scope   The level of visibility in which a procedure or variable operates. A variable's scope or visibility may be at the procedure level (private), module level, or macro level (public).
Select query  A type of query object that lets you ask questions of your database, retrieve data from multiple tables, sort the data, and display the results in a datasheet.
Simple Query Wizard  In Access, a software feature that simplifies the process of creating a query.
Sort key  The field or column used to sort the contents of a datasheet.
SQL  Abbreviation for Structured Query Language. A standardized database query language that is popular in client/server database applications. Using SQL, you typically enter language statements instead of making selections from a visual query-by-example (QBE) interface.
Subdatasheet  An extension of a datasheet that provides a picture-in-picture display of related or hierarchical data.
subform  A form that is embedded in a main form. A subform typically displays records that are related to the active record in a main form in a tabular or datasheet layout.
Sub procedure   In VBA, the default procedure type that is used to perform a series of instructions and to effect change on its environment.
subreport  A report that is embedded in a main report. A subreport provides the detail section for a comprehensive report that typically includes report headers, report footers, and other sections.
switchboard form  A form that acts as a main menu for a database application. A switchboard form displays command buttons that help users navigate among objects, procedures, forms, and reports.
Switchboard Manager  In Access, a software feature for managing the creation and customization of a switchboard form.
synchronize  In replication, the process of exchanging and updating the contents of objects between two members in the replica set.
syntax   In VBA code, the rules that each program statement must follow in order to execute properly.
Table  A database object used to collect and store data relating to a particular subject or topic.
Table Analyzer Wizard   In Access, a software feature that you use to analyze and normalize table objects in a database.
Table Wizard  In Access, a software feature that simplifies the process of creating a table.
tab order  The order in which text boxes and other bound controls are accessed when the user presses Tab. Shift + Tab reverses the tab order.
Task Pane  A toolbar-like window providing quick access to frequently used commands. By default, the Task Pane appears docked to the right side of the application window, but it may be displayed and hidden using the View, Toolbars menu command.
Toolbox window  In Design view, the window containing controls, such as labels, text boxes, and command buttons, that you can select for use in forms and reports.
Typeface  The shape and appearance of characters. There are two categories of typefaces: serif and sans serif. Serif type (for example, Times Roman) is more decorative and, some say, easier to read than sans serif type (for example, Arial).
unbound controls  A control that doesn’t have a source of data. Includes label controls and decorative graphic objects used to enhance a form or report.
Undo command  A command that makes it possible to reverse the last command or action performed.
upsizing   The process of converting a desktop database, such as an MDB database file creating in Microsoft Access, to a true client/server solution, such as SQL Server. Upsizing typically separates the data from the interface components (forms and reports.)
user defined functions   In VBA, a function procedure that you code to perform a calculation and return a result.
validation text  When a validation rule is violated, the text that displays in the warning dialog box. See also field validation rule and record validation rule.
variable   A temporary value or storage location in memory for data that can be adjusted and modified.
variant   The default data type in VBA that allows you to store any kind of data.
VB Script   A scripting language based on the Visual Basic language and designed for creating Web-based applications.
Visual Basic Editor  A special utility program for creating, editing, and managing VBA macros and procedures. See Visual Basic for Applications (VBA).
watermark   Text or a graphic that appears faded in the background of a form or report.
Wildcard characters  Special symbols that are used to represent other alphanumeric characters in search, filter, and query operations. You can use the question mark (?) to represent any single character and the asterisk (*) to represent any group of characters.
Windows Clipboard  A program, in Windows, that allows you to copy and move information within an application or among applications. The Windows Clipboard temporarily stores the information in memory before you paste the data in a new location.
World Wide Web  A visual interface to the Internet based on hyperlinks. Using Web browser software, you click on hyperlinks to navigate resources on the Internet.
XML  Abbreviation for Extensible Markup Language. XML is a structured markup language, similar to HTML, which is used for describing and exchanging data on the World Wide Web.
XY chart   A chart that shows how one or more data elements are related to another data element. Also called scatter plot diagrams.




McGraw-Hill/Irwin