Copyright: Build 6.99.00828: 28-Aug-95 at 12:21p


Table Datasheet toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


Sort Ascending button (Table Datasheet toolbar) Ascending subcommand (Records, sort command)
  Sort Ascending button
Ascending subcommand (Records, Sort command)

Sorts records based on the selected column(s) in ascending order (0 to 9, A to Z). Subsequent sorts replace previous sorts. To undo a sort, choose Remove Filter/Sort on the Records menu.


Sort Descending button (Table Datasheet toolbar) Ascending subcommand (Records, sort command)
  Sort Descending button
Descending subcommand (Records, Sort command)

Sorts records based on the selected column(s) in descending order (9 to 0, Z to A). Subsequent sorts replace previous sorts. To undo a sort, choose Remove Filter/Sort on the Records menu.


Filter by Selection button (Table Datasheet toolbar) Filter by Selection subcommand (Records, Filter command)
  Filter By Selection button
Filter By Selection subcommand (Records, Filter command)

Filters records based on selected data. To filter by selection, select a field or part of a field in a datasheet or form, and then click Filter by Selection.


Quick Filter button (Table Datasheet toolbar) Filter by Selection subcommand (Records, Filter command)
  Filter By Form button
Filter By Form subcommand (Records, Filter command)

Displays the Filter by Form window, which displays a blank version of the active form or datasheet, so you can filter data.


Find button (Table Datasheet toolbar) Find command (Edit menu)
  Find button
Find command (Edit menu)

Searches for a string, such as an employee's last name in a datasheet or form, or a Visual Basic keyword in the Module window.


Replace button (Toolbar Well, Edit Group) Replace command (Edit menu)
  Replace button
Replace command (Edit menu)

Searches for a string, such as an employee's last name in a datasheet or form or a Visual Basic keyword in the Module window, and replaces it with another string.


Find Next button (Toolbar Well, Edit group)
  Find Next button

Finds the next occurrence of a string entered in the Find dialog box, such as an employee's last name in a datasheet or form, or a Visual Basic keyword in the Module window.


New Record button (Table Datasheet toolbar) New subcommand (Records menu, Go To command)
  New Record button
Record command (Insert menu)
New subcommand (Edit menu, Go To command)

Moves to the end of the form or datasheet so you can enter a new record.


Delete Record button (Table Datasheet toolbar) (Delete Record command (Edit menu)
  Delete Record button
Delete Record command (Edit menu)

Deletes the selected record or records from the form or datasheet. To select a record, click the record selector.


AutoForm command (Insert menu)
  AutoForm button
AutoForm command (Database window, Insert menu)

Automatically creates a form based on the selected table or query.


Auto Report button (Table Datasheet Toolbar) AutoReport command (Insert menu)
  AutoReport button
AutoReport command (Database window, Insert menu)

Automatically creates a report based on the selected table or query.


New Table button (Table Datasheet Toolbar) Table command (Insert menu)
  New Table button
Table command (Database window, Insert menu)

Displays the New Table dialog box so you can create a new table using the Table Wizard, table Datasheet view, table Design view, or Import/Link Table.


New Query button (Table Datasheet Toolbar) Query command (Insert menu)
  New Query button
Query command (Database window, Insert menu)

Displays the New Query dialog box so you can create a new query using one of the query wizards or query Design view.


New Form button (Table Datasheet Toolbar) Form command (Insert menu)
  New Form button
Form command (Database window, Insert menu)

Displays the New Form dialog box so you can create a new form using one of the form wizards or form Design view.


New Report button (Table Datasheet Toolbar) Report command (Insert menu)
  New Report button
Report command (Database window, Insert menu)

Displays the New Report dialog box so you can create a new report using one of the report wizards or report Design view.


New Macro button (Table Datasheet Toolbar) Macro command (Insert menu)
  New Macro button
Macro command (Database window, Insert menu)

Displays the Macro window so you can create a new macro.


New Module button (Table Datasheet Toolbar) Module command (Insert menu)
  New Module button
Module command (Database window, Insert menu)

Displays the Module window so you can create a new module.


Save Record button (Toolbar Well, File Group) Save Record command (Records menu)
  Save Record button
Save Record command (Records menu)

Saves changes to data in the current record.


Font button (Toolbar Well, Datasheet Group) Font command (Format menu)
  Font button
Font command (Format menu)

Changes the typeface of all the field names and data in a datasheet. The default font is Arial, the default font style is Regular, and the default size is 10 points.


Row Height button (Toolbar Well, Datasheet Group) Row command (Format menu)
  Row Height button
Row Height command (Format menu)

Changes the height of all rows in a datasheet. You can also resize rows by dragging the lower border of the record selector.


Column Width button (Toolbar Well, Datasheet Group) Column Width command (Format menu)
  Column Width button
Column Width command (Format menu)

Changes the width of the selected columns in a datasheet. You can also resize a column by dragging the right border of the column selector.


Show Hidden button (Toolbar Well, Records Group) Unhide Command (Format menu)
  Show Hidden button
Unhide Columns command (Format menu)

Displays previously hidden columns.


Freeze Column button (Toolbar Well, Records Group) Freeze Column command (Format menu)
  Freeze button
Freeze Columns command (Format menu)

Freezes the selected columns on the left side of the window to prevent them from scrolling off the screen.


First Record button (Toolbar Well, Records Group) First subcommand (Records menu, Go To command)
  First Record button
First subcommand (Edit menu, Go To command)

Moves to the first record in the datasheet or form.


Last Record button (Toolbar Well, Records Group) Last subcommand (Records menu, Go To command)
  Last Record button
Last subcommand (Edit menu, Go To command)

Moves to the last record in the datasheet or form.


Next Record button (Toolbar Well, Records Group) Next subcommand (Records menu, Go To command)
  Next Record button
Next subcommand (Edit menu, Go To command)

Moves to the next record in the datasheet or form.


Previous Record button (Toolbar Well, Records Group) Previous subcommand (Records menu, Go To command)
  Previous Record button
Previous subcommand (Edit menu, Go To command)

Moves to the previous record in the datasheet or form.


Go To Field button (Toolbar Well, Records group)
  Go To Field box

Moves to the field you select from the field list. Use, for example, when your table has many columns and you want to go directly to a column by name, instead of scrolling.


Table Design toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


Primary Key button (Table Design toolbar)
  Primary Key button
Primary Key command (Edit menu)

Toggles between setting and removing a primary key field, which is a unique identifier for each record in the table.

For more information on primary keys, click  [image].


Indexes button (Table Design toolbar)
  Indexes button
Indexes command (View menu)

Displays the Indexes window so you can view, edit, or create indexes. Indexes can speed searches and queries for large amounts of data, but they can slow data entry because Microsoft Access must update the indexes each time a record is added, changed, or deleted.


Insert Row button (Table Design toolbar)
  Insert Row button
Row/Field command (Insert menu)

Creates a blank row above the selected row. To select a row, click the row selector. The type of row inserted depends on the current view or window.

View or Window	Type of Row
Table Design view	Field
Query Design view	Criteria
Advanced Filter/Sort window	Criteria
Macro window	Action


Delete Row button (Table Design toolbar)
  Delete Row button
Delete Row command (Edit menu)

Deletes the selected row(s). To select a row, click the row selector.


Build button (Table Design toolbar)
 Build button

Displays a builder for the selected item or property. Microsoft Access enables this button only if a builder is available for the selected item (such as a field name in table Design view) or a property (such as an input mask property or property set with an expression).


Add Table button (Relationship toolbar)
  Show Table button
Show Table command (Relationships menu)
Show Table command (Query menu)

Shows one or more tables or queries that you can add to the Relationships window or the active query in query Design view.

You can also add tables and queries by dragging them from the Database window to the Relationships window or the upper pane of the query Design view.


Show Direct Relationships button (Relationships toolbar)
  Show Direct Relationships button
Show Direct command (Relationships menu)

Displays tables and queries that have a direct relationship to the selected table or query. To select a table or query, click anywhere in its field list.

For more information on viewing relationships, click  [image].


Show All Relationships button (Relationships toolbar)
  Show All Relationships button
Show All command (Relationships menu)

Displays in the Relationships window all the tables and queries that have relationships defined in the current database (if they are not already displayed).


Database Window button (Relationships toolbar)
  Database Window button

Displays the Database window, which lists all objects in the current database. Use, for example, to drag and drop objects from the Database window to the current window.


Print Preview toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


One Page button (Print Preview toolbar)Pages 1 subcommand (View menu)
  One Page button
Pages 1 subcommand (View menu)

Displays one full page in Print Preview or Layout Preview.


Two Page button (Print Preview toolbar)
  Two Pages button
Pages 2 subcommand (View menu)

Displays two full pages in Print Preview or Layout Preview.


Page Setup button (Print Preview toolbar)
  Page Setup button
Page Setup command (File menu)

Controls margin settings (such as margin width, page settings (such as orientation and paper size), and layout options for forms and reports (such as the number of columns to print).


Zoom Control button (Print Preview toolbar)Pages 1 subcommand (View menu)
  Zoom Control box

Controls the percentage you can zoom in Print Preview or Layout Preview. To change the zoom percentage, click the arrow and select from the list of percentages, or type a percentage number.


Publish it with MS Word button (Print Preview toolbar)
 Publish It With MS Word button
Publish It With MS Word subcommand (Tools menu, OfficeLinks command)

Creates a rich-text format (.rtf) file of the selected object (such as a table, report, or portion of a datasheet) and loads it into Microsoft Word. By default, the filename is the name of the object, the file extension is .rtf, and the document is stored in the Microsoft Access folder.


Analyze it with MS Excel button (Print Preview toolbar)
  Analyze It With MS Excel button
Analyze It With MS Excel subcommand (Tools menu, OfficeLinks command)

Creates a Microsoft Excel (.xls) file of the selected object (such as a table, report, or portion of a datasheet) and loads it into Microsoft Excel. By default, the filename is the name of the object, the file extension is .xls, and the document is stored in the Microsoft Access folder.


Zoom button (Print Preview toolbar)
  Zoom button

Switches between the full page and zoom views. When the pointer is a magnifying glass, you can also click on a portion of the full page view to zoom to that portion, and click again to return to the full page view.


Report Design toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


  Layout Preview button
Layout Preview command (View menu)

Displays the report as it looks when printed, but using only sample data so you can take a quick look at the report layout. Layout Preview displays all report sections and sorts and groups the data in the detail section, but ignores criteria and joins in an underlying query.


  Sorting And Grouping button
Sorting And Grouping command (View menu)

Adds, deletes, and changes the following: Fields or Expressions to group on, Sort Order, and Group Properties such as headers and footers.


Query Datasheet toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


Query Design toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


SQL View button (Query Design toolbar)
 View SQL button
SQL command (View menu)

Displays SQL view so you can display and modify a query using Structured Query Language (SQL). Changes in the SQL window are reflected in query design view and vice versa (except for SQL specific queries). For example, if you add a field in the SQL window, the field also appears in the query design grid.


Select command (File menu) or button (Query Design toolbar)
  Select button
Select command (Query menu)

Makes the active query a select query, which finds records in one or more tables, often based on criteria. A select query is the default query type.


Crosstab command (File menu) or button (Query Design toolbar)
  Crosstab button
Crosstab command (Query menu)

Creates a crosstab query, which summarizes data in spreadsheet format using values from a field or expression as columns. For example, to show total sales of employees by month, display the months of the year as columns and the salespeople as rows.


Make Table command (File menu) or button (Query Design toolbar)
  Make Table button
Make Table command (Query menu)

Makes the active query a make table query, which makes a new table in the current database or another database. Because this command copies data, verify the results in Datasheet view before running it.

For more information on action queries, click  [image].


Append command (File menu) or button (Query Design toolbar)
  Append button
Append command (Query menu)

Makes the active query an append query, which adds the results of the query to the end of a table in the current database or another database. Because this command copies data, verify the results in Datasheet view before running it.

For more information on action queries, click  [image].


Update command (File menu) or button (Query Design toolbar)
  Update button
Update command (Query menu)

Makes the active query an update query, which updates a group of records, such as increasing salaries by 5%. Because this command changes data, verify the results in Datasheet view before running it.

For more information on action queries, click  [image].


Delete command (File menu) or button (Query Design toolbar)
  Delete button
Delete command (Query menu)

Makes the active query a delete query, which deletes a group of records, such as all orders placed in 1990. Because this command changes data, verify the results in Datasheet view before running it.

For more information on action queries, click  [image].


Run command (Query Menu) or button (Query Design toolbar)
  Run button
Run command (Query Menu)

•	Displays the results in Datasheet view for select and crosstab queries, and SQL union and pass-through queries that return data.

•	Changes, copies, or deletes data or creates a database object for action queries (make table, update, append, and delete), and SQL data definition and SQL pass-through queries. Before running these queries, check the records that will be affected in Datasheet view.

For more information on action queries, click  [image].


Totals comand (View menu) or button (Query Design toolbar)
  Totals button
Totals command (View menu)

Toggles between hiding and displaying the Total row in the query design grid for the following query types: select, crosstab, make table, and append. Use to group data in the active query or perform summary calculations, such as averages and counts.


Top Values button (Query Design toolbar)
  Top Values box

Finds the top values in the active query based on a percentage of rows or a number of rows. To find the top values, click the down arrow, then choose a percentage (such as 10%) or enter a number (such as 25).


Filter toolbar
Filter/Sort toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


Close button (Filter toolbar)
Cancel button

Closes the active window and does not apply a filter to the current datasheet or form.


Clear Grid command (Edit menu)
  Clear Grid button
Clear Grid command (Edit menu)
Clear Filter command (Edit menu)

Clears the fields in the grid or filter.

Also, in Query Design view, it clears any parameters in the Query Parameters dialog box. Clearing fields in the grid does not delete them from the underlying table.


Load From Query command (File menu) or button (Advanced Filter Selection  toolbar)
  Load From Query button
Load From Query command (File menu)

Displays a list of applicable queries you can use to load a query to filter the active table, form, or query.


Save As Query command (File menu) or button (Advanced Filter Selection toolbar)
  Save As Query button
Save As Query command (File menu)

Saves the active filter as a query, including the criteria and sort order.


Save As Report button (Tool button well)
  Save As Report button

Saves the active form as a report. Use this button, for example, to create a report from a form listing product orders; then add a control in the report to calculate running totals.


Flat button (Tool button well)
  Flat button

Applies a flat effect to the cells on a datasheet, or to the selected control or controls on a form or report. The cells are flush with the gridlines on a datasheet; the controls are flush with the background of a form or report.


Raised button (Tool button well)
  Raised button

Applies a raised effect to the cells on a datasheet, or to the selected control or controls on a form or report. The cells stand out in slight relief from the gridlines on a datasheet; the controls stand out in slight relief from the background of a form or report.

This effect overrides any settings for a control's BorderColor, BorderWidth, and BorderStyle properties.


Sunken button (Tool button well)
  Sunken button

Applies a sunken effect to the cells on a datasheet, or to the selected control or controls on a form or report. The cells appear slightly recessed from the gridlines on a datasheet; the controls appear slightly recessed from the background of a form or report.

This effect overrides any settings for a control's BorderColor, BorderWidth, and BorderStyle properties.


Etched button (Tool button well)
  Etched button

Applies an etched effect to the selected control—that is, the control appears "engraved" upon the background of the form or report. This effect overrides any settings for the control's BorderColor, BorderWidth, and BorderStyle properties.


Chiseled button (Tool button well)
  Chiseled button

Applies a chiseled, or "beveled," effect to the selected control. This effect overrides any settings for the control's BorderColor, BorderWidth, and BorderStyle properties.


Shadowed button (Tool button well)
  Shadowed button

Applies a shadowed effect to the selected control.


Solid button (Tool button well)
  Solid button

Applies a solid border to the selected control.


Dashes button (Tool button well)
  Dashes button

Applies a dashed style to the border of the selected control.


Short Dashes button (Tool button well)
  Short Dashes button

Applies short dashes to the border of the selected control.


Dots button (Tool button well)
  Dots button

Applies a dotted border to the selected control.


Sparse Dots button (Tool button well)
  Sparse Dots button

Applies sparse dots to the border of the selected control.


Dash-Dot button (Tool button well)
  Dash-Dot button

Applies alternating dashes and dots to the border of the selected control.


Dash-Dot-Dot button (Tool button well)
  Dash-Dot-Dot button

Applies a style consisting of a dash alternating with two dots to the border of the selected control.


Align General button (Tool button well)
  Align General button

Aligns text to the left and numbers to the right within the selected control.


Output To  Notepad button (Tool button well)
  Output To Notepad button (File category)

Exports the following database objects as text to a Microsoft Notepad file from any view:

•	Tables, queries, and forms. Regardless of the current view, Microsoft Access exports the datasheet to Notepad. If you export from Datasheet view, you can select a portion of the datasheet to export.

•	A report or module.


Design View button (Tool button well)
  Design View button and commands

Switches from the current view to Design view for the current database object. You can also use the Table Design, Query Design, Form Design, and Report Design commands on the View menu of the appropriate object.


Datasheet View button (View category) and commands
  Datasheet View button
Datasheet command (View menu)

Switches from the current view to Datasheet view for the current table, query, or form. You can also use the Datasheet command on the View menu of the appropriate database object.


Switch To MS Word button (Tool button well)
  Switch To MS Word button (Microsoft toolbar)

Switches from Microsoft Access to Microsoft Word, or starts Word if you are not already running it in the background. To return to your database, click the Microsoft Access button on the taskbar.


Switch To MS Excel button (Tool button well)
  Switch To MS Excel button (Microsoft toolbar)

Switches from Microsoft Access to Microsoft Excel, or starts Excel if you are not already running it in the background. To return to your database, click the Microsoft Access button on the taskbar.


Switch To MS PowerPoint button (Tool button well)
  Switch To MS PowerPoint button (Microsoft toolbar)

Switches from Microsoft Access to Microsoft PowerPoint, or starts PowerPoint if you are not already running it in the background. To return to your database, click the Microsoft Access button on the taskbar.


Switch To MS Mail button (Tool button well)
  Switch To MS Mail button (Microsoft toolbar)

Switches from Microsoft Access to Microsoft Mail, or starts Mail if you are not already running it in the background. To return to your database, click the Microsoft Access button on the taskbar.


Switch To MS Project button (Tool button well)
  Switch To MS Project button (Microsoft toolbar)

Switches from Microsoft Access to Microsoft Project, or starts Project if you are not already running it in the background. To return to your database, click the Microsoft Access button on the taskbar.


Switch To MS FoxPro button (Tool button well)
  Switch To MS FoxPro button (Microsoft toolbar)

Switches from Microsoft Access to Microsoft FoxPro, or starts FoxPro if you are not already running it in the background. To return to your database, click the Microsoft Access button on the taskbar.


Switch To MS Schedule button (Tool button well)
  Switch To MS Schedule+ button (Microsoft toolbar)

Switches from Microsoft Access to Microsoft Schedule+, or starts Schedule+ if you are not already running it in the background. To return to your database, click the Microsoft Access button on the taskbar.


Visual Basic toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


Insert Module button (Visual Basic toolbar) Module command (Insert menu)
  Insert Module button
Module command (Insert menu)

Inserts a new module into the current database and displays its declarations section in the Module window.


Insert Procedure button (Visual Basic toolbar)
  Insert Procedure button
Procedure command (Insert menu)

Inserts a procedure declaration statement after the current insertion point in the active module, or at the end of a procedure if the insertion point is inside a procedure.


Debug Window button (Visual Basic toolbar)
  Debug Window button
Debug Window command (View menu)

Displays the Debug window so you can test and debug code.

For more information on debugging in the Debug window, click  [image].


Object Browser button (Visual Basic toolbar)
  Object Browser button
Object Browser command (View menu)

Displays all methods and properties in the current database, in other available databases, and in available applications that support Visual Basic. Use to display and insert code templates of a selected method or property.

For more information on using the Object Browser, click  [image].


Continue button (Visual Basic toolbar)
  Continue button
Continue command (Run menu)

Continues code execution after it has been suspended, unless the suspension prevents the code from continuing (such as a division by zero error).

For more information on the suspension of code execution, click  [image].


  End button
 End command (Run menu)

Terminates execution of Visual Basic procedures and clears all private variables, but preserves all public variables. Use to reinitialize procedures in a module you have changed before rerunning them.


Reset command (Run menu)
  Reset button
Reset command (Run menu)

Terminates execution of Visual Basic procedures and clears all public and private variables. Use to reinitialize all code in a module you have changed before rerunning it.


Break Point button (Visual Basic toolbar)
  Breakpoint button
Toggle Breakpoint command (Run menu)

Toggles between setting and removing a breakpoint. Visual Basic suspends code execution and enters break mode when it reaches a line of code containing a breakpoint (Microsoft Access bolds the line).


Instant Watch button (Visual Basic toolbar)
  Instant Watch button
Instant Watch command (Tools menu)

Displays the value of a selected expression (such as a variable, property, or function call). Optionally, you can add the expression to the Debug window's Watch pane to continue examining its value.


Calls command (View menu)
  Calls button
Calls command (Tools menu)

Displays a list of active procedure calls, starting with the most recently called, so you can trace the calling sequence.

Microsoft Access enables this button or command only when the Module window or the Debug window is open and code execution is suspended.


Step Into command (Run menu)
  Step Into button
Step Into command (Run menu)

Runs one statement at a time, including statements within a called procedure.


Step Over button (Visual Basic toolbar)
  Step Over button
Step Over command (Run menu)

Runs one statement at a time, treating a called procedure as one step.


Compile Loaded Modules button (Visual Basic toolbar)
Compile All Modules command (Run menu)

Compiles all procedures in all modules in the current database, whether loaded or not.


Indent button (Visual Basic toolbar)
  Indent button
Indent command (Edit menu)

Shifts the selected code or the line at the insertion point four spaces to the right, by default. Use to format and align blocks of code.

To change the default shift, change the Tab Width option in the Options dialog box's Module tab.


Outdent button (Visual Basic toolbar)
  Outdent button
Outdent command (Edit menu)

Shifts the selected code or the line at the insertion point four spaces to the left by default. Use to format and align blocks of code.

To change the default shift, change the Tab Width option in the Options dialog box's Module tab.


Procedure Definition command (View menu)
  Procedures button
Procedure Definition command (View menu)

Displays the procedure code of the procedure name at the current insertion point in the Module window. If the procedure is defined in a dynamic-linked library (.dll), then Microsoft Access displays the Declare statement used to define the .dll entry point.


Clear All Breakpoints command (Run menu)
  Clear All Breakpoints button
Clear All Breakpoints command (Run menu)

Removes all breakpoints in all procedures in all modules in the current database.


Macro toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


Print Preview button (Macro toolbar) Print Preview command (File menu)
  Print Preview button
Print Preview command (File menu)

Displays the Database Documentor, so you can choose one or more of the following report sections: Actions and Arguments, Properties, and Permissions by User and Group. Then, it displays the macro report in Print Preview.


Print button (Macro toolbar) Print command (File menu)
  Print button
Print command (File menu)

Displays the Database Documentor, so you can choose to print one or more of the following report sections: Actions and Arguments, Properties, and Permissions by User and Group. Then, it prints the macro report to the default printer.


Macro Names button (Macro toolbar)
  Macro Names button
Macro Names command (View menu)

Toggles between displaying and hiding the Macro Name column in the Macro window. Display the Macro Name column when you define a macro group.


Conditions button (Macro toolbar)
  Conditions button
Conditions command (View toolbar)

Toggles between displaying and hiding the Condition column in the Macro window. Display the Condition column when you want to set conditions for an action.

For more information on conditions, click  [image].


Run command (Macro menu)
  Run button
Start command (Run menu)

Runs the active macro in the Macro window. If the macro is a macro group, Microsoft Access runs the first macro in the group. If the first line is blank or contains a comment, the macro won't run.


Single Step button (Macro toolbar)
  Single Step button
Single Step command (Run menu)

Toggles the single step mode on or off. When you run a macro in single step mode, Microsoft Access displays the Macro Single Step dialog box to run the actions one by one.

If you have turned the single step mode on, it remains on until you turn it off.


Option Button tool (Toolbox)
  Option Button

A button you can use as:

•	A stand-alone control bound to a Yes/No field. Select the button to enter a value of Yes; clear the button to enter a value of No.

•	An unbound control for accepting user input in a custom dialog box.

•	Part of an option group, displaying values to choose from (for example, Air, Sea, or Land in a Ship By field). You can use a wizard to create the option buttons in an option group.


Toggle Button tool (Toolbox)
  Toggle Button

A button you can use as:

•	A stand-alone control bound to a Yes/No field. When the button is pressed in, the value is Yes; when the button is not pressed in, the value is No.

•	An unbound control for accepting user input in a custom dialog box.

•	Part of an option group, displaying values to choose from (for example, Air, Sea, or Land in a Ship By field). You can use a wizard to create the toggle buttons in an option group.


Check Box tool (Toolbox)
  Check Box

A box you can use as:

•	A stand-alone control bound to a Yes/No field. Select (check) the box to enter a value of Yes; clear the box to enter a value of No.

•	An unbound control for accepting user input in a custom dialog box.

•	Part of an option group, displaying values to choose from (for example, Air, Sea, or Land in a Ship By field). You can use a wizard to create the check boxes in an option group.


Option Group tool (Toolbox)
  Option Group

A control, for use on a form or report, to which you add check boxes, option buttons, or toggle buttons to display a set of alternative values. For example, you can use an option group to specify whether an order is to be shipped by air, sea, or land.

To create this control, click  [image]  in the toolbox, and then click the form or report where you want to place the control. To use a wizard to help you create the option group  [image]  must be pressed in.

For more information on the option group control, click  [image].


Object Frame tool (Toolbox)
  Unbound Object Frame

A frame for displaying an unbound OLE object, such as a Microsoft Excel spreadsheet, on a form or report. The object remains constant as you move from record to record.

To create this control, click  [image]  in the toolbox, and then click the form or report where you want to place the control.


Page Break tool (Toolbox)
  Page Break

A control that begins a new screen on a form, a new page on a printed form, or a new page of a report. To keep data output uniform, position the page break control above or below other controls.

To create this control, click  [image]  in the toolbox, and then click the form or report where you want to place the control.


Image Frame tool (Toolbox)
  Image Control

A frame for displaying a static picture on a form or report. Because a static picture is not an OLE object, you can't edit the image inside Microsoft Access once you've added it to a form or report.

To create this control, click  [image]  in the toolbox, and then click the form or report where you want to place the control.


Rectangle tool (Toolbox)
  Rectangle

A rectangle for such graphic effects as grouping a set of related controls on a form, or emphasizing important data on a report.

To create this control, click  [image]  in the toolbox, and then click the form or report where you want to place the control.


Subform/Subreport tool (Toolbox)
  Subform/Subreport

A control you use to display data from more than one table on a form or report.

To create this control, click  [image]  in the toolbox, and then click the form or report where you want to place the control. To use a wizard to help you create a subform or subreport,  [image]  must be pressed in.

For more information on subforms, click  [image].

For more information on subreports, click  [image].


Text Box tool (Toolbox)
  Text Box

A box you can use to:

•	Display, enter, or edit data in a form's or report's underlying record source.

•	Display the results of a calculation. This type of text box is an unbound control.

•	Accept input from a user. This type of text box is an unbound control.

To create this control, click  [image]  in the toolbox, and then click the form or report where you want to place the control.


Right-Align Text button (Formatting toolbar)
  Align Right button

Aligns text to the right within the selected control or controls.


Select Objects tool (Toolbox)
  Select Objects

Use to select a control, section, or form. Click this tool to unlock a toolbox button that you've locked down.


Special Effect button (Formatting toolbar)
  Special Effect/Cell Effect button

Displays a variety of special effects that you can apply to:

•	The selected control or controls on a form or report. For example, you can add a shadowed effect to a text box.

•	All cells on a datasheet. For example, you can apply a Raised or Sunken effect.


Toolbox button (Formatting toolbar)
  Toolbox button

Displays or hides the toolbox. Use the toolbox to create controls on a form or report.


Form View button (tool button well)
  Form View button
Form command (View menu)

Switches to Form view of the current form.


Subform Datasheet command (View menu)
Subform Datasheet command

Switches between Form view and Datasheet view of the current subform.


Bottom subcommand (Format menu, Align command)
  Align Controls Bottom button
Bottom subcommand (Format menu, Align command)

Aligns the bottom edges of the selected controls with the bottom edge of the bottommost control in the selection.


Bring to Front command (Format menu)
  Bring To Front button
Bring to Front command (Format menu)

Moves the selected control to the top of a stack of overlapping controls.


Duplicate command (Edit menu)
  Duplicate Control button
Duplicate command (Edit menu)

Creates an evenly spaced and aligned copy of the selected control. Use to quickly create multiple controls of the same type—for example, option buttons in an option group.


Left subcommand (Format menu, Align command)
  Align Controls Left button
Left subcommand (Format menu, Align command)

Aligns the left edges of the selected controls with the left edge of the leftmost control in the selection.


Right subcommand (Format menu, Align command)
  Align Controls Right button
Right subcommand (Format menu, Align command)

Aligns the right edges of the selected controls with the right edge of the rightmost control in the selection.


Send to Back command (Format menu)
  Send To Back button
Send to Back command (Format menu)

Moves the selected control to the bottom of a stack of overlapping controls.


Set Control Defaults button (Tool button well)
  Set Control Defaults button
Set Control Defaults command (Format menu)

Uses the properties of the selected control as the default properties for any control of the same type that you later add to the current form or report.


To Fit subcommand (Format menu, Size command)
  Size To Fit button
To Fit subcommand (Format menu, Size command)

Sizes the selected control on a form or report relative to its contents. You may want to enlarge a control, for example, if you increase the font size of its text.


To Grid subcommand (Format menu, Size command)
  Size To Grid button
To Grid subcommand (Format menu, Size command)

Moves all sides of selected controls in or out to meet the nearest points on the grid. Use this command, for example, when you've changed the fineness of the grid and you want to resize controls to the new grid settings.


To Grid subcommand (Format menu, Align command)
  Align To Grid button
To Grid subcommand (Format menu, Align command)

Aligns the top left corner of each selected control to the nearest point on the grid.


Top subcommand (Format menu, Align command)
  Align Controls Top button
Top subcommand (Format menu, Align command)

Aligns the top edges of selected controls with the top edge of the topmost control in the selection.


Ruler command (View menu)
  Ruler button
Ruler command (View menu)

Shows or hides the rulers at the top and along the left side of a form or report in Design view.


Snap to Grid command (Format menu)
  Snap To Grid button
Snap to Grid command (Format menu)

Turns the grid on and off. When Snap To Grid is on, Microsoft Access for Windows 95 aligns controls with points on the grid. When Snap To Grid is off, you can place controls anywhere on the form or report.


Grid command (View menu)
  Show Grid button
Grid command (View menu)

Shows or hides the grid. Use the grid to evenly size or align controls when you design a form or report.


AutoFormat button (Form Design toolbar)
  AutoFormat button
AutoFormat command (Format menu)

Applies your choice of predefined formats to a form or report. AutoFormat sets such characteristics as the background picture for forms and reports, and fonts for controls.


Back Color button (Formatting toolbar)
  Back Color button

Displays a palette of colors you can apply to:

•	The background of the selected control or controls on a form or report.

•	The background of any section of a form or report that doesn't have its Picture property set to picture.

•	The color of an entire datasheet.

To display the palette, click the arrow. Then click the color you want to apply.


  Transparent button

Applies a clear background or border to the selected control or controls.


Bold button (Formatting toolbar)
  Bold button

Bolds text in:

•	The current datasheet. All text in the datasheet is bolded.

•	The selected control or controls in form or report Design view.


Border Color button (Formatting toolbar)
  Border Color button

Displays a palette of colors and the Transparent button. To display the palette, click the arrow.

•	Click the color you want to apply to the border of the selected control or controls.

•	Click Transparent to apply a clear border to the selected control or controls.


Hairline Border Width button (Formatting toolbar)
  Hairline Border Width button

Applies the narrowest border width to the selected control or controls.


1-pt. Border Width button (Formatting toolbar)
  1-pt. Border Width button

Applies a 1-point border width to the selected control or controls.


2-pt. Border Width button (Formatting toolbar)
  2-pt. Border Width button

Applies a 2-point border width to the selected control or controls.


3-pt. Border Width button (Formatting toolbar)
  3-pt. Border Width button

Applies a 3-point border width to the selected control or controls.


4-pt. Border Width button (Formatting toolbar)
  4-pt. Border Width button

Applies a 4-point border width to the selected control or controls.


5-pt. Border Width button (Formatting toolbar)
  5-pt. Border Width button

Applies a 5-point border width to the selected control or controls.


6-pt. Border Width button (Formatting toolbar)
  6-pt. Border Width button

Applies a 6-point border width to the selected control or controls.


Bound Object Frame tool (Toolbox)
  Bound Object Frame

A frame for displaying OLE objects, such as a series of pictures, on a form or report. This control is for objects stored in a field in the form's or report's underlying record source. A different object displays on the form or report as you move from record to record.

To create this control, click  [image]  in the toolbox, and then click the form or report where you want to place the control.


Center button (Formatting toolbar)
  Center button

Centers text within the selected control or controls.


Combo Box tool (Toolbox)
  Combo Box

Combines the features of a list box and a text box. You can type in the text box or select an entry in the list box to add a value to an underlying field.

To create this control, click  [image]  in the toolbox, and then click the form where you want to place the control. To use a wizard to help you create the combo box,  [image]  must be pressed in.


Command Button tool (Toolbox)
  Command Button

A button you can use to perform many actions—for example, finding a record, printing a record, or applying a form filter.

To create this control, click  [image]  in the toolbox, and then click the form where you want to place the control. To use a wizard to help you create the command button,  [image]  must be pressed in.


Control Wizards tool (Toolbox)
  Control Wizards button

Turns control wizards on or off. You can use control wizards to help you create a list box, combo box, option group, command button, chart, or subform. To use wizards to create these controls, the Control Wizards button must be pressed in.


Field List button (Form Design toolbar)
  Field List button
Field List command (View menu)

Displays a list of the fields contained in a form's or report's underlying record source. You can drag fields from the list to create controls that are automatically bound to the record source.


Font Size box (Formatting toolbar)
  Font Size box

Changes the font size of the text in:

•	The current datasheet. The new font size applies to the entire datasheet.

•	The selected control or controls in form or report Design view.


Font Name box (Formatting toolbar)
  Font Name box

Changes the font of the text in:

•	The current datasheet. The new font applies to the entire datasheet.

•	The selected control or controls in form or report Design view.


Fore Color button (Formatting toolbar)
  Fore Color button

Displays a palette of colors you can apply to:

•	The text on a datasheet.

•	The text in the selected control or controls on a form or report.

To display the palette, click the arrow. Then click the color you want to apply.


Form Design toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


Form Header/Footer command (Format menu)
  Form Header/Footer button
Form Header/Footer command (View menu)

Adds a form header section and a form footer section to, or removes them from, a form. These sections are typically used for such information as titles and instructions, or for command buttons that open related forms or carry out other tasks. They appear at the top and bottom of the Form window and at the beginning and end of a printout. They don't appear in Datasheet view.


Graph tool (Toolbox)
  Chart

Displays Microsoft Access data in a chart on a form or report. To add a chart created with another application, such as Microsoft Excel or Lotus 1-2-3, use the Unbound Object Frame tool or the Bound Object Frame tool in the toolbox.

To create this control, click  [image]  and then click the form or report where you want to place the control. Microsoft Access starts the Chart Wizard.


Italic button (Formatting toolbar)
  Italic button

Italicizes text in:

•	The current datasheet. All text in the datasheet is italicized.

•	The selected control or controls in form or report Design view.


Label tool (Toolbox)
  Label

A control that displays descriptive text, such as a title, a caption, or instructions on a form or report. Microsoft Access automatically attaches labels to the controls you create.

To create an unattached—or "freestanding"—label, click  [image]  in the toolbox, and then click the form or report where you want to place the control.


Align Left button (Formatting toolbar)
  Align Left button

Aligns text to the left within the selected control or controls.


Line tool (Toolbox)
  Line

A line on a form or report used, for example, to emphasize related or especially important information.

To create this control, click  [image]  in the toolbox, and then click the form or report where you want to place the control. Use the moving and sizing handles to adjust the line.


List Box tool (Toolbox)
  List Box

Displays a scrollable list of values. In Form view, you can select from the list to enter a value into a new record or to change the value in an existing record.

To create this control, click  [image]  in the toolbox, and then click the form where you want to place the control. To use a wizard to help you create the list box,  [image]  must be pressed in.


Page Header/Footer command (Format menu)
  Page Header/Footer button
Page Header/Footer command (View menu)

Adds a page header section and a page footer section to, or removes them from, a form or report. Use page headers for titles, column headings, or other information you want displayed at the top of the printed page. Use page footers for page numbers, dates, or other information you want displayed at the bottom of the printed page.


Underline button (Formatting toolbar)
  Underline button

Underlines text in:

•	The current datasheet. All text in the datasheet is underlined.

•	The selected control or controls in form or report Design view.


Properties button (Database toolbar)
  Properties button
Properties command (View menu)

Displays the general properties of the object that is currently selected in the Database window. In form and report Design views, you can also display the properties of an entire form or report, of a section (for example, a header or footer), or of a control. In table and query Design views, you can display the properties of an entire table or query, and the properties of a query's individual fields.


Code button (Database toolbar)
  Code button
Code command (View menu)

Displays a Visual Basic form module or report module in the Module window.


Copy button (Database toolbar)
  Copy button
Copy command (Edit menu)

Copies the selected item (for example, a control or a record) to the Clipboard so you can insert it elsewhere.


Cut button (Database toolbar)
  Cut button
Cut command (Edit menu)

Removes the selected item (for example, a control or a record) and places it on the Clipboard so you can insert it elsewhere. To reverse the most recent cut operation, choose Undo Cut on the Edit menu.


Database toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


Details button (Database toolbar)
  Details button
Details command (View menu)

Lists database objects for the selected object type and provides the following details: name, description, last date modified, date created, type, and owner.


Format Painter button (Database toolbar)
  Format Painter button

Copies formatting (such as colors, line styles, and font properties) from one control to another. Click Format Painter once to copy a format to a single control, or double-click to copy to several controls. If copying to several controls, press ESC when finished to turn the button off.


Large Icons button (Database toolbar)
  Large Icons button
Large Icons command (View menu)

Lists database objects in large icons for the selected object type.


List button (Database toolbar)
  List button
List command (View menu)

Lists database objects in small icons for the selected object type. Icons are alphabetized vertically within the Database window.


New Database button (Database toolbar)
  New Database button
New Database command (File menu)

Creates a new database.


New Object button (Database toolbar)
  New Object button

Creates a new database object. Select Auto Form or Auto Report from the drop-down list to have Microsoft Access create a basic form or report for you. Choose an object type (for example, New Form or New Table) to create the object yourself.


Open Database button (Database toolbar)
  Open Database button
Open Database command (File menu)

Opens an existing database.


Paste button (Database toolbar)
  Paste button
Paste command (Edit menu)

Inserts an item (for example, a control or a record) from the Clipboard into an active database object. Use Paste with Copy or Cut to copy or move an item. To reverse your paste operation, choose Undo Paste on the Edit menu.


Print button (Database toolbar)
Print command (File menu)

Prints a form, report, table, query, or module. Displays the Print dialog box first so you can change Printer settings and properties.


Save button (Database toolbar)
  Save button
Save command (File menu)
Save Layout command (File menu)

Saves the:

•	Layout of a datasheet.

•	Design of a table, query, form, or report.

•	Structure and content of a macro or module.


Small Icons button (Database toolbar)
  Small Icons button
Small Icons command (View menu)

Lists database objects in small icons for the selected object type.


Spellcheck button (Database toolbar)
  Spelling button
Spelling command (Tools menu)

Checks the spelling of text entries in table, query, or form Datasheet view or selected text in a text box in Form view.


Undo button (Database toolbar)  Undo command (Edit menu)
  Undo button
Undo command (Edit menu)

Undoes your most recent reversible action. The name of the command changes (for example, to Undo Cut or Undo Move) depending on the action you last took.

If an action can't be undone, the name of the command changes to Can't Undo.


Relationships button (Database toolbar)  Relationships command (Tools menu)
  Relationships button
Relationships command (Tools menu)

Displays the Relationships window so you can view, edit, or define relationships between tables and queries.


Open command (Database Window, Object names)
Open shortcut command

Displays the selected table's or query's Datasheet view, or the selected form's default view (either Datasheet or Form).


Design  command (Database Window, Object names)
Design shortcut command

Displays the selected object's Design view.


Preview  command (Database Window, Object names)
Preview shortcut command

Displays the selected report in Print Preview.


Run  command (Database Window, Object names)
Run shortcut command

Runs the selected macro.


Print  command (Database Window, Object names)
  Print button
Print shortcut command

Prints the selected form, report, table, query, or module immediately without displaying the Print dialog box.


Design Table  command (Relationship Window, Field list)
Design Table shortcut command

Displays the selected table's Design view.


Design Query  command (Relationship Window, Field list)
Design Query shortcut command

Displays the selected query's Design view.


Zoom  command (Table Design)
Zoom shortcut command

Displays the Zoom window so you can easily view and edit long property definitions.


Object definition  command (Macro Design title bar)
Object Definition shortcut command

Displays the Database Documentor, so you can choose to print one or more of the following report sections: Actions and Arguments, Properties, and Permissions by User and Group. Then, it prints the macro report to the default printer.


Delete Watch  command (Module Design)
Delete Watch shortcut command

Deletes the selected watch expression in the Debug window's Watch pane.


Filter Excluding Selection  command (Datasheet title bar)
Filter Excluding Selection shortcut command

Filters records by excluding selected data. To filter by excluding the selection, select a field or part of a field in a datasheet or form, and then click Filter Excluding Selection.


Pages Layout subcommand (Pages command, Print Preview)
Pages shortcut subcommands

Displays a matrix of full pages in Print Preview or Layout Preview (for example, 2x3 displays pages in 2 rows of 3 columns).


Database  command (Database Window toolbar)
Database shortcut command

Hides the Database toolbar. To redisplay the toolbar, select Toolbars on the File menu and select the check box next to the Database toolbar's name.


Relationships  command (Relationships toolbar)
Relationships shortcut command

Hides the Relationships toolbar. To redisplay the toolbar, select Toolbars on the View menu and select the check box next to the Relationships toolbar's name.


Table Datasheet  command (Table Datasheet toolbar)
Table Datasheet shortcut command

Hides the Table Datasheet toolbar. To redisplay the toolbar, select Toolbars on the View menu and select the check box next to the Table Datasheet toolbar's name.


Table Design  command (Table Design toolbar)
Table Design shortcut command

Hides the Table Design toolbar. To redisplay the toolbar, select Toolbars on the View menu and select the check box next to the Table Design toolbar's name.


Query Datasheet  command (Query Datasheet toolbar)
Query Datasheet shortcut command

Hides the Query Datasheet toolbar. To redisplay the toolbar, select Toolbars on the View menu and select the check box next to the Query Datasheet toolbar's name.


Query Design  command (Query Design and SQL toolbar)
Query Design shortcut command

Hides the Query Design toolbar. To redisplay the toolbar, select Toolbars on the View menu and select the check box next to the Query Design toolbar's name.


Form View  command (Form View toolbar)
Form View shortcut command

Hides the Form View toolbar. To redisplay the toolbar, select Toolbars on the View menu and select the check box next to the Form View toolbar's name.


Form View  command (Form Datasheet toolbar)
Form Design shortcut command

Hides the Form Design toolbar. To redisplay the toolbar, select Toolbars on the View menu and select the check box next to the Form Design toolbar's name.


Report Design  command (Report Design toolbar)
Report Design shortcut command

Hides the Report Design toolbar. To redisplay the toolbar, select Toolbars on the View menu and select the check box next to the Report Design toolbar's name.


Formatting  command (Form and Report toolbar)
Formatting (Form/Report Design) shortcut command

Hides the Formatting (Form/Report Design) toolbar. To redisplay the toolbar, select Toolbars on the View menu and select the check box next to the Formatting (Form/Report Design) toolbar's name.


Formatting  command (Datasheet toolbar)
Formatting (Datasheet) shortcut command

Hides the Formatting (Datasheet) toolbar. To redisplay the toolbar, select Toolbars on the View menu and select the check box next to the Formatting (Datasheet) toolbar's name.


Toolbox  command (Form and Report toolbar)
Toolbox shortcut command

Hides the Toolbox. To redisplay the toolbox, select Toolbox on the View menu.


Print Preview  command (Print Preview toolbar)
Print Preview shortcut command

Hides the Print Preview toolbar. To redisplay the toolbar, select Toolbox on the View menu and select the check box next to the Print Preview toolbar's name.


Filter/Sort  command (Filter/Sort toolbar)
Filter/Sort shortcut command

Hides the Filter/Sort toolbar. To redisplay the toolbar, select Toolbars on the View menu and select the check box next to the Filter/Sort toolbar's name.


Macro  command (Macro toolbar)
Macro shortcut command

Hides the Macro toolbar. To redisplay the toolbar, select Toolbars on the View menu and select the check box next to the Macro toolbar's name.


Visual Basic  command (Visual Basic toolbar)
Visual Basic shortcut command

Hides the Visual Basic toolbar. To redisplay the toolbar, select Toolbars on the View menu and select the check box next to the Visual Basic toolbar's name.


Customize command (All toolbars)
Customize shortcut command

Modifies the current toolbar. You can add, move, or remove buttons on the toolbar; add or remove space between buttons on the toolbar; or change the toolbar button's image or description.


Design view (Table window)
Table Design view

Use table Design view to create and modify the structure of a table. For more information on how to modify a table's design, click  [image].


Row Selector and Primary Key symbols (Table window)
Row Selector and Primary Key

 	Use the row selector to select an entire row.
 	Use the primary key to indicate the primary key field.


Relationships window

Use the Relationships window to view or edit existing relationships or define new ones between tables and queries.


Relationship Line (Relationships window)
Relationship Line

The relationship line indicates whether two tables have a relationship and what type of relationship.

To edit the relationship, double-click on the relationship line. The following symbols appear at each end of the relationship line if referential integrity is enforced:

 	The "one" side of a relationship.
 	The "many" side of a relationship.


Report Design  window
Report Design view

Use to graphically create and modify a report. By default, the window is divided into three sections: page header, detail, and page footer.


Ruler (Report Design window)
Ruler

Use the rulers to position controls and determine the size of form or report sections. To display or hide the rulers, choose Ruler on the View menu.


Detail section (Report Design window)
Detail

Use the detail section to contain the main body of the report. To place controls in the detail section, use the field list or the toolbox. To not use the detail section (for example, to create a summary report), set its Height property to 0.


Group Header section (Report Design window)
Group Header

Use to place information, such as a group name or group total, at the beginning of a group of records. To create a group header, select Sorting And Grouping on the View menu, select a field or expression, and set the GroupHeader property to Yes.


Group Footer section (Report Design window)
Group Footer

Use to place information, such as a group name or group total, at the end of a group of records. To create a group footer, select Sorting And Grouping on the View menu, select a field or expression, and set the GroupFooter property to Yes.


Page Header section (Report Design window)
Page Header

Use to place information, such as column headings, dates, or page numbers, at the top of each report page. To add or remove the page header, click Page Header/Footer on the View menu.

Microsoft Access adds page headers and footers as a pair. To not use the page footer, set its Height property to 0.


Page Footer section (Report Design window)
Page Footer

Use to place information, such as page summaries, dates, or page numbers, at the bottom of each report page. To add or remove the page footer, click Page Header/Footer on the View menu.

Microsoft Access adds page headers and footers as a pair. To not use the page header, set its Height property to 0.


Report Header section (Report Design window)
Report Header

Use to place information, such as a title, date, or report introduction, at the beginning of a report. To add or remove the report header, choose Report Header/Footer on the View menu.

Microsoft Access adds report headers and footers as a pair. To not use the report footer, set its Height property to 0.


Report Footer section (Report Design window)
Report Footer

Use to place information, such as a report summary, grand total, or date, at the end of a report. To add or remove the report footer section, choose Report Header/Footer on the View menu.

Microsoft Access adds report headers and footers as a pair. To not use the report header, set its Height property to 0.


Layout Preview window

Use to display the report as it will appear when printed, but using only sample data so you can take a quick look at the report layout. Layout Preview displays all report sections and sorts and groups the data in the detail section, but ignores criteria and joins in an underlying query.


Print Preview window

Use to display the report as it will appear when printed. Print Preview runs any underlying query and displays all the data in the report.


SQL view (Query window)
SQL window

Use the SQL window to display, create, or modify a query using Structured Query Language (SQL). Changes in the SQL window are reflected in the query Design view and vice versa. For example, if you add a field in the SQL window, the field also appears in the query design grid.

Also, use it to create an SQL-specific query (union, pass-through, or data definition) which you cannot create in the query Design view.


Query Design view

Use query Design view to graphically modify a query's design. The upper pane can contain a field list for each table in the active query and join lines between tables. The lower pane contains columns for each field in the query so you can, for example, display fields in the query results, sort fields, or specify criteria.


Field List (Query Design view)
Field List

Use the field list to add fields to the active query. To add a field to the active query, drag the field from the field list to a column in the design grid.


Join Line (Query Design view)
Join Line

Use the join line to relate active tables or queries. To create a join, drag a field from one table or query to a related field in another table or query. To change the join type, double-click the selected join line.


Column Selector (Query Design view)
Column Selector

Use the column selector to resize a column or select a column so you can perform an operation, such as moving or deleting it.

•	To resize a column, click the right boundary of the column selector, and then drag it left or right.

•	To size a column to fit, double-click the right boundary of the column selector.

•	To select a column, click the column selector.

•	To select more than one column, click the column selector, and then drag the pointer to adjacent columns.


Field row (Query Design view)
Field row

Use the Field row to add a field to the results of the active query. To add a field, click the cell in the query design grid, and then select from the list of fields.


Table row (Query Design view)
Table row

The Table row indicates the table in which the field is located. Use to clarify which field belongs to which table in a multiple-table query. To hide or display the Table row, select the Table Names command on the View menu.


Totals row (Query Design view)
Total row

Use the Total row to group data in the active query or perform summary calculations, such as averages and counts. To hide or display the Total row, select the Totals command on the View menu.


Crosstab row (Query Design view)
Crosstab row

Use the Crosstab row to create a crosstab query, which summarizes data in spreadsheet format using values from a field or value as columns. For example, to show total sales of each employee by month, display the months of the year as columns and the salespeople as rows.

To display the Crosstab row, select the Crosstab command on the Query menu. To create a crosstab query, select a Crosstab cell, click the arrow, and then select a heading or value from the list.


Update To row (Query Design view)
Update To row

Use the Update To row to create an action query that updates many records based on criteria, such as increasing salaries by 5%.

To display the Update To row, select the Update command on the Query menu. To create an update query, select an Update To cell, and then type a heading or value.


Delete row (Query Design view)
Delete row

Use the Delete row to create an action query that deletes a group of records based on criteria, such as all orders placed in 1990.

To display the Delete row, select the Delete command on the Query menu. To create a delete query, select a Delete cell, click the arrow, and then enter a Where or From clause.


Sort row (Query Design view)
Sort row

Use the Sort row to indicate the type of sort for the active query: Ascending (0 to 9, A to Z), Descending (9 to 0, Z to A), or not sorted. To sort on a field in the active query, select a Sort cell, click the arrow, and then select the type of sort.


Show row (Query Design view)
Show check box

Use the Show check box to display or hide a column in the results of the active query. If you hide a column, you can still use it to specify criteria.


Criteria and Or row (Query Design view)
Criteria and Or row

Use the Criteria and Or rows to define one or more set of limiting conditions (such as = "Denmark" or > 30,000) that obtains a specific set of records in the query results. You can keep adding alternate values or expressions below the Or cell.

For more information on logical operations, click  [image].


Filter By Form window

Use the Filter by Form window to specify the values you want filtered records to contain.

To filter records, click one or more fields, select from the list of values, and then click the Apply Filter button [image]. You can also type an expression in these fields.


Look For tab (Filter By Form window)
Look For tab

Use the Look For tab to filter records.

To filter records, click the Look For tab, if not already selected, and enter the values you want in one or more fields.


Or tab (Filter By Form window)
Or tab

Use the Or tab to filter records by alternate values.

To filter records, you must first enter a value in a field on the Look For tab to enable the Or tab. Click the Or tab and enter the alternate values you want the filtered records to contain in one or more fields.


Module window (Module, Design)
Module window

Use the Module window to create procedures that customize and extend your database.

For more information on the Module window, click  [image].


Object box (Module Design view)
Object box

Use the Object box to choose an object in a form or report module so you can view or edit an event procedure. To view or edit a different object, click the arrow and select an object.

Note   In a standard module, the Object box only displays the word "General".


Procedure box (Module Design view)
Proc box

Use the Proc box to choose a procedure in the current module. To edit a different procedure, click the arrow and select a procedure.

For forms and reports, the Proc box displays all the events for the object selected in the Object box, and displays events with associated procedures in bold.


Debug Window (Module Design view)
Debug window

Use the Debug window to examine and correct errors in your code. The Debug window has two panes, the Watch pane and the Immediate Pane, which you can size by moving the split bar vertically.

For more information on debugging in the Debug window, click  [image].


Ready Bar (Module Design view)
Procedure Bar

Use the Procedure Bar to see the execution mode and current context.

Mode	Text Displayed	Description
Wait	<Ready>	Code is not running.
Run	<Running>	Code is running.
Break	Current module and procedure.	Code execution is suspended.


Expression Column (Module Design view, Debug Window)
Expression column

The Expression column displays a list of current watch expressions. To size the column, click and drag the right boundary of the Expression column header left or right. To size a column to fit, double-click the right boundary of the Expression column header.

The symbols on the left indicate the Watch Type.

	Watch Expression
	Break When Expression is True
	Break When Expression has Changed


Value Column (Module Design view, Debug Window)
Value column

The Value column displays a list of watch expression values or a description of the current state of the expression (such as "out of context" if the watch expression is not active). To size the column, click and drag the right boundary of the Value column header left or right. To size a column to fit, double-click the right boundary of the Value column header.


Context Column (Module Design view, Debug Window)
Context column

The Context column displays the current context of the watch expression. To size the column, click and drag the right boundary of the Context column header left or right. To size a column to fit, double-click the right boundary of the Context column header.


Call Stack button (Module Design view, Debug Window)
Call Stack button

Use the Call Stack button to display a list of active procedure calls, starting with the most recently called, so you can trace the calling sequence.

Microsoft Access enables this button only when the Module window or the Debug window is open and code execution is suspended.


Macro window (Macro, Design)
Macro window

Use the Macro window to create and modify a macro.

For more information on macros, click  [image].


Macro Name column (Macro window)
Macro Name column

Use the Macro Name column to define more than one macro within a macro group. To show or hide the Macro Name column, select Macro Names on the View menu.


Condition column (Macro window)
Condition column

Use the Condition column to set conditions for an action. To show or hide the Condition column, select Conditions on the View menu.

For more information on conditions, click  [image].


Action column (Macro window)
Action column

Use the Action column to specify an action you want the macro to perform. To specify an action for a macro, click the Action cell, click the arrow, and then select an action on the list.

For more information on actions, click  [image].


Action Arguments (Macro window)
Action Arguments

Use action arguments to provide additional information for the selected action, such as an object name or expression.


Comment column (Macro window)
Comment column

Use the Comment column to describe what each action does, or to describe a macro group and its entry point. Comments are optional.


Row Selector (Macro window)
Row Selector

Use the row selector to select and rearrange actions so they execute in proper sequence. To move a row, click the row selector, click the row selector again, and then drag the row to the new position.


Design view (Form window)
Form Design view

Use to create and modify a form. By default, the window displays only the detail section. You can display the other sections of a form by choosing the Page Header/Footer and Form Header/Footer commands on the View menu.


Form view (View, Form)
Form view

Use to enter, change, and view data using the form itself instead of the form's datasheet. Datasheet view displays many records, whereas Form view typically displays one record at a time. In Form view, you can also display pictures, other OLE objects, command buttons, and other controls.


Detail section (Form Design view)
Detail section

Use to display records from the form's record source. This section usually contains controls bound to the fields in the record source. It can also contain unbound controls, such as labels that identify a field's contents in Form view.


Form Footer section (Form Design view)
Form Footer

Use to display, for example, instructions for using the form, command buttons, or unbound controls to accept input. Form footers display at the bottom of the Form window and at the end of a printout. They do not appear in Datasheet view. In a multiple-record form, the controls in the footer section don't scroll so they appear on the screen at all times.


Form Header section (Form Design view)
Form Header

Use to display, for example, a title for the form, instructions for using it, or command buttons that open related forms or carry out other tasks. Form headers display at the top of the Form window and at the beginning of a printout. They do not appear in Datasheet view. In a multiple-record form, the controls in the header section don't scroll so they appear on the screen at all times.


Page Footer section (Form Design view)
Page Footer

Use to display the date, page number, or any information you want at the bottom of every page. A page footer appears only on printed forms.


Page Header section (Form Design view)
Page Header

Use to display a title, column headings, or any information you want at the top of every page. A page header appears only on printed forms.


Property Sheet (Form Design view)
Property Sheet

Use to display the properties of tables, queries, forms, and reports. In table and query Design views, you can also display the properties of individual fields. In form and report Design views, you can also display the properties of sections and controls.


Toolbox (Form Design)
Toolbox

Use to create controls on the design of a form or report.

•	To create a single control, click the appropriate tool in the toolbox, and then click the area of the form or report where you want to place the control.

•	To create multiple controls of the same type, double-click the appropriate tool and then place the controls. When finished, click the tool again to turn it off.

To use a wizard to create an option group, a combo box, a list box, a command button, or a subform or subreport, make sure that  [image]  is pressed in. Then place the control on the form or report.


Database window

Use to display all database objects in the current database. Click the appropriate tab (for example, Tables) to display a list of all objects of that type. Use the buttons to the right of the list to perform such tasks as modifying existing database objects or creating new ones.


Design button (Database window)
Design button

Use to modify the design of the currently selected table, query, form, or report, or to edit the currently selected macro or module.


Field List (Relationships window)
Field List

Use to define a relationship between two tables. The field used as a table's primary key is shown in bold.

For more information on defining relationships, click  [image].


Forms tab (Database window)
Forms tab

Click to display a list of all forms in the current database. Use the buttons to the right of the list to open the selected form, modify the design of the selected form, or create a new form.


Macros tab (Database window)
Macros tab

Click to display a list of all macros in the current database. Use the buttons to the right of the list to run the selected macro, edit the selected macro, or create a new macro.


Modules tab (Database window)
Modules tab

Click to display a list of all modules in the current database. Use the buttons to the right of the list to edit the selected module or create a new module.


New button (Database window)
New button

Use to create a new database object. Before clicking this button, click the tab for the type of database object you want to create.


Open button (Database window)
Open button

Click to open the currently selected table or query in Datasheet view, or the currently selected form in Form view.


Preview button (Database window)
Preview button

Click to display the currently selected report in the Print Preview window.


Queries tab (Database window)
Queries tab

Click to display a list of all queries in the current database. Use the buttons to the right of the list to open the selected query, modify the design of the selected query, or create a new query.


Reports tab (Database window)
Reports tab

Click to display a list of all reports in the current database. Use the buttons to the right of the list to preview how the selected report will look when printed, modify the design of the selected report, or create a new report.


Run button (Database window)
Run button

Click to run the macro that is currently selected in the Database window.


Scroll bars

The shaded bars along the right and bottom sides of a window. To scroll to another part of the document, drag the box or click the arrows.


Tables tab (Database window)
Tables tab

Click to display a list of all tables in the current database. Use the buttons to the right of the list to open the selected table, modify the design of the selected table, or create a new table.


Application Title (Tools menu, Startup command, Startup dialog box, Datasheet view)
To display your own application title in the Database title bar, type an application name.

For more information on displaying an application title, click  [image].


Application Icon (Tools menu, Startup command, Startup dialog box, Datasheet view)
To display your own application icon in the Windows title bar, type the name of a bitmap (.bmp) or icon (.ico) file containing an icon.

For more information on displaying a custom icon, click  [image].


Application Icon Builder (Tools menu, Startup command, Startup dialog box, Datasheet view)
To browse for an icon bitmap file, click this button.

For more information on displaying a custom icon, click  [image].


Menu Bar (Tools menu, Startup command, Startup dialog box, Datasheet view)
To display your own menu bar as the default menu bar for the current database, click the arrow and select a menu bar from the list.

For more information on a global menu bar, click  [image].


Menu Bar Builder (Tools menu, Startup command, Startup dialog box, Datasheet view)
To start the Menu Builder so you can create a new menu bar, click this button.

For more information on a global menu bar, click  [image].


Shortcut (Tools menu, Startup command, Startup dialog box, Datasheet view)
To set your own menu bars as the default shortcut menu bar for the forms and reports in the current database, click the arrow and select a shortcut menu.

For more information on a global shortcut menu bar, click  [image].


Shortcut Builder (Tools menu, Startup command, Startup dialog box, Datasheet view)
To start the Menu Builder so you can create a new shortcut menu bar, click this button.

For more information on a global shortcut menu bar, click  [image].


Display Form (Tools menu, Startup command, Startup dialog box, Datasheet view)
To display your own form when you open the database, click the arrow, and select a form on the list.

For more information on startup forms, click  [image].


Display Database Window (Tools menu, Startup command, Startup dialog box, Datasheet view)
To display the Database window when you open the database, select Display Database Window. (This is the default.) To prevent the Database window from displaying when you open the database, clear Display Database Window.

For more information on displaying and hiding the Database window, click  [image].


Display Status Bar (Tools menu, Startup command, Startup dialog box, Datasheet view)
To display the status bar, select Display Status Bar. (This is the default.) To not display the status bar, clear Display Status Bar.

For more information on displaying or hiding the status bar, click  [image].


Allow Default Toolbars (Tools menu, Startup command, Startup dialog box, Datasheet view)
To view and use the Microsoft Access default toolbars, select Allow Built-in Toolbars. (This is the default.) To remove the Microsoft Access default toolbars, clear Allow Built-in Toolbars.

For more information on allowing and preventing access to built-in toolbars, click  [image].


Allow Toolbar Changes (Tools menu, Startup command, Startup dialog box, Datasheet view)
To allow toolbar changes, select Allow Toolbar Changes. (This is the default.) To lock toolbars (which disables the right mouse button, the Close button on toolbars, and the Toolbars command on the View menu), clear Allow Toolbar Changes.

For more information on allowing or preventing toolbar changes, click  [image].


Advanced (Tools menu, Startup command, Startup dialog box, Datasheet view)
To display advanced startup options, click Advanced.


Allow Viewing Code After Error (Tools menu, Startup command, Startup dialog box, Datasheet view)
•	Select this check box to enable the CTRL+BREAK key and allow code viewing in the Module window after an error.

•	Clear this check box to disable the CTRL+BREAK key and disallow code viewing in the Module window after an error.

For more information on enabling or disabling code viewing, click  [image].


Use Access Special Keys (Tools menu, Startup command, Startup dialog box, Datasheet view)
To allow use of special keys, select Use Access Special Keys. (This is the default.) To not allow use of special keys, clear Use Access Special Keys.

For more information on enabling or disabling special keys, click  [image].


Macro Name (Tools menu, Macro command, Macro dialog box, Datasheet view)
To run a macro, click the arrow and select a macro from the list. Microsoft Access lists macros in a macro group, using the format, group.macro (for example, Invoice.Tax).


Available Controls (Tools menu, Custom Controls command, Custom Controls dalog box, Datasheet view)
•	To  register a control, click Register and locate the file (.ocx) containing the control. Microsoft Access will update the list of available controls.

•	To  unregister a control, select a control in the Available Controls list box and click Unregister.


Control Location (Tools menu, Custom Controls command, Custom Controls dalog box, Datasheet view)
Displays the complete filename of the selected control.


Register (Tools menu, Custom Controls command, Custom Controls dalog box, Datasheet view)
To  register a control, click Register and then locate the file containing the control (.OCX).


Unregister (Tools menu, Custom Controls command, Custom Controls dalog box, Datasheet view)
To unregister the selected control in the Available Controls list box, click Unregister.


Password (Tools menu, Security command, Set Database Password subcommand, Set Database Password dialog box)
Type a password you want users to enter each time they open the current database.


Verify (Tools menu, Security command, Set Database Password subcommand, Set Database Password dialog box)
Type the password again to confirm it.


User/Group Name (Tools menu, Security command, User and Group Permissions subcommand, User and Group Permissions dialog box, Datasheet v
To display or modify permissions for a user or group, select that user or group's name.


Object Name (Tools menu, Security command, User and Group Permissions subcommand, User and Group Permissions dialog box)
To display or modify permissions for an object, select the object name.


Permissions List (Tools menu, Security command, User and Group Permissions subcommand, User and Group Permissions dialog box, Datasheet v
To display all the database users or groups in the User/Group Name list box, select either Users or Groups.


Object Type (Tools menu, Security command, User and Group Permissions subcommand, User and Group Permissions dialog box)
To display a list of the database objects in the Object Name list box, click the arrow and select a database object type from the list.


Permissions (Tools menu, Security command, User and Group Permissions subcommand, User and Group Permissions dialog box)
Displays and modifies the available permissions for the selected user, group, and object. To assign or revoke a permission, select or clear its corresponding check box.

For more information on assigning or removing permissions, click  [image].


Current User (Tools menu, Security command, User and Group Permissions subcommand, User and Group Permissions dialog box)
Displays the current user (the user currently logged on and using the database).


Object/Current Owner List (Tools menu, Security command, User and Group Permissions subcommand, User and Group Permissions dialog box, Datasheet v
To indicate the object whose ownership you want to change, select an object from the list.


New Owner (Tools menu, Security command, User and Group Permissions subcommand, User and Group Permissions dialog box)
To indicate the new owner, click the arrow and select a new owner from the list.


Change Owner List (Tools menu, Security command, User and Group Permissions subcommand, User and Group Permissions dialog box, Datasheet v
To display all the database users or groups in the New Owner list box, select Users or Groups.


Change Owner (Tools menu, Security command, User and Group Permissions subcommand, User and Group Permissions dialog box, Datasheet v
To change the owner of the selected object in the Object/Current Owner list box to the selected owner in the New Owner list box, click Change Owner.


User Name (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
User To display and modify a user name, click the arrow and select a user name. To enter a new name, type a user name.


New (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
To add a new user or group, click New and enter your Personal identifier.


Name (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
To display and modify a user name, click the arrow and select a user name. To enter a new name, type a user name.


Personal ID (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
Type your Personal identifier (PID) for the new user or group name.

A PID is a case-sensitive, alphanumeric string of 4 to 20 characters in length that Microsoft Access combines with a user account name to identify a user or group in a workgroup.


Delete (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
To delete the current user or group displayed in the Name box, click Delete.


Clear Password (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
To clear the password of the user displayed in the Name box, click Clear Password. Use to let the user enter a new logon password if they have forgotten the old one.


Group Membership group (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
•	To add the current user (displayed in the Name box) to a group, select a group from the Available Groups list box and click Add.

•	To remove the current user (displayed in the Name box) from a group, select the group from the Member Of list box and click Remove.


Print Users and Groups (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
To print a report of all user and group account information, click Print Users and Groups.


Group Name (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
To display a group name, click the arrow and select a group name. To delete a group, click the arrow, select a group name, and click Delete. To add a new group, type a new group name and click New.


Old Password (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
Type the user's current logon password for Microsoft Access.


New Password (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
Type the user's new logon password for Microsoft Access.


Source (Edit menu, Paste Special command, Paste Special dialog box, Datasheet view)
Identifies the location of the object you're pasting from the Clipboard.


Paste (Edit menu, Paste Special command, Paste Special dialog box, Datasheet view)
To embed an object previously copied from another application into the current form, report, or datasheet, click Paste.


As (Edit menu, Paste Special command, Paste Special dialog box, Datasheet view)
Select a format for the object you are pasting from the Clipboard.

For more information on paste special options, click  [image].


Paste Link (Edit menu, Paste Special command, Paste Special dialog box, Datasheet view)
To link and display the object you previously copied from another application into the current form, report, or datasheet, click Paste Link. Linking connects the object so you can view and edit it from another application. To enable this option, you must have the other application open.


Search In group (Edit menu, Find, Find dialog box, Datasheet view)
Click the arrow and select a search direction: Up (toward the first record), Down (toward the last record), or All (through the entire table).


Where (Edit menu, Find, Find dialog box, Datasheet view)
Click the arrow and select one of the match types:

•	Any Part of Field (for example, "berg" finds Bergen and Heidelberg).

•	Match Whole Field (for example, "London" finds London, but not Londonderry).

•	Start of Field (for example, "berg" finds Bergen, but not Heidelberg).


Search Fields as Formatted (Edit menu, Find, Find dialog box, Datasheet view)
•	To find data based on its display format (for example, a date stored as the number, 1/5/92, but displayed as, 05-Jan-92), select Search Fields As Formatted. Searching this way is usually slowest.

•	To find data based on its value, clear Search Fields As Formatted. (This is the default.)


Current Field (Edit menu, Find, Find dialog box, Search In group, Datasheet view)
•	To search through all records in the current field only, select Search Only Current Field. (This is the default.) Searching only the current field, especially if indexed, is usually quicker.

•	To search through all fields in all records, clear Search Only Current Field.


Find First (Edit menu, Find, Find dialog box, Datasheet view)
To find the first occurrence of the search string in the table, click Find First.


Link Group (Edit menu, OLE/DDE Links command, Links dialog box, Datasheet view)
To display the desired link group in the Links list box, click the arrow and select either OLE links or DDE links.


Links (Edit menu, OLE/DDE Links command, Links dialog box, Datasheet view)
Displays the name of each linked file, the information linked (such as a Microsoft Excel spreadsheet cell), the type of object application, and the type of updating (manual or automatic). To edit a link, select the link, and then click the desired command button.


Source (Edit menu, OLE/DDE Links command, Links dialog box, Datasheet view)
Displays the complete filename and location of the object application file for the selected link in the Links list box.


Type (Edit menu, OLE/DDE Links command, Links dialog box, Links group, Datasheet view)
Displays the object application linked to the file selected in the Links list box.


Update (Edit menu, OLE/DDE Links command, Links dialog box, Links group, Datasheet view)
•	Select Automatic to update information whenever new information becomes available. (This is the default.)

•	Select Manual to update information only when you select a link and either choose the Update Now button or, in a datasheet or form, press SHIFT+F9.


Update Now (Edit menu, OLE/DDE Links command, Links dialog box, Datasheet view)
To update the link selected in the Links list box, click Update Now. If information has changed in the object application file, the new information shows in your form, report, or datasheet.


Open Source (Edit menu, OLE/DDE Links command, Links dialog box, Datasheet view)
To edit the selected file using the object application, click Open Source.


Change Source (Edit menu, OLE/DDE Links command, Links dialog box, Datasheet view)
To specify a different object application file for the selected link, or to change item information, click Change Source.


Break Link (Edit menu, OLE/DDE Links command, Links dialog box, Datasheet view)
To break the link selected in the Links list box, click Break Link. Use when you no longer want to receive changes from the linked object (such as a Microsoft Excel spreadsheet).


Show gridlines group (Format menu, Cells command, Cells dialog box, Datasheet view)
To display or hide vertical gridlines, select or clear Vertical. To display or hide horizontal gridlines, select or clear Horizontal.

If you print a datasheet, the gridlines print if they are displayed; they don't print if they are hidden.


Cell Effect group (Format menu, Cells command, Cells dialog box, Datasheet view)
Select a cell effect for the datasheet. The sunken and raised cell effects default to a silver background color.


Gridline color (Format menu, Cells command, Cells dialog box, Datasheet view)
To change the gridline color, click the arrow and select a color on the list.


Background color (Format menu, Cells command, Cells dialog box, Datasheet view)
To change the background color, click the arrow and select a color from the list.


Row Height (Format menu, Row Height command, Row Height dialog box, Datasheet view)
To change the height of the rows, type a number (measured in points).


Standard Height (Format menu, Row Height command, Row Height dialog box, Datasheet view)
To apply the default row height (12.75 points), select Standard Height.


Column (Format menu, Unhide Columns, Unhide Column dialog box, Datasheet view)
•	To hide a column, clear its corresponding check box.

•	To display the column, select its corresponding check box.


Table Name (File, Save As, Save As dialog, Table Design view)
•	To save the table in the current database, click Within The Current Database and then type the table name.

•	To save the table to another database or file, click To An External File Or Database.


Table/Query (Relationships, Edit Relationships, Relationships dialog box)
Displays the names of the primary tables or queries and the matching field(s) for this relationship (often the table's primary key). To change the matching field(s), click the field cell, click the arrow, and then select the desired field name.


Related Table/Query (Relationships, Edit Relationships, Relationships dialog box)
Displays the names of the related tables or queries and the matching field(s) for the relationship (often called a foreign key). To change the matching field(s), click the field cell, click the arrow, and then select the desired field name.


Enforce Referential Integrity (Relationships, Edit Relationships, Relationships dialog box)
Select this option to enforce referential integrity for this relationship. Clear this option to allow changes to related tables that would break referential integrity rules. Select this option only if:

•	The matching field from the primary table is a primary key or has a unique index.

•	The related fields have the same data type.

•	Both tables are stored in the same Microsoft Access database.

For more information on referential integrity, click  [image].


Cascade Update Related Fields (Relationships, Edit Relationships, Relationships dialog box)
•	To automatically update corresponding values in the related table whenever you change a primary key value in the primary table, select Enforce Referential Integrity and then select Cascade Update Related Fields.

•	To prevent changes from being made to a primary key value in the primary table whenever there are related records in the related table, select Enforce Referential Integrity and then clear Cascade Update Related Fields.

For more information on cascading updates, click  [image].


Cascade Delete Related Records (Relationships, Edit Relationships, Relationships dialog box)
•	To automatically delete related records in the related table whenever you delete a record in the primary table, select Enforce Referential Integrity and then select Cascade Delete Related Records.

•	To prevent records from being deleted from the primary table whenever there are related records in the related table, select Enforce Referential Integrity and then clear Cascade Delete Related Records.

For more information on cascading deletes, click  [image].


Relationship Type (Relationships, Edit Relationships, Relationships dialog box)
Displays the kind of relationship defined.

•	"One-To-Many" means one of the related fields is a primary key or has a unique index.

•	"One-To-One" means both of the related fields are primary keys or have unique indexes.

•	"Indeterminate" means neither field is a primary key or has a unique index. To prevent an Indeterminate relationship, define at least one primary key or unique index for a related field.

If the relationship exists between two linked tables, the relationship will be labeled "External."

For more information on relationship types, click  [image].


Join Type (Relationships, Edit Relationships, Relationships dialog box)
To choose the type of join you want to use by default when creating queries based on the related tables, click Join Type.


Create New (Insert, Object, Insert Object dialog box, Report Design View)
To create a new object on the form or report, select the object type in the list box, and then click Create New.


Create from File (Insert, Object, Insert Object dialog box, Report Design View)
To create an object from an existing file on the form or report, click Create From File, and then type the filename.


Object Type (Insert, Object, Insert Object dialog box, Report Design View)
To indicate the type of object you want to insert on the form or report, select an object type in the list box.


Link (Insert, Object, Insert Object dialog box, Report Design View)
•	To insert the file contents into the form or report as an embedded object, clear Link. (This is the default). Changes to the file are not reflected in the form or report.

•	To insert a link to the file into the form or report, select Link. Changes to the file are reflected in the form or report.


Display as Icon (Insert, Object, Insert Object dialog box, Report Design View)
To insert an icon representing the file into the form or report, select Display As Icon. The icon can represent either a linked or embedded object.


Change Icon (Insert, Object, Insert Object dialog box, Report Design View)
To change the icon or icon label, click Change Icon.


Result Box (Insert, Object, Insert Object dialog box, Report Design view)
Describes the results of your selections.


Icon group (Insert, Object, Insert Object dialog box, Change Icon dialog box, Report Design View)
•	To keep the current icon, click Current Icon, and then select an icon in the icon list.

•	To use the default icon defined for the OLE object, click Default.

•	To create a new icon from an existing file, click From File, and then type a filename or click the Browse button, select a file containing an icon, and then select an icon in the icon list. The icon list displays one or more icons in that file.


Label (Insert, Object, Insert Object dialog box, Change Icon dialog box, Report Design View)
To change the label associated with the icon, type the new label text.


Custom Control (Insert, Custom Control, Insert OLE Controls dialog box, Report Design View)
Select a custom control in the list box.


Format group (Insert, Page Numbers, Page Numbers dialog box, Report Design view)
•	To insert a page number expression on the form or report with the format Page 5, for example, click Page N.

•	To insert a page number expression on the form or report with the format Page 5 of 10, for example, click Page N Of M.


Position group (Insert, Page Numbers, Page Numbers dialog box, Report Design view)
•	To position the page number at the top of the form or report page, click Top Of Page [Header].

•	To position the page number at the bottom of the form or report page, click Bottom Of Page [Footer].


Alignment (Insert, Page Numbers, Page Numbers dialog box, Report Design view)
•	To align the page number on the left side, center, or right side of the form or report page, select Left, Center, or Right, respectively.

•	To align the page number on the inside or outside of the form or report page for duplex printing, select Inside or Outside, respectively.


Show Number on First Page (Insert, Page Numbers, Page Numbers dialog box, Report Design view)
To show the page number on the first page, select Show Number On First Page. To hide the page number on the first page, clear Show Number On First Page.


Date group (Insert, Date and Time, Date and Time dialog box, Report Design view)
To insert a date expression on the form or report, click Include Date, and then select a date format.


Time group (Insert, Date and Time, Date and Time dialog box, Report Design view)
To insert a time expression on the form or report, click Include Time, and then select a time format.


Sample box (Inasert, Date and Time, Date and Time dialog box, Report Design view)
Displays a sample of your selections.


Column Width (Format, Column Width, Column Width dialog box)
To set the column width by the number of field characters displayed, type the number. You can also set the column width by dragging the right border of the column selector left or right.


Standard Width (Format, Column Width, Column Width dialog box)
Click this button to set the column as the default width (approximately one screen inch).


BestFit (Format, Column Width, Column Width dialog box)
Click this button to set the column width to completely show the column heading and all visible field values. You can also double-click the right border of the column selector.


Add (Query, Add Table, Add Table dialog box)
To add the selected table or query, click Add.


Close (Query, Add Table, Add Table dialog box)
Click this button to close this dialog box without saving any changes you have made.


Make New Table (Query, Make Table, Make Table dialog box)
•	To make a new table in the current database, enter the table name, and then click the Current Database option.

•	To make a new table in another database, enter the table name, click the Another Database option, and then type the filename of the database. If the database is a non-Microsoft Access database, use the following format: filename "database name", for example, "C:\Data\Sales "Paradox;".


Append To (Query, Append, Append dialog box)
•	To append the query results to a table in the current database, enter the table name, and then click the Current Database option.

•	To append to a table in another database, enter the table name, click the Another Database option, and then type the filename of the database. If the database is a non-Microsoft Access database, use the following format: filename "database name", for example, "C:\Data\Sales "Paradox;".


Parameter (Query, Parameters, Query Parameters dialog box)
To enter a parameter, click the parameter field, and then type the statement you want to appear as a prompt when you run the query. For example, to prompt for the name of a salesperson, type "Type the salesperson's name:". This statement must match the text enclosed in brackets in the Criteria row of the design grid (you can copy and paste the text to ensure an exact match).


Data Type (Query, Parameters, Query Parameters dialog box)
To enter a data type, click the data type field, and then select the data type that matches the query field for whose values you are prompting. For example, if you are prompting for the name of a salesperson, choose Text to match the data type of the Employee field (Text is the default).


Applicable Filter (File, Load From Query, Load From Query dialog box, Filter/Sort view)
To load a query from the active filter, select a query from the list.

Note   Listed queries are based on the same underlying table or query as the current datasheet or form and they are a select query with no total fields.


Query Name (File, Save As Query, Save As Query dialog box, Filter/Sort view)
To save the filter as a query for the first time or under a different name, enter the name.


Find What (Edit menu, Find command, Find dialog box, Module Design view)
Type the text string you want to search for. The default string is the selected text (if less than a line) or the first line of the selected text (if more than a line).


Direction (Edit menu, Find command, Find dialog box, Module Design view)
Click the arrow and select a search direction: Up (toward the first procedure), Down (toward the last procedure), or All (through the entire module). Microsoft Access searches procedures based on the order they were added to the module.


Match Case (Edit menu, Find command, find dialog box, Module Design view)
•	To find text based on an exact lower and upper case match, select Match Case.

•	To find text regardless of case, clear Match Case. (This is the default.)


Find Next (Edit menu, Find command, find dialog box, Module Design view)
To find the next occurrence of the text string, click Find Next.


Replace (Edit menu, Find command, find dialog box, Module Design view)
To replace the text string in the Find What box with the text string in the Replace With box, click Replace.


Replace All (Edit menu, Find command, find dialog box, Module Design view)
To replace all occurrences of the text string in the Find What box with the text string in the Replace With box, click Replace All.


Search group (Edit, Find, Find dialog, Module Design view)
•	To limit the search to the current procedure, select Current Procedure.

•	To limit the search to the current module, select Current Module. (This is the default.) Microsoft Access searches procedures based on the order they were added to the module.

•	To search all modules in the entire database, select Current Database.

•	To limit the search to selected text, select Selected Text.


Find Whole Word Only (Edit menu, Find command, Find dialog box, Module Design view)
•	To find only whole word occurrences of the search string, select Find Whole Word Only.

•	To find any occurrence of the search string, clear Find Whole Word Only. (This is the default.)


Use Pattern Matching (Edit menu, Find command, Find dialog box, Module Design view)
•	To find a text string based on pattern matching (which uses the same semantics as the Like operator), select Use Pattern Matching.

•	To find a text string based on its literal value, clear Use Pattern Matching. (This is the default.)


Replace (Insert, File, File dialog, Module Design view)
To switch to the Replace dialog box, click Replace.


Replace With (Edit menu, Find command, Replace dialog box, Module Design view)
Type the text string that you want to replace the found string with. The default value is the previous Replace With text string, if any.


Libraries/Databases
To choose from a list of available object libraries and databases directly referenced by the current database, click the arrow and select an object library or database.

For more information on using the Object Browser, click  [image].


Modules/Classes
To choose a module or class defined in the library specified in the Libraries/Databases text box, select a module or class.

For more information on using the Object Browser, click  [image].


Members
To choose a method or property in the currently selected module or class, select a method or property.

For more information on using the Object Browser, click  [image].


Element Help
To display help information for the currently selected module, class, method, or property, click Element Help.


Paste Text (View menu, Object Browser command, Object Browser dialog box, Module Design view)
Displays the method or property definition to be inserted into the Module window when you click the Paste Text button.


Show button
Displays the selected module, class, method, or property in the Module window.


Paste Text
Inserts the text displayed in the Paste Text Sample box at the insertion point in the Module window or the Debug window's Immediate pane.


Name (Edit, New Procedure, New Procedure dialog, Module Design view)
Type a valid Sub, Function, or Property procedure name.


Type group (Edit, New Procedure, New Procedure dialog, Module Design view)
Inserts a procedure declaration statement in the Module window.

•	To insert a Sub procedure, select Sub.

•	To insert a Function procedure, select Function. (This is the default.)

•	To insert a Property procedure, select Property.


Scope Group
•	To make the procedure callable from anywhere in the database, select Public. (This is the default.)

•	To make the procedure callable only from other procedures in the current module, select Private.


All Local Variables As Statics
•	To preserve the values of all local variables after procedure exit, select All Local Variables As Statics. Microsoft Access inserts the keyword Static in the procedure declaration.

•	To delete all local variables after procedure exit, clear All Local Variables As Statics. (This is the default.)


Expression
Displays the currently selected expression (such as a variable, property, or function call), or the word located at the insertion point in the Module window. If the selection is not a valid expression, then type a valid expression.


Context Group
Sets the scope of variables in the watch expression. Use if variables of the same name have a different scope and you want to ensure that Microsoft Access resolves to the desired procedure.

To limit the range of expression evaluation, click the arrow and select a procedure or module from the Procedure or Module text box.

Note   Selecting All Procedures or All Modules can slow code execution.


Watch Type
•	To add a watch expression to the Debug window's Watch pane that does not pause execution, select Watch Expression.

•	To add a watch expression to the Debug window's Watch pane and pause execution when the expression evaluates to true, select Break When Expression Is True.

•	To add a watch expression to the Debug window's Watch pane and pause execution when the expression changes value, select Break When Expression Has Changed.


Delete
To delete the currently selected watch expression in the Debug window's Watch pane, click Delete.


Current Context
Displays the current context (the database, module, and procedure) of the instant watch expression.


Expression
Displays the currently selected expression or the expression at the insertion point.


Value
Displays the current value or a description of the current state of the watch expression.


Add
Adds an expression (such as a variable, property, or function call) to the list of watch expressions in the Debug window's Watch pane.


Database Module Procedure
To go to a procedure in the call stack, select the procedure and click the Show button. Microsoft Access displays the procedures starting with the most recently called.


Show
To display the selected procedure in the Module window's Procedure list box, click Show. You can also double-click the procedure name.


Available References
•	Select or clear the check box next to the object library or database, to make procedures from another object library or database callable or unavailable.

•	The Available References box lists object libraries and databases in the order Microsoft Access searches to resolve references.


Priority
To change the search order Microsoft Access uses to resolve references, select a library or database and then click the Priority up or down arrows. Use, for example, when two procedures from different libraries or databases have the same name and you want to ensure that Microsoft Access resolves to the desired procedure first.


Macro Name (File, Save As, Save As dialog, Macro Design view)
To convert the macro to Visual Basic, click Save As Visual Basic Module.


Macro Name (Macro single step dialox box)
Displays the name of the macro currently running.


Condition (Macro single step dialox box)
Displays the current condition, if any, for the active macro.


Action Name (Macro single step dialox box)
Displays the name of the current action in the active macro.


Arguments for the action (Macro single step dialox box)
Displays the arguments, if any, for the current action in the active macro.


Step button (Macro single step dialox box
To execute the next action in the macro, click Step. If no error occurs, Microsoft Access displays the next action in the dialog box.


Halt button (Macro single step dialox box)
To stop running the macro and close the dialog box, click Halt.


Continue button (Macro single step dialox box)
To turn off the single step mode and run the remainder of the macro, click Continue. If you are running a macro in a macro group, Microsoft Access stops when it gets to a new macro name.


Print Margins group (Tools, Options, Options dialog, General tab)
To change the default margins for datasheets and modules, or new forms and reports, type the measurements you want. Margins can range from zero to the width or height of the printed page. Use the Page Setup command on the File menu to change the margins of existing forms and reports.


Default Database Directory option (Tools, Options, Options dialog, General tab)
To change the default folder for storing new databases, type the path to any valid folder. If no path is specified (which is the default), Microsoft Access defaults to the My Documents folder.


New Database Sort Order option (Tools, Options, Options dialog, General tab)
To change the default alphabetic sort order for new databases, click the arrow and select the language you want to use. The default is General (used for English, French, German, Italian, Portuguese, and Modern Spanish).

To reset the sort order for an existing database, select the language you want to use and then compact the database.


Default Field Sizes group (Tools, Options, Options dialog, Tables/Queries tab)
To change the default field size for new tables:

•	In the Text box, type the number of characters (0 through 255) for fields with a Text data type.

•	Click the arrow next to the Number box; then select the option you want for fields with a Number data type.

For more information on changing the FieldSize property in existing tables, click  [image].


Default Field Type option (Tools, Options, Options dialog, Tables/Queries tab)
To change the default data type of fields in new tables, or fields you add to existing tables, click the arrow and select from the list of data types.

For more information on changing the data type of existing fields, click  [image].


AutoIndex on Import option (Tools, Options, Options dialog, Tables/Queries tab)
To automatically index one or more fields imported from an external file, type the beginning or ending characters of the field name. For example, if you type "unit; name", Microsoft Access will index "UnitPrice" and "CompanyName" fields imported from a file containing these field names. This option also applies to fields you create in table Design view.


Show Table Names option (Tools, Options, Options dialog, Tables/Queries tab)
Select to show or clear to hide table names on the query design grid. When shown, table names are displayed beneath the field names. This option is especially useful for tracking the source of fields in a query based on several tables.


Output All Fields option (Tools, Options, Options dialog, Tables/Queries tab)
Select to display all fields in a query's underlying tables or queries when you run the query. Clear to display only those fields added to the design grid. This option applies only to new queries you create.

For more information on changing the OutputAllFields property of existing queries, click  [image].


Enable AutoJoin option (Tools, Options, Options dialog, Tables/Queries tab)
Select to automatically create an inner join between two tables you add to the design grid. Clear if you want to define relationships between the tables yourself.

For the AutoJoin to occur:

•	The tables must each have a field with the same name and data type.

•	One of the join fields must be a primary key.


Run Permissions group (Tools, Options, Options dialog, Tables/Queries tab)
Select the appropriate option to change the default permissions for allowing others to view data returned from queries or to run action queries.

For more information on changing default permissions for all queries, click [image].


Code Colors group (Tools, Options, Options dialog, Module tab)
To distinguish textual components of procedures displayed in the Module window, click the arrow next to the Text Area option and select the type of text you want. Then click the arrow next to, and select a color from, the Foreground and Background options.


Font option (Tools, Options, Options dialog, Module tab)
To set the font used in the Module window, click the arrow and select the font you want.


Size option (Tools, Options, Options dialog, Module tab)
To set the size of the font used in the Module window, click the arrow and select the size you want. Available sizes depend on the font you have selected in the Font option.


Tab Width option (Tools, Options, Options dialog, Module tab)
To set the number of spaces between tab stops in the Module window, type a value from 1 through 32.


Sample (Tools, Options, Options dialog, Module tab)
Displays sample text based on your settings in the Code Colors option group and the Font and Size options.


Coding Options group (Tools, Options, Options dialog, Module tab)
Select or clear the appropriate option to enable or disable:

•	Automatic indenting of successive lines of code.

•	Automatic checking for correct syntax each time you enter a line of code.

•	Automatic error handling when you run a procedure containing an On Error statement.

•	The requirement that all variables used in a procedure are explicitly declared.

•	Compiling of individual modules. When this option is cleared, Microsoft Access compiles all the modules in the database whenever it compiles an individual module.


Code View group (Tools, Options, Options dialog, Module tab)
To control how code is displayed in the Module window:

•	Select Full Module View to display the declarations section and all procedures; clear this option to display only the declarations section or an individual procedure. When this option is cleared, use the Procedures box in the Module window to select the parts of your code you want to display.

•	Select Procedure Separator to separate each procedure from the next with a line across the window; clear this option to hide the separators.


Current Database Only group (Tools, Options, Options dialog, Module tab)
Use these options to specify:

•	The value you want the Command function to return. This option provides the same functionality as the /Cmd command line option. For more information on the Command function, click  [image].

•	The parts of a module you want Microsoft Access to include or ignore when running and compiling. Type a conditional compilation argument (constant). Use a colon to separate multiple arguments.


Default Find/Replace Behavior group (Tools, Options, Options dialog, Edit/Find tab)
Select the appropriate option to set the default behavior of Microsoft Access Find/Replace operations:

•	Fast Search searches the current field and matches the whole field.

•	General Search searches all fields and matches any part of the field.

•	Start of Field Search searches the current field and matches the beginning character(s) of the field.


Show list of values in group (Tools, Options, Options dialog, Edit/Find tab)
Select or clear the appropriate option to control the size of the value lists displayed for fields in the Filter By Form window. You can display values for indexed and/or non-indexed fields in the current database and/or a linked table in an external file. The more options you have selected, the longer it will take to display the value lists.


Confirm group (Tools, Options, Options dialog, Edit/Find tab)
Select or clear to display or not display a confirmation message when you change a record, delete a database object, or run an action query.


Don't display list where more than this number of rows read option (Tools, Options, Options dialog, Edit/Find tab)
Type the maximum number of records you want Microsoft Access to read while building the value lists for fields in the Filter by Form window. No value list will display for any field where the number of records required to complete the list exceeds the number you've specified. All value lists displayed contain unique values, even if their fields are not indexed.


Default Record Locking group (Tools, Options, Options dialog, Advanced tab)
Select the appropriate option to specify the default record locking behavior in a multiuser environment:

•	No Locks does not lock the record you're editing.

•	All Records locks all records in the form or datasheet (and underlying tables) you're editing for as long as you have it open.

•	Edited Records locks the record you're editing.

For more information on record locking, click  [image].


DDE Operations group (Tools, Options, Options dialog, Advanced tab)
Select or clear the appropriate option to:

•	Ignore or accept DDE requests from other applications.

•	Enable or disable updating DDE links. When this option is selected, DDE links are updated at the interval specified in the Refresh Interval option.


OLE/DDE Timeout (sec) option (Tools, Options, Options dialog, Advanced tab)
To set the interval after which Microsoft Access re-attempts an OLE or DDE operation that has failed, type a value from 0 through 300 seconds.


Default Open Mode group (Tools, Options, Options dialog, Advanced tab)
Select the appropriate option to open an existing database for exclusive or shared access.


Number of Update Retries option (Tools, Options, Options dialog, Advanced tab)
To set the number of times Microsoft Access tries to save a changed record that is locked by another user, type a value from 0 through 10.


ODBC Refresh Interval (sec) option (Tools, Options, Options dialog, Advanced tab)
To set the interval after which Microsoft Access automatically refreshes records that you're accessing using ODBC, type a value from 1 through 3,600 seconds. This setting takes effect only if the database is shared on a network.


Refresh Interval (sec) option (Tools, Options, Options dialog, Advanced tab)
To set the number of seconds after which Microsoft Access automatically updates records in Datasheet or Form view, type a value from 1 through 32,766 seconds.

For more information on updating records click  [image].


Update Retry Interval (msec) option (Tools, Options, Options dialog, Advanced tab)
To set the number of milliseconds after which Microsoft Access automatically tries to save a changed record that is locked by another user, type a value from 0 through 1,000 milliseconds.


Buttons (View, Toolbars, Customize, Customize Toolbars dialog)
To add a button to a toolbar, drag your selection from the Buttons/Objects option box to the toolbar. (The name of this option changes depending on your selection in the Categories box.) You can add the following buttons to any toolbar that is currently displayed:

•	A built-in button.

•	A button to create a custom control.

•	A button that displays a table, form, or report, or that runs a query or a macro.


Categories (View, Toolbars, Customize, Customize Toolbars dialog)
To customize a toolbar, first select the category associated with the button. For example, select Formatting to display the built-in formatting buttons you can add to a toolbar; select All Tables to create a button for opening any table in your database.


Description (View, Toolbars, Customize, Customize Toolbars dialog)
To display a description of any button that you can add to a toolbar, point to the button or object name in the Buttons/Objects option box. (The name of the box changes depending on your selection in the Categories box.)


Toolbar Name (View, Toolbars, New, New Toolbar dialog)
To name a custom toolbar, type the name and click OK. You can then begin to construct the new toolbar by clicking Customize.


Color Buttons (View, Toolbars, Toolbars dialog)
Select to turn on or clear to turn off colors for all toolbar buttons. Turning off colors may improve screen resolution if you are using a monochrome monitor.


Customize (View, Toolbars, Toolbars dialog)
To modify a toolbar, click Customize. You can add, move, or remove buttons on toolbars; add or remove space between buttons on toolbars; or change a toolbar button's image or description.


Large Buttons (View, Toolbars, Toolbars dialog)
Select to enlarge toolbar buttons or clear to return them to their original size. Try selecting this option if the buttons are too small to see clearly on your monitor.


New (View, Toolbars, Toolbars dialog)
Type a name for the custom toolbar, and click OK. To modify the toolbar (for example, to add or remove buttons), click Customize.


Rename (View, Toolbars, Toolbars dialog)
To change the name of a custom toolbar, click Rename. You must first select the name you want to change in the Toolbars list. The Rename button is not available for built-in toolbars.


Reset (View, Toolbars, Toolbars dialog)
To return a built-in toolbar to its original state, click Reset. You must first select the name of the toolbar you want to reset in the Toolbars list. Use Reset if you've modified a built-in toolbar and you want to restore the original buttons to their original order.


Show ToolTips (View, Toolbars, Toolbars dialog)
Select to turn on or clear to turn off ToolTips.


Toolbars (View, Toolbars, Toolbars dialog)
To show or hide a toolbar, select or clear the box next to the toolbar's name in the Toolbars list.


Options dialog box (Tool menu)
For details on an option in the dialog box, click  [image]  and then select the option.


Show group (Tools, Options, Options dialog, View tab)
Select or clear the appropriate box to show or hide:

•	The status bar.

•	The dialog box that appears when Microsoft Access starts up.

•	Any object in the Database window with a property of Hidden. When shown, the hidden objects display as dimmed icons.

•	Tables automatically created by Microsoft Access when you create a new database, or any system object you create. When shown, these objects display as dimmed icons in the Database window.


Show in Macro Design group (Tools, Options, Options dialog, View tab)
Select or clear the appropriate box to show or hide the Macro Name and Condition columns for new macros.


Toolbars group (Tools, Options, Options dialog, View tab)
Select or clear the appropriate box to display:

•	Large (if selected) or small (if cleared) toolbar buttons.

•	Toolbar buttons in color (if selected) or black and white (if cleared).

•	ToolTips for toolbar buttons (if selected).


Default Colors group (Tools, Options, Options dialog, Datasheet tab)
Click the appropriate arrow to display the font, background, and gridline colors for new datasheets. For each option that you want to change, select the color you want.


Default Font group (Tools, Options, Options dialog, Datasheet tab)
Click the appropriate arrow to display the font, font weight, and font size for new datasheets. For each option that you want to change, select the choice you want. Select or clear the Italic and Underline options.


Default Gridlines Showing group (Tools, Options, Options dialog, Datasheet tab)
Select or clear the appropriate options to show or hide horizontal and vertical gridlines. For no gridlines, clear both options.


Default Column Width option (Tools, Options, Options dialog, Datasheet tab)
To change the default column width for new datasheets, type a measurement in inches or centimeters, depending on the system of measurement specified under Regional Settings in the Windows Control Panel.


Default Cell Effect group (Tools, Options, Options dialog, Datasheet tab)
To change the default appearance of cells for new datasheets, select the option you want. You can change the Microsoft Access default of Flat to a Sunken or Raised effect.


Show Animations option (Tools, Options, Options dialog, Datasheet tab)
Select to turn on or clear to turn off animated features of Microsoft Access, such as the animated insertion of new columns into datasheets.


Move After Enter group (Tools, Options, Options dialog, Keyboard tab)
Select an option to define the behavior of the ENTER key:

•	Don't Move (the insertion point remains in the current field).

•	Next Field (moves the insertion point to the next field).

•	Next Record (moves the insertion point to the first field of the next record).


Arrow Key Behavior group (Tools, Options, Options dialog, Keyboard tab)
Select an option to define the behavior of the RIGHT or LEFT ARROW key:

•	Next Field (right or left moves the insertion point to the next or previous field).

•	Next Character (right or left moves the insertion point to the next or previous character).

To move the insertion point within a field when the Next Field option is selected, press F2.


Behavior Entering Field group (Tools, Options, Options dialog, Keyboard tab)
Select an option to change the default behavior of the ENTER, TAB, and arrow keys when used to move from field to field on forms and datasheets:

•	Select Entire Field selects the entire field.

•	Go to Start of Field places the insertion point at the start of the field.

•	Go to End of Field places the insertion point at the end of the field.


Cursor Stops at First/Last Field option (Tools, Options, Options dialog, Keyboard tab)
Select to lock the cursor within the current record, preventing the LEFT and RIGHT ARROW keys from moving the insertion point from the first or last field to the previous or next record. Clear to allow the insertion point to move from record to record.


Selection Behavior group (Tools, Options, Options dialog, Forms/Reports tab)
Select an option to define selection behavior when you drag the pointer to select controls on forms and reports:

•	Partially Enclosed (the selection must cover only part of a control or group of controls).

•	Fully Enclosed (the selection must fully encompass a control or group of controls).


Form Template option (Tools, Options, Options dialog, Forms/Reports tab)
Type the name of an existing form to use as the template for a new form. The new form has the same section and control properties as the existing form. This option applies only to forms that you create without using a wizard.


Report Template option (Tools, Options, Options dialog, Forms/Reports tab)
Type the name of an existing report to use as the template for a new report. The new report has the same section and control properties as the existing report. This option applies only to reports that you create without using a wizard.


AutoCorrect command (Tools menu)

Customizes the settings used to automatically correct text as you type, and lets you create and modify the list of words to correct as you type.


  Merge It button
Merge It subcommand (Tools menu, OfficeLinks command)

Starts the Microsoft Word Mail Merge Wizard, which merges Microsoft Access data with a Microsoft Word document so you can create, for example, form letters or mailing labels.


Analyze Table button (Database toolbar) Table subcommand (Tools menu, Analysis command)
  Analyze Table button
Table subcommand (Tools menu, Analyze command)

Starts the Table Analyzer Wizard, which analyzes a table, and if necessary, splits it into related tables and creates a more efficient table design.


Analyze Performance button (Database toolbar) Performance subcommand (Tools menu, Analysis command)
  Analyze Performance button
Performance subcommand (Tools menu, Analyze command)

Starts the Performance Analyzer, which analyzes the performance of your database and database objects.


Documentor button (Database toolbar)Documentor subcommand (Tools menu, Analysis command)
  Documentor button
Documentor subcommand (Tools menu, Analyze command)

Starts the Database Documentor, which provides detailed descriptions of one or more database objects.


Database Password subcommand (Tools menu, Protection command)
Set Database Password subcommand (Tools menu, Security command)

Toggles between setting and removing the password used to open the current database. Only users who have Administer permission on the current database and who know the current password can set or remove the database password.


Users and Groups subcommand (Tools menu, Protection command)
  User and Group Permissions button
User And Group Permissions subcommand (Tools menu, Security command)

Displays, assigns, and removes user and group account permissions for the current database and its objects. Also, it displays, assigns, and changes ownership of database objects.


User And Group Accounts subcommand (Tools menu, Security command)

Displays, prints, adds, removes, and changes user and group accounts. Also, it changes the password of the default user account, Admin.


User-Level Security Wizard subcommand (Tools menu, Security command)

Starts the Security Wizard, which creates a new, secured copy of the current database.


Startup command (Tools menu)

Controls and customizes various database startup properties and actions, such as application title and icon, and which startup form to display.


Custom Controls command (Tools menu)

Registers or unregisters custom controls in the Windows registration database (which is used for tracking information about applications, such as filename and path). Registration determines whether or not custom controls are available for use.


Menu Builder subcommand (Tools menu, Add-ins command)

Creates a custom menu bar that you can attach to a form or report.


Attachment Manager subcommand (Tools menu, Add-ins command)
Linked Tables Manager subcommand (Tools menu, Add-ins command)

Displays or refreshes links to tables. Use the Linked Tables Manager, for example, to refresh links when the structure or location of a linked table has changed.


Add-in Manager subcommand (Tools menu, Add-ins command)

Installs, uninstalls, or customizes add-ins, which are tools that extend the functionality of Microsoft Access. Add-ins include wizards, builders, and menu add-ins (which are additional menu items you can add to the Add-ins command on the Tools menu).


Application Splitter subcommand (Tools menu, Add-ins command)
Database Splitter subcommand (Tools menu, Add-ins command)

Splits the current database into two databases: A back end database containing all the tables, and a front end database containing all other objects and linked tables to the back end database.


Advanced Filter/Sort command (Records menu)
  Advanced Filter/Sort button
Advanced Filter/Sort subcommand (Records menu, Filter command)

Displays the Filter/Sort window so you can create a filter to apply to the datasheet or form.


Refresh command (Records menu)

Updates records in the active form or datasheet with changes made to the data by others in a multiuser environment.

For more information on displaying the most current data, click  [image].


Data Entry command (Records menu)

Hides all current records and displays a blank record so you can enter data in a form or datasheet. Only newly added records will show until you choose the Remove Filter/Sort command from the Records menu.


Paste Special command (Edit menu)

Links or embeds an OLE object or pastes text in your current form, report, or datasheet. Also, lets you select the data format for the object and display it as an icon.


Paste Append command (Edit menu)

Adds records from the Clipboard to the end of the active form or datasheet. Records that Microsoft Access can't append (for example, due to validation errors) are placed in the Paste Errors table.


Select Record command (Edit menu)

Selects the current record in a form or datasheet so you can, for example, copy it to another table.


Select All Records command (Edit menu)

Selects all records in a form or datasheet so you can, for example, copy them to another table.


Links command (Edit menu)
OLE/DDE Links command (Edit menu)

Updates, modifies, copies, reconnects, or breaks the link of the selected object.


Cells command (Format menu)

Turns horizontal and vertical gridlines on and off, changes the cell and gridline color, and changes the cell effect (such as sunken or raised).


Rename Column command (Format menu)

Lets you rename the selected column.

Note   This command changes the datasheet field name and can require changes to property settings, queries, macros, and code that reference the old name.


Hide subcommand (Format menu, Column command)
Hide Column command (Format menu)

Hides the selected datasheet columns from view. Use, for example, to remove columns from the window without having to run a query. You can use hidden column values as the criteria for a filter, even though the column remains hidden after the filter is applied.


Unfreeze All Columns command (Format menu)

Unfreezes all frozen columns in a datasheet. When you unfreeze columns, they remain in the same order they were in when frozen.


Delete (Edit menu)
Delete command (Edit menu)

Deletes the selected object or item, such as a form in the Database window or a Field row in table Design view. To select an object or item, click it.


Select All command (Edit menu)

Selects all field definitions in a table, controls in a form or report, or rows in a macro so you can, for example, copy these items to a new object.


Test Validation Rules (Edit menu)
Test Validation Rules command (Edit menu)

Reports whether or not data in a table meets the table's record and field validation rules (the ValidationRule, Required, and AllowZeroLength properties). If the table is large, this operation can take a long time.


Lookup Column command (Insert menu)
Lookup Column/Field command (Insert menu)

Displays the Lookup Wizard so you can create a lookup column for the selected data type. A lookup column looks up values from another table and stores the reference to the values in the main table. For example, you can lookup a shipper from the Shippers table to store the Shipper ID in the Orders table.


Clear Layout command (Edit menu)
 Clear Layout button
Clear Layout command (Edit menu)

Clears the Relationships window. Clearing the layout does not delete actual tables, queries, or relationships.


Remove Table command (Relationships menu)
Hide Table command (Relationships menu)

Hides the selected table or query in the Relationships window. To select a table or query, click anywhere in its field list.


Edit Relationship command (Relationships menu)
Edit Relationships command (Relationships menu)

Displays settings for the selected relationship line so you can modify the relationship. You can also double-click the relationship line to modify the relationship.


Zoom 200% subcommand (View menu)

Zooms the current page by a factor of 200 percent and makes that the new zoom setting.


Zoom 150% subcommand (View menu)

Zooms the current page by a factor of 150 percent and makes that the new zoom setting.


Zoom 100% subcommand (View menu)

Displays the page(s) the same size as the printed page and makes that the new zoom setting.


Zoom 75% subcommand (View menu)

Zooms the current page by a factor of 75 percent and makes that the new zoom setting.


Zoom 50% subcommand (View menu)

Zooms the current page by a factor of 50 percent and makes that the new zoom setting.


Zoom 25% subcommand (View menu)

Zooms the current page by a factor of 25 percent and makes that the new zoom setting.


Zoom 10% subcommand (View menu)

Zooms the current page by a factor of 10 percent and makes that the new zoom setting.


Fit to Window subcommand (View menu)

Displays one or more full pages in Print Preview or Layout Preview. The current Pages setting determines the number of full pages displayed. To change the Pages setting, choose the Pages command from the View menu.


Pages 4 subcommand (View menu)

Displays four full pages in Print Preview or Layout Preview.


Pages 8 subcommand (View menu)

Displays eight full pages in Print Preview or Layout Preview.


Pages 12 subcommand (View menu)

Displays twelve full pages in Print Preview or Layout Preview.


Select Report command (Edit menu)

Selects the report so you can see its property sheet.


Report Header/Footer command (Format menu)
  Report Header/Footer button
Report Header/Footer command (View menu)

Displays or removes report header and footer sections. Use the report header (which appears once at the beginning of the report) for introductions that contain, for example, text, pictures, and logos. Use the report footer (which appears once at the end of the report) for summaries that contain, for example, grand totals.


Print Preview command (File menu)
  Print Preview button
Print Preview command (File menu)

Displays the active object, such as a table, form, or report, as it will appear when printed. You can zoom in or out of a page or see several pages at once.


Page Numbers command (Insert menu)
Page Number command (Insert menu)

Inserts a page number expression in a text box control on a form or report. You can specify format, position, alignment, and whether or not to display the page number on the first page.


Date And Time command (Insert menu)

Inserts a current date and time expression in a text box control on a form or report. You can specify format and whether or not to display just the date or time.


Picture command (Insert menu)

Inserts a picture into an image control on the form or report. Use an image control for static pictures, such as a logo, and for fast access.


Object command (Insert menu)
  Insert Object button
Object command (Insert menu)

Inserts an OLE object into a bound or unbound object frame on a form or report or a selected OLE object field in a datasheet. To edit the object using its associated application, double-click on the object.

For more information on OLE object fields, click   [image].


Delete Column command (Edit menu)
  Delete Column button
Delete Column command (Edit menu)

•	In query Design view, deletes the selected column from the design grid, which in turn deletes a field from the active query or filter. To select a column, click the column selector. Deleting a column from the design grid does not delete it from the underlying table.

•	In table Datasheet view, permanently deletes the selected column. To select a column, click the field selector.


Table Names command (View menu)
  Table Names button
Table Names command (View menu)

Switches between displaying and hiding table names immediately below the field name in the design grid. Displaying table names helps you keep track of which field belongs to which table in multi-table queries.


Join Properties command (View menu)

Changes the type of join between two tables for a selected join line. To select a join line, click the join line (this bolds the line).


Column command (Insert menu)
  Insert Column button
Column command (Insert menu)

Inserts a column to the left of the selected column in the design grid so you can add a field to the active query. To select a column, click the column selector.


Remove Table command (Query menu)

Removes the selected table or query from the active query. Select the table or query by clicking anywhere in its field list. Removing a table or query clears the contents of the design grid, but does not delete it from the current database.


Union subcommand (Query menu, SQL Specific command)

Displays the SQL window and makes the active query a union query. A union query combines fields from two or more tables or queries end-to-end, rather than side-by-side.


Data Definition subcommand (Query menu, SQL Specific command)

Displays the SQL window and makes the active query a data definition query, which creates or alters tables in the current database.


Pass-Through subcommand (Query menu, SQL Specific command)

Displays the SQL window and makes the active query a Pass-through query, in which an SQL query is sent to a database server (such as Microsoft SQL Server). For details on the SQL query syntax, see the documentation for the database server.


Parameters command (Query menu)
  Parameters button
Parameters command (Query menu)

Sets the parameters and data types for a query that prompts you for information (such as criteria) when you run it. For example, you can prompt for a salesperson's name and a range of dates to get varied results from the same query.


Delete Tab command (Edit menu, Filter by Form view)
Delete Tab command (Edit menu)

Deletes the active Or tab or Look for tab so the values specified in it are no longer used as criteria to filter records.


Save All Modules (File menu)
Save All Modules command (File menu)

Saves all open modules, whether compiled or uncompiled.


Clear (Edit menu)
Clear command (Edit menu)

Clears selected text from the Module window or Debug window without moving it to the Clipboard.


Last Position (View menu)
Last Position command (View menu)

Returns to the last line position in the previous procedure that you were viewing in the Module window.


File command (Insert menu)

Inserts code from a text file into the current module above the line containing the insertion point.


Step To Cursor (Run menu)
Step To Cursor command (Run menu)

Runs the procedure from the current executable statement to the selected line or insertion point (which must be within the same procedure), and then re-enters break mode. Use to avoid unnecessarily stepping through each line of code.


Set Next Statement command (Run menu)

Changes the run sequence of your code so that the statement at the insertion point is the next statement to run. The statement to be run must be within the currently running procedure. Use when debugging to rerun a statement or skip statements you don't want to run.


Show Next Statement command (Run menu)

Shows the next executable statement. Use when examining other statements during debugging so you can return to your original place.


Compile All Modules (Run menu)
  Compile Loaded Modules button
Compile Loaded Modules command (Run menu)

Compiles all procedures in open modules or modules behind open forms and reports. Use to check for compile-time and syntax errors.


Add Watch command (Tools menu)

Creates a watch expression at the selected expression (such as a variable, property, or function call) in the Module window so you can examine its values in the Watch pane of the Debug window.


Edit Watch command (Tools menu)

Modifies or deletes a watch expression at the selected expression (such as a variable, property, or function call). In the Watch pane of the Debug window, you can also double-click on the selected expression.


References command (Tools menu)

Displays a list of available references from object libraries and databases. Use to make procedures in other databases callable from the current database, or to resequence the order in which Microsoft Access searches object libraries and databases to resolve references.


Split Window (Windows menu)
Split Window command (Windows menu)

Toggles between splitting the Module window into two panes and restoring the two panes to one window. To size the panes, move the split bar vertically.

Note   In a split window, you cannot view procedures from different modules.


Help on Keyword command (Help)
Help On Keyword command (Help menu)

Displays a Help topic for the selected keyword or the keyword located at the insertion point.


Decrease subcommand (Format menu, Vertical Spacing command)

Decreases the vertical space between selected controls by one grid point. If your selection includes three or more controls, spacing is first equalized and then decreased.


Increase subcommand (Format menu, Vertical Spacing command)

Increases the vertical space between selected controls by one grid point. If your selection includes three or more controls, spacing is first equalized and then increased.


Make Equal subcommand (Format menu, Vertical Spacing command)

Equalizes the vertical space between three or more selected controls.


To Tallest subcommand (Format menu, Size command)

Sizes selected controls to the same height as the tallest selected control.


To Widest subcommand (Format menu, Size command)

Sizes selected controls to the same width as the widest selected control.


Toolbox command (View menu)
  Toolbox button
Toolbox command (View menu)

Shows or hides the toolbox. Use the toolbox to create controls on a form or report.


Text Box subcommand (Format menu, Change To command)

Changes the selected control to a text box. Microsoft Access copies any common properties from the selected control to the text box.


Label subcommand (Format menu, Change To command)

Changes the selected control to a label. Microsoft Access copies any common properties from the selected control to the label.


List Box subcommand (Format menu, Change To command)

Changes the selected control to a list box. Microsoft Access copies any common properties from the selected control to the list box.


Combo Box subcommand (Format menu, Change To command)

Changes the selected control to a combo box. Microsoft Access copies any common properties from the selected control to the combo box.


Check Box subcommand (Format menu, Change To command)

Changes the selected control to a check box. Microsoft Access copies any common properties from the selected control to the check box.


Toggle Button subcommand (Format menu, Change To command)

Changes the selected control to a toggle button. Microsoft Access copies any common properties from the selected control to the toggle button.


Option Button subcommand (Format menu, Change To command)

Changes the selected control to an option button. Microsoft Access copies any common properties from the selected control to the option button.


Image subcommand (Format menu, Change To command)

Changes an unbound OLE object to an image control. An image control loads and displays more quickly than an unbound OLE object. However, if you change an unbound OLE object to an image, you can no longer edit the object in Microsoft Access.


Decrease subcommand (Format menu, Horizontal Spacing command)

Decreases the horizontal space between selected controls by one grid point. If your selection includes three or more controls, spacing is first equalized and then decreased.


Increase subcommand (Format menu, Horizontal Spacing command)

Increases the horizontal space between selected controls by one grid point. If your selection includes three or more controls, spacing is first equalized and then increased.


Make Equal subcommand (Format menu, Horizontal Spacing command)

Equalizes the horizontal space between three or more selected controls.


Select Form command (Edit menu)
Select Form/Report command (Edit menu)

Selects the entire form or report so you can, for example, view or modify its properties with the Properties command on the View menu. When the Ruler is displayed, you can also click the form selector or report selector to select the entire form or report.


To Narrowest subcommand (Format menu, Size command)

Sizes selected controls to the same width as the narrowest selected control.


To Shortest subcommand (Format menu, Size command)

Sizes selected controls to the same height as the shortest selected control.


Auto Arrange subcommand (View menu, Arrange Icons command)

Turns Auto Arrange on and off. When Auto Arrange is on, icons on the Database window are aligned with the underlying grid in even columns. You can move an icon only to a different position within the columns. When Auto Arrange is off, icons are released from the grid—you can move them anywhere on the Database window.


By Created subcommand (View menu, Arrange Icons command)

Arranges icons on the Database window by the date on which they were created. This command is available only if you have chosen the List or Details command on the View menu.


By Modified subcommand (View menu, Arrange Icons command)

Arranges icons on the Database window by the date on which they were last modified. This command is available only if you have chosen the List or Details command on the View menu.


By Name subcommand (View menu, Arrange Icons command)

Arranges icons on the Database window alphabetically by name. This command is available only if you have chosen the List or Details command on the View menu.


By Type subcommand (View menu, Arrange Icons command)

Arranges icons on the Database window by type. For example, queries are grouped by such types as select, crosstab, and union, and then displayed alphabetically, first by type and then by name. This command is available only if you have chosen the List or Details command on the View menu.


Arrange Icons command (Window menu)

Arranges all icons of minimized database objects into rows across the bottom of the window.


Cascade command (Window menu)

Arranges windows in Microsoft Access in an overlapping pattern so that the title bar of each window remains visible.


Encrypt/Decrypt subcommand (Tools menu, Protection command)
Encrypt/Decrypt Database subcommand (Tools menu, Security command)

Makes an encrypted or decrypted copy of a database. Encrypting a database protects information by making it indecipherable to utility programs or word processors. Decrypting a database reverses the encryption.


Forms command (View menu)
Forms subcommand (View menu, Database Objects command)

Displays in the Database window a list of forms in the current database.


Hide command (Window menu)

Hides the active window. The window remains open when hidden. To redisplay a hidden window, choose Unhide on the Window menu (or on the File menu if all windows are hidden).


Macros command (View menu)
Macros subcommand (View menu, Database Objects command)

Displays in the Database window a list of the macros in the current database.


Modules command (View menu)
Modules subcommand (View menu, Database Objects command)

Displays in the Database window a list of the modules in the current database.


Queries command (View menu)
Queries subcommand (View menu, Database Objects command)

Displays in the Database window a list of the queries in the current database.


Reports command (View menu)
Reports subcommand (View menu, Database Objects command)

Displays in the Database window a list of the reports in the current database.


Tables command (View menu)
Tables subcommand (View menu, Database Objects command)

Displays in the Database window a list of the tables in the current database.


Tile Vertically command (Window menu)

Arranges windows in Microsoft Access as vertical panes so that all windows are visible and don't overlap.


Tile Horizontally command (Window menu)

Arranges windows in Microsoft Access as horizontal panes so that all windows are visible and don't overlap.


Toolbars command (View menu)

Displays a list of toolbars so you can display or modify them. You can also create, modify, or delete custom toolbars.


Unhide command (Window menu)

Displays hidden windows. If all open windows are hidden, this command appears on the File menu in the Microsoft Access window.


Redo command (Edit menu)
  Redo button
Redo command (Edit menu)

Restores what you've undone with the Undo button or command. The command name changes to Redo Typing, Cut, Delete, or Paste, depending on what you’ve undone.


Close command (File menu)
  Close button
Close command (File menu)

Closes the current window. If you have made changes to the design of a database object and not yet saved them, Microsoft Access asks if you want to save them.


Save As command (File menu)
  Save As/Export button
Save As/Export command (File menu)

•	Saves a copy of an object in the current database under a different name.

•	Saves the output of a table, query, form, report, or module to a text, rich-text format, or Microsoft Excel file. You can save all of an object's output or a selected portion of a datasheet.

•	Exports an object to another Microsoft Access database.

•	Exports a table or query to a different file format, such as Microsoft Excel or Paradox.


Database Properties command (File menu)

Displays database properties so you can view or modify them.


Page Setup command (File menu)

Sets options, such as margins, paper size, and printer, for printing forms and reports. To set options for tables, queries, or modules, choose Print Preview from the File menu. After the object is displayed, choose Page Setup on the File menu.


Mail It button (tool button well)
  Mail It button
Send command (File menu)

Sends the output of a table, query, form, report, or module through your electronic mail program. You can send all of an object's output or a selected portion of a datasheet in one of the following formats: MS-DOS text, rich-text format, or Microsoft Excel.


Exit command (File menu)

Ends your Microsoft Access session. If you have made changes to the design of a database object and not yet saved them, Microsoft Access asks if you want to save them.


Toolbars command (File menu) - Null menu bar
Toolbars command (File menu)

Modifies built-in toolbars or creates, modifies, or deletes custom toolbars.


Unhide command (File menu) - Null menu bar
Unhide command (File menu)

Displays hidden windows. This command appears on the File menu when all open windows are hidden and on the Windows menu when some windows are hidden and others are not.


Can't Undo command (Edit menu)

Indicates that your most recent action cannot be undone. When an action can be undone, the command name changes depending on the last action that you performed (for example, to Undo Cut or Undo Saved Record).


Delete command (Edit menu)
Delete Relationship shortcut menu

•	In general, removes the selected item without placing it on the Clipboard. Choose Delete when you want to permanently remove an item and don't want to paste or insert it elsewhere.

•	In the Relationship window, deleting a relationship line deletes the relationship between the two tables.

•	In query Design view, deleting a join line causes the query to return every combination of records between the two tables, but does not delete the relationship, if any, between the two tables.


Compact subcommand (Tools menu, Database Utilities command)

Reduces the disk space used to contain the latest changes to a database. The compacted database file is usually smaller and often provides better performance.


Repair subcommand (Tools menu, Database Utilities command)

Repairs a database that has been damaged, for example, by a power failure that caused an unexpected shutdown of Microsoft Access. You may need to redo any design or editing changes that you made during the session in which the damage occurred.


Convert subcommand (Tools menu, Database Utilities command)

Converts a database created with Microsoft Access version 1.0, 1.1, or 2.0 to a Microsoft Access for Windows 95 database.


Database Utilities command (Tools menu)

Maintains a Microsoft Access database.


Options command (Tools menu)

Customizes characteristics of the Microsoft Access environment, such as screen fonts and colors, keyboard actions, and viewing options.


Make Replicable (Save As dialog box)
•	To allow the new object to be replicated to other databases, select Make Replicable.

•	To prevent the new object from being replicated to other databases, clear Make Replicable.

For more information making design changes, click  [image].


Switchboard Manager subcommand (Tools menu, Add-ins command)

Creates, edits, and deletes switchboard forms for an application.


Apply Filter/Sort button  Show All Records button (Filter toolbar)
  Apply Filter | Remove Filter button

Applies or removes a filter in the active datasheet or form.


Apply Filter/Sort button (Toolbar Well, Records group) Apply Filter/sort command (Records menu)
  Apply Filter/Sort button
Apply Filter/Sort command (Records menu)

Applies a filter or sort in the active datasheet or form.


Remove Filter/Sort button (Toolbar Well, Records group) Remove Filter/Sort command (Records menu)
  Remove Filter/Sort button
Remove Filter/Sort command (Records menu)

Removes a filter or sort in the active datasheet or form, if one is currently applied, and displays the most current records.


Selector box (Report Design window)
Form and Report Selector

Use the form and report selector to select the entire form or report (Microsoft Access displays a black square in the selector to indicate the form or report is currently selected.)

To display the property sheet of the form or report, double-click on the form or report selector.


Macro Selector (Macro Design window)
Selector

Use the selector to select the entire view or window so you can, for example, copy data to another application from Datasheet view or copy the current macro to another macro in the Macro window.


Row Selector and New Record (Datasheet view)
Row Selector and New Record

 	Use the row selector to select an entire row.
 	Indicates the row to use to add a new record.


Delete Row shortcut command (Indexes window)
Delete Row shortcut command

Deletes the selected row(s). To select a row, click the row selector.


Object command (Edit menu)
Object Type Object command (Edit menu)

Displays several subcommands (which vary depending on the selected object) that let you:

•	Open the selected OLE object in a separate window or in-place by using its source application (such as Microsoft Word or Microsoft Excel). "In-place" editing temporarily replaces the Microsoft Access menus and toolbars with those of the source application, but is enabled only in Form view if the application supports in-place editing.

•	Convert compatible OLE object types.

•	Play or run the selected OLE object (such as a sound object or video clip).

•	Open the property sheet for the selected custom control.


Column command (Insert menu)

Inserts a new column to the left of the selected column or the column with the current insertion point.


Dialog Box Standard Help Topic
For details on an option in the dialog box, click  [image]  and then click the option.


Properties command (View menu)

Displays the property sheet for the selected item, such as a table field or form control. Displays the active object's property sheet if nothing is selected.


Custom Control command (Insert menu)
Custom Controls command (Insert menu)

Inserts a custom control into your form or report. Custom controls are stored as separate files and must be registered. You can obtain custom controls from Microsoft or a third-party developer.


Object Name
Type the name of the object.


Structure Only (Paste Table As dialog box)
•	To paste only the structure of the table, select Structure Only.

•	To paste the structure of the table and its data, select Structure And Data.

•	To append the data to an existing table, select Append Data To Existing Table.


Import button (Toolbar Well, File Group) Import/Link command (Tools menu)
  Import button
Import subcommand (File menu, Get External Data command)

Copies data from a text file, spreadsheet, or database table into a Microsoft Access 95 table. Also, it copies objects from another Microsoft Access database into the current database.


Import button (File menu, Get External Data command, Import subcommand, Import dialog box)
To import the selected text file, spreadsheet, or database table, click Import.


Link Tables subcommand (File menu, Get External Data command)

Links data from a table in another database to a Microsoft Access version 7.0 table in the current database.


Link button (File menu, Get External Data command, Link subcommand, Link dialog box)
To link the selected table, click Link.


Allow Default Shortcut Menus (Tools Menu, Startup Command, Startup Dialog Box)
To allow or restrict the use of Microsoft Access default shortcut menus, select or clear Allow Default Shortcut Menus.

For more information on enabling or disabling shortcut menus, click  [image].


Allow Full Menus (Tools Menu, Startup Command, Startup Dialog Box)
To allow or restrict the use of all Microsoft Access menu commands, select or clear Allow Full Menus.

For more information on displaying and hiding built-in menus, click  [image].


Section Selector (Form and Report Design view)
Section Selector

To display the section's property sheet, double-click the section selector.


Macro command (Tools menu)
Run Macro subcommand (Tools menu, Macros command)

Runs a macro.

For more information on running macros, click  [image].


Convert Form's or Report's Macros to Visual Basic
Convert Form's/Report's Macros To Visual Basic subcommand (Tools menu, Macros command)

Converts a macro to a Visual Basic module.


Add Error Handling To Generated Function (Tools menu, Macros command, Convert Form's or Report's Macros to Visual Basic, subcommand, Convert form or report macros dialog box)
Select or clear this option to add or not add error handling to a generated function in a Visual Basic module.


Include Macro Comments (Tools menu, Macros command, Convert Form's or Report's Macros to Visual Basic, subcommand, Convert form or report macros dialog box)
Select or clear this option to include or ignore Macro comments in a Visual Basic module.


Convert button (Tools menu, Macros command, Convert Form's or Report's Macros to Visual Basic, subcommand, Convert form or report macros dialog box)
To Convert the macro to a Visual Basic module, click Convert.


Field List (Report Design view)
Field list

Use the field list to add bound controls to the form or report. To add a bound control, drag the field from the field list to a section on the form or report.


Autodialer button (Toolbar Well, Records group)
  AutoDialer button

Dials a selected phone number automatically.

For more information on autodialing, click  [image].


Builder list (Build button, Choose Builders dialog)
Select the builder you want.


Relationships toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


Result (Tools menu, References command, References dialog box, Module Design view)
Describes the path and language for your current selection.


New Object Type list (Database window, Insert menu, Object Type, New Object Type dialog box)
Select a wizard or view to create the new object.


Choose The Table Or Query (Database window, Insert menu, Object Type, New Object Type dialog box)
Select a table or query to use as the source of data for the new form or report.


Indexes window

Use to view, edit, and delete indexes in the active table.

For more information on indexes, click  [image].


Index Name column (Indexes window)
Index Name column

Use to provide a name for this index.


Field Name column (Indexes window)
Field Name column

Use to enter the name of the field to be indexed.


Sort Order column (Indexes window)
Sort Order column

Use to indicate the type of sort order: Ascending (0 to 9, A to Z) or Descending (9 to 0, Z to A).


Row Selector and Primary Key symbols (Indexes window)
Row Selector and Primary Key

 	Use the row selector to select an entire row.
 	Indicates the primary key field.


Sorting and Grouping window (View, Sorting and Grouping)
Sorting And Grouping box

Use to view and edit sorting and grouping fields, expressions, and properties for the current report.

For more information on sorting and grouping report records, click  [image].


Field Expression column (Sorting and Grouping box)
Field/Expression column

Use to select a field or type an expression to sort or group on.

For more information on using the Field/Expression column, click  [image].


Sort Order column (Sorting and Grouping box)
Sort Order column

Use to indicate the type of sort order: Ascending (0 to 9, A to Z) or Descending (9 to 0, Z to A).

For more information on sorting records in a report, click  [image].


Row Selector - describe all the symbols (Sorting and Grouping box)
Row Selector and Sorting And Grouping Indicator

Use the row selector to select an entire row.
Indicates the field or fields the records are grouped on.


Convert Database subcommand (Tools menu, Database Utilities command, Null Window)

Converts a Microsoft Access version 1.x or 2.0 database to a Microsoft Access 95 database.

For more information on converting databases, click  [image].


Convert button (Null Window, Tools menu, Database Utilities command, Convert Database subcommand, Convert dialog box)
To convert the selected Microsoft Access version 1.x or 2.0 database, click Convert.


Compact Database (Tools menu, Database Utilities command, Null Window)
Compact Database subcommand (Tools menu, Database Utilities command, Null Window)

Rearranges how a fragmented database is stored on disk. Compacting a database often reduces its size and improves its performance.

For more information on compacting a database, click  [image].


Compact button (Null Window, Tools menu, Database Utilities command, Compact Database subcommand, Compact dialog box)
To compact the selected database, click Compact.


Repair Database subcommand (Tools menu, Database Utilities command, Null Window)

Repairs a damaged database. The database may become damaged if, for example, there is a power outage or your computer experiences a hardware problem while the database is in use.

For more information on repairing a database, click  [image].


Repair button (Null Window, Tools menu, Database Utilities command, Repair Database subcommand, Repair dialog box)
To repair the selected database, click Repair.


Encrypt/Decrypt Database subcommand (Tools menu, Security command, Null Window)

Makes an encrypted or decrypted copy of a database. Encrypting a database protects information by making it indecipherable to utility programs or word processors (but with a small decrease in performance). Decrypting a database reverses the encryption.

For more information on encrypting and decrypting a database, click  [image].


First Record button (Print Preview - navigation button)
First Page button

Use to move to the first page in Print Preview or Layout Preview.


Last Record button (Print Preview - navigation button)
Last Page button

Use to move to the last page in Print Preview or Layout Preview.


Next Record button (Print Preview - navigation button)
Next Page button

Use to move to the next page in Print Preview or Layout Preview.


Previous Record button (Print Preview - navigation button)
Previous Page button

Use to move to the previous page in Print Preview or Layout Preview.


Specific Record button (Print Preview - navigation button)
Specific Page box

Use to move to a specific page in Print Preview or Layout Preview by entering the page number.


First Record button (Sample Preview - navigation button)
First Record button

Use to move to the first record in Datasheet or Form view.


Last Record button (Sample Preview - navigation button)
Last Record button

Use to move to the last record in Datasheet or Form view.


Next Record button (Sample Preview - navigation button)
Next Record button

Use to move to the next record in Datasheet or Form view.


Previous Record button (Sample Preview - navigation button)
Previous Record button

Use to move to the previous record in Datasheet or Form view.


Specific Record button (Sample Preview - navigation button)
Specific Record box

Use to move to a specific record in Datasheet or Form view by entering the record number.


New Record button (Sample Preview - navigation button)
New Record button

Use to move to the end of the form or datasheet so you can enter a new record.


Inner Join option (Join Properties dialog box, Relationship window, Relationship dialog box, Join Type button, 1 option)
Click this option to create an inner join.

To see examples of different join types and how they affect query results, click  [image].


Left-Outer Join (Join Properties dialog)
Click this option to create a left-outer join.

To see examples of different join types and how they affect query results, click  [image].


Right-Outer Join (Join Properties dialog)
Click this option to create a right-outer join.

To see examples of different join types and how they affect query results, click  [image].


Synchronize Now subcommand (Tools menu, Replication command)

Synchronizes the open replica or Design Master with another member in the replica set.

For more information on synchronization, click  [image].


Create New Replica subcommand (Tools Menu, Replication Command)
Create Replica subcommand (Tools Menu, Replication Command)

Creates a replica of the open database at a designated location. You can also create a replica by dragging the database from the Database window to the Windows Briefcase on the desktop.

For more information on creating replicas, click  [image].


Make Design Master subcommand (Tools menu, Replication command)
Recover Design Master subcommand (Tools menu, Replication command)

Makes the open replica the Design Master for the replica set. The Design Master is the only member of the replica set you can use to change the structure of the database.

Note   Use this command only when the Design Master replica has been permanently lost. Using more than one Design Master can cause irreparable problems to your replica set.

For more information on recovering the Design Master, click  [image].


Resolve Conflicts subcommand (Tools menu, Replication command)

Starts the Conflict Resolver, which displays the records that were in conflict during previous synchronizations between the open replica or Design Master and other members in the replica set.

For more information on resolving conflicts, click  [image].


Expression Box (Builder button, Expression Builder dialog box)
Displays the expression as you build it. Use the operator buttons and list boxes to help you build the expression using correct syntax.

Microsoft Access often inserts placeholders surrounded by double angle-brackets that you must modify to complete the expression. Either enter an appropriate value, or select the placeholder and substitute it with an element from the right-most box.

For more information on creating expressions, click  [image].


Undo button (Builder button, Expression Builder dialog box)
To undo the last element you inserted in the Expression box, click Undo. You can only undo the last operation. If you click Undo again before the next operation, it reinserts the removed element.


Help button (Builder button, Expression Builder dialog box)
To get help on a selected element in the right-most box, click Help.


Paste button (Builder button, Expression Builder dialog box)
To insert the selected element in the right-most box into the Expression box, click Paste.

For more information on pasting elements, click  [image].


Operator button (Builder button, Expression Builder dialog box)
To insert a common operator, click the appropriate operator button. To display a complete list of operators in the right-most box, double-click the Operators folder in the left-most box.


Left list box (Builder button, Expression Builder dialog box)
Displays a hierarchy of folders containing main categories of expression elements. To find an element, double-click a folder in the left-most box to display subcategories in the middle box and elements in the right-most box.


Middle list box (Builder button, Expression Builder dialog box)
•	Displays subcategories of expression elements, which are displayed in the right-most box. To choose a different subcategory and display a different list of elements in the right-most box, select a subcategory in the middle box.

•	Displays expression elements. To insert a selected element in the Expression box, click Paste or double-click the element in the middle box.


Right list box (Builder button, Expression Builder dialog box)
Displays expression elements depending on the selected folder in the left-most box and selected subcategory in the middle box. To insert a selected element in the Expression box, click Paste or double-click on the element in the right-most box.

If the element is a function, its arguments are displayed in the lower left-hand corner of the Expression Builder.


Sample (File, Page Setup, Page Setup dialog, Margins tab)
Shows how your document will look with the current margins.


Print Headings (datasheet)/Print Data Only (forms or reports) (File, Page Setup, Page Setup dialog, Margins tab)
Select Print Headings to print column headings when printing a datasheet.

Select Print Data Only to omit labels, control borders, gridlines, and graphics such as lines and boxes when printing a form or report.


Printer For group (File, Page Setup, Page Setup dialog, Page tab)
•	Click Default Printer to use your default printer to print your document.

•	Click Use Specific Printer, and then click Printer to select a different printer.


Grid Settings group (File, Page Setup, Page Setup dialog, Layout tab)
When printing multiple-column reports or labels, you can specify the following values:

•	In the Items Across box, specify the number of columns.

•	In the Row Spacing box, specify the space between rows.

•	In the Column Spacing box, specify the space between columns.


Item Size group (File, Page Setup, Page Setup dialog, Layout tab)
When printing multiple-column reports or labels, you can specify the following values:

•	In the Width box, specify the width of the column.

•	In the Height box, specify the height of the row.

•	Select Same As Detail to make the values in the Width and Height boxes match the width and height of the Detail section of the report.


Layout Items group (File, Page Setup, Page Setup dialog, Layout tab)
When printing multiple-column reports or labels, to specify the order records are printed:

•	Click Down, Then Across, to print records down the leftmost column, then down the next column, and so on.

•	Click Across, Then Down, to print records across the first row, then across the second row, and so on.


Setup button (File, Print, Print dialog)
Controls margin settings and, when printing forms and reports, layout settings (such as the number of columns to print).


Import group (File, Get External Data, Import, Import Objects dialog)
•	Select Relationships to include relationships defined between the tables and queries you import.

•	Select Toolbars to include all custom toolbars in the database you are importing from. If a custom toolbar being imported has the same name as a custom toolbar in the current database, that toolbar won’t be imported.

•	Select Import/Export Specs to include all import and export specifications in the database you are importing from.


Import Tables group (File, Get External Data, Import, Import Objects dialog)
•	Click Definition And Data to import the definition of a table and the data it contains.

•	Click Defintion Only to import only the definition of a table.


Import Queries group (File, Get External Data, Import, Import Objects dialog)
•	Click As Queries to save imported queries as queries.

•	Click As Tables to save imported queries as tables.


Options button (File, Get External Data, Import, Import Objects dialog)
Click to specify options for importing objects from another Microsoft Access database. You can import:

•	Relationships, custom toolbars, and import and export specifications.

•	Definition and data or definition only of tables.

•	Queries as either queries or tables.


About Microsoft Access command (Help menu)

Provides information about Microsoft Access for Windows 95 and the operating system installed on your computer, and instructions for contacting Microsoft Product Support Services.


Examines your computer and displays information about your computer and its operating system.


Provides information on how to contact Microsoft Product Support Services if you have a question about Microsoft Access for Windows 95.


Answer Wizard (Help menu)

Directs you to Help topics based on questions you type, such as "How do I create a form?"


Microsoft Network (Help menu)
The Microsoft Network command (Help menu)

Connects you to the Microsoft Access Forum if you have an account on The Microsoft Network.


Exclusive option (File Open dialog)
Select to prevent other users from opening the database while you have it open.


Location option (Create Shortcut dialog)
To place the shortcut in a location other than the desktop, type the new path in the Location box. If you're not sure of the path, use the Browse button to find it.


Browse button (Create Shortcut dialog)
To locate a file, click Browse.


This Database Is On The Network group (Create Shortcut dialog)
To store the network location of the database it opens along with the shortcut, select This Database Is On The Network, and then type the network path. This enables others to use the shortcut without having to know, or having previously connected to, that location.

For more information on specifying a network path for the shortcut, click  [image].


Create a New Database Using group (Microsoft Access dialog)
•	Select Blank Database to create a blank database to which you can add tables, forms, reports, and other objects.

•	Select Database Wizard to create the required tables, forms, and reports for the type of database you choose.


Open an Existing Database option (Microsoft Access dialog)
•	Select Open An Existing Database to open a database on your computer or on the network.

•	To open one of the last four databases you had open, double-click the filename in the list. To open a database not listed, double-click More Files.


Gridline Color button (Formating (Datasheet) toolbar)
  Gridline Color button

Displays a palette of colors. To display the palette, click the arrow. Click the color you want to apply to the gridlines on the datasheet.


Gridlines Shown button (Formating (Datasheet) toolbar)
  Gridlines Shown button

Displays options for showing gridlines on a datasheet. To display the options, click the arrow. Click the option you want to apply to the datasheet.


Show Both Gridlines button (Formating (Datasheet) toolbar)
  Show Both Gridlines button

Shows both horizontal and vertical gridlines on a datasheet.


Show Horizontal Gridlines button (Formating (Datasheet) toolbar)
  Show Horizontal Gridlines button

Shows only horizontal gridlines on a datasheet.


Show Vertical Gridlines button (Formating (Datasheet) toolbar)
  Show Vertical Gridlines button

Shows only vertical gridlines on a datasheet.


Show No Gridlines button (Formating (Datasheet) toolbar)
  Show No Gridlines button

Hides all gridlines on a datasheet.


Chart command (Insert menu)

Starts the Chart Wizard so you can add a chart that displays Microsoft Access data to a form or report.

To add a chart created with another application, such as Microsoft Excel or Lotus 1-2-3, use the Unbound Object Frame tool in the toolbox.


Select Object button (Form & Report Design toolbar)
  Select Object button

Selects an entire form or report, a section of a form or report, or a control on a form or report. Click the down arrow and select from the list.


Size To Fit Form command (Window menu)

Adjusts the size of the Form view window to display only whole records. Microsoft Access adjusts the size of the form depending on the form's DefaultView property setting.

To get information on sizing a form to fit its contents, click  [image].


Border Width button (Formatting toolbar)
  Border Width button

Displays a variety of line widths. Click the width you want to apply to the border of the selected control or controls.


Field Selector (Form Datasheet view)
Field Selector

Use the field selector to resize a field or to select a field so you can perform an operation, such as copying or moving it.

•	To resize a field, click the right boundary of the field selector, and then drag it left or right.

•	To size a field for best fit, double-click the right boundary of the field selector.

•	To select a field, click the field selector.

•	To select more than one field, click the field selector, and then drag the pointer to adjacent fields.


Datasheet view (Form Datasheet view)
Datasheet view

Use to display data from a table, form, or query in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data. In table Datasheet view, you can also add new fields.


Form View toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


Tab Order button (Tool button well)
  Tab Order button
Tab Order command (View menu)

Changes the order in which the insertion point moves through controls when you tab through a form in Form view.


Auto Order (View, Tab Order, Tab Order dialog)
Click to set the tab order from left-to-right, top-to-bottom. Fields in the form's Datasheet view are rearranged to correspond to the new tab order.


Custom Order (View, Tab Order, Tab Order dialog)
Click the gray bar to the left of the field you want to move (or click the bar and drag to select contiguous fields); then click again and drag the field(s) to their new position. Changing the tab order also rearranges the fields in the form's Datasheet view.


Section group (View, Tab Order, Tab Order dialog)
Select the section of the form whose tab order you want to change.


Custom Control command (Insert menu)

Adds a custom control to a form or report. A custom control, like a built-in control, is an object that you insert on a form or report to enable or enhance a user's interaction with that form or report.


Microsoft Access Help Topics button (Database toolbar)
  Microsoft Access Help Topics button
Microsoft Access Help Topics command
(Help menu)

Provides various entry points to Microsoft Access for Windows 95 Help. You can display Help contents organized by category, use an alphabetized index, search for a specific topic, or ask the Answer Wizard a question.


F1 Help button (Database toolbar)
  F1 Help button

Provides help on:

•	Property settings in table, query, form, and report Design view. On the property sheet, click the property you want and then click F1.

•	Actions and their arguments in macro Design view. Click the action or argument you want and then click F1.

•	Visual Basic keywords. Highlight the keyword you want and then click F1.


Line Up Icons command (View menu)

Aligns icons in the Database window with the nearest points on the underlying grid.


Create Shortcut command (Edit menu)

Creates a shortcut so you can quickly open a database object by clicking an icon. You can open objects that are stored in a database on your computer, on a network file server, or in a shared directory. You can place shortcut icons on the desktop, in a folder, or on the Start menu.


1, 2, 3...9 command (Window menu)

Lists all visible windows. To bring a window to the front, click it.


1, 2, 3...9 command (File menu)

Lists most recently used databases. To open a file from the list, click it.


Utility toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


Query Datasheet toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


Formatting toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


Formatting toolbar (Form/Report Design)
Formatting toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


Save <Object> <Objectname> group (File, Save As/Export, Save As dialog box)
Select the appropriate option to save a copy of a database object:

•	Within The Current Database As. Type a new name for the copy in the New Name box, and click OK.

•	To An External File Or Database. Click OK to display the Save In dialog box.


Microsoft toolbar

Help is available for each button on this toolbar. Click  [image]  and then click the specific button you want information about.


General Properties sheet

Use to display the general properties of the object currently selected in the Database window.


To display a hidden window, select the name of the window and click OK.


Rename command (Edit menu)

Renames the selected database object. Type the new name and press ENTER. You can restore the original name by clicking the Undo Rename command on the Edit menu before carrying out another command.

To get information on renaming database objects, click  [image].