fm.htm

Microsoft_Access_97_Quick_Reference.zip

			might not be familiar. Ever wonder what <I>concatenation</I> is? You don't have to
			complete a task to find out. You can check out such terms or definitions in the glossary.
			<H2><FONT COLOR="#000077"><B>Task Reference</B></FONT></H2>
			<P>This Quick Reference is divided into sections, all dedicated to Access 97 functional
			areas. In each section, you will find an alphabetical listing of topics that are
			detailed with tasks.</P>
			<P>To find all tasks that Access' online Help system, for example, go to the &quot;Database
			Essentials&quot; section, find the task topic &quot;Help,&quot; and then turn to
			the tasks that cover activities in that topic area. Tasks follow one another and
			are sorted in alphabetical order, unless there is special value in completing multiple
			tasks in order.</P>
			<P>When a prerequisite task must be read to understand the task you are reading,
			a cross reference will let you know: (See &quot;Help: Help Contents and Index,&quot;
			&quot;Help: Searching for Topics,&quot; or &quot;Help: Office Assistant&quot; before
			you complete this task). When other tasks might be more useful, or might be used
			instead of the task you are viewing, a cross reference will let you know where to
			find it: (See also &quot;Width of Column&quot; in the Database Essentials part of
			this book). And when other related tasks might be useful after completing a task,
			a cross reference at the end of the task will direct you to their location: (For
			formatting numbers, see also &quot;Query: Format Field&quot; in the Queries and Filters
			part of this book, and &quot;Format: Numbers and Dates&quot; in the Forms and Reports
			part of the book).
			<H2><FONT COLOR="#000077"><B>Conventions Used in This Book</B></FONT></H2>
			<P>This book uses certain conventions in order to guide you through the various tasks.
			Special typefaces in this Quick Reference include the following: 
			<TABLE BORDER="0">
				<TR ALIGN="LEFT" rowspan="1">
					<TD ALIGN="LEFT"><B>Type</B></TD>
					<TD ALIGN="LEFT"><B>Meaning</B></TD>
				</TR>
				<TR ALIGN="LEFT" rowspan="1">
					<TD ALIGN="LEFT"><I>italic</I></TD>
					<TD ALIGN="LEFT">Terms or phrases that might be found in the Glossary; required function variables
						that must be entered.</TD>
				</TR>
				<TR ALIGN="LEFT" rowspan="1">
					<TD ALIGN="LEFT"><U>underline</U></TD>
					<TD ALIGN="LEFT">Menu and dialog box options that appear underlined on-screen.</TD>
				</TR>
				<TR ALIGN="LEFT" rowspan="1">
					<TD ALIGN="LEFT"><B>boldface</B></TD>
					<TD ALIGN="LEFT">Information you are asked to type.</TD>
				</TR>
				<TR ALIGN="LEFT" rowspan="1">
					<TD ALIGN="LEFT">italic boldface</TD>
					<TD ALIGN="LEFT">Optional function variables that can be entered.</TD>
				</TR>
				<TR ALIGN="LEFT" rowspan="1">
					<TD ALIGN="LEFT"><TT>special type</TT></TD>
					<TD ALIGN="LEFT">Direct quotations of words that appear on-screen or in a figure.</TD>
				</TR>
			</TABLE>
<BR>
			<BR>
			Elements printed in uppercase include functions, such as SUM(), and file names.</P>
			<P>When a direction is given to &quot;click,&quot; this means click the left side
			of the mouse control for those mice with alternate keys. When it is necessary for
			the right or alternate side of the mouse to be used, the direction &quot;right-click&quot;
			will be given.</P>
			<P>In most cases, keys are represented as they appear on the keyboard. The arrow
			keys usually are represented by name (for example, the up-arrow key). The Print Screen
			key is abbreviated PrtSc; Page Up is PgUp; Insert is Ins; and so on. On your keyboard,
			these key names might be spelled out or abbreviated differently.</P>
			<P>When two keys appear together with a plus sign, such as Shift+Ins, press and hold
			the first key as you press the second key. When two keys appear together without
			a plus sign, such as End Home, press and release the first key before you press the
			second key.</P>
			<P>Various toolbar buttons, such as the one next to this paragraph, are used throughout
			the steps and are identified with a visual icon next to the appropriate step. These
			icons resemble the on-screen toolbar button and make it easier for you to find them
			quickly.</P>
			<P>Many tasks include warnings, cautions, notes, and tips. These are described in-depth
			in this section.</P>
			<P>The author has gone to great lengths to protect you from disaster, often warning
			you of impending, often irreversible danger before you get in over your head. Warnings
			are just one way this Quick Reference will inform you when you need to know.


			<BLOCKQUOTE>
			<P>
<HR>
<FONT COLOR="#000077"><B>WARNING:</B></FONT> AutoRecover does not save your documents--only
			certain recovery information! Be sure to save all documents you are working on at
			frequent intervals. 
<HR>


			</BLOCKQUOTE>

			<P>The completion of some tasks might change several aspects of a document or the
			way your MS Access package works in the future. Cautions inform the reader about
			unforeseen events that might not occur as expected. Cautions are not as severe as
			warnings, but you will want to read cautionary information.


			<BLOCKQUOTE>
			<P>
<HR>
<FONT COLOR="#000077"><B>CAUTION:</B></FONT> Do not turn the power off before exiting
			Access. You could damage your database. If you need to repair a damaged database,
			there is a repair procedure that might (or might not) work. 
<HR>


			</BLOCKQUOTE>

			<P>Notes often advise and direct you while you complete a task. Expect to find pieces
			of great wisdom while you complete tasks.


			<BLOCKQUOTE>
			<P>
<HR>
<FONT COLOR="#000077"><B>NOTE:</B></FONT> Only controls that have Control Source
			properties can take an expression with a calculated result. Expressions can be any
			valid Access function or operator, values, fields, or identifiers, and must start
			with an equal sign. 
<HR>


			</BLOCKQUOTE>

			<P>Tips offer expert input from those who really know the software. Tips often include
			time-saving solutions and ways to shortcut your way to success. If you're looking
			for a shortcut key, tips are where you'll find them!


			<BLOCKQUOTE>
			<P>
<HR>
<FONT COLOR="#000077"><B>TIP:</B></FONT> To change additional options for a specific
			pivot table field, double-click the field button. Choose the options you want in
			the PivotTable Field dialog box; then choose OK. 
<HR>


			</BLOCKQUOTE>

			<P>All tasks in this book are not for everyone. In some tasks, if you are not already
			familiar with the instances of use of a task, we might direct you to a <I>Special
			Edition Using</I> book. A <I>Special Edition Using</I> is the most complete core
			tutorial reference on the topic and can provide you with both background information
			and tutorial style learning that will help you to understand the topic more thoroughly.


			<BLOCKQUOTE>
			<P>
<HR>
<FONT COLOR="#000077"><B>NOTE:</B></FONT> This feature's task requires understanding
			of a complex subject. If you are not familiar with this feature, you will probably
			want to become acquainted with it by reading <I>Special Edition Using Microsoft Access
			97</I> for a complete tutorial coverage. 
<HR>


			</BLOCKQUOTE>

			<H2><FONT COLOR="#000077"><B>Related Books</B></FONT></H2>
			<P>No one book can cover all of the needs of every user. Que offers a complete line
			of Office 97-related titles. Look for Quick References on each of the Office 97 components
			as well as Windows 95. <I>Special Edition Using Microsoft Access 97 </I>is the most
			complete tutorial and reference volume available for Access 97, and answers end-user
			questions with clear, concise, and comprehensive authority. <I>Special Edition Using
			Microsoft Office 97 Professional </I>is the most complete tutorial and reference
			volume available for Office 97, and Que's <I>Net Savvy Office 97</I> concentrates
			its content on getting the most of Office 97's extensive Internet and intranet features.
			Ask your bookseller for the availability of other Que titles.
		</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="ch01.htm"><IMG
			SRC="../buttonart/bforward.gif" WIDTH="41" HEIGHT="41" ALIGN="BOTTOM" ALT="FORWARD"
			BORDER="0" NAME="toc7"></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>