ch09.htm

Microsoft_Access_97_Quick_Reference.zip

			is usually a primary key in one table and a foreign key in the second table.
			<H2><FONT COLOR="#000077"><B>K</B></FONT></H2>
			<P><B>key or key field</B> A field that identifies a record. Tables are indexed and
			sorted on key fields. Within a sort, the fields that determine sort order.
			<H2><FONT COLOR="#000077"><B>L</B></FONT></H2>
			<P><B>label</B> Text on a form or report that appears for every record. A label can
			be a title on the top of the form or attached to a control such as a text box identifying
			the contents of the control. Last Name: is an example of a label.</P>
			<P><B>linked table</B> Within a database a table whose data originates in another
			file. The file could be another Access file or a file from a different database application.</P>
			<P><B>list box</B> On a form or dialog box, a rectangular area that enables the user
			to choose one from a choice of many values. When the list of values is larger than
			the space provided, Access and Windows provide a scroll bar to see more of the values.</P>
			<P><B>lookup column</B> A combo box within a field of a table. By choosing Lookup
			Wizard in the Data Type column in Table Design View, you create a lookup column for
			the field.
			<H2><FONT COLOR="#000077"><B>M</B></FONT></H2>
			<P><B>macro</B> A stored list of commands that are automatically executed by Access.</P>
			<P><B>mail merge</B> The process of combining a list (usually of addresses) into
			another document (usually a letter or envelope).</P>
			<P><B>master</B> In Access, the main form or report. The subform becomes the child
			form. In the subform's properties, the Link Master Fields property is a field from
			the main form that links to the subform's field mentioned in the Link Child Fields
			property.</P>
			<P><B>memo</B> An Access data type that can hold a great deal of text (up to 64,000
			characters).</P>
			<P><B>merge field</B> Used to identify which category of data source information
			will be printed in its location.</P>
			<P><B>modal</B> A form (or dialog box) that keeps the focus until it is closed.</P>
			<P><B>modeless</B> A form (or dialog box) that can be minimized or can lose the focus
			to another form or dialog box. A pop-up modeless form remains on top of other forms
			yet allows you to input in the other forms.</P>
			<P><B>module</B> A collection of stored procedures. Modules are named on the Modules
			tab in the Database window. However, forms and reports also have modules associated
			with them. Form and report modules are also called class modules.
			<H2><FONT COLOR="#000077"><B>N</B></FONT></H2>
			<P><B>null</B> A field with no value. This is not the same as a 0 or a zero-length
			string. Use Is Null in the criteria grid of a query to find fields without an entry.
			<H2><FONT COLOR="#000077"><B>O</B></FONT></H2>
			<P><B>object</B> On one level in Access, the specific tables, queries, forms, and
			any other items listed in the Database window. On another level, anything that can
			be manipulated in Access including controls, procedures, and the database itself.</P>
			<P><B>Office Assistant</B> An on-screen, interactive program that provides tips and
			Help information, and also interprets what Help you might need based on your current
			actions.</P>
			<P><B>operator</B> A mathematical symbol (such as +) or logical keyword (such as
			AND) that is a part of an expressions.</P>
			<P><B>optimization</B> The process of improving the application's performance.</P>
			<P><B>option button</B> On a form or dialog box, a small circle that the user can
			click to turn on. Also called a radio button. A check box is usually associated with
			an option group but can also represent a Yes/No value.</P>
			<P><B>option group</B> On a form or dialog box, a group of controls where only one
			of them can be selected at once. Usually the controls inside an option group are
			option buttons but they can also be toggle buttons or check boxes.</P>
			<P><B>outer join</B> In an Access query, the link between two related tables, that
			returns all the records from one table and records from related fields that are common
			in both tables.
			<H2><FONT COLOR="#000077"><B>P</B></FONT></H2>
			<P><B>parameters</B> In an Access query, prompts for user input. In an Access procedure,
			variables that are supplied to the procedure from outside the procedure.</P>
			<P><B>permissions</B> In Access security, authority given to perform operations (such
			as read or modify) on a database object.</P>
			<P><B>pivot table</B> A feature that enables you to summarize and analyze data in
			lists and tables. Pivot tables are called such because you can quickly rearrange
			the position of pivot table fields to give you a different view of the table.</P>
			<P><B>PivotTable Wizard</B> An Access and Excel feature that automates the creation
			of a pivot table.</P>
			<P><B>primary key</B> The field (or fields) that uniquely identify a record in a
			table. You cannot have duplicate primary keys within a table.</P>
			<P><B>property</B> An attribute or characteristic of an object. Properties can define
			the appearance of an object (such as color) or what happens when the user performs
			an action on the object (such as click).
			<H2><FONT COLOR="#000077"><B>Q</B></FONT></H2>
			<P><B>query</B> In Access, an object that chooses and sorts selected records and
			fields from another query or table. A query can also modify a table (see action query).
			<H2><FONT COLOR="#000077"><B>R</B></FONT></H2>
			<P><B>record</B> The information in one row of a list or database.</P>
			<P><B>record locking</B> In a multiuser system, when one person is modifying a record,
			you can set the record locking properties to lock other users out of the record or
			to verify changes made when two users edit the same record at the same time.</P>
			<P><B>referential integrity</B> Rules between primary and foreign keys of tables.
			Referential integrity requires that every foreign key must have a related field in
			the primary table. Access accomplishes this through cascade delete and cascade update<I>.
			</I>If these properties are not set in the relationship window, Access will not allow
			deletions or updates of primary keys who have related records in a foreign table.</P>
			<P><B>relationship</B> Between two tables, the common field (or fields) that identify
			how they are connected.</P>
			<P><B>replication</B> The process of copying a database in more than one location.
			After the two (or more) databases are updated, changes can be propagated to both
			databases.</P>
			<P><B>report</B> An Access object used for printed output that details or summarizes
			records in a table or query.
			<H2><FONT COLOR="#000077"><B>S</B></FONT></H2>
			<P><B>sections</B> Divisions in a form or report that each have their own properties.
			Sections include the form or report header and footer, page header and footer, details,
			and in reports group headers and footers.</P>
			<P><B>self-join</B> In a query, a table that is related to itself by two different
			fields. For example, an employee table can include the ID of a manager who is also
			in the same table.</P>
			<P><B>SQL (Structured Query Language)</B> Pronounced &quot;sequel.&quot; A standard
			computer language used by many programs, including mainframes and client/server databases.
			The SQL used in Access is a subset of the available language. To see a SQL statement,
			choose SQL View on the View button while you are in Design View of a query.</P>
			<P><B>string</B> A data type used in programming that accepts text values.</P>
			<P><B>subform</B> A form that is inside a main form. Usually the subform displays
			in Datasheet View and many records can be related to the one in the main form.</P>
			<P><B>subprocedure</B> A procedure called from within another procedure.</P>
			<P><B>subqueries</B> A query that is used within another query. This can be where
			the second query was created using the first as the data source or where a SQL statement
			is typed in a criteria cell.</P>
			<P><B>subreport</B> A report that is inside another report.</P>
			<P><B>syntax</B> The rules for writing functions or programming statements. For example,
			you need to include parentheses with the Sum function and include a field name in
			the parentheses. If the field name includes a space, you must surround the field
			name with brackets.
			<H2><FONT COLOR="#000077"><B>T</B></FONT></H2>
			<P><B>tab order</B> The order of the fields on a form accessed when you press Tab
			or Enter.</P>
			<P><B>table</B> The primary building block within a database where data is actually
			stored. You must have at least one table before you can create a query, form, or
			report.</P>
			<P><B>text box</B> On a form or dialog box, a rectangular area where the user can
			type an entry.</P>
			<P><B>toggle button</B> On a form or dialog box, a rectangular button that appears
			pressed or unpressed. A toggle button usually is attached to a Yes/No field or is
			part of an option group.</P>
			<P><B>Toolbox</B> In form and report design, a toolbar that contains buttons for
			adding controls such as check boxes, combo boxes and text boxes to the design.
			<H2><FONT COLOR="#000077"><B>U</B></FONT></H2>
			<P><B>unbound</B> On a form or report, data that is not connected to a particular
			record in a table. The most common unbound control is a label but you can also have
			graphics such as a logo on your form or report as well.</P>
			<P><B>union query</B> A query that combines two tables with multiple common field
			names. The union query is most often used with a history table and a current table
			where the field names correspond to each other. The two tables remain in separate
			locations but the Datasheet View of the union query shows the records from one table
			below the other.
			<H2><FONT COLOR="#000077"><B>V</B></FONT></H2>
			<P><B>validation</B> A rule for correct data entry within a series or range of acceptable
			values. If a field's Validation Rule is broken, the Validation Text appears in a
			message box to the user.</P>
			<P><B>variable</B> The name given to a symbol that represents a value that can be
			a string, number, or Access object. The value of a variable can change during program
			execution.</P>
			<P><B>VBA (Visual Basic for Applications)</B> The programming language provided with
			Access, Excel, Word, and PowerPoint.
			<H2><FONT COLOR="#000077"><B>W</B></FONT></H2>
			<P><B>wild card</B> A symbol that can represent one or more characters. You use the
			* wild card to represent multiple characters in the criteria row of a query.</P>
			<P><B>workgroup</B> In Access, a group of users that are part of the same security
			file who share database files. The names of the users and their passwords are stored
			in the workgroup file (the default is SYSTEM.MDW).
			<H2><FONT COLOR="#000077"><B>Y</B></FONT></H2>
			<P><B>Yes/No field</B> A field data type that can accept one of two responses such
			as Yes/No, True/False, or On/Off.
			<H2><FONT COLOR="#000077"><B>Z</B></FONT></H2>
			<P><B>zero length string</B> Also called empty string, a zero length string indicates
			no data and is entered with two double quotes with no space between them(&quot;&quot;).
			A zero length string generally represents that you know that there is no value for
			the field. This is contrasted with the null value where the value could be unknown.
		</TD>
	</TR>
	<TR>
		<TD WIDTH="80"></TD>
		<TD WIDTH="520">
			<P ALIGN="CENTER"><A HREF="index.htm"><IMG
			SRC="../buttonart/btoc.gif" WIDTH="41" HEIGHT="41" ALIGN="BOTTOM" ALT="TOC" BORDER="0"
			NAME="toc8"></A><A HREF="ch08.htm"><IMG
			SRC="../buttonart/bback.gif" WIDTH="41" HEIGHT="41" ALIGN="BOTTOM" ALT="BACK" BORDER="0"
			NAME="toc6"></A><A HREF="index.htm"><IMG
			SRC="../buttonart/bhome.gif" WIDTH="41" HEIGHT="41" ALIGN="BOTTOM" ALT="HOME" BORDER="0"
			NAME="toc5"></A><BR>
			<BR>
			<IMG SRC="../buttonart/corp.gif" WIDTH="284" HEIGHT="45" ALIGN="BOTTOM" BORDER="0"></P>
			<P><BR>
			<FONT COLOR="#000000">&#169;</FONT><A HREF="copy.htm"><FONT COLOR="#000000">Copyright</FONT></A><FONT
			COLOR="#000000">, Macmillan Computer Publishing. All rights reserved.</FONT>
		</TD>
	</TR>
</TABLE>



</BODY>

</HTML>