📄 ch09.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Symantec Visual Page 1.0">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html;CHARSET=iso-8859-1">
<TITLE>Ch 9 -- Glossary</TITLE>
</HEAD>
<BODY BACKGROUND="../buttonart/bg1.gif" BGCOLOR="#FFFFFF">
<P>
<TABLE BORDER="0" WIDTH="600">
<TR>
<TD WIDTH="80" VALIGN="TOP"><IMG SRC="../buttonart/que.gif" WIDTH="75" HEIGHT="24" ALIGN="BOTTOM" BORDER="0"><BR>
<BR>
<A HREF="index.htm"><IMG
SRC="../buttonart/toc.gif" WIDTH="40" HEIGHT="40" ALIGN="BOTTOM" ALT="TOC" BORDER="0"
NAME="toc4"></A><BR>
<A HREF="ch08.htm"><IMG
SRC="../buttonart/back1.gif" WIDTH="40" HEIGHT="40" ALIGN="BOTTOM" ALT="BACK" BORDER="0"
NAME="toc1"></A><BR>
<A HREF="index.htm"><IMG
SRC="../buttonart/home.gif" WIDTH="40" HEIGHT="40" ALIGN="BOTTOM" ALT="HOME" BORDER="0"
NAME="toc3"></A></TD>
<TD WIDTH="520" VALIGN="TOP">
<H2><FONT COLOR="#000077">Microsoft® Access 97 Quick Reference</FONT></H2>
<P>
<H1 ALIGN="CENTER"><FONT COLOR="#000077"><B>Glossary</B></FONT></H1>
<H2><FONT COLOR="#000077"><B>Terms</B></FONT></H2>
<P>This glossary contains the terms that appear italicized throughout this book.
Look them up as you go along or scan for any terms that you might not be familiar
with.
<H2><FONT COLOR="#000077"><B>A</B></FONT></H2>
<P><B>action query</B> A query that updates a table (such as deleting records, updating
records, creating a new table, or appending records to an existing table).</P>
<P><B>Active Web</B> Shared by all Microsoft Office 97 programs, this feature is
used to author and browse documents on an intranet or on the Web.</P>
<P><B>ActiveX Controls</B> Additional dialog objects that you insert on a form to
help data input or viewing. These include the calendar control and spinner control
and are supplied from files with an OCX extension.</P>
<P><B>add-in</B> A wizard (such as the Report Wizard) or a builder (such as the Expression
Builder) that helps users perform a potentially complex operation.</P>
<P><B>aggregate functions</B> Functions you use to summarize data on a query, report,
or form. These include Sum(), Avg(), Min(), Max(), and Count().</P>
<P><B>alias</B> When you use a self-join, a temporary name assigned to a table to
help differentiate one table joined to itself.</P>
<P><B>arguments</B> Inputs used to calculate functions and procedures. Arguments
are enclosed in parentheses. Arguments passed to procedures are also called parameters.</P>
<P><B>AutoFormat</B> An Access feature that applies a set of predefined formatting
choices to reports and forms.</P>
<P><B>AutoNumber</B> An Access data type that automatically increments by one for
every new record. This data type replaced Counter in Access 1.x and 2.0. AutoNumber
fields are usually mostly for primary keys.
<H2><FONT COLOR="#000077"><B>B</B></FONT></H2>
<P><B>bound</B> On a form or report, data is bound to a control when the data is
linked to an underlying query or table. Thus, for every record, the value in the
control changes.</P>
<P><B>Briefcase replication</B> A Windows 95 and Windows NT 4.0 feature implemented
in Access that creates more than one copy of a database (on a network and laptop,
for example) where changes in any copy can be updated to other copies.</P>
<P><B>builder</B> A help feature that provides assistance in creating expressions
for formulas and properties. The Expression Builder is an example.
<H2><FONT COLOR="#000077"><B>C</B></FONT></H2>
<P><B>caption</B> The text that appears in the title bar of a window. The caption
property of a field in table design becomes the label associated with a text box
or other control. The label itself has a caption property that is the text that appears
on the form.</P>
<P><B>cascade delete</B> When referential integrity is set in a relationship, the
property that causes records on the many side of a relationship to delete when the
related record is deleted.</P>
<P><B>cascade update</B> When referential integrity is set in a relationship, the
property that causes the related key on the many side of a relationship to change
to the new value on the related record.</P>
<P><B>Chart Wizard</B> An Access feature that automates the creation of a chart.</P>
<P><B>check box</B> On a form or dialog box, a small square that the user can click
to turn on or off. A check box is usually associated with a Yes/No field.</P>
<P><B>child</B> Data or an element that is related to another object but lower in
hierarchical level than the related (parent) object. An Access subform is related
to an Access form. The Link Child Fields property indicates the field that links
the Child to the master (Parent) form (which is related to the Link Master Fields
property field).</P>
<P><B>code</B> The text you enter in a program to create your application. In Access,
you enter code in modules.</P>
<P><B>combo box</B> On a form or dialog box, a combination of a text box and a list
box where the user can type a value or choose one from a list.</P>
<P><B>command button</B> On a form or dialog box, a rectangular object that a user
can click that confirms the choices, cancels the choices, or causes another action.
The most common command buttons are OK and Cancel.</P>
<P><B>compile</B> To translate text programming into something the machine can read.
In Access, when you click the Compile Loaded Modules button, you will check for some
errors in your programming.</P>
<P><B>concatenation</B> Combining text, numbers, or dates within a text box. In Access,
you use the ampersand (&) symbol to join the contents of multiple cells.</P>
<P><B>controls</B> Data-entry objects commonly used in Access forms, such as text
boxes, combo boxes, and check boxes.</P>
<P><B>criteria </B>The basis for selection in a query, established by entering it
on a line in the Query Design grid.
<H2><FONT COLOR="#000077"><B>D</B></FONT></H2>
<P><B>data type</B> A description on a field that determines what kind of information
you can enter in the field. Field data types include Text, Memo, and Number.</P>
<P><B>data source</B> Where an object gets its information. The data source for a
form or report is called the record source. The data source for a text box or other
control is called the control source.</P>
<P><B>database</B> A set of related tables, queries, forms, reports, macros, and
modules. In Access, the database is a single file indicated by a MDB extension.</P>
<P><B>Database window</B> The primary window visible in Access where you can view
or design all objects such as tables, queries, and other objects. To view the Database
window, press F11.</P>
<P><B>Datasheet View</B> A row and column view of a table, query, or form where you
can generally input data.</P>
<P><B>Debug window</B> A window that enables you to test code statements and expressions
as well as check on the values of variables within your procedures.</P>
<P><B>Design View</B> The view of table, query, form, and macro objects that enables
you to create or change the object.</P>
<P><B>dialog box</B> A form within the Windows application or created in Access that
accepts input from the user. Also called a dialog, this form is usually modal, which
means it stays in front of other objects until it is closed.</P>
<P><B>dynaset</B> Short for dynamic set of data. A dynaset is the datasheet (row
and column) view of a query that you can edit.
<H2><FONT COLOR="#000077"><B>E</B></FONT></H2>
<P><B>embedded object</B> A document (the source) stored inside of another document
(the container). For example, a Word document could be stored in an OLE field of
the Access database. The information is actually stored in the container rather than
pointing to a linked document somewhere else on a disk.</P>
<P><B>empty</B> A VBA variable that has been declared but has not yet received a
value. Empty is not the same as null or a zero-length<I> </I>string.</P>
<P><B>encryption</B> The process of rendering a file unreadable without the use of
a key to decrypt the file.</P>
<P><B>event</B> An action taken by a user such as a mouse click or keystroke that
is recognized by one of Access' event properties such as On Click or On DblClick.
Events can also be triggered by the program such as when a form opens or the Timer
Interval is reached.</P>
<P><B>expression</B> A combination of field or variable names and arithmetic or other
operators used to perform a calculation, manipulate characters, or test data. For
example, =Date(), [Price]*[Quantity], and =[FirstName] & " " &
[LastName] are expressions.
<H2><FONT COLOR="#000077"><B>F</B></FONT></H2>
<P><B>field</B> The information in one column of a list or database. Also, a single
item of information in a record.</P>
<P><B>filter</B> To show only certain records from a table. A filter in Access can
also include sorting information. A filter is not stored in the Database window while
a query is.</P>
<P><B>flow control</B> Programming expressions that direct the execution of a procedure.
If, Then, Else, End If is a flow control statement.</P>
<P><B>focus</B> The capability of a control, form, or dialog box to receive keyboard
or mouse input. Only one object, such as a text box, can have the focus at a time.</P>
<P><B>foreign key</B> A field (or fields) on the many side of a one-to-many relationship
between tables that relates to the primary key of the other table. Foreign keys do
not need to be unique within the table.</P>
<P><B>form</B> An organized and formatted document that facilitates data entry.</P>
<P><B>Form View</B> The view of a form where users can input data. This is opposed
to Design View where you can create and modify the form.</P>
<P><B>front-end</B> The visible, user entry part of an application. Access can act
as a front-end with the forms, reports, and queries attached to a back-end database
on another system such as SQL Server.</P>
<P><B>function</B> A predefined formula that performs a specific operation in Access.
Sum() is the most used function in both Access and Excel.
<H2><FONT COLOR="#000077"><B>G</B></FONT></H2>
<P><B>global</B> When dealing with procedures and variables, those that any other
part of Access can use. VBA uses the reserved word Public to refer to global variables.</P>
<P><B>grid</B> On a form, a set of non-printing lines that aides the user in aligning
objects such as text boxes and other controls. In Design View, Access shows the grid
as a series of dots.</P>
<P><B>gridlines</B> On a datasheet, the lines that indicate the rows and columns.
On a chart, the lines that start at and are perpendicular to the category and value
axes.</P>
<P><B>group</B> In an Access report, one or more records that are combined together
and identified with a group header and summarized with a group footer.
<H2><FONT COLOR="#000077"><B>H</B></FONT></H2>
<P><B>HTML (Hypertext Markup Language)</B> The underlying code of Web pages.</P>
<P><B>hyperlink</B> A link in an Access field that enables you to quickly jump to
Internet or intranet sites, or to other Access or Office documents.
<H2><FONT COLOR="#000077"><B>I</B></FONT></H2>
<P><B>index</B> In an Access table, the property that will speed up searches and
sorts. One or more fields can be part of an index.</P>
<P><B>inner join</B> In an Access query, the link between two related tables, that
only returns related fields that are common in both tables.</P>
<P><B>input mask</B> An input aid that adds characters such as dashes for social
security numbers or parentheses for phone numbers. An input mask can also force the
user to input text or numeric characters.</P>
<P><B>integer</B> A number with no decimal places. Access integer data types include
integers that can be numbers +/- 32,000 or long integers that can be +/- 2 billion.
<H2><FONT COLOR="#000077"><B>J</B></FONT></H2>
<P><B>join</B> Connect two tables together in a query on a common field. The field
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -