Alignment and Sizing (Format menu)

Displays the Alignment and Sizing toolbar. Use the buttons on the toolbar to align or size text boxes and other controls on a data access page.


Size Height button (Alignment and Sizing toolbar)

Sizes a control to the same height as the selected control. Select a control that has the height you want, click the Size Height button, and then click the control that you want to resize.

To size just one control, click the Size Height button once. To lock the Size Height button so that you can align several controls, double-click it. To unlock the button, click the same button or a different button, or press ESC.


Size Width button (Alignment and Sizing toolbar)

Sizes a control to the same width as the selected control. Select a control that has the width you want, click the Size Width button, and then click the control that you want to resize.

To size just one control, click the Size Width button once. To lock the Size Width button so that you can align several controls, double-click it. To unlock the button, click the same button or a different button, or press ESC.


Size Height/Width button (Alignment and Sizing toolbar)

Sizes a control to the same height and width as the selected control. Select a control that has the same height and width you want, click the Size Height/Width button, and then click the control that you want to resize.

To size just one control, click the Size Height/Width button once. To lock the Size Height/Width button so that you can align several controls, double-click it. To unlock the button, click the same button or a different button, or press ESC.


Align Left button (Alignment and Sizing toolbar)

Aligns a control with the left edge of the selected control. Select a control that's aligned the way you want it, click the Align Left button, and then click the control that you want to bring into alignment.

To align just one control, click the Align Left button once. To lock the Align Left button so that you can align several controls, double-click it. To unlock the button, click the same button or a different button, or press ESC.


Align Top button (Alignment and Sizing toolbar)

Aligns a control with the top edge of the selected control. Select a control that's aligned the way you want it, click the Align Top button, and then click the control that you want to bring into alignment.

To align just one control, click the Align Top button once. To lock the Align Top button so that you can align several controls, double-click it. To unlock the button, click the same button or a different button, or press ESC.


Align Right button (Alignment and Sizing toolbar)

Aligns a control with the right edge of the selected control. Select a control that's aligned the way you want it, click the Align Right button, and then click the control that you want to bring into alignment.

To align just one control, click the Align Right button once. To lock the Align Right button so that you can align several controls, double-click it. To unlock the button, click the same button or a different button, or press ESC.


Align Bottom button (Alignment and Sizing toolbar)

Aligns a control with the bottom edge of the selected control. Select a control that's aligned the way you want it, click the Align Bottom button, and then click the control that you want to bring into alignment.

To align just one control, click the Align Bottom button once. To lock the Align Bottom button so that you can align several controls, double-click it. To unlock the button, click the same button or a different button, or press ESC.


Line up Icons command (View menu)
Line Up Icons (View menu)

Aligns icons in the Database window with the nearest points on the underlying grid.


Create Shortcut (Edit menu)

Creates a shortcut so you can quickly open a database object by clicking an icon. You can create shortcuts for 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 (Window menu)

Lists all visible windows. To bring a window to the front, click it.


1, 2, 3, 4 (File menu)

Lists most recently used databases. To open a file from the list, click it. To change the number of files listed, click Options on the Tools menu, click the General tab, select the Recently used file list check box, and enter a number.


Select a window to display it.


Rename command (Edit menu)
Rename (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.


Size To Fit Form (Window menu)

Adjusts the size of the Form view window (using the Default View property setting) to display only whole records. For more information, refer to Microsoft Access Help.


Field Selector

Resizes a field, or selects a field so you can, for example, copy or move 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

Displays 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.


Tab Order (View menu)

Changes the order in which the insertion point moves through controls when you tab through a form.


Auto Order (View, Tab Order, Tab Order dialog)
Sets 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.


ActiveX Control (Insert menu)

Adds an ActiveX control (such as the Calendar control) to a form or report. ActiveX controls are stored as separate files and must be registered. You can obtain ActiveX controls from Microsoft or a third-party developer. For more information, refer to Microsoft Access Help.


About Microsoft Access (Help menu)

Provides information about Microsoft Access 2000 and the operating system installed on your computer, and instructions for contacting Microsoft Technical Support Services.


Examines your computer and displays information about your computer and its operating system.


Provides information on how to contact Microsoft Technical Support Services if you have a question about Microsoft Access 2000.


Location text box (Create Shortcut dialog)
To place the shortcut in a location other than the desktop, type the new path in the Location box.


Browse button (Create Shortcut dialog)
Locates a folder on your computer or on the network.


This Database Is On The Network group (Create Shortcut dialog)
Select to store the network location of the database it opens along with the shortcut, 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, refer to Microsoft Access Help.


Create a New Database Using group (Microsoft Access dialog)
•	Select Blank Access database to create a blank database to which you can add tables, forms, reports, and other objects.

•	Select Access database wizards, pages, and projects to create the required tables, forms, and reports for the type of Microsoft Access database you choose or to create a data access page or Microsoft Access project.


Open an Existing Database option (Microsoft Access dialog)
Select Open an existing file to open a Microsoft Access database or Microsoft Access project on your computer or on the network.

To open one of the last databases you had open, or to open a sample database, double-click the file name in the list. To open a database not listed, double-click More Files.


Show Both Gridlines (Formatting toolbar)

Shows both horizontal and vertical gridlines on a datasheet.


Show Horizontal Gridlines (Formatting toolbar)

Shows only horizontal gridlines on a datasheet.


Show Vertical Gridlines (Formatting toolbar)

Shows only vertical gridlines on a datasheet.


Show No Gridlines (Formatting toolbar)

Hides all gridlines on a datasheet.


Chart (Insert menu)

Displays Microsoft Access data in a chart on a form or report. To create this control, click Chart on the Insert menu, and then click the form or report where you want to place the control. Microsoft Access starts the Chart Wizard. 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.


Select Object (Form & Report Design toolbars)

Displays a list by which you can select an entire form or report, a section of a form or report, or a control on a form or report.


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)
•	Select Default Printer to use your default printer to print your document.

•	Select Use Specific Printer, and then click Printer to select a different printer.


Grid Settings group (File, Page Setup, Page Setup dialog, Layout tab)
Controls the grid settings when printing multiple-column reports or labels.

•	Type the number of columns In the Number of Columns box.

•	Type the space between rows in the Row Spacing box.

•	Type the space between columns In the Column Spacing box.


Item Size group (File, Page Setup, Page Setup dialog, Layout tab)
Controls the size of columns when printing multiple-column reports or labels.

•	Type the width of the column in the Width box.

•	Type the height of the row in the Height box.

•	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)
Use to indicate the order records are printed when printing multiple-column reports or labels.

•	Select Down, Then Across, to print records down the leftmost column, then down the next column, and so on.

•	Select 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 (Microsoft Access database only).

•	Select Menus and Toolbars to include all custom menus and 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 (Access database only).


Import Tables group (File, Get External Data, Import, Import Objects dialog)
•	Select Definition And Data to import the definition of a table and the data it contains.

•	Select Definition Only to import only the definition of a table.


Import Queries group (File, Get External Data, Import, Import Objects dialog)
•	Select As Queries to save imported queries as queries.

•	Select As Tables to save imported queries as tables.


Options button (File, Get External Data, Import, Import Objects dialog)
Specifies additional options for importing objects from another Microsoft Access database or Microsoft Access project.


Enter the new name for the table.


Structure Only (Paste Table As dialog box)
•	Select Structure Only to paste only the structure of the table.

•	Select Structure And Data to paste the structure of the table and its data.

•	Select Append Data To Existing Table to append the data to an existing table.


Import button (Toolbar Well, File Group) Import/Link command (Tools menu)
Get External Data Import (File menu)

Copies data from a text file, HTML file, spreadsheet, Microsoft Exchange folder or address book, database object, or database table into a Microsoft Access table. Also, copies objects from another database into the current database.


Link Tables subcommand (File menu, Get External Data command)
Get External Data Link Tables (File menu)

Links data from a table in another database to a Microsoft Access table in the current database.


Allow Default Shortcut Menus (Tools Menu, Startup Command, Startup Dialog Box)
Select to allow the use of Microsoft Access default shortcut menus. For more information, refer to Microsoft Access Help.


Allow Full Menus (Tools Menu, Startup Command, Startup Dialog Box)
Select to allow the use of all Microsoft Access menu commands. For more information, refer to Microsoft Access Help.


Section Selector (Form and Report Design view)
Section Selector

Double-click to display the section's property sheet.


Macro command (Tools menu)
Macro / Macros Run Macro (Tools menu)

Runs a selected macro. For more information, refer to Microsoft Access Help.


Convert Form's or Report's Macros to Visual Basic
Macros Convert Form's/Report's Macros To Visual Basic (Tools menu)

Converts a selected macro to Visual Basic event procedures in the form or report module.


Field List (Report Design view)
Field list

Use to add bound controls to the form or report by dragging the field from the field list to a form or report section.


AutoDialer

Dials a selected phone number automatically.


Builder list (Build button, Choose Builders dialog)
Select the builder you want.


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, report, or data access page.


Indexes window

Use to view, edit, and delete indexes in the active table.


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.


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 button (Null Window, Tools menu, Database Utilities command, Convert Database subcommand, Convert dialog box)
Converts the selected Microsoft Access database.


Compact Database (Tools menu, Database Utilities command, Null Window)
Database Utilities Compact and Repair Database (Tools menu)

Rearranges how a fragmented database is stored on disk. Compacting a database often reduces its size and improves its performance. Also, repairs a damaged database if necessary. 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.


Compact button (Null Window, Tools menu, Database Utilities command, Compact Database subcommand, Compact dialog box)
Compacts and repairs the selected database.


Encrypt/Decrypt Database subcommand (Tools menu, Security command, Null Window)
Security Encrypt/Decrypt Database (Tools menu)

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.


First Record button (Print Preview - navigation button)
First Page button

Moves to the first page in Print Preview or Layout Preview.


Last Record button (Print Preview - navigation button)
Last Page button

Moves to the last page in Print Preview or Layout Preview.


Next Record button (Print Preview - navigation button)
Next Page button

Moves to the next page in Print Preview or Layout Preview.


Previous Record button
Previous Page button

Moves 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

Moves to the first record in Datasheet or Form view.


Last Record button (Sample Preview - navigation button)
Last Record button

Moves to the last record in Datasheet or Form view.


Next Record button (Sample Preview - navigation button)
Next Record button

Moves to the next record in Datasheet or Form view.


Previous Record button (Sample Preview - navigation button)
Previous Record button

Moves to the previous record in Datasheet or Form view.


Specific Record button (Sample Preview - navigation button)
Specific Record box

Moves to a specific record in Datasheet or Form view by entering the record number.


New Record button (Sample Preview - navigation button)
New Record button

Moves 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)
Select to create an inner join. For more information, refer to Microsoft Access Help.


Left-Outer Join (Join Properties dialog)
Select to create a left-outer join. For more information, refer to Microsoft Access Help.


Right-Outer Join (Join Properties dialog)
Select to create a right-outer join. For more information, refer to Microsoft Access Help.


Synchronize Now subcommand (Tools menu, Replication command)
Replication Synchronize Now (Tools menu)

Synchronizes the open replica with another member in the replica set.


Replica subcommand (Tools Menu, Replication Command)
Replication Create Replica (Tools menu)

Creates a replica of the open database at a designated location.


Design Master subcommand (Tools menu, Replication command)
Replication Recover Design Master (Tools menu)

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.


Resolve Conflicts subcommand (Tools menu, Replication command)
Replication Resolve Conflicts (Tools menu)

Starts the Conflict Viewer, which displays the records that were in conflict during previous synchronizations between the open replica and other members in the replica set.


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.


Undo button (Builder button, Expression Builder dialog box)
Removes the last element you inserted in the Expression box. 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)
Displays help on a selected element in the right-most box.


Paste button (Builder button, Expression Builder dialog box)
Inserts the selected element in the right-most box into the Expression box.


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.


Object Name
•	In the Save <object><object name> To box, type the name of the new object.

•	In the As box, either leave the type of object the same as the original object or select the type of object that you want the new object to be converted to. Not all objects can be converted to different types of objects.


Apply Filter/Sort button  Show All Records button (Filter toolbar)
Apply Filter/Remove Filter (Datasheet toolbars)

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 (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 (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 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

Selects 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)
Record Selector

Click to select the entire record. Also, can display the following symbols:

The current record; the record has been saved as it appears.

A new record that you can enter information in.

You are editing this record; changes aren't yet saved.

This record is locked by another user; you can't edit it (Microsoft Access database only).


Object command (Edit menu)
Object Type Object (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 OLE object.


Column command (Insert menu)
Column (Insert menu)

In query Design view and the Advanced Filter/Sort window, inserts a column to the left of the selected column in the design grid so you can add a field to the active query or filter. To select a column, click the column selector.

In table Datasheet view, inserts a new column to the left of the selected column or the column with the current insertion point.


Make Replicable (Save As dialog box)
Select to allow the new object to be replicated to other databases.


Conditional Formatting (Format menu)

Applies conditional formatting to a selected control, making it easier to spot different values in the control. For example, a control can have a green background if sales exceed your forecast or a red background if sales fall, or a control can be enabled or disabled when it meets or does not meet the criteria you specify.

You can see how the values of controls compare to a constant or to the results of an expression, or set conditional formatting based on either the value in a control, an arbitrary expression referencing another control, a user-defined VBA function, or the control with focus.


Displays the current default formatting for the selected control, including colors, font styles, and any expressions that might be defined for the field.

If the value of the control changes and no longer meets the specified condition, Microsoft Access returns to the default formatting for the control. Conditional formatting remains applied to the controls until you remove them, even though none of the conditions are met and the specified control formatting is not displayed.


Conditional Formatting toolbar

Select the conditional formatting you want to apply to text (for example, bold, italic, underline, and color formatting) or select the formatting you want to apply to a control or controls (for example, background color). Use the Enabled button to enable or disable a control when it does or does not meet the criteria you specify. Microsoft Access applies the selected formatting only if the control value meets the condition or if the expression returns a value of TRUE.


Select the conditional formatting element you want to apply to the selected control. To use values in the selected control as the formatting criteria, click Field Values Is. To use an expression as the formatting criteria, click Expression Is. To change the font style, color, or other formatting of the control that has focus on a form, click Field Has Focus.


Click the comparison phrase you want to use to set the condition for the selected control. You can evaluate value(s) that are in a specific range, or you can evaluate value(s) that are equal to, greater than, or less than a specific value.


Type a constant value if you selected Field Values Is. Type an expression if you selected Expression Is. The expression must return a logical value of TRUE or FALSE. For more information, refer to Microsoft Access Help.


Type a constant value for the selected control.


Shows how the control will look with the conditional formatting you applied if the value in the control meets the condition or if the expression returns a value of TRUE.


Adds another condition in which you can specify additional criteria for formatting a control.


Removes one or more conditions.


Select the conditional formatting element you want to delete. You can delete one or more conditional formatting elements that you defined for the control.


Convert Database To Current Access Database Version
Convert Database To Current Access Database Version (Tools menu)

Converts a previous-version Microsoft Access database to an Access 2000 database.


Convert Database To Prior Access Database Version (Tools menu)

Converts a Microsoft Access 2000 database to an Access 97 database if the Access 97 database is not a member of a replica set.


Microsoft Access project

An Access file that connects to a Microsoft SQL Server database through the OLE DB component architecture. An Access project contains only code-based or HTML-based database objects: forms, reports, macros, modules, and shortcuts to data access pages. An Access project does not contain any data or data-definition-based objects: tables, views, database diagrams, or stored procedures. These database objects are stored in the SQL Server database. Access projects are used to create client/server applications.


updateable snapshot

A type of recordset that works efficiently in a client/server environment by caching data on the client and minimizing round trips to the server to access and update data. Updateable snapshots are used in Microsoft Access projects behind forms and datasheets, and in data access pages connected either to a Microsoft Access database or Microsoft SQL Server database.


Group Filter Control

Creates a drop-down list box control that works as a filter to find records on a data access page. In a grouped page, use the control to choose the group whose records you want to see. In an ungrouped page, choose a value from the control to find all records that contain that value.


Individual Controls

Adds individual controls to a data access page for each field, table, or other record source that you drag from the field list to the page.


PivotTable List

Adds a PivotTable list control for each field, table, or other record source that you drag from the field list to the data access page.


Bound HTML (Toolbox)

Adds a bound HTML control to a data access page. You can make the bound HTML control the default control for a grouped page, and you can use the control to display calculations and all data on a grouped page. If you store HTML code in a field in a table, you can bind a bound HTML control to that field. When the page displays the values from that field in the bound HTML control, the HTML code performs the actions you specified.


Bound Hyperlink (Toolbox)

Binds a bound hyperlink control on a data access page to a Text field containing a hyperlink address. Use when you want a different hyperlink address for each record in a table — as you move from record to record, you can click the hyperlink to go to a different Web page for each record.


Dropdown List Box (Toolbox)

Creates a drop-down list box on a data access page. A drop-down list box looks like a combo box on a form, but unlike in a combo box, you cannot type new values in a drop-down list box. In a bound drop-down list box, the value you select is inserted in the field that the drop-down list is bound to. In an unbound drop-down list box, you can store a value that you can use with another control or find a record based on the value you select in the drop-down list box.


Hotspot Image (Toolbox)

Adds to a data access page an image that is a hyperlink. You select the image to display on the page and the address of the file to go to when the image is clicked. You can also define ScreenTips and alternative text for the image. For more information, refer to Microsoft Access Help.


Image (Toolbox)

Adds a control that displays a picture on a data access page. You can add a bound picture that is specific to each record and that changes with each record on the page. You can also add an unbound picture, such as a logo or banner, that doesn't change when you move to a new record.


Office Chart (Toolbox)

Use to start the Microsoft Office Chart Wizard so that you can insert a two-dimensional chart on a data access page. You can display database data in a chart to show trends, patterns, and comparisons.


Office PivotTable (Toolbox)

Use to insert a Microsoft Office PivotTable list, which displays read-only data in a row-and-column format that you can reorganize to analyze the data in different ways, on a data access page.


Office Spreadsheet (Toolbox)

Use to insert a Microsoft Office Spreadsheet on a data access page so that you can do complex calculations by using spreadsheet functions. You can display the calculated values in the spreadsheet or hide the spreadsheet and display the calculated values in bound HTML controls.


Scrolling Text (Toolbox)

Use to display moving text or text that scrolls on a data access page to draw attention to a line of text, such as a headline or an important announcement. You display text contained in a field of your database by binding the scrolling text control to the field. You can customize scrolling text by setting options such as direction of travel, speed, and type of motion.


Expand (Toolbox)

Adds an expand/collapse button to a data access page so that you can display or hide records that are grouped under a record.


Record Navigation (Toolbox)

Adds a record navigation control to a data access page. In Page view or in Microsoft Internet Explorer, you use the record navigation control to move to, add, delete, and find records, and to get Help. You can set properties to customize a record navigation control — for example, on a grouped page, you can hide the buttons that add and delete records.


Hyperlink (Toolbox)

Adds a hyperlink to a data access page.


Movie (Toolbox)

Creates a movie control on a data access page. You can select whether to start playing a movie when the page is opened (default behavior) or when the pointer is moved over the movie control.


Select All Columns

Displays all data columns in the query result set. The Query Designer displays only a title bar for the input source if you do not have access rights or if the database provider cannot return information about the input source.


Select All Rows from objectname

Selects the content in the input source window.


Select All Rows from objectname

Selects the outer join, which includes rows even if they do not have related rows in the joined table. You can create three variations of an outer join to specify the unmatched rows to be included:

•	A left outer join includes all rows from the first-named or "left" table that appears leftmost in the JOIN clause; unmatched rows in the right table do not appear.

•	A right outer join includes all rows in the second-named or "right" table that appears rightmost in the JOIN clause; unmatched rows in the left table are not included.

•	A full outer join includes all rows in all joined tables, whether they are matched or not.


Remove

Removes the table from the diagram pane.


Group By (Query menu)

Adds a Group by column to the grid in the Grid pane so that you can create subtotals or show other summary information for subsets of a table by using an aggregate query. Each group summarizes the data for all the rows in the table that have the same value.


Hide Pane

Hides the selected pane.


Show Panes Diagram (View menu)

Displays the input sources (tables or views) you selected from the data connection. Each input source appears as a separate window in the Diagram pane. Any join relationships among the input sources are also shown.

In the Diagram pane, you can add or remove input sources, specify data columns for output, specify columns for ordering the query (except in views), specify that you want to group rows in the result set, and create or modify joins between input sources.


Show Panes Grid (View menu)

Displays a spreadsheet-like grid in which you can specify query options. The rows in the Grid pane display the data columns used in your query; columns in the Grid pane display query options.

You can enter the columns to display column name aliases, the table that a column belongs to, expressions for calculated columns, search conditions, grouping criteria, and the sort order for the query. You cannot enter a sort order for views, but you can sort a view's results in Datasheet view.


Show Panes SQL (View menu)

Displays the SQL statement for the current query. In the SQL pane you can create new SELECT queries by entering SQL statements; modify the SQL statement created by the Query Designer based on settings you make in the Diagram and Grid panes; and enter statements that take advantage of features specific to the database you are using.


Add to Output

Adds a column to the Grid pane.


Sort Ascending

Specifies an ascending sort priority for data columns to sort the result set. When you change the sort order for a data column, the sort order for all other columns is updated accordingly. Sort Ascending is not available in the Query Designer for views.


Sort Descending

Specifies a descending sort priority for data columns to sort the result set. When you change the sort order for a data column, the sort order for all other columns is updated accordingly. Sort Descending is not available in the Query Designer for views.


Verify SQL Syntax (Query menu)

Checks that the syntax is correct in the query you have built.


Triggers

Creates a new trigger in a source code editor with the default SQL statements already defined for you. Triggers execute automatically and are used to cascade changes through related tables in the database. Triggers can also enforce restrictions that are more complex than those defined with check constraints, because triggers can reference columns in other tables.


Server Filter By Form (Records/Filter menu)

Displays the Server Filter By Form window, which is a copy of the form (or datasheet) you are filtering, but without records. In the form, you can specify different criteria by choosing your search values from drop-down lists in each field. When you apply the filter, Microsoft Access sets the ServerFilter property to the filter you defined in the Server Filter By Form window, and filters the records before it retrieves them from either the server or the client. You can't use Server Filter By Form with a form bound to a stored procedure.


Apply/Remove Server Filter (Datasheet toolbar)

Applies or removes a filter created in the Server Filter By Form window in the active form or form datasheet.


bound HTML control

On a data access page, a control that is bound to HTML code that is stored in a field in a table. On the data access page, you can either display the contents of the field as HTML text by setting the DataFormatAs property to HTML, or run the HTML code to carry out specific actions, such as changing the color of the text, by setting the DataFormatAs property to Text. Bind the bound HTML control to a Text or Memo field in a Microsoft Access database (.mdb) or a text, ntext, or varchar column in a Microsoft Access project (.adp).

Using bound HTML controls on a data access page makes the page load faster in Page view or in Internet Explorer. However, you can't edit the values displayed in HTML controls.

Tool:


bound hyperlink control

A control used on a data access page to bind a link, intranet address, or Internet address to a Text field in an underlying table. Use when you want a different hyperlink address for each record in a table — for example, as you move from record to record in a Suppliers table, you can click on the hyperlink and go to a different Web page for each supplier.

Tool:


bound picture

A picture object in a form, report, or data access page; it is bound to an OLE Object field in a Microsoft Access database or an image column in a Microsoft Access project. When you move from record to record, you see the picture associated with each individual record.


drop-down list box

On a data access page, a control that you can use to select a value from a list. A drop-down list box shows only one record until you click to expand the contents. You can't type new values in a drop-down list box.

When you select a value in a bound drop-down list box, that value is inserted into the field that the drop-down list is bound to. In an unbound drop-down list box, you can store a value to use with another control or find a record based on the value you select in the drop-down list box.

Tool


expand control

A control that, when clicked, displays or hides records that have been grouped under another record on a data access page.

Tool:


Formatting toolbar (Page)

A data access page toolbar that is displayed beneath the Page Design toolbar. It includes buttons to change characteristics of controls, such as font, font size, font style (bold, italic, or underlined), alignment, color, border, and special effect. By default, the Formatting toolbar is docked beneath the Page Design toolbars, but you can drag it to create a floating toolbar.


group filter control

A type of drop-down list box control that is used on a data access page to limit the records that are retrieved from the underlying database and displayed on the page. On a grouped data access page, use the control to filter records by group. On an ungrouped page, use the control to filter for all records containing the value selected in the drop-down list box, similar to Filter By Form.


hotspot
hotspot image control

A control used on a data access page to add an unbound image that is a hyperlink to a file or Web page. When you create a hotspot image control, you select the image you want to display on the page and the address of the file you want the hyperlink to go to. In Page view or in Internet Explorer, the cursor changes to a hand as it passes over the image, indicating that the image is a link you can click to go to another file or Web page. You can also define ScreenTips and alternate text for the image.

Tool:


marquee

In Microsoft Access, the control that you use to place a marquee, or moving text, on a data access page is called a scrolling text control. Use the scrolling text control to display text that you want to catch your users' attention, such as a headline or an important announcement. You can display text stored in a field in your database by binding the scrolling text control to that field. You can customize the scrolling text control by setting options such as direction of travel, speed, and type of motion. If the Web browser cannot display scrolling text, the text will still be displayed in the control, but it won't scroll.

Tool:


Microsoft Office Web component
Microsoft Office Web Components

Components you can use to put interactive spreadsheets, PivotTable lists, and charts on a data access page. To view and work with the objects created by using these components, you must have a Microsoft Office 2000 site license.


PivotTable list

Similar to a Microsoft Excel PivotTable report, a PivotTable list displays data in a row and column format. A PivotTable list provides interactive capabilities in Microsoft Internet Explorer, so that you can reorganize the data by moving rows to columns and columns to rows, displaying totals at the intersection of rows and columns, and otherwise rearranging and summarizing the data to analyze it in different ways. A PivotTable list includes its own toolbar and built-in Help.


record navigation control

A control used on a data access page to add a record navigation toolbar to the body or to a group level's record navigation section. You can customize the record navigation control by changing the properties in the property sheet. For example, on a grouped page, you can hide the buttons for adding and deleting records.

Tool:


scrolling text control

A control used on a data access page to display a marquee — text that scrolls. Use the scrolling text control to display text that you want to catch your users' attention, such as a headline or an important announcement. You can display text stored in a field in your database by binding the scrolling text control to that field. You can customize the scrolling text control by setting options such as direction of travel, speed, and type of motion. If the Web browser cannot display scrolling text, the text will still be displayed in the control, but it won't scroll.

Tool:


ActiveX control

In addition to the built-in controls that appear in the toolbox, Microsoft Access supports ActiveX controls. An ActiveX control, like a built-in control, is an object that you insert on a form, report, or data access page to enable or enhance a user's interaction with an application. The Calendar Control is an example of an ActiveX control.

Note   In previous versions of Microsoft Access, ActiveX controls were also referred to as custom controls and OLE controls.


bound control <definition>
bound control

A text box or other control on a form, report, or data access page that gets its contents from a field in the underlying table, query, or SQL statement. (The control's ControlSource property is set to a field name in the table, query, or SQL statement.) For example, a text box that displays an employee's last name is bound to the LastName field in the Employees table.


calculated control <definition>
calculated control

A control on a form, report, or data access page that displays the result of an expression rather than stored data. The value is recalculated each time a value in the expression changes.

A calculated field is a field that is defined in a query and displays the result of an expression rather than stored data.


combo box <definition>
combo box

A control in a form that is like a list box and a text box combined. In a combo box, you can type a value or click the arrow to select an item in the list that drops down.

Control	Tool


control <definition>
control

A graphical object, such as a text box, check box, command button, or rectangle, that you place on a form, report, or data access page in Design view. A control can display data, perform an action, or make the form, report, or data access page easier to read.


Control menu <definition>
Control menu

The menu in the upper-left corner of an application or a window. It contains commands to move, resize, and close the application or window and is designated by an icon rather than by a menu name.

Control menu for an application

Control menu for a window


default control style <definition>
default control style

The properties a control has by default when you create it. For example, a text box control has an attached label by default. You can change the default control style for a type of control in a form or report by clicking the tool for that type of control in the toolbox, clicking Properties  [image] on the toolbar, and then changing the settings in the property sheet.


default value <definition>
default value

A value that is automatically entered in a field or control when you add a new record. You can accept the default value or type a new value over it.


disabled control <definition>
disabled control

A text box or other control that appears dimmed on a form or data access page, can't be tabbed to, and won't respond to typing or clicking. On a form, you disable a control by setting its Enabled property to No. On a data access page, you disable a control by setting its Disabled property to True.


image control <definition>
image control

A control you use to add a picture to a form, report, or data access page. For example, you could use an image control for a logo on an invoice report.

Control	Tool


label <definition>
label

A control that displays descriptive text, such as a title, a caption, or instructions, on a form, report or data access page. Labels can be attached or freestanding. Attached labels appear as column headings in Datasheet view.

Control	Tool


Lookup field <definition>
Lookup field

A field that displays one of the following types of lists:

•	A list that looks up data from an existing table or query. You can select a value in the list to store in the field. Any updates to the table or query are reflected in the list.

•	A list that stores a fixed set of values that won't change. You can select a value in the list to store in the field.

You can use a Lookup field on a form or report in a Microsoft Access database (.mdb).


New Object button <definition>
New Object button

A button on the toolbar that you can click from any window to create a new database object of any type. The graphic on the button changes depending on whether you are in a Microsoft Access database or a Microsoft Access project, and on which object you last selected.


option button <definition>
option button

A control that can be selected or cleared. Option buttons are typically used as part of an option group in which the user can select one and only one option, but they can also be used outside an option group for fields that have the Yes/No or bit data type. This button is sometimes called a radio button in other applications.

Control	Tool


option group <definition>
option group

In a form or report, a control that contains a set of check boxes, toggle buttons, or option buttons. In a data access page, a control that contains a set of option buttons.

You can choose only one option in an option group. If the option group is bound, the option selected determines the value of the underlying field. For example, to allow users to choose a shipping method, you could use an option group with three options: Air, Sea, and Land.

Control	Tool


sizing handle <definition>
sizing handle

In form, report, and data access page Design view, one of the small squares displayed on the edge of a selected control that you click and drag to resize the control.

Form or report sizing handles

Data access page sizing handles

In data access pages, you can’t resize a list box or drop-down list box vertically. The vertical size of list boxes and drop-down list boxes is based on the font setting of the control.

Note   The large square in the upper-left corner of the selected control is a move handle, not a sizing handle.


Snap To Grid <definition>
Snap To Grid

A tool that you can use to align new or existing controls to the grid in forms, reports, and data access pages.


Special Effect button <definition>
Special Effect button

Makes the selected control on a form, report, or data access page appear flat, raised, sunken, etched, shadowed, or chiseled.


text box <definition>
text box

A control that provides a place to enter or view text in a form, report, or data access page. The text box is sometimes called an edit field in other applications.

Control	Tool


toggle button <definition>
toggle button

A control that acts as an on/off button in a form or report. A toggle button can display either text or a picture, and can stand alone or be part of an option group.

Control	Tool


toolbox <definition>
toolbox

The set of tools you use in Design view to place controls on a form, report, or data access page. You can show or hide the toolbox by clicking Toolbox on the View menu.

Note   Some of the tools available in the toolbox in data access pages are different from the ones available in forms and reports. For information on what each tool does, rest the pointer over the tool. Microsoft Access displays a ToolTip that describes the tool. For more detailed information, click a tool and press F1.

Button


unbound control <definition>
unbound control

A control that's not connected to a field. You can use unbound controls to display informational text, such as instructions about using a form, or graphics and pictures from other applications. For example, lines and rectangles are unbound controls. You can also use unbound controls to accept user input and then perform an action based on that input.


validation rule <definition>
validation rule

A rule that sets limits or conditions on what can be entered in one or more fields. You can set validation rules for a field, a record, or a control on a form. A validation rule for a field or control is checked when you move to a different field or control. A validation rule for a record is checked when you move to a different record. Microsoft Access displays the message specified in the ValidationText property whenever the rule is violated.


View button <definition>
View button

A button located at the far left of the toolbar in the Table, Query, View, Stored Procedure, Form, Report, and Data Access Page windows. You can click the button to change to the view displayed in the picture on the button, or you can click the arrow next to the button to display a list of views to choose from. The list of views displayed depends on whether you're in a table, query, view, stored procedure, form, report, or data access page. For example, if you click the View button in a form, it looks like this:

For forms, the views that are available in the list depend on the settings specified for the DefaultView and ViewsAllowed properties. For example, if you disable Datasheet view through the ViewsAllowed property, Datasheet view appears dimmed in the list.


body

The basic design surface of a data access page. On a data entry page, you can use the body to display informational text, controls bound to data, and sections. On a grouped page, you can use the body to display informational text and sections. By default, the position of text, sections, and other elements in the body are relative — that is, elements flow one after the other in the same order as they appear in the HTML source. The position of an element in the body is determined by the preceding content. When a data access page is viewed in Page view or Internet Explorer, the content in the body of the page adjusts itself to fit the size of the Web browser window.


caption section

The section on a grouped data access page that is used to display captions for columns of data. A group level's caption section is displayed only when the next-higher group level is expanded. A caption section appears immediately before the group header. You can't add bound controls to a caption section.


data access page

A Web page that has a connection to a database; in a data access page, you can view, add to, edit, and manipulate the data stored in the database. A data access page may also include data from other sources, such as Microsoft Excel.


data access page properties

Attributes of a data access page that identify the database the page is connected to and affect its appearance or behavior. For example, the DataEntry property determines whether a page opens with a new blank record in Page view and in Internet Explorer.


Data Access Page window

A window in which you work with data access pages in Design view and Page view.


data definition

The fields in tables and in queries, and the expressions that make up the record source for a data access page. To add a field to the data definition, bind a control on the page to the field. Fields you reference in an expression on a data access page must be in the data definition of the page before you create the expression. Once the expression is created, you can delete the control bound to the field from the page.


data source control

The engine behind data access pages, PivotTable list controls, and data-bound chart controls. The data source control has no visual representation. It is designed to manage the connection to the underlying data source and deliver records to be displayed by other controls on a Web page. When you create a data access page and add fields to the page by dragging them from the field list, Access automatically adds a properly configured data source control to the page.


data access page Design view

A window in which you design data access pages.

To open a data access page in Design view, in the Database window, click Pages  [image]  under Objects, click the page you want to open, and then click Design on the Database window toolbar.

If the page is already open, you can switch to Design view by clicking View  [image]  on the toolbar.


document properties

Properties such as title, subject, and author that are stored with each data access page.


fixed object
fixed positioning

Places the element relative to either the next positioned element in the hierarchy (its parent), or, if there isn't one, the body. Values for the element's Left and Top properties are relative to the upper-left corner of the element's parent. For example, by default the position of a control in a section is fixed relative to the Left and Top properties of the section. When viewed in Page view or in Internet Explorer, the content keeps the same position even when you resize the window.


absolute positioning

Places the element relative to either the next positioned element in the hierarchy (its parent), or, if there isn't one, the body. Values for the element's Left and Top properties are relative to the upper-left corner of the element's parent. For example, by default the position of a control in a section is fixed relative to the Left and Top properties of the section. When viewed in Page view or in Internet Explorer, the content keeps the same position even when you resize the window.


grouped data access page

A data access page that has two or more group levels.


hyperlink field

A field that stores hyperlink addresses. In a Microsoft Access database (.mdb), it is a field with a Hyperlink data type. In a Microsoft Access project (.adp), it is a field with a char, nchar, nvarchar, or varchar data type that has the IsHyperlink Property set to True.


inline object
inline positioning

Places the element in the natural HTML flow of the document but offsets the position of the element based on the preceding content. For example, by default the position of a control inserted into a paragraph of text in the body of a page is relative to the text that precedes it. When viewed in Page view or in Microsoft Internet Explorer, the content adjusts itself to fit the size of the window.


relative positioning

Places the element in the natural HTML flow of the document but offsets the position of the element based on the preceding content. For example, by default the position of a control inserted into a paragraph of text in the body of a page is relative to the text that precedes it. When viewed in Page view or in Microsoft Internet Explorer, the content adjusts itself to fit the size of the window.


maximum record limit

In a Microsoft Access project, the maximum number of records retrieved in a form or datasheet from a Microsoft SQL Server database. Setting the maximum record limit helps improve performance when you're downloading large recordsets.


Page view

A window in which you can view and work with data in data access pages within Microsoft Access. Pages have the same functionality in Page view as in Internet Explorer 5 or later.

To open a data access page in Page view, go to the Database window, click Pages  [image] under Objects, click the page you want to open, and then click Open on the Database window toolbar.

If the page is already open in Design view, you can switch to Page view by clicking View  [image]  on the toolbar.


record navigation section

In a data access page, the section that is used to display the record navigation control for a group level. The record navigation section for a group level appears after the group header section. You can't place bound controls in a record navigation section.


record navigation toolbar

A toolbar that contains buttons for adding, deleting, saving, undoing changes to, sorting, filtering, and moving between records, and getting Help. In a grouped data access page, each group may have its own record navigation toolbar that's located at the bottom of the expanded group. If the toolbar on your page doesn't include some of the buttons displayed in the following art, or includes buttons that aren't listed here, it's been customized by the person who designed the page.


Sorting And Grouping box (data access pages)

In data access page Design view, the dialog box in which you specify property settings for each group level. For example, use this dialog box to specify the default sort order and the sections to be displayed for a group level.

To display the Sorting And Grouping box, click Sorting And Grouping  [image]  on the toolbar in data access page Design view.


theme

A collection of formats that determines the appearance of the controls, sections, body, and text on a data access page. You can apply a theme to a page by clicking Theme on the Format menu, or you can select a theme when you create a page with a wizard.


Web Page Preview

Opens a data access page in Internet Explorer 5 or later. To view a data access page in Internet Explorer, open the page in Design view or Page view and click Web Page Preview on the File menu.


Microsoft Access data file

A Microsoft Access database (.mdb) or Microsoft Access project (.adp) file. An Access database stores all its database objects and its data in the .mdb file, and uses the Microsoft Jet database engine to manage the data. An Access project stores only code-based or HTML-based objects (forms, reports, data access pages, macros, and modules). The Access project connects to a Microsoft SQL Server database where the tables, views, stored procedures, database diagrams, and data are stored.


General sort order

The default setting for the NewDatabaseSortOrder property. Sort order determines how characters are sorted in the entire database (tables, queries, reports, and so on). Use the General sort order if you plan to use a database with multiple language editions of Microsoft Access. Set the sort order on the General tab of the Options dialog box (Tools menu).


Groups bar

In the column on the left side of the Database window, the horizontal bar you click to display the Favorites group and other groups you create.


Microsoft Access database

A collection of data and objects related to a particular topic or purpose. A Microsoft Access database may contain tables, queries, forms, reports, macros, modules, and shortcuts to data access pages. The Microsoft Jet database engine manages data in tables that reside in the database. Data in linked tables may reside in another Access database, in an external data source such as dBASE or Microsoft Excel, or in an ODBC data source such as Microsoft SQL Server.


Name AutoCorrect

In a Microsoft Access database, a feature that automatically corrects common side effects that occur when you rename forms, reports, tables, queries, or fields, or controls on forms and reports. However, Name AutoCorrect can't repair all references to renamed objects; for instance, for forms or reports that contain Visual Basic code, Access repairs references to the form, but does not repair references to objects in the Visual Basic project.


Object list

List of objects on the right side of the Database window.


Objects bar

In the column on the left side of the Database window, the horizontal bar you click to display the different types of database objects: tables, forms, reports, and so on.


enabled database <definition>
enabled database

A database created with a previous version of Microsoft Access that has been opened in Microsoft Access 2000 without converting its format. An enabled database can be used by both Access 2000 and the version it was created with. To change the design of objects in an enabled database, you must open the database in the version of Access in which it was originally created.


database <definition>
database

A collection of data and objects related to a particular topic or purpose. A Microsoft Access database can contain tables, queries, forms, reports, macros, modules, and data access pages (which are shortcuts to corresponding HTML files). A SQL Server database can contain tables, views, stored procedures, triggers, and database diagrams. A Microsoft Access project is not a database, but it connects to a SQL Server database, and can contain forms, reports, macros, modules, and data access pages.


database objects <definition>
database objects

In a Microsoft Access database, the types of database objects available are tables, queries, forms, reports, macros, and modules.

For a Microsoft Access project connected to a SQL Server database, the database objects are tables (including indexes, triggers, keys, constraints, defaults, rules, and user-defined data types), views, stored procedures, and database diagrams. The Access project objects are forms, reports, macros, and modules.

From both Access databases and Access projects, you can also create data access page objects, which are stored as separate files outside the Access database or Access project file.


Database window <definition>
Database window

The window that appears when you open a Microsoft Access database (in the diagram below) and a Microsoft Access project.

In an Access database, you can click Tables, Queries, Forms, Reports, Pages, Macros, and Modules in the Database window to display a list of all objects of that type in the database.

In an Access project, which is connected to a SQL Server database, you can click Tables, Views, Stored Procedures, Database Diagrams, Forms, Reports, Pages, Macros, and Modules in the Database window.

To display the Database window, click Database Window  [image]  on the toolbar. You can also press F11 to switch to the Database window from any other window.


object <definition>
object

Objects seen in a Microsoft Access database:

•	tables, queries, forms, reports, macros, and modules

•	objects that are defined by the system, such as the MSysObjects table

Objects seen in a Microsoft Access project:

•	objects stored in the Access project file: forms, reports, macros, and modules

•	objects stored in the Microsoft SQL Server database: tables, table properties (such as indexes, triggers, keys, constraints, defaults, rules, and user-defined data types), views, stored procedures, and database diagrams

•	objects defined by the system, such as the sysindexes table

Objects seen in both Access databases and Access projects:

•	data access pages, which are shortcuts (displayed in the Database window) to corresponding HTML files stored in the file system

•	information from another application, such as a chart (graph) or a drawing


export

To output data and database objects to another database, spreadsheet, or file format so another database, application, or program can use the data or database objects. You can export data to a variety of supported databases, programs, and file formats.


OLE DB

A component database architecture that implements efficient network and Internet access to many types of data sources, including relational data, mail files, flat files, and spreadsheets.

OLE DB architecture is used to connect a Microsoft Access project to a Microsoft SQL Server database. It is also used to connect a data access page to either a Microsoft Access database or a SQL Server database.


OLE DB provider

The program in the OLE DB architecture that enables native access to the data, meaning the database accesses the data in a way that is intrinsic to the product, as opposed to using ODBC, IISAM drivers, and so on, which are external ways to access the data. Examples of OLE DB providers are Microsoft OLE DB Provider for SQL Server or Microsoft OLE DB Provider for Jet . By contrast, the application that accesses the data, such as Microsoft Access 2000 or Microsoft Visual Basic, is called an OLE DB consumer, or data consumer.


page (HTML)

A Web page that has a connection to a database and is referred to as a data access page in Microsoft Access. In a data access page, you can view, add, edit, and manipulate the data stored in the database. A data access page may also include data from other sources, such as Microsoft Excel.


server-generated HTML

An Active Server Pages (ASP) file or IDC/HTX files; ASP files and IDC/HTX files are output from a table, query, or form; are connected to an ODBC data source; and are processed by the Internet Information Server to dynamically create HTML files. The data displayed in the HTML files is read-only, and is displayed in table format in an HTML Web page in any Web browser.


spreadsheet

On a data access page, a feature that is similar to a Microsoft Excel worksheet. By using a spreadsheet, you can enter raw data, add formulas, apply filters, and perform additional spreadsheet operations. A spreadsheet includes its own toolbar and built-in Help.


external database <definition>
external database

A database other than the one that is currently open. In a Microsoft Access database or Microsoft Access project, an external database can be used as the source of a table to be imported, or as the destination for a table to be exported. In an Access database, an external database can also be the source of a table to be linked, and the destination for a table that is the result of a make-table query based on a pass-through query.


IDC/HTX files <definition>
IDC/HTX files

The Microsoft Internet Information Server uses an IDC and an HTX file together to get data from an ODBC data source and format it as an HTML document. The IDC file is a text file that contains information on how to connect to an ODBC data source, and also contains an SQL statement to execute. The HTX file is an HTML file that acts as a template; it contains keywords that control how data is formatted, and placeholders specifying where that data is inserted in the HTML document when the data is returned from the data source, as specified in the SQL statement in the IDC file.


import <definition>
import

To copy data from a text file, spreadsheet, or database table into a Microsoft Access table. You can use the imported data to create a new table, or you can append (add) it to an existing table with a matching data structure. You can also import database objects from a Microsoft Access database or a Microsoft Access project.


import/export specification <definition>
import/export specification

A specification that stores the information Microsoft Access needs to import or export a fixed-width or delimited text file. You create an import/export specification by running the Text Import Wizard or the Text Export Wizard, and it is stored in the database in which you ran the wizard.


Filter Excluding Selection

A technique for filtering records in which you select a value that you want to exclude from the filtered records in a form, datasheet, or data access page. In a form or datasheet, you can filter for all or part of a value you select. For example, you can select the first character in a field to find all records that do not start with that character in the filtered field. In a data access page, you can only filter for the entire value in the field. After selecting a value, right-click it, and then click Filter Excluding Selection on the shortcut menu.


Server Filter By Form

In a Microsoft Access project, a technique for filtering data at the server before it's retrieved from the database. This technique uses a version of the current form or datasheet with empty fields in which you can type the values you want the filtered records to contain. If the server database your Access project is connected to contains many records, Server Filter By Form may be faster than other filtering techniques.

Server Filter By Form cannot be used with a form bound to a stored procedure.


field list <definition>
field list

In a form and report, a small window listing all fields in an underlying record source. In a Microsoft Access database, you can display a field list in Design view for forms, reports, and queries, and in the Relationships window. Microsoft Access displays the appropriate field list in the filter windows. In a Microsoft Access project, you can display a field list in Design view for forms and reports, or you can display an input source (the equivalent to a field list) in a view or SQL statement.

In a data access page, a window listing the database’s record sources and their fields, which you can add and bind to the page.

In a PivotTable list control, a window listing the fields added to the PivotTable list from the data access page’s field list. These fields comprise the data available for the PivotTable list in Page view or Microsoft Internet Explorer.


filter <definition>
filter

A set of criteria applied to data in order to show a subset of the data or to sort the data. In Microsoft Access, you can use a variety of ways to filter records, such as Filter By Selection and Filter By Form.


Filter By Form <definition>
Filter By Form

A technique for filtering data that uses a version of the current form or datasheet with empty fields in which you can type the values you want the filtered records to contain. In a Microsoft Access project, you can filter data at the server before it’s retrieved from the database by using Server Filter By Form.


Filter By Selection <definition>
Filter By Selection

A technique for filtering data that's based on data you select in a form, datasheet, or data access page. In a form or datasheet, you can filter for all or part of a value you select. For example, you can select the first character in a field to find all records that start with that character in the filtered field. In a data access page, you can only filter for the entire value in the field.


conditional formatting

In a form or report, a format applied to the value of a text box or other control. You can set conditional formatting based on the value in a control, an arbitrary expression referencing another control, a user-defined Visual Basic for Applications function, or the control with focus. For example, you can set conditional formatting so that if an employee's salary exceeds $100,000 the field's background turns red. Or set the formatting so the control's background color changes to yellow when the control has focus.


Fill

A report magnification that fills the Report Snapshot window in the following way: If the report is in portrait orientation, the report width or short side of the page fits the window; if the report is in landscape orientation, the height or short side of the page fits the window.


grouped controls

Two or more text boxes or other controls that create one group on a form or report. You can organize related controls in a group, and then select the group instead of selecting each individual control as you're arranging controls or assigning properties.


record source

In a Microsoft Access database, the table, query, or SQL statement that provides the underlying data for a form, report, or data access page. In a Microsoft Access project, the table, view, SQL statement, or stored procedure that provides the underlying data for a form, report, or data access page.


report snapshot

A file (.snp extension) that contains a high-fidelity copy of each page of a Microsoft Access report and that preserves the two-dimensional layout, graphics, and other embedded objects of the report.


Snapshot Viewer

A program that you can use to view, print, and mail a snapshot, such as a report snapshot. Snapshot Viewer 9.0 consists of a stand-alone executable program, a Snapshot Viewer control (Snapview.ocx), and other related files. You can install Snapshot Viewer when you install or reinstall Microsoft Access 2000. By default, it is automatically installed by Microsoft Access 2000 the first time you create a report snapshot. You can also install Snapshot Viewer from the World Wide Web software download page located at the Microsoft Access Developer's Web site.


Snapshot Viewer control

An ActiveX control (Snapview.ocx) that you use to view a snapshot report from Microsoft Internet Explorer 3.0 or later, or from any application that supports ActiveX controls, such as Microsoft Access or Microsoft Visual Basic.


expression <definition>
expression

Any combination of operators, constants, literal values, functions, and names of fields (columns), controls, and properties that evaluates to a single value. You can use expressions as settings for many properties and action arguments; to define calculated controls in forms, reports, and data access pages; to set criteria (search conditions) or define calculated fields in queries; and to set conditions in macros. In a Microsoft Access project, you can use expressions to define check constraints.

You also use expressions in Microsoft Visual Basic.


form Design view<definition>
form Design view

A window in which you design forms.

To open a form in Design view, go to the Database window, click Forms  [image]  under Objects, click the form you want to open, and then click Design on the Database window toolbar.

If the form is already open, you can switch to Design view by clicking View  [image] on the toolbar.


form selector <definition>
form selector

The box where the rulers meet, in the upper-left corner in form Design view. Click this box to select the form. Double-click this box to open the form's property sheet.

Note   If the form selector does not appear, click Ruler on the View menu.


Form view <definition>
Form view

A window that usually displays one or more whole records. Form view is the primary means of adding and modifying data in tables.

To open a form in Form view, go to the Database window, click Forms  [image]  under Objects, click the form you want to open, and then click Open on the Database window toolbar.

If the form is already open in Design view, you can switch to Form view by clicking View  [image]  on the toolbar.


format <definition>
format

Specifies how numbers, dates, times, and text are displayed and printed. A Microsoft Access database provides standard formats for the Number, Date/Time, and Yes/No data types, as does a Microsoft Access project for the equivalent SQL data types. You can also create a user-defined format by using formatting symbols. How the standard formats print and are displayed depends on the country specified in the Regional Settings section of the Microsoft Windows Control Panel. For example, when you are using the Currency format, 1234.56 is displayed as $1,234.56 when you are using the English (United States) regional setting, but it is displayed as £1,234.56 when you are using the English (British) regional setting.


PivotTable form

An interactive table that quickly summarizes large amounts of data by using format and calculation methods that you choose. It is called a PivotTable form because you can rotate its row and column headings around the core data area to give you different views of the source data, similar to an Excel PivotTable report.


Design view - reports <definition>
report Design view

A window in which you design reports.

To open a report in Design view, go to the Database window, click Reports  [image] under Objects, click the report you want to open, and then click Design on the Database window toolbar.

If the report is already open, you can switch to Design view by clicking View  [image]  on the toolbar.


report selector <definition>
report selector

The box where the rulers meet in the upper-left corner in report Design view. Click this box to select the report. Double-click this box to open the report's property sheet.

Note   If the report selector does not appear, click Ruler on the View menu.


section <definition>
section

A part of a form, report, or data access page such as a header, footer, or detail section. On a data access page, you can position the controls and other elements in a section relatively or absolutely (default). For example, controls positioned relatively move to fit the size of the window when viewed in Page view or in Microsoft Internet Explorer. Controls positioned absolutely keep the same position even when the window is resized.


section selector <definition>
section selector

The box to the left of a section bar in form or report Design view. Click this box to select the section. Double-click this box to open the section's property sheet.

Note   If the section selector does not appear, click Ruler on the View menu.


hyperlink address <definition>
hyperlink address

The path to a destination such as an object, document, or Web page. A hyperlink address can be a URL (address to an Internet or intranet site) or a UNC network path (address to a file on a local area network). A hyperlink address may also contain more specific address information (for example, a database object, Microsoft Word bookmark, or Microsoft Excel cell range that the address points to). When you click a hyperlink, your Web browser or Microsoft Access uses the hyperlink address to go to the specified destination.


Hyperlink data type <definition>
hyperlink data type

In a Microsoft Access database, a field data type for fields that will store hyperlinks. A Hyperlink field contains a hyperlink address that is composed of either text or a combination of text and numbers (numbers stored as text). A hyperlink address can have up to four parts (each part can contain up to 2,048 characters) and uses the following syntax:

displaytext#address#subaddress#screentip


universal naming convention (UNC) <definition>
universal naming convention (UNC)

A naming convention for files that provides a machine-independent means of locating the file. A UNC name will usually include a reference to a shared folder and file accessible over a network rather than a folder and file specified by a drive letter and path. For example, the UNC name for a database named Northwind.mdb on a shared directory named Samples on a computer called MyWorkstation would be \\MyWorkstation\Samples\Northwind.mdb.

The UNC is particularly useful in Web-based applications because it allows you to reference data that is not necessarily stored on a particular Web server.


argument <definition>
argument

A constant, variable, or expression that supplies information to an action, event, method, property, or procedure.


array <definition>
array

A variable that contains a finite number of elements that have a common name and data type. Each element of an array is identified by a unique index number. Changes made to one element of an array don't affect the other elements.


bitmap <definition>
bitmap

An image made up of pixels on the screen and stored as a collection of bits, one or more of which correspond to one pixel. When stored as files, bitmaps usually have the extension .bmp.


Bookmark <definition>
Bookmark

A property of a Recordset object or a form that contains a binary string identifying the current record.


channel number <definition>
channel number

An integer that corresponds to an open dynamic data exchange (DDE) channel. Channel numbers are assigned by Microsoft Windows 95, created with the DDEInitiate function, and used by other DDE functions and statements, such as the DDERequest function.


comparison operator <definition>
comparison operator

An operator used to compare two values or expressions — for example, < (less than), > (greater than), and = (equal to).


compile time <definition>
compile time

The time during which Visual Basic prepares code for execution. Modules automatically compile before they run.


conditional expression <definition>
conditional expression

An expression that Microsoft Access evaluates and compares to a specific value — for example, If...Then and Select Case statements. If the condition is met, one or more operations are carried out. If the condition isn't met, Microsoft Access skips the operations associated with the expression and moves to the next expression.

You can use conditional expressions in macros and Visual Basic code.


constant <definition>
constant

A representation of a numeric or string value that doesn't change. True, False, and Null are constants. You can use constants in expressions in tables, queries, forms, reports, and macros. In a Visual Basic module, you can use the Const statement to declare your own constants. A constant may be a string or numeric literal, another constant, or any combination that includes arithmetic or logical operators, except the Is statement and exponentiation.

Microsoft Access also provides intrinsic constants that supply fixed values for action arguments and function values (such as the values returned by the VarType function).

These constants can be viewed in the Object Browser.


current record <definition>
current record

The record in a recordset that you can modify or retrieve data from. Only one record in a recordset can be the current record; however, a recordset may have no current record. For example, after a record has been deleted from a dynaset-type Recordset object, or when a recordset has no records, the current record is undefined. In this case, operations that refer to the current record result in a trappable error.


debugging <definition>
debugging

The process of finding and fixing errors in a Visual Basic procedure or a macro. Debugging usually involves executing specific portions of the procedure or macro and analyzing them at various points.


Empty <definition>
Empty

The state of an uninitialized Variant variable. Variants that are Empty return a VarType of 0.

Empty isn't the same as Null, which is a variable state indicating invalid data. Variables containing zero-length strings (" ") aren't Empty, nor are numeric variables having a value of 0.


Function procedure <definition>
Function procedure

A procedure that returns a value and that can be used in an expression. You declare a function with the Function statement and end it with the End Function statement.


handle <definition>
handle

A unique Integer value (Long in a 32-bit environment) you use to identify and access a Form or Report window. Use the hWnd property to return the handle.


keyword <definition>
keyword

A word that's part of the Visual Basic for Applications programming language. Keywords include the names of statements, data types, methods, operators, objects, and predefined functions. Don't use keywords for variable or object names.


method <definition>
method

A procedure similar to a statement or function that operates on specific objects.

For example, you can apply the Print method to the Debug object to transfer printed output to the Immediate window.


module <definition>
module

A collection of declarations, statements, and procedures stored together as one named unit. Microsoft Access has two types of modules: standard modules and class modules. Form and report modules are class modules containing code that's local to the form or report. Unless explicitly made private to the module in which they appear, procedures in standard modules are recognized and can be called by procedures in other modules in the same database or in referenced databases.


module level <definition>
module level

Describes any variable or constant declared in the Declarations section of a module or outside a procedure. Variables or constants declared at the module level are available to all procedures in a module.


numeric expression <definition>
numeric expression

Any expression that evaluates to a number. The expression can be any combination of variables, constants, functions, and operators.


procedure <definition>
procedure

A sequence of declarations and statements in a module that are executed as a unit. Procedures in Visual Basic include both Sub and Function procedures.


public variable <definition>
public variable

A variable you declare with the Public keyword in the Declarations section of a module. A public variable can be shared by all the procedures in every module in a database.


recordset <definition>
recordset

The collective name given to table-, dynaset-, and snapshot-type Recordset objects, which are sets of records that behave as objects.


snapshot <definition>
snapshot

A static image of a set of data, such as the records displayed as the result of a query. Snapshot-type Recordset objects can be created from a base table, a query, or another recordset.


statement <definition>
statement

A syntactically complete unit that expresses one specific kind of operation, declaration, or definition. Usually, a statement consists of one line in a procedure or Declarations section. In most cases, however, you can include more than one statement on a line by separating the statements with a colon (:).


string comparison <definition>
string comparison

The use of an operator to determine whether one string is greater than or equal to another string. If you use Option Compare Text in the Declarations section of a module, string comparisons aren't case-sensitive. If you use Option Compare Binary, comparisons are case-sensitive. If you use Option Compare Database, the comparison method is set by the current database.


string expression <definition>
string expression

Any expression that evaluates to a sequence of contiguous characters. Elements of the expression can include a function that returns a string, a string literal, a string constant, a string variable, a string Variant, or a function that returns a string Variant (VarType 8).


Sub procedure <definition>
Sub procedure

A procedure that carries out an operation. Unlike a Function procedure, a Sub procedure doesn't return a value. You declare a Sub procedure with the Sub keyword and end it with an End Sub statement.


syntax error <definition>
syntax error

An error in the grammatical structure of the code or expression. If syntax checking is enabled, errors are highlighted after you type a line and press ENTER.


system object <definition>
system object

Database objects that are defined by the system, such as the table MSysIndexes, or by the user. You can create a system object by naming the object with USys as the first four characters in the object name.


variable <definition>
variable

A named storage location that can contain data that can be modified during program execution. Each variable has a name that uniquely identifies it within its level of scope. A data type can be specified or not.


Variant <definition>
Variant

The default data type for variables that don't have type-declaration characters when a Deftype statement isn't in effect. A Variant can store numeric, string, date/time, Null, or Empty data.


Boolean <definition>
Boolean

An expression that can be evaluated as either true (nonzero) or false (0). You can use the keywords True and False to supply the values of –1 and 0, respectively. The field data type Yes/No is Boolean and has the value of –1 for Yes and 0 for No.

Several property sheet settings are Boolean, including Yes/No, True/False, and On/Off.


Byte data type <definition>
Byte data type

A Microsoft Access database data type used to hold small positive integers ranging from 0 to 255.


Date data type <definition>
Date/Time data type

A Microsoft Access database data type used to hold date and time information.


domain <definition>
domain

A set of records defined by a table, a query, or an SQL expression. Domain aggregate functions return statistical information about a specific domain or set of records.


domain aggregate function <definition>
domain aggregate function

The domain aggregate functions are DAvg, DCount, DFirst, DLast, DLookup, DMax, DMin, DStDev, DStDevP, DSum, DVar, and DVarP. These functions are used when calculating statistics over a certain set of records (a domain).


Double data type <definition>
Double data type

A fundamental data type that holds double-precision floating-point numbers in IEEE format. A Double variable is stored as a 64-bit (8-byte) number ranging in value from –1.79769313486231E308 to –4.94065645841247E–324 for negative values, from 4.94065645841247E–324 to 1.79769313486231E308 for positive values, and 0. The type-declaration character is # (ANSI character 35).


Integer data type <definition>
Integer data type

A fundamental data type that holds integers. An Integer variable is stored as a 16-bit (2-byte) number ranging in value from –32,768 to 32,767. The type-declaration character is % (ANSI character 37).

In Visual Basic, you can use Integer variables to store Boolean (True/False) values.


intrinsic constant <definition>
intrinsic constant

A constant supplied by Microsoft Access, Visual Basic for Applications, Microsoft ActiveX Data Objects (ADO), or Microsoft Data Access Objects (DAO). These constants are available in the Object Browser by clicking <globals> in each of these libraries.


Long data type <definition>
Long data type

A fundamental data type that holds large integers. A Long variable is stored as a 32-bit (4-byte) number ranging in value from –2,147,483,648 to 2,147,483,647. The type-declaration character is & (ANSI character 38).


Null <definition>
Null

A value that indicates missing or unknown data in a field. You can use Null values in expressions. Null values can be entered in fields for which information is unknown, as well as in expressions and queries. In Visual Basic, the Null keyword indicates a Null value. Some fields, such as those defined as containing the primary key, can't contain Null values.


object data type <definition>
Object data type

A fundamental data type representing any object that can be recognized by Visual Basic. The Object data type is generic; you can declare any object variable as type Object. For better performance, however, you should declare object variables according to their specific type. For example, use a variable of type Form to represent a form rather than a variable of type Object.

There are three categories of the Object data type: Microsoft Access object types, ADO object types, and DAO object types.

Microsoft Access object types

Application	Form	Screen
Control	Module
DataAccessPage	Report
ADO object types

Command	Field	Recordset
Connection	Parameter
Error	Property
DAO object types

Connection	Error	Property	User
Container	Field	QueryDef	Workspace
Database	Group	Recordset
DBEngine	Index	Relation
Document	Parameter	TableDef


page (data storage)

A portion of the database (.mdb) file in which record data is stored. Depending on the size of the records, a page (4K in size) may contain more than one record.


Single data type <definition>
Single data type

A fundamental data type that holds single-precision floating-point numbers in IEEE format. A Single variable is stored as a 32-bit (4-byte) number, ranging in value from –3.402823E38 to –1.401298E–45 for negative values, from 1.401298E–45 to 3.402823E38 for positive values, and 0. The type-declaration character is ! (ANSI character 33).


String data type <definition>
String data type

A fundamental data type that holds character information. A String variable is of either fixed or variable length, and contains one character per 2 bytes. Fixed-length strings are declared to be a specific length, and can contain 1 to approximately 64K (2^16) characters. Variable-length strings can be any length up to 2 billion (2^31) characters (approximately 64K (2^16) characters for Microsoft Windows version 3.1 and earlier), less a small amount of storage overhead. The type-declaration character is $ (ANSI character 36).


Automation object <definition>
Automation object

An object supplied by a component that supports Automation. For example, the Microsoft Access Application object is an Automation object. Automation objects may also be referred to as "ActiveX objects" or simply "objects."


bit mask <definition>
bit mask

A value used with bit-wise operators (And, Eqv, Imp, Not, Or, and Xor) to test, set, or reset the state of individual bits in a bit-wise field value.


cascading event <definition>
cascading event

A sequence of events caused by an event procedure directly or indirectly calling itself; also referred to as an event cascade or a recursion. Be careful when producing cascading events, because they often result in stack-overflow or other run-time errors.


class name (OLE) <definition>
class name (OLE)

A predefined name used to refer to an OLE object in Visual Basic. A class name consists of the name of the application used to create the OLE object, the object's type, and, optionally, the version number of the application. Examples of class names are Excel.Sheet, Excel.Worksheet, Word.Document, and MSGraph.Chart.5. To determine the class name of an OLE object, see the documentation for the application that created the object.


code stub <definition>
code stub

A segment of Visual Basic code that defines the beginning and end of a procedure.


collection <definition>
collection

An object that contains a set of related objects. An object's position in the collection can change whenever a change occurs in the collection; therefore, the position of any specific object in a collection may vary.


connection string <definition>
connection string

A string expression used to open an external database.


Data Access Objects (DAO) <definition>
Data Access Objects (DAO)

The objects that represent the structure of your database and the data that it contains. From Visual Basic you can use DAO objects to create or change tables and queries, secure your database, or access data from external data sources. You can also use DAO objects to manipulate the data stored in your database from code.


event procedure <definition>
event procedure

A procedure automatically executed in response to an event initiated by the user or program code, or triggered by the system.


identifier <definition>
identifier (Visual Basic)

A data member in a Visual Basic code module. An identifier can be a Sub, Function, or Property procedure, a variable, a constant, a Declare statement, or a user-defined data type.


keyboard handler <definition>
keyboard handler

Code that determines and responds to keys or key combinations pressed by the user.


Microsoft Jet database engine <definition>
Microsoft Jet database engine

That part of the Microsoft Access database system that retrieves data from and stores data in user and system databases. The Microsoft Jet database engine can be thought of as a data manager upon which database systems, such as Microsoft Access, are built.


procedure level <definition>
procedure level

Describes any variables or constants declared within a procedure. Variables and constants declared within a procedure are available to that procedure only.


user-defined collection <definition>
user-defined collection

A collection that you create by adding objects to a Collection object. Items in a collection defined by the Collection object are indexed beginning with 1.


event property <definition>
event property

A named attribute of a control, form, report, data access page, or section associated with an event that the control, form, report, page, or section can respond to. You can run a procedure or macro when an event occurs by setting the related event property to [Event Procedure], a function, or the name of a macro.


Microsoft Access object <definition>
Microsoft Access object

An object defined by Microsoft Access that relates to Microsoft Access itself, its interface, or an application's forms, reports, and data access pages. You use Microsoft Access objects, such as the Form and Report objects, to represent in code the elements of the interface that are used to enter and display data, such as forms and reports.


session <definition>
session

A sequence of operations performed by the Microsoft Jet database engine. A session begins when a user logs on and ends when the user logs off. All operations during a session form one transaction scope and are subject to permissions determined by the logon user name and password.


Windows application programming interface (API) <definition>
Windows application programming interface (API)

The functions, messages, data structures, data types, and statements you can use in creating applications that run under Microsoft Windows 95 or later. The parts of the API you use most are code elements included for calling API functions from Windows. These include procedure declarations (for the Windows functions), user-defined type definitions (for data structures passed to those functions), and constant declarations (for values passed to and returned from those functions).


zero-length string <definition>
zero-length string

A string containing no characters. You can use a zero-length string to indicate that you know there's no value for a field. You enter a zero-length string by typing two double quotation marks with no space between them (" "). In a Microsoft Access database, you can enter zero-length strings in Text, Memo, or Hyperlink fields if you set the AllowZeroLength property for the field to Yes. In a Microsoft Access project, you can enter zero-length strings in varchar and nvarchar fields. You can't enter zero-length strings in other types of fields. Zero-length strings are not supported in SQL Server 6.5.


bound column <definition>
bound column

The column in a list box, combo box, or drop-down list box that's bound to the field specified by the control's ControlSource property.


transaction <definition>
transaction

A series of changes made to a database's data and schema. Mark the beginning of a transaction with the BeginTrans statement, commit the transaction by using the CommitTrans statement, and undo all your changes since the BeginTrans statement by using the RollbackTrans (ADO) or Rollback (DAO) statement.


control containing a hyperlink <definition>
control containing a hyperlink

A control can contain a hyperlink, allowing the user to click the control to jump to a document, Web page, or object. The control can be one of the following types:

•	A text box control bound to a field containing hyperlinks.

•	A combo box that displays a hyperlink. The column whose value is displayed in the text box portion of the combo box when you select an item from the combo box list has as its source a table field containing hyperlinks.

•	A command button, label, or image control whose HyperlinkAddress property and/or HyperlinkSubAddress property, or DHTML Href property (data access pages) is set to a hyperlink address.

You can also use the FollowHyperlink method in code to add a hyperlink to any control.


project <definition>
project

The set of all code modules in a database, including standard modules and class modules. By default, the project has the same name as the database. The project name also appears in the Project/Library box in the Object Browser.

If you save a database to a new name by copying, compacting, encrypting, or saving it as an .adp or .mdb file, the current project name is retained in the new database.


call tree <definition>
call tree

All modules that might be called by any procedure in the module in which code is currently running.


class module <definition>
class module

A module that can contain the definition for a new object. When you create a new instance of a class, you create the new object. Any procedures defined in the module become the properties and methods of the object.

Class modules in Microsoft Access exist both independently and in association with forms and reports.


class name <definition>
class name

The name used to refer to a class module. If the class module is a form or report module, the class name is prefaced with the type of module. For example, the class name for a module associated with a form called OrderForm would be Form_OrderForm, while one associated with a report called OrderReport would be Report_OrderReport.


conditional compiler constant <definition>
conditional compiler constant

A Visual Basic identifier that's defined by using the #Const compiler directive or defined in the host application, and used by other compiler directives to determine when or if certain blocks of Visual Basic code are compiled.


data item <definition>
data item

An application-specific piece of data that can be transferred over a DDE channel.


DDE channel <definition>
DDE channel

An active link between Microsoft Windows applications over which data can be exchanged.


Declarations section <definition>
Declarations section

The section of a module containing declarations that apply to every procedure in the module. It can include declarations for variables, constants, user-defined data types, and external procedures in a dynamic-link library. You can locate the Declarations section by clicking (Declarations) in the Procedure box.


default property <definition>
default property

A property that you can set for a control, so each time a new control of that type is created, this property will have the same value.


echo <definition>
echo

The process of Microsoft Access updating or repainting the screen while a macro is running. You can suspend the echo process by using the Echo action or the Echo method of the DoCmd object.


foreign table <definition>
foreign table

A table that contains a foreign key field that's the primary key field in another table in the database. A foreign table is usually on the "many" side of a one-to-many relationship. An example of a foreign table is a table of customer orders related to a table of customer names by a CustomerID foreign key field.


form module <definition>
form module

A module that includes code for all event procedures triggered by events occurring on a specific form or its controls. Additionally, a form module can contain other Sub or Function procedures that relate to the form. A form module is a type of class module.


global menu bar <definition>
global menu bar

A special custom menu bar that replaces the built-in menu bar in all windows in your application, except where you've specified a custom menu bar for a form or report.


instance <definition>
instance

An object created from the class that contains its definition. For example, multiple instances of a form class share the same code and are loaded with the same controls with which the form class was designed. You can think of a class as a template and an individual instance of a class as object made from that template.


ODBC database <definition>
ODBC database

A database for which an Open Database Connectivity (ODBC) driver that you can use for importing, linking to, or exporting data is supplied.


private procedure <definition>
private procedure

A Sub or Function procedure that has been declared as private by using the Private keyword in a Declare statement. Procedures that are private are accessible only to other procedures in the same module where the procedure is declared.


referenced database <definition>
referenced database

The Microsoft Access database to which the user has established a reference from the current database. The user can create a reference to a database and then call procedures within standard modules in that database.


referencing database <definition>
referencing database

The current Microsoft Access database from which the user has created a reference to another Microsoft Access database. The user can create a reference to a database and then call procedures within standard modules in that database.


report module <definition>
report module

A module that includes code for all event procedures triggered by events occurring on a specific report or its controls. Additionally, a report module can contain other Sub or Function procedures that relate to the report. A report module is a class module.


selection rectangle <definition>
selection rectangle

The rectangle formed by the currently selected rows (records) and columns (fields) within Datasheet view.


SQL database <definition>
SQL database

A database based on Structured Query Language (SQL).


standard module <definition>
standard module

A module in which you can place Sub and Function procedures that you want to be available to other procedures throughout your database.


string delimiter <definition>
string delimiter

Text characters that set apart a string embedded within a string. Single quotation marks (') and double quotation marks (") are string delimiters.


type library <definition>
type library

A file (or component within another file) that contains Automation standard descriptions of exposed objects, properties, and methods. Object library (.olb) files contain type libraries. Type libraries that are shipped as stand-alone files have the file extension .tlb.


user-defined object <definition>
user-defined object

A custom object defined in a form or report class module. In a class module, the user can create a set of procedures that will become the methods and properties for a new object. The user can then create a new instance of this object, and manipulate it with these properties and methods.


class <definition>
class

The definition for an object, including its name, its properties and methods, and any events that it has. When you create an instance of a class, you create a new object with all of the characteristics defined by that class.


component/ActiveX component <definition>
component/ActiveX component

An application that can use objects supplied by another application, or which exposes its own objects for use by another application. Formerly these were known as "OLE Automation servers" and "OLE Automation controllers."


ActiveX component

An application that can use objects supplied by another application, or which exposes its own objects for use by another application. Formerly these were known as "OLE Automation servers" and "OLE Automation controllers."


custom properties dialog box <definition>
custom properties dialog box

A custom property sheet that allows users to set properties for an ActiveX control.


global shortcut menu <definition>
global shortcut menu

A special custom shortcut menu that replaces the built-in shortcut menu for the following objects: fields in table and query datasheets; forms and form controls in Form view, Datasheet view, and Print Preview; and reports in Print Preview. If you've specified a custom shortcut menu for a form, form control, or report, that custom shortcut menu is displayed instead of the global shortcut menu.


module-level variable <definition>
module-level variable

A variable that's declared in the Declarations section of a module by using the Private keyword. These variables are available to all procedures in the module.


object library <definition>
object library

A file that contains definitions of objects and their methods and properties. The file that contains an object library typically has the extension .olb.


procedure-level variable <definition>
procedure-level variable

A variable that's declared within a procedure. Procedure-level variables are always private to the procedure in which they're declared.


tab control <definition>
tab control

A control that contains multiple pages on which you can place other controls, such as text boxes or option buttons. When a user clicks the corresponding tab, that page becomes active.

With the tab control, you can construct a single form or dialog box that contains several different tabs, and you can group similar options or data on each tab's page.

Control:	Tool:


Unicode <definition>
Unicode

A character-encoding scheme that uses two bytes to represent every character regardless of whether it's an ASCII character. This scheme is capable of encoding all known characters and is used as a worldwide character-encoding standard. Unicode is supported by all 32-bit versions of Microsoft Windows and by 32-bit OLE technology.


ODBCDirect <definition>
ODBCDirect

A technology that allows you to access ODBC data sources directly by using DAO features that bypass the Microsoft Jet database engine.


break mode <definition>
break mode

Temporary suspension of program execution while in the development environment. In break mode, you can examine, debug, reset, step through, or continue program execution. Break mode can be entered by: encountering a breakpoint during program execution; pressing CTRL+BREAK during program execution; encountering a Stop statement or untrapped run-time error during program execution; adding a Break When True watch expression (execution stops when the value of the watch expression changes and evaluates to True); adding a Break When Changed watch expression (execution stops when the value of the watch expression changes).


ASP files <definition>
ASP files

Microsoft Internet Information Server 3.0 or later supports the use of Microsoft Active Server Pages (ASP) files to get data from an ODBC data source and format it as an HTML Web page. The ASP file contains server-side scripts that specify how to connect to the data source, as well as the appropriate HTML tags to format the data once it's returned. An Access form that is saved as an ASP file also contains ActiveX controls and Microsoft Visual Basic Scripting Edition (VBScript) code.


American Standard Code for Information Interchange (ASCII)

A coding scheme using 7 or 8 bits that assigns numeric values to up to 256 characters, including letters, numerals, punctuation marks, control characters, and other symbols.


American Standard Code for Information Interchange (ASCII)

A coding scheme using 7 or 8 bits that assigns numeric values to up to 256 characters, including letters, numerals, punctuation marks, control characters, and other symbols.


ActiveX Data Objects (ADO)

Programming objects that represent the structure of your database and the data it contains. In the Visual Basic Editor, you can use ADO objects and an additional component of ADO called Microsoft ADO Extensions for DDL and Security (ADOX) to create or change tables and queries, secure your database, or access data from external data sources. You can also use ADO objects in code to manipulate data stored in your database. ADO and ADOX support access to any data source that has an ODBC driver or OLE DB provider created for that data source. This includes Access databases (.mdb files), through the OLE DB Provider for Microsoft Jet 4.0, and SQL Server 6.5 and 7.0 databases, through the Microsoft OLE DB Provider for SQL Server.


chart <definition>
chart

A graphical representation of data in a form, report, or data access page. (In versions of Microsoft Access earlier than Access 97, charts were referred to as graphs.)


command bar <definition>
command bar

Toolbars, menu bars, and shortcut (right-click) menus are combined into a single functionality, called "toolbars" in the user interface, and "command bars" in Visual Basic for Applications. Command bars can be one of three types: menu bar, toolbar, or pop-up menu. The pop-up menu type includes drop-down menus on menu bars (such as the Edit menu) and shortcut (right-click) menus. Each type can include built-in and custom commands.


front-end/back-end application <definition>
front-end/back-end application

An application consisting of two database files. The "back-end" database file contains the tables. The "front-end" database file contains all other database objects (queries, forms, reports, macros, and modules) and links to the tables in the back-end database. Typically the back-end database is located on a network server, and copies of the front-end database are installed on individual users' computers.


hyperlink <definition>
hyperlink

Colored and underlined text or a graphic that you click to jump to a file, a location in a file, an HTML page on the World Wide Web, or an HTML page on an intranet. Hyperlinks can also jump to Gopher, Telnet, newsgroup, and FTP sites.


selected control <definition>
selected control

To select a control, click it.


URL <definition>
Uniform Resource Locator (URL)

An address to an object, document, page, or other destination (for example, a newsgroup or a World Wide Web page) on the Internet or an intranet. A URL expresses the protocol (such as FTP or HTTP) to be accessed and where the destination is located. A URL may also specify an Internet e-mail address. Some examples of URLs are:

http://www.someones.homepage/default.html

ftp://ftp.server.somewhere/ftp.file

news:alt.hypertext


HTML <definition>
Hypertext Markup Language (HTML)

The system of marking up, or tagging, a document so that it can be published on the World Wide Web. Documents prepared in HTML include reference graphics and formatting tags. You use a Web browser (such as Microsoft Internet Explorer) to view these documents.


Object Browser <definition>
Object Browser

A dialog box that displays information about objects, properties, methods, and constants in the current project and in referenced object libraries. You can use the Object Browser to search for a specific element, view its definition, get help on it, or paste it into a module.


Office Links button <definition>
Office Links button

Exports the currently selected object to Microsoft Excel or Word. You can export tables, queries, forms, or reports with Analyze It With MS Excel or Publish It With MS Word. You can merge data from a table or a query to the Microsoft Word Mail Merge Wizard with Merge It With MS Word.


Analyze button <definition>
Analyze button

Launches the Table Analyzer Wizard, which makes suggestions on improving the structure of your data.


Move mode <definition>
Move mode

The mode in which you can move one or more columns in Datasheet view. After you select the columns that you want to move, turn on Move mode by pressing CTRL+SHIFT+F8 (the letters MOV appear in the right side of the status bar). In Move mode, you can move columns by using the left and right arrow keys. To turn off Move mode, press ESC.


Line/Border Width button <definition>
Line/Border Width button

Changes the width of the selected control's border.


Gridl button <definition>
Grid button

Displays the gridlines you choose in Datasheet view: Horizontal, Vertical, Both, or None.


shortcut key <definition>
shortcut key

A function key or a key combination, such as F5 or CTRL+A, that allows you to carry out a menu command. In contrast, an access key is a key combination, such as ALT+F, that moves the focus to a menu, command, or control, without using the mouse.


Filter For Input <definition>
Filter For Input

A technique for filtering records that uses a value or expression you enter in the Filter For box to find only records that contain the value or satisfy the expression you specify. (The Filter For box is available on the shortcut menu when you right-click in a field in Datasheet view of a table, query, or form, or in Form view.)


access key <definition>
access key

A key combination, such as ALT+F, that moves the focus to a menu, command, or control, without using the mouse. For example, to move the focus to a menu command, press ALT plus the designated character for the menu, and then press the designated character for the command. In contrast, a shortcut key is a function key or a key combination, such as F5 or CTRL+A, that carries out a menu command.


action <definition>
action

The basic building block of a macro; a self-contained instruction that can be combined with other actions to automate tasks. This is sometimes called a command in other macro languages.


action argument <definition>
action argument

Additional information required by some macro actions — for example, the object affected by the action or special conditions under which the action is carried out.


action list <definition>
action list

The list appears when you click the arrow in the Action column of the Macro window.


action row <definition>
action row

A row in the upper part of the Macro window in which you enter macro names, actions, conditions, and comments associated with a particular macro or macro group.


American National Standards Institute (ANSI) character set <definition>
American National Standards Institute (ANSI) character set

An 8-bit character set used by Microsoft Windows that allows you to represent up to 256 characters (0 through 255) using your keyboard. The ASCII character set is a subset of the ANSI set.


linked table <definition>
linked table

A table stored in a file outside the open database from which Microsoft Access can access records. You can add, delete, and edit records in a linked table, but you can't change its structure.

Note   Linked tables are known as "attached tables" in previous versions of Microsoft Access.


automatic link <definition>
automatic link

A link from an OLE object in Microsoft Access to an OLE server that automatically updates the object in Microsoft Access when the information in the object file changes. In contrast, a manual link requires you to take action to update the object in Microsoft Access.


bound object frame <definition>
bound object frame

A control on a form or report used to display and manipulate OLE objects that are stored in tables.

Control:	Tool:


breakpoint <definition>
breakpoint

A line of code in a Function or Sub procedure at which Visual Basic automatically suspends execution.


case-sensitive <definition>
case-sensitive

Capable of distinguishing between uppercase and lowercase letters. A case-sensitive search finds only text that is an exact match of uppercase and lowercase letters. For example, such a search would treat "ZeroLengthStr" and "zerolengthstr" as different words.


check box <definition>
check box

A control that indicates whether an option is selected. A check mark appears in the box when the option is selected.

Control:	Tool:


command button <definition>
command button

A control that runs a macro, calls a Visual Basic function, or runs an event procedure. This is sometimes called a push button in other applications.

Control:	Tool:


continuous form <definition>
continuous form

A form that displays more than one record on the screen in Form view. You can create a continuous form by setting a form's DefaultView property to Continuous Forms.


criteria <definition>
criteria

A set of limiting conditions, such as = "Denmark" (meaning equal to Denmark) or >30000, used in creating a query or filter to show a specific set of records.


Currency data type <definition>
Currency data type

A data type that is useful for calculations involving money or for fixed-point calculations in which accuracy is extremely important. This data type is used to store numbers with up to 15 digits to the left of the decimal point and 4 digits to the right. The type-declaration character in Visual Basic is @.


dynamic data exchange (DDE) <definition>
dynamic data exchange (DDE)

An established protocol for exchanging data between Windows-based applications.


dynamic-link library (DLL) <definition>
dynamic-link library (DLL)

A set of routines that can be called from Visual Basic procedures and are loaded and linked into your application at run time.


result set <definition>
result set

The set of records that results from running a query or applying a filter. In some cases, you can update the data in the underlying table or tables when you make changes to a result set.


embed <definition>
embed (insert)

To insert a copy of an OLE object from another application. The source of the object, called the OLE server, can be any application that supports object linking and embedding.

Once an object is embedded, changes to it are not reflected in the original object and vice versa.


event <definition>
event

An action recognized by an object, such as a mouse click or key press, for which you can define a response. An event can be caused by a user action or a Visual Basic statement, or it can be triggered by the system. Using properties associated with events, you can tell Microsoft Access to run a macro, call a Visual Basic function, or run an event procedure in response to an event.


field selector <definition>
field selector

A small box or bar that you click to select an entire column in a datasheet.


focus <definition>
focus

The ability to receive user input through mouse or keyboard actions or the SetFocus method. In Microsoft Windows, only one item at a time can have the focus. For example, when you type a string, the string appears in a text box only if the text box has the focus.


font <definition>
font

A graphic design applied to all numerals, symbols, and alphabetic characters. Arial and Courier New are examples of fonts. Fonts usually come in different sizes, such as 9- and 10-point, and various styles, such as bold and italic.


form <definition>
form

A Microsoft Access database object on which you place controls for taking actions or for entering, displaying, and editing data in fields.


form properties <definition>
form properties

Attributes of a form that affect its appearance or behavior. For example, the DefaultView property is a form property that determines whether a form will automatically open in Form view or Datasheet view. Form properties are set in form Design view, as are control properties, but field properties for tables or queries are set in table Design view or, in a Microsoft Access project, a database diagram.


Form window <definition>
Form window

A window in which you work with forms in Design view, Form view, Datasheet view, or Print Preview.


left outer join <definition>
left outer join

An outer join in which all the records from the left side of the LEFT JOIN operation in the query's SQL statement are added to the query's results, even if there are no matching values in the joined field from the table on the right. Records from the table on the right are combined with those from the table on the left only when there are matching values in the joined fields.

A left outer join is indicated by a join line arrow (Microsoft Access database) or key symbol (Microsoft Access project) pointing from left to right.


OLE/DDE link <definition>
OLE/DDE link

A connection between an OLE object and its OLE server, or between a dynamic data exchange (DDE) source document and a destination document.


list box <definition>
list box

A control that provides a list of choices. A list box consists of a list and an optional label.

Control:	Tool:


list index <definition>
list index

The sequence of numbers for items in a list, starting with 0 for the first item, 1 for the second item, and so forth.


locked <definition>
locked

The condition of a record, recordset, or database that makes it read-only to all users except the user currently modifying it.


macro <definition>
macro

An action or a set of actions you can use to automate tasks.


macro group <definition>
macro group

A collection of related macros that are stored together under a single macro name. The collection is often referred to simply as a macro.


Macro window <definition>
Macro window

The window in which you create and modify macros.


manual link <definition>
manual link

A link that requires you to take action to update your data after the data in the source document changes. In contrast, an automatic link updates your data automatically when the data in the source document changes.


Memo data type <definition>
Memo data type

A field data type. Memo fields can contain up to 65,535 characters.


menu <definition>
menu

A list of commands that is displayed when you click a menu name on a menu bar or other toolbar.


menu bar <definition>
menu bar

The horizontal bar below the title bar that contains the names of menus. A menu bar can be the Microsoft Access built-in menu bar or a custom menu bar. You can click a menu name on a menu bar to display the list of commands.


metafile <definition>
metafile

A vector-based graphic. Metafiles are represented as collections of lines rather than pixels, so you can manipulate them without the distortions common to bitmap (raster) graphics.


modal <definition>
modal

A window or form state. You can't click or select anything in any other window until you close the modal window. Dialog boxes and messages are usually modal.


multiuser (shared) database <definition>
multiuser (shared) database

A database that permits more than one user to access and modify the same set of data at the same time.


normalize <definition>
normalize

To minimize the duplication of information in a relational database through effective table design. You can use the Table Analyzer Wizard to normalize your database.


Number data type <definition>
Number data type

A field data type designed for numerical data that will be used in mathematical calculations. Use the Currency data type, however, to display or calculate currency values.


OLE <definition>
OLE

A protocol by which an object, such as a chart (graph) in an OLE server or file, can be linked or embedded (inserted) in an OLE container file, such as a Microsoft Access form or report.


OLE object <definition>
OLE object

An object that supports the OLE protocol for object linking and embedding. An OLE object from an OLE server, for example, a Windows Paint picture or a Microsoft Excel spreadsheet, can be linked or embedded in a field, form, or report. A linked OLE object displays the object’s data in a form or report, but the data remains stored in its original file. You can edit a linked OLE object from the form or report and save changes to the original file, but it can still be opened and edited from the OLE server. When the information in the object is changed by the OLE server, the change is reflected in Microsoft Access. In contrast, an embedded OLE object is a copy of the information created in the OLE server that is stored in the database file. Changes made to the original file aren't reflected in Microsoft Access, and likewise, changes made to the embedded object aren’t saved back to the original file.


OLE Object data type <definition>
OLE Object data type

A field data type you use for objects created in other applications that can be linked or embedded (inserted) in a Microsoft Access database. For example, you could use an OLE Object field to store a collection of pictures.


operator <definition>
operator

A symbol or word, such as > and Or, that indicates an operation to be performed on one or more elements. Microsoft Access has several classes of operators, including arithmetic, comparison, concatenation, and logical operators.


pixel <definition>
pixel

An abbreviation for picture element; a dot that represents the smallest graphic unit of display on the screen.


pop-up form <definition>
pop-up form

A form that stays on top of other windows. A pop-up form can be modal or modeless.


preview <definition>
preview

To view data or modules on the screen as they will appear when printed. There are two preview windows: Print Preview and Layout Preview.

•	The Print Preview window is available for forms, reports, datasheets, and modules.

•	The Layout Preview window is available only for reports in Design view. Layout Preview provides a quick view of the basic layout of a report but may not include all the data in the report.


property sheet <definition>
property sheet

In a Microsoft Access database, the window in which you can view or modify the properties of tables, queries, fields, forms, reports, data access pages, and controls.

In a Microsoft Access project, the window in which you can view or modify the properties of forms, reports, and data access pages. You use property pages to modify the properties of tables, queries, and other Microsoft SQL Server database objects.

On a data access page in an Access database or Access project, the Property Toolbox is the window in which you set properties for  Microsoft Office Web Components. You can set these same properties in the property sheet instead; the property sheet includes additional properties not displayed in the Property Toolbox.


design grid <definition>
design grid

The grid that you use to design a query or filter in query Design view or in the Advanced Filter/Sort window. For queries, this grid was formerly known as the QBE grid.


Query window <definition>
Query window

A window in which you work with queries in Design view, Datasheet view, SQL view, or Print Preview.


record <definition>
record

A collection of data about a person, a place, an event, or some other item. A record is represented as a row in Datasheet view of a table, query, or form.


relationship <definition>
relationship

An association established between common fields (columns) in two tables. A relationship can be one-to-one, one-to-many, or many-to-many.


report <definition>
report

A Microsoft Access database object that prints information formatted and organized according to your specifications. Examples of reports are sales summaries, phone lists, and mailing labels.


Report window <definition>
Report window

A window in which you work with reports in Design view, Layout Preview, or Print Preview.


row selector <definition>
row selector

A small box or bar that when clicked selects an entire row in table or macro Design view. Row selectors also appear in the Sorting And Grouping box in report Design view.


run time <definition>
run time

The time during which an application is running. During run time, you can interact with an application. In contrast, during design time, you can create objects and modify their design.


run-time error <definition>
run-time error

An error that Microsoft Access can detect only when an application is running.


separator <definition>
separator

A character that separates units of text or numbers. Except for the field separator, separators are set on the Number tab in the Regional Settings section of the Microsoft Windows Control Panel.

•	A list separator separates items in a list (0,3,2).

•	A thousand separator (or digit grouping symbol) separates groups of three digits in numbers (2,000 or 456,871,029).

•	A decimal separator (or decimal symbol) separates the integer part of a number from its fractional part (9.35).

•	A field separator separates items in imported or exported text files.


single stepping <definition>
single stepping

A debugging technique that enables you to run a macro one action at a time or run Visual Basic code one line at a time.


sort order <definition>
sort order

The order in which records are displayed — either ascending (A to Z or 0 to 100) or descending (Z to A or 100 to 0).


Sorting And Grouping box <definition>
Sorting And Grouping box (reports)

The box in which you specify the order of your data and define the group levels for a report.

To display the Sorting And Grouping box, click Sorting And Grouping  [image]  on the toolbar.


object-naming rules <definition>
object-naming rules

A set of specific rules for naming Microsoft Access objects. In Microsoft Access, names can be up to 64 characters long and can include any combination of letters, numbers, spaces, and special characters except a period (.), an exclamation point (!), an accent grave (`), and brackets ([ ]). Note that you also can't use leading spaces or control characters (ASCII values 0 to 31). For information on Visual Basic naming conventions, search the Help index for "naming conventions."

Tips

•	Avoid including spaces in object names if you'll frequently refer to the objects in expressions or Visual Basic code.

•	Avoid using extremely long names because they are difficult to remember and refer to.


status bar <definition>
status bar

A horizontal bar at the bottom of the screen that displays information about commands, toolbar buttons, and other options.


string <definition>
string

A collection of characters that can include both numbers and text.


subform <definition>
subform

A form contained within another form or a report.


subform/subreport control <definition>
subform/subreport control

A control that displays a subform in a form or a subform or a subreport in a report.

Control:	Tool:


submenu <definition>
submenu

A menu that appears when a user points to a command on a higher-level menu.


subreport <definition>
subreport

A report contained within another report.


tab order <definition>
tab order

The order in which the focus moves in a form from one field or button to the next as you press the TAB key.


table <definition>
table

The fundamental structure of a relational database management system. In Microsoft Access, a table is an object that stores data in records (rows) and fields (columns). The data is usually about a particular category of things, such as employees or orders.


Text data type <definition>
Text data type

A field data type. Text fields can contain up to 255 characters or the number of characters specified by the FieldSize property, whichever is less.


title bar <definition>
title bar

The bar that appears at the top of a window and displays the window's name.


topic <definition>
topic

The subject of a dynamic data exchange (DDE) conversation between two applications. For most applications that use files, the topic is a filename. A special topic that most applications recognize is System. You can use the System topic to obtain information about the application, such as the other topics it supports.


twip <definition>
twip

Unit of measurement used by Microsoft Access that is equal to 1/20 of a point, or 1/1440 of an inch. There are 567 twips in a centimeter.


unbound object frame <definition>
unbound object frame

A control you place on a form or report to contain an unbound object. An unbound object is an object, such as a picture, whose value isn't derived from data stored in a table. You can edit the object directly from the form or report; if you don't need to edit a picture object, it's better to use an image control.

Control:	Tool:


validation <definition>
validation

The process of checking whether entered data meets certain conditions or limitations.


WHERE clause <definition>
WHERE clause

The part of an SQL statement that specifies which records to retrieve.


Yes/No data type <definition>
Yes/No data type

A field data type you use for fields that will contain only one of two values, such as Yes or No and True or False.


aggregate function <definition>
aggregate function

A function, such as Sum, Count, Avg, or Var, that you use to calculate totals.


compound control <definition>
compound control

A control and an attached label; for example, a text box with an attached label.


delimited text file <definition>
delimited text file

A file containing values separated by commas, tabs, semicolons, or other characters.


exclusive <definition>
exclusive

A type of access that protects data in a database shared over a network. When you open a database in exclusive mode, you prevent others from opening the database.


fixed-width text file <definition>
fixed-width text file

A file containing values arranged so that each field has a certain width.


group account <definition>
group account

A collection of user accounts in a workgroup, identified by group name and personal ID (PID). Permissions assigned to a group apply to all users in the group.


Open Database Connectivity (ODBC) <definition>
Open Database Connectivity (ODBC)

A standard protocol for accessing information in SQL database servers, such as Microsoft SQL Server. You can install ODBC drivers that enable Microsoft Access to connect to these SQL database servers and access the data in the SQL databases.


referential integrity <definition>
referential integrity

Rules that you follow to preserve the defined relationships between tables when you enter or delete records. If you enforce referential integrity, Microsoft Access prevents you from adding records to a related table when there is no associated record in the primary table, changing values in the primary table that would result in orphan records in a related table, and deleting records from the primary table when there are matching related records in a related table.


repaint <definition>
repaint

To redraw the screen. The Repaint method completes any pending screen updates for a specified form.


secure workgroup <definition>
secure workgroup

A Microsoft Access workgroup in which users log on with a user name and password and in which access to database objects is restricted according to permissions specified for user accounts and groups.


user account <definition>
user account

An account identified by a user name and personal ID (PID) that is created to manage access to database objects in a Microsoft Access workgroup.


command line <definition>
command line

The string of characters used to start an application. For example, you enter a command line when you start Microsoft Access by clicking the Windows Start button and then clicking Run, or when you use the RunApp action.


library database <definition>
library database

A collection of procedures and database objects that you can call from any application. In order to use the items in the library, you must first establish a reference from the current database to the library database.


literal <definition>
literal

A value that Microsoft Access uses exactly as you see it. For example, the number 25, the string "Hello", and the date #01-05-95# are all literals. You can use literals in expressions, and you can assign literals to constants or variables in Visual Basic.


question mark pointer <definition>
question-mark pointer

Use the question-mark pointer to get context-sensitive Help on toolbar buttons, dialog box options, tools in the toolbox, and other parts of the window. To display the question-mark pointer, press SHIFT+F1, click What's This on the Help menu, or click the question mark  [image]  on a dialog box's title bar.


workgroup <definition>
workgroup

A group of users in a multiuser environment who share data and the same workgroup information file.


add-in

A Visual Basic procedure and any objects the procedure opens, which are stored in a database and can be added to or removed from the Microsoft Access user interface by using the Add-In Manager.

Some add-ins, such as Microsoft Access wizards, are installed with Microsoft Access. You can also create your own add-ins or buy them from third-party vendors.


Build button <definition>
Build button (toolbar)

Build button (property sheet, dialog box)

A button on a toolbar, property sheet, or dialog box that you can click to start a builder that helps you perform a task, such as creating an expression or an event procedure.


builder <definition>
builder

A Microsoft Access tool that simplifies a task. For example, you can quickly create a complex expression with the Expression Builder.


built-in toolbar <definition>
built-in toolbar

A toolbar that is part of Microsoft Access when it's installed on your computer. In contrast, a custom toolbar is one you create for your own application.


OLE container <definition>
OLE container

An application that contains a linked or embedded OLE object from another application. For example, if an OLE object in a Microsoft Access database contains a Microsoft Excel worksheet, Microsoft Access is the OLE container.

Note   OLE containers are known as "container applications" in previous versions of Microsoft Access.


custom toolbar <definition>
custom toolbar

A toolbar that you create for your application. In contrast, a built-in toolbar is part of Microsoft Access when it's installed on your computer.


docked <definition>
docked

Fixed to the top, bottom, or side of a Microsoft Access window. The toolbox, menu bar, and all toolbars can be docked.


floating <definition>
floating

Able to move freely as its own window. A floating window is always on top. Toolbars, menu bars, the toolbox, and palettes can float.


identifier (expressions)

An element of an expression that refers to the value of a field, control, or property. For example, Forms![Orders]![OrderID] is an identifier that refers to the value in the OrderID control on the Orders form.

Identifiers can be presented in two ways: qualified or nonqualified. A qualified identifier, such as Forms![Orders]![Orders Subform].Form![UnitPrice], refers to the same data object within an active database regardless of the context. A nonqualified identifier, such as [Orders Subform].Form![UnitPrice], can refer to different data objects within an active database depending on the context.


in-place activation <definition>
in-place activation

Activation of an OLE object's OLE server from within a field or control. For example, a waveform audio (.wav) file contained in a control can be played by double-clicking the control. During in-place activation, the Microsoft Access menus and toolbars are replaced with the source application's menus and toolbars.


OLE server <definition>
OLE server

An application or DLL that supplies a linked or embedded OLE object to another application. For example, if an OLE object in a Microsoft Access database contains a Microsoft Excel worksheet, Microsoft Excel is the OLE server.

Note   OLE servers are known as "object applications" in previous versions of Microsoft Access.


Automation <definition>
Automation

A way to work with an application's objects from another application or development tool.  Formerly called OLE Automation, Automation is an industry standard and a feature of the Component Object Model (COM).


point <definition>
point

Unit of measure referring to the height of a printed character. A point equals 1/72 of an inch, or approximately 1/28 of a centimeter.


shortcut menu <definition>
shortcut menu

A list of commands that is displayed when you click the right mouse button on a toolbar, property sheet, control, object, or screen region (such as a title bar or window background). The commands listed depend on what you click on.


ToolTips <definition>
ToolTips

Brief descriptions of the names of buttons and boxes on toolbars and in the toolbox. A ToolTip is displayed when the mouse pointer rests on the button or combo box.


verb <definition>
verb

One of three operations, Edit, Run, or Play, that you activate by double-clicking an OLE object that is embedded in an object frame. For example, you double-click an embedded sound object to play that object. Double-clicking an embedded Windows Paint picture will run Paint and enable you to edit the picture.

The primary verb is the default action supported by the OLE object. When the object is activated, the primary verb will determine what occurs unless another verb has been set using the object's Verb property.


wizard <definition>
wizard

A Microsoft Access tool that asks you questions and creates an object according to your answers. For example, you can create tables, queries, forms, reports, or data access pages by using wizards.


Expression Builder <definition>
Expression Builder

A Microsoft Access tool you can use to create an expression. It is available by clicking the Build button wherever you want to create an expression (for example, in many property boxes, in the Field or Criteria rows in query Design view, or in a Module window). The Expression Builder includes a list of common expressions that you can select.


ODBC Connection String Builder <definition>
ODBC Connection String Builder

A Microsoft Access tool you can use to connect to an SQL database when you create a pass-through query. If you save the query, the connection string is stored with the query.


custom dialog box <definition>
custom dialog box

A modal pop-up form you create to ask the user for additional information or to display a message.


Admin account <definition>
Admin account

The default user account. When you install Microsoft Access, the Setup program automatically includes the Admin user account in the workgroup information file it creates. The Admin account is the same for every copy of Microsoft Access and for other applications, such as Microsoft Visual Basic, that use the Microsoft Jet database engine. By default, Microsoft Access automatically logs you on at startup using this account and gives you full permissions to database objects.


Admins group <definition>
Admins group

The system administrator's group account that retains full permissions on all databases used by a workgroup. The Setup program automatically adds the default Admin user account to the Admins group. There must be at least one user in the Admins group at all times.


Advanced Filter/Sort window <definition>
Advanced Filter/Sort window

A window in which you can create a filter from scratch. You enter criteria expressions in the filter design grid to restrict the records in the open form or datasheet to a subset of records that meet the criteria. You can also specify a sort order on one or more fields in the design grid.


application background <definition>
application background

The background area of an application window. In Microsoft Access, this is the screen area behind the Database window or any other open windows, but contained within the Microsoft Access application window.


autoformat <definition>
autoformat

A collection of formats that determines the appearance of the controls and sections in a form or report. You can apply an autoformat to a form or report by clicking AutoFormat  [image]  on the toolbar, or you can select an autoformat when you create a form or report with a wizard.


AutoNumber data type <definition>
AutoNumber data type

A field data type that automatically stores a unique number for each record as it's added to a table. Three kinds of numbers can be generated: sequential (increment by 1), random, and Replication ID (used by the Replication Manager to ensure the integrity of data in replicated databases). Numbers generated by an AutoNumber field can't be deleted or modified.

Note   For replicated databases, an AutoNumber field is not incremented by 1. Instead, it is assigned a random value between -2,000,000,000 and 2,000,000,000.


Design view <definition>
Design view

A window that shows the design of a table, query, form, report, macro, or data access page. In Design view, you can create new database objects and modify the design of existing ones.


link (tables) <definition>
link (tables)

To establish a connection to data from another application so that you can view and edit the data in both the original application and in Microsoft Access. You can also link tables from other Microsoft Access databases so you can use them without opening the other database. In previous versions of Microsoft Access, this process was referred to as attaching.


main form <definition>
main form

A form that contains one or more subforms.


Navigation mode <definition>
Navigation mode

The mode in which an entire field is selected and the insertion point is not visible. In Navigation mode, you can move between fields by using the arrow keys.


ODBC data source <definition>
ODBC data source

Data and the information needed to access that data from programs and databases that support the Open Database Connectivity (ODBC) protocol. This includes, but is not limited to, Microsoft SQL Server. For example, a SQL Server data source is the SQL Server database, the server on which it resides, and the network information required to access that server. The information required to define an ODBC data source varies depending on the requirements of its ODBC driver. You must create a data source definition for each ODBC database you want to import from, export to, or link to Microsoft Access.


owner <definition>
owner

When security is being used, the user account that has control over a database or database object. By default, the user account that created a database or database object is the owner. Group accounts can't own databases, but can own database objects, in which case all members of that group own the object. An account that owns an object has irrevocable permissions for that object and can assign permissions for that object; an account that owns a database can always open that database.


plus pointer <definition>
plus pointer

The pointer that appears when you move the pointer to the left edge of a field in a datasheet. When the plus pointer appears, you can click to select the entire field.


primary table <definition>
primary table

The "one" side of two related tables in a one-to-many relationship. A primary table should have a primary key and each record should be unique. An example of a primary table is a table of customer names that is uniquely identified by a CustomerID primary key field or column.


Query Type button <definition>
Query Type button

A button on the Query Design toolbar that lists the types of queries you can create in the query design grid. Click the arrow next to the button, and then click the type of query you want to create.


unbound form or report <definition>
unbound form or report

A form or report that isn't connected to a record source such as a table, query, or SQL statement. (The form's or report's RecordSource property is blank.) A dialog box is an example of an unbound form.


user-defined function <definition>
user-defined function

A custom function that you can use in place of an expression.


Users group <definition>
Users group

The group account that contains all user accounts. Microsoft Access automatically adds user accounts to the Users group when you create them. By default, this account has full permissions on all newly created objects. Part of the process of creating a secure database involves revoking selected permissions for members of the Users group.


watch expression <definition>
watch expression

An expression you define in the Watch pane of the Immediate window to be monitored while you are debugging Visual Basic code. When execution of your code is suspended, you can observe the values of the watch expressions you specify as you step through the code.


Watch pane <definition>
Watch pane

A window of the Visual Basic Editor that shows the current values of watch expressions while code is running.


What's This button <definition>
What's This button

A button in a dialog-box title bar that you can click to get help on items in the dialog box. After you click the What's This button, the mouse pointer changes to the question-mark pointer. You can then click an item to get help on it.

Note   You can add your own What's This button to your forms and reports by using the WhatsThisButton property.


What's This tip <definition>
What's This tip

A tip that appears beside a control, screen region, menu command, or toolbar button. To display a What's This tip, press SHIFT F1 or click the question mark  [image]  in the dialog box's title bar and then click the item you want help on.


Microsoft Knowledge Base <definition>
Microsoft Knowledge Base

The Microsoft Knowledge Base (KB) is the primary source of product information for Microsoft support engineers and customers. This comprehensive collection of articles, which is updated daily, contains detailed how-to information, answers to technical support questions, bug lists, and fix lists. Use text and keyword queries to access information in the KB.


text query (Microsoft Knowledge Base) <definition>
text query (Microsoft Knowledge Base)

One or more phrases that tell the Knowledge Base what to search for. Queries can contain operators, quotation marks, wildcard characters, and parentheses to help focus the search.


action query <definition>
action query

A query that copies or changes data. Action queries include append, delete, make-table, and update queries; they are identified by an exclamation point (!) next to their name in the Database window. Append and make-table queries copy existing data; delete and update queries change existing data. These queries are also known as DML (Data Manipulation Language).


append query <definition>
append query

An action query that adds the records in a query's result set to the end of an existing table.


calculated field <definition>
calculated field

A field, defined in a query, that displays the result of an expression rather than displaying stored data. The value is recalculated each time a value in the expression changes.

A calculated control is a control on a form, report, or data access page that displays the result of an expression rather than displaying stored data.


crosstab query <definition>
crosstab query

A query that calculates a sum, average, count, or other type of total on records, and then groups the result by two types of information — one down the left side of the datasheet and the other across the top. For example, the Quarterly Orders by Product query in the Northwind sample database is a crosstab query. You can also display data in a crosstab format by using a PivotTable list or PivotTable form.


data-definition query <definition>
data-definition query

An SQL-specific query that contains Data Definition Language (DDL) statements. These statements allow you to create or alter objects in the database.


delete query <definition>
delete query

A query (SQL statement) that removes rows matching the criteria you specify from one or more tables.


make-table query <definition>
make-table query

A query (SQL statement) that creates a new table and then creates records (rows) in it by copying records from an existing table.


parameter query <definition>
parameter query

A query in which a user interactively specifies one or more criteria values. A parameter query is not, strictly speaking, a separate kind of query; instead, it extends the flexibility of select queries, including crosstab queries.


pass-through query <definition>
pass-through query

An SQL-specific query you use to send commands directly to an ODBC database server (such as Microsoft FoxPro). By using pass-through queries, you work directly with the tables on the server instead of having the Microsoft Jet database engine process the data.


query <definition>
query

A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form, report, or data access page.

In a Microsoft Access database (.mdb), you can create a query, which is stored as a separate object and listed in the Database window. Or you can create a query as an SQL statement in the RecordSource property of a form, report, or a section of a data access page. An SQL statement is not listed in the Database window; it's stored in a form or report in an Access database, or in a data access page outside the Access database.

In a Microsoft Access project (.adp), you can create a query as a view or stored procedure, which is listed as a separate object in the Database window. Or you can create a query as an SQL statement in the RecordSource property of a form, report, or a section of a data access page. Views and stored procedures are stored in the Microsoft SQL Server database, not in the Access project. SQL statements are stored in a form or report in the Access project, or in a data access page outside the Access project.


Design view - queries <definition>
query Design view

A window in which you design queries.

To open a query in Design view, go to the Database window, click Queries  [image]  under Objects, click the query you want to open, and then click Design on the Database window toolbar.

If the query is already open, you can switch to Design view by clicking View  [image] on the toolbar.


query parameter data types <definition>
query parameter data types

The set of data types for a field in a parameter query. A Microsoft Access database has 14 query parameter data types.

Category	Data type
Table fields	Currency, Date/Time, Memo, OLE Object, Text, and Yes/No correspond to the same data types in table fields.
Number	Byte, Single, Double, Integer, Long Integer, and Replication ID correspond to the five FieldSize property settings of the Number data type in table fields.
Generic	Value is a Generic data type that will accept any type of data.
Binary	Although not recognized by Access, you can use the Binary data type in parameter queries directed to linked tables that do recognize this data type.


requery <definition>
requery

To rerun a query underlying the active form or datasheet in order to reflect changes to the records, display newly added records, and eliminate deleted records.


select query <definition>
select query

A query that asks a question about the data stored in your tables and returns a result set in the form of a datasheet — without changing the data. A select query can contain specifications for the fields (columns) to return, the records (rows) to select, the order to put the records in, and the way to group (summarize) information. After the result set is displayed, you can view and, in some cases, make changes to the data in the underlying tables.

In contrast to select queries, action queries such as delete queries do make changes to your data.


SQL string/statement <definition>
SQL string/statement

An expression that defines an SQL command, such as SELECT, UPDATE, or DELETE, and includes clauses such as WHERE and ORDER BY. SQL strings/statements are typically used in queries and in aggregate functions.


SQL-specific query <definition>
SQL-specific query

A query that consists of an SQL statement. Subqueries and pass-through, union, and data-definition queries are SQL-specific queries.


SQL view <definition>
SQL view

A window that displays the SQL statement for the current query or is used to create an SQL-specific query (union, pass-through, or data definition). When you create a query in Design view, Microsoft Access constructs the SQL equivalent in SQL view.


Structured Query Language (SQL) <definition>
Structured Query Language (SQL)

A language used in querying, updating, and managing relational databases. You can view or write Microsoft Access queries as SQL statements in the Query window by clicking SQL on the View menu, or by clicking one of the commands on the SQL Specific submenu of the Query menu.

You can use SQL SELECT statements anywhere that Access accepts a table name, query name, or field name. For example, to generate a list of items in a list box control, you can set the list box's ControlSource property to an SQL SELECT statement.


stored procedure <definition>
stored procedure

A precompiled collection of SQL statements and optional control-of-flow statements stored under a name and processed as a unit. Stored procedures are stored in an SQL database such as Microsoft SQL Server, usually on a server; can be run with one call from an application; and allow user-declared variables, conditional execution, and other powerful programming features.


subquery <definition>
subquery

An SQL SELECT statement inside another select or action query. You can use a subquery as an expression in the field (column) cell in the design grid for a query or to define criteria (search conditions) for a field (column). The result set of the embedded SELECT statement becomes part of the search condition for the main query. For example, the following query uses a subquery to find all suppliers in Sweden and then uses the results in a WHERE clause to find all products with the selected suppliers:

WHERE supplier_id IN
(SELECT supplier_id
FROM supplier
WHERE (country = 'Sweden'))


totals query <definition>
totals query

A query that displays a summary calculation, such as an average or sum, for values in various fields from a table or tables. Strictly speaking, a totals query is not a separate kind of query; rather, it extends the flexibility of select queries.


union query <definition>
union query

A query that combines corresponding fields from two or more tables or queries into one field. It's the equivalent of appending one table to another.

For example, a union query of the Customers table and the Suppliers table returns a result set that contains all the specified records from both the Customers table and the Suppliers table. The result set isn't updatable.


update query <definition>
update query

An action query (SQL statement) that changes a set of records according to criteria (search conditions) you specify.


view (window)

A window that allows you to work with a database object in a particular way.

•	In Design view, you can design an object so that it will look and behave the way you want.

•	In Datasheet view, you can modify and view data in a row-and-column format.

•	In Form view, you can modify and view data in fields on a form.

•	In Print Preview, you can see how an object will appear when printed.

•	In Layout Preview (Access database (.mdb) only), you can see a report's layout quickly, without printing the report, with only enough data to show what the report will look like.

•	In SQL view (Access database (.mdb) only), you can see the current query as an SQL statement.

•	In Page view, you can modify and interact with the data in the active data access page as you would in Internet Explorer 5 or later, while remaining in Access.


cascading delete <definition>
cascading delete

For relationships that enforce referential integrity between tables, the deletion of all related records in the related table or tables when a record in the primary table is deleted.


cascade update <definition>
cascading update

For relationships that enforce referential integrity between tables, the updating of all related records in the related table or tables when a record in the primary table is changed.


foreign key <definition>
foreign key

One or more table fields (columns) that refer to the primary key field or fields in another table. A foreign key indicates how the tables are related — the data in the foreign key and primary key fields must match, though the field names do not have to be the same. For example, a Products table might contain the foreign key SupplierNumber, which relates to the primary key SupplierID in a Suppliers table.

A foreign key can be Null; if a foreign key consists of more than one field and any of those fields is Null, all the fields must be Null.


inner join <definition>
inner join

A join in which records from two tables are combined and added to a query's results only if the values of the joined fields meet a specified condition. For example, when designing a query, the default join between tables is an inner join that selects records from both tables only if the values of the joined fields are equal.


join <definition>
join

An association between a field in one table or query and a field of the same data type in another table or query. A join tells Microsoft Access how data is related.

When you add tables to a query, and those tables already have a defined relationship, Access automatically creates an inner join that selects records from both tables when the values in the joined fields are equal. Even if relationships weren't previously defined, Access automatically creates an inner join between fields that have the same names and data types if one of the fields is a primary key. You can also create joins manually. Access allows you to create inner joins, outer joins, and self-joins.


many-to-many relationship <definition>
many-to-many relationship

An association between two tables in which one record in either table can relate to many records in the other table. To establish a many-to-many relationship, you need to create a third (junction) table and add the primary key fields from each of the other two tables to this table. For example, if you have a Products table and an Orders table, an order can include more than one product, and a product can be included in more than one order. You must create a junction table that has a one-to-many relationship with the Products table and a one-to-many relationship with the Orders table.


one-to-one relationship <definition>
one-to-one relationship

An association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of one and only one record in the related table.

This type of relationship is unusual. An example is the relationship between an Employees table and a Mailboxes table used to store information about employees' e-mail addresses. The tables have a one-to-one relationship because each employee has only one mailbox, and each mailbox is assigned to only one employee.


one-to-many relationship <definition>
one-to-many relationship

An association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of many records in the related table.

An example is the relationship between a Customers table and an Orders table, in which each customer can have many orders, but each order is related to only one customer.


outer join <definition>
outer join

A join in which each matching record from two tables is combined into one record in the query's results. When a record from the table that's contributing all of its records can't be matched with a record from the other table, the record still appears in the results of the query, view, or stored procedure; however, the cells that had no matching record in the other table are empty. You can create three variations of an outer join to specify the unmatched rows to be included: left outer joins and right outer joins are in Microsoft Access databases and Microsoft Access projects; full outer joins are only in Access projects.


primary key <definition>
primary key

One or more fields (columns) whose value or values uniquely identify each record in a table. A primary key cannot allow Null values and must always have a unique index. A primary key is used to relate a table to foreign keys in other tables.


Relationships window <definition>
Relationships window

A window in which you view, create, and modify relationships between tables and queries.


right outer join <definition>
right outer join

An outer join in which all the records from the right side of the RIGHT JOIN operation in the query's SQL statement are added to the query's results, even if there are no matching values in the joined field from the table on the left. Records from the table on the left are combined with those from the table on the right only when there are matching values in the joined fields.

A right outer join is indicated by a join line arrow (Microsoft Access database) or key symbol (Microsoft Access project) pointing from right to left.


self-join <definition>
self-join

A join in which records from a table are combined with other records from the same table when there are matching values in the joined fields. For example, if you have an Employees table, you can create a self-join between the EmployeeID field in one instance of the Employees table and the ReportsTo field in another instance of the Employees table. You can then use this join to retrieve information about each employee's supervisor. A self-join can be an inner join or an outer join. A self-join is also known as a reflexive relationship.


unique index <definition>
unique index

An index defined by setting a field's Indexed property to Yes (No Duplicates). A unique index will not allow duplicate entries in the indexed field. Setting a field as the primary key automatically defines the field as a unique index.


anonymous replica

In a Microsoft Access database, a special type of replica, in which you don't keep track of individual users. The anonymous replica is particularly useful in an Internet situation where you expect many users to download replicas.


conflict

Can occur if data has changed in the same record of two replica set members. Conflicts occur for many reasons; for example, two users updating the same record at the same time will cause a conflict.

When a conflict occurs, a winning change is selected and applied in all replicas, and the losing change is recorded as a conflict at all replicas.


Design Master

A database to which system tables, system fields, and replication properties have been added. A Design Master is the first member in a replica set and is used in the creation of the first replica in a replica set. You can make changes to the database structure only with the Design Master. Replicas in the same replica set can take turns being the Design Master, but there can be only one Design Master at a time in each replica set.


direct synchronization

A method used to synchronize data between replicas that are connected directly to the local area network and are available through shared network folders.


global replica

The replica from which you can create all other types of replicas. Changes made in a global replica are fully tracked and can be exchanged with any other global replica in the set. The global replica can also exchange changes with any local or anonymous replicas for which it becomes the hub. When a database is replicated, the first replica that is created (the Design Master) is a global replica.


hub

A global replica that all replicas in the replica set synchronize their changes to. The hub serves as the parent replica.


indirect synchronization

A synchronization method used in a disconnected environment, such as when you travel with a portable computer. Indirect synchronization can only be configured by using Replication Manager, which is available through Microsoft Office 2000 Developer. Once indirect synchronization is configured with Replication Manager, you can perform indirect synchronization by using Microsoft Access, Replication Manager, or Jet and Replication Objects (JRO).


Internet synchronization

Used to synchronize replicas in a disconnected environment in which an Internet server is configured. You must use Replication Manager, which is available through Microsoft Office 2000 Developer, to configure Internet synchronization.


local object

A table, query, form, report, macro, or module that remains in the replica or Design Master where it was created. Neither the object nor changes to the object are copied to other members in the replica set.


local replica

Displays only the data in that replica and not in any of the other replica sets, including the Design Master. A local replica synchronizes data with its hub, a global replica. Local replicas are not permitted to synchronize with other replicas in the replica set. If a change in a local replica conflicts with the global hub replica, the changes will automatically lose in any conflict resolution process.


partial replica

A database that contains only a subset of the records in a full replica. With a partial replica, you can set filters and identify relationships that define which subset of the records in the full replica should be present in the database.


publication

In a Microsoft Access project, a publication can contain one or more published tables or stored procedure articles from one user database. Each user database can have one or more publications. An article is a grouping of data to be replicated as a unit; it can be an entire table, or specific rows or columns in a table as defined by a filter. A publication can have multiple articles. Subscribers subscribe to a publication, not the articles within a publication.


replica set

The Design Master and all replicas that share the same database design and unique replica set identifier.


subscribe

To agree to receive a publication in a Microsoft Access database (.mdb) or a Microsoft Access project (.adp). A subscriber database subscribes to replicated data from a publisher database. To subscribe, you must install Microsoft Data Engine (MSDE) or Microsoft SQL Server version 7.0 on your computer.


subscription

The database that receives tables and data replicated from a publisher database in a Microsoft Access project (.adp).


topology

The order in which changes are propagated from replica to replica. Topology is important because it determines how quickly changes in another replica appear in your replica.


visibility

Replicas fall into three visibility types: global, local, and anonymous. A replica's visibility type determines several issues for the replica. For instance, a replica's visibility determines what type of replicas it can create from itself, whether it can act as the Design Master in the replica set, and how it handles conflicts during synchronization.


database replication <definition>
database replication

The process of reproducing a Microsoft Access database so that two or more copies (replicas) of the same database can stay synchronized. Changes to the data in a replicated table in one replica are sent and applied to the other replicas and Design Master in the replica set. Changes made to the design of the database in the Design Master are sent and applied to all replicas in the set.


globally unique identifier (GUID) <definition>
globally unique identifier (GUID)

A 16-byte field used in a Microsoft Access database to establish a unique identifier for replication. GUIDs are used extensively to identify replicas, replica sets, tables, records, and other objects.

Note   In an Access database, GUIDs are referred to as Replication IDs.


replica <definition>
replica

A copy of a database, including its tables, queries, forms, reports, macros, and modules. A replica is a member of a replica set and can be synchronized with other replicas in the set. Changes to the data in a replicated table in one replica are sent and applied to the other replicas.


synchronization <definition>
synchronization

The process of updating two members of a replica set by exchanging all updated records and objects in each member. Two replica set members are synchronized when the changes in each have been applied to the other.


replication <definition>
replication

The process of copying a database so that two or more copies can exchange updates of data or replicated forms, reports, or other objects. This exchange is called synchronization. Each copy of the database is called a replica, and each contains a common set of tables, queries, reports, forms, macros, and modules. Each replica can also contain local objects that exist only in that specific replica.


group level <definition>
group level

The depth at which a group in a report or data access page is nested inside other groups. Groups are nested when a set of records is grouped by more than one field, expression, or group record source. The first field, expression, or group record source you sort or group on is level 0; you can create as many as 10 group levels in a report and an unlimited number of group levels in a data access page. In other database products, group levels are sometimes referred to as break levels.


personal identifier (PID) <definition>
personal ID (PID)

A case-sensitive alphanumeric string 4 to 20 characters long that Microsoft Access uses in combination with the account name to identify a user or group in a Microsoft Access workgroup. You enter the PID and the account name when you create a new user or group.


permissions <definition>
permissions

A set of attributes that specify what kind of access a user has to data or objects in a database. For example, if a user in a Microsoft Access database has Read Data permission for a table, or if a user in a Microsoft Access project has SELECT object permission on a table, the user can view, but not edit, data in the table.


user-level security <definition>
user-level security

When using user-level security in a Microsoft Access database, a database administrator or an object's owner can grant specific permissions to individual users and groups of users on the following objects: tables, queries, forms, reports, and macros. Data access pages and modules are not protected by user-level security.


workgroup ID (WID) <definition>
workgroup ID (WID)

A case-sensitive alphanumeric string 4 to 20 characters long that you enter when creating a new workgroup information file by using the Workgroup Administrator. This uniquely identifies the Admins group for this workgroup file.


workgroup information file <definition>
workgroup information file

A file Microsoft Access reads at startup that contains information about the users in a workgroup. This information includes users' account names, their passwords, and the groups of which they are members.

Notes

•	In Microsoft Access 95 and earlier versions, preference information for each user (specified in the Options dialog box) is stored in the workgroup information file. In Microsoft Access 97 and later, preference information is stored in the Windows Registry.

•	In Microsoft Access version 2.0, the default name for the workgroup information file is System.mda. It is sometimes referred to just as a "workgroup" or the "system database." In Microsoft Access 95 and later, the default name for this file is System.mdw.


binary data type

In a Microsoft Access project, a fixed-length data type with a maximum of 8,000 bytes of binary data.


bit data type

In a Microsoft Access project, a data type that stores either a 1 or 0 value. Integer values other than 1 or 0 are accepted, but are always interpreted as 1.


char data type

In a Microsoft Access project, a fixed-length data type with a maximum of 8,000 ANSI characters.


cursor data type

In a Microsoft Access project, a data type you can only use for creating a cursor variable. This data type cannot be used for columns in a table. A cursor is a mechanism used to work with one row at a time in the result set of a SELECT statement.


datetime data type

In a Microsoft Access project, a date and time data type that ranges from January 1, 1753, to December 31, 9999, to an accuracy of three-hundredths of a second, or 3.33 milliseconds.


decimal data type (Microsoft Access project)

In a Microsoft Access project, an exact numeric data type that holds values from –10^38 – 1 through 10^38 – 1. Precision specifies the maximum total number of decimal digits that can be stored, both to the left and right of the decimal point. Scale specifies the maximum number of decimal digits that can be stored to the right of the decimal point. The scale value must be less than or equal to the precision. The decimal data type is identical to the numeric data type. Both decimal and numeric data types are provided for ANSI compatibility.


Decimal data type (Microsoft Access database)

In a Microsoft Access database, an exact numeric data type that holds values from –10^28 – 1 through 10^28 – 1. Precision specifies the maximum total number of decimal digits that can be stored, both to the left and right of the decimal point. Scale specifies the maximum number of decimal digits that can be stored to the right of the decimal point. The scale value must be greater than or equal to zero and less than the precision value. The decimal data type is provided for ANSI compatibility.


expand indicator

A button that is used to expand or collapse groups of records on a data access page, and on a datasheet containing a subdatasheet; it displays the plus (+) or minus (–) sign.


float data type

In a Microsoft Access project, a data type that can hold positive or negative floating point numbers. By default, this data type has a 15-digit precision. The range of positive values is approximately 2.23E – 308 through 1.79E + 308; the range of negative values is approximately –2.23E – 308 through –1.79E + 308. Zero can also be stored.


image data type

In a Microsoft Access project, a variable-length data type that can hold a maximum of 2^31 – 1 (2,147,483,647) bytes of binary data. An image data type is used to store objects such as pictures and documents. Columns with the image data type store a 16-byte pointer in the data row, and the data is stored separately.


int data type

In a Microsoft Access project, a data type that stores whole numbers in the range of –2^31  (–2,147,483,648) through 2^31 – 1 (2,147,483,647).


Microsoft Data Engine (MSDE)

A client/server data engine that provides local data storage on a smaller computer system, such as a single-user computer or small workgroup server, and is compatible with Microsoft SQL Server 7.0. Unlike SQL Server 7.0, MSDE has a 2-gigabyte database size limit, does not support Symmetrical Multiprocessing (SMP) on Windows 95 or later, and can't be a replication publisher (although it can act as a replication subscriber) in a replicated-database environment. MSDE runs under Windows NT 4.0 or later and Windows 95 or later.


money data type

In a Microsoft Access project, a data type that stores monetary values in the range –922,337,203,685,477.5707 through 922,337,203,685,477.5807, with accuracy to a ten-thousandth of a monetary unit.


nchar data type

In a Microsoft Access project, a fixed-length data type with a maximum of 4,000 Unicode characters. Unicode characters use 2 bytes per character and support all international characters.


ntext data type

In a Microsoft Access project, a variable-length data type that can hold a maximum of 2^30 – 1 (1,073,741,823) characters. Columns with the ntext data type store a 16-byte pointer in the data row, and the data is stored separately.


numeric data type

In a Microsoft Access project, an exact numeric data type that holds values from –10^38 – 1 through 10^38 – 1. Precision specifies the maximum total number of decimal digits that can be stored, both to the left and right of the decimal point. Scale specifies the maximum number of decimal digits that can be stored to the right of the decimal point. The scale value must be less than or equal to the precision. The numeric data type is identical to the decimal data type. Both decimal and numeric data types are provided for ANSI compatibility.


nvarchar(n) data type

In a Microsoft Access project, a variable-length data type with a maximum of 4,000 Unicode characters. Unicode characters use 2 bytes per character and support all international characters.


real data type

In a Microsoft Access project, a data type that can hold positive or floating point numbers similar to numbers held by the float data type. The real data type has seven-digit precision and has a range of positive values of approximately 1.18E – 38 through 3.40E + 38; the range of negative values is approximately –1.18E – 38 through –3.40E + 38. Zero can also be stored.


smalldatetime data type

In a Microsoft Access project, a date and time data type that is less precise than the datetime data type. Data values range from January 1, 1900, through June 6, 2079, to an accuracy of one minute.


smallint data type

In a Microsoft Access project, a data type that stores whole numbers in the range of –2^15 (–32,768) through 2^15 – 1 (32,767).


smallmoney data type

In a Microsoft Access project, a data type that stores monetary values in the range of –214,748.3648 through 214,748.3647, with accuracy to a ten-thousandth of a monetary unit. When smallmoney values are displayed, they are rounded up to two decimal places.


 subdatasheet

A datasheet that is nested within another datasheet and that contains data related or joined to the first datasheet. You can add subdatasheets to a table or query in a Microsoft Access database, or a form by using a subform in an Access database or Microsoft Access project. For example, if a Suppliers table has a one-to-many relationship with a Products table; then for each row of the Suppliers table in Datasheet view, you can view and edit the related rows of the Products table in a subdatasheet.


sysname data type

In a Microsoft Access project, a special system-supplied, user-defined data type. The sysname data type is defined by Microsoft SQL Server as nvarchar(128), which means it contains 128 Unicode characters (or 256 bytes). SQL Server uses the sysname data type as a common data type between SQL Server–supplied system tables and stored procedures. Use sysname to refer to columns referencing the names of database objects. Instead of using sysname in your user-defined tables, stored procedures, and scripts, either create your own user-defined data type by using the system stored procedure called sp_addtype, or use one of the other system-supplied data types like varchar.


text data type

In a Microsoft Access project, a variable-length data type that can hold a maximum of 2^31 – 1 (2,147,483,647) characters; default length is 16. Columns with the text data type store a 16-byte pointer in the data row, and the data is stored separately.


timestamp data type

In a Microsoft Access project, a special data type that is automatically updated every time a row is inserted or updated. Values in timestamp columns are not datetime data, but binary(8) or varbinary(8), indicating the sequence of data modifications in the database. A table can have only one timestamp column.


tinyint data type

In a Microsoft Access project, a data type that stores whole numbers in the range of 0 through 255.


uniqueidentifier data type

In a Microsoft Access project, a 16-byte globally unique identifier (GUID).


varbinary data type

In a Microsoft Access project, a variable-length data type with a maximum of 8,000 bytes of binary data.


varchar (n) data type

In a Microsoft Access project, a variable-length data type with a maximum of 8,000 ANSI characters.


column <definition>
column

A location within a database table that stores a particular type of data (for example, the First Name column in the Employees table of the Northwind sample Microsoft Access database). It is also the visual representation of a field in a datasheet, and in a Microsoft Access database, the query design grid or the filter design grid. In a datasheet, a column is a vertical stack showing the value of a field in every record. In the query and filter design grids in an Access database, a column is a vertical stack of information, such as the field name and the sort order, about each of the fields included in the query or filter. Individual columns have their own specifications as to data type and maximum length. These are called column (or field) properties.


column selector <definition>
column selector

The  horizontal bar at the top of a column. You can click a column selector to select an entire column in the query design grid or the filter design grid.


datasheet <definition>
datasheet

Data from a table, form, query, view, or stored procedure displayed in a row-and-column format.


Datasheet view <definition>
Datasheet view

A window that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.

To open a table, form, query, view, or stored procedure in Datasheet view, go to the Database window, click the type of database object under Objects, click the database object you want, and then click either Open or Design. (By default, forms open in Form view. To switch to Datasheet view in a form, click the arrow next to View  [image]  on the toolbar.)

If the table, query, view, or stored procedure is already open, switch to Datasheet view by clicking View  [image]  on the toolbar.


data type <definition>
data type

The attribute of a variable or field that determines what kind of data it can hold. For example, in a Microsoft Access database, the Text and Memo field data types allow the field to store either text or numbers, but the Number data type will allow the field to store numbers only. Number data type fields store numerical data that will be used in mathematical calculations. Use the Currency data type to display or calculate currency values.

In a Microsoft Access project, the varchar and text field data types are used to store either text or numbers. There are many different data types used to store only numbers, such as int, smallint, numeric, and decimal; they are used according to the number's length and precision. Money and smallmoney data types are used to store monetary values.

Supported data types in Access include field data types, Visual Basic data types, and query parameter data types.


external table <definition>
external table

A table outside the open Microsoft Access database or Microsoft Access project.


field <definition>
field

An element of a table that contains a specific item of information, such as a last name. A field is represented by a column or cell in a datasheet. On a form, report, or data access page, you can use a control, such as a text box, to display data from a field. In some databases, such as Microsoft SQL Server, "column" is used instead of "field."


field data types <definition>
field data types

The set of data types you can choose from for a field in a Microsoft Access table. An Access database has many field data types, including AutoNumber, Currency, Date/Time, Hyperlink, Memo, Number, OLE Object, Text, and Yes/No. A Microsoft Access project connected to a Microsoft SQL Server database has many field (or column) data types, including binary, bit, char, datetime, decimal, float, image, int, money, nchar, ntext, numeric, nvarchar, real, smalldatetime, smallint, smallmoney, text, timestamp, tinyint, uniqueidentifier, varbinary, and varchar.


grid (Datasheet view)

In Datasheet view of a table, query, form, view, or stored procedure, vertical and horizontal lines that visually divide the rows and columns of data into cells. You can customize the color of the lines and turn on or turn off their appearance.


grid <definition>
grid (Design view)

In Design view of a form, report, or data access page, an arrangement of vertical and horizontal dotted and solid lines that help you position controls precisely.


index <definition>
index

A feature that speeds up searching and sorting in a table based on key values and can enforce uniqueness on the rows in a table. The primary key of a table is automatically indexed. Some fields can't be indexed because of their data type.


Indexes window <definition>
Indexes window

In a Microsoft Access database, a window in which either you can view or edit a table's indexes or you can create multiple-field indexes.


input mask <definition>
input mask

In a Microsoft Access database, a format you specify to assist data entry in a control or field. An input mask consists of literal display characters (such as parentheses, periods, and hyphens) and mask characters that specify where data is to be entered, what kind of data is allowed, and how many characters are allowed. The literal display characters in an input mask can optionally be stored as data.


null field <definition>
null field

A field containing a Null value. A null field isn't the same as a field that contains a zero-length string (" ") or a field with a value of 0.


record selector <definition>
record selector

A small box or bar to the left of a record that you can click to select the entire record in Datasheet view and Form view.

To show the status of the current record in a form or datasheet, Microsoft Access displays one of the following symbols in the current record selector.

Symbol	Meaning
	Current record: This is the current record; the record has been saved as it appears.
	Pencil: You are editing this record; changes to the record aren't yet saved.
	Locked record: This record is locked by another user; you can't edit it (Microsoft Access database only).
	New record: This is a new record that you can enter information in.
	Primary key: This field is the primary key field and contains unique data to identify the record (table Design view only).
Note   To see record selectors in Form view, set the RecordSelectors property for the form to Yes.


refresh <definition>
refresh

In a Microsoft Access database, to redisplay the records in a form or datasheet to reflect changes and indicate deletions that other users have made (in a multiuser environment) or that you have made elsewhere.

In a Microsoft Access project, to rerun a query underlying the active form or datasheet in order to reflect changes to the records, display newly added records, and eliminate deleted records.


Design view - tables <definition>
table Design view

A window in which you design tables, as shown below for a Microsoft Access database.

To open a table in Design view, go to the Database window, click Tables  [image]  under Objects, click the table you want to open, and then click Design on the Database window toolbar.

If the table is already open, you can switch to Design view by clicking View  [image]  on the toolbar.


table properties <definition>
table properties

In a Microsoft Access database, attributes of a table that affect the appearance or behavior of the table as a whole. Table properties are set in table Design view, as are field properties.


Table window <definition>
Table window

In a Microsoft Access database, a window in which you work with tables in Design view or Datasheet view.


update <definition>
update

To accept changes to data in a record. The changes are saved in the database when you move to another record on a form, datasheet, or data access page, or when you explicitly save the record.


Zoom box <definition>
Zoom box

A box for entering expressions or text. The Zoom box is available in property sheets and in grid cells in table Design view (Microsoft Access database only), the Advanced Filter/Sort window (Microsoft Access database only), the Macro window, and Datasheet view.


property <definition>
property

A named attribute of a control, field, or object that you set to define one of the object's characteristics (such as size, color, or screen location) or an aspect of its behavior (such as whether the object is hidden).


aggregate function

A function that generates a single value, such as a total, from a group of values. Aggregate functions include Avg, Count, Max, Min, and Sum.


aggregate query

A query (SQL statement) that summarizes information from multiple rows by including an aggregate function such as Sum or Avg. For example, you can create a query that averages the contents of a Price column. You can also use aggregate queries to display subtotal information by creating groups of rows that have data in common. An example would be a query that displays the average book price for each publisher.


alias

Visual Basic for Applications: An alternate name that you give to an external procedure to avoid conflict with a Visual Basic keyword, public variable, constant, or a name not allowed by the Visual Basic naming conventions.

SQL: An alternative name for a table or field in expressions. Aliases are often used to shorten the table or field name for subsequent references in code, to prevent possible ambiguous references, or to provide a more descriptive name in query output.


asynchronous

Of an action that executes separately from other events or actions. Asynchronous actions are performed in such a way that other actions can be performed simultaneously. For example, queries are executed asynchronously. Because individual results are returned as they are found, you can view results or perform other actions while the query continues to search for additional results.


back end

The server or engine in a database system. In general, back end refers to the system that is the repository for the data, in contrast to the client, or front end, which presents data to the user. In a client/server system, the back end is the server. As a rule, the back end contains the code that handles not only data storage, but indexes, validation, triggers, referential integrity, and other database functions.


BCP (Bulk Copy Program)

A command-line utility that copies Microsoft SQL Server data to or from an operating-system file in a user-specified format.


BLOB (Binary Large Object)

A type of data column containing binary data such as graphics, sound, or compiled code.


candidate key

A unique identifier for a row within a database table. A candidate (or surrogate) key can be made up of one or more columns. Every table must have at least one candidate key. If a table has only one candidate key, it automatically becomes the primary key for the table. If a table has more than one candidate key, one of them must be designated as the primary key. Any candidate key that is not the primary key is called an alternate key.


check constraint

Specifies data values that are acceptable in a column. You can apply check constraints to multiple columns and you can apply multiple check constraints to a single column. When a table is deleted, all check constraints are also deleted.


client

The portion of a database system or application that presents data to the user. As a rule, the client (or front end) does not perform any database functions; instead, the client sends requests for data to a server, and then formats and displays the results.


client/server

A type of application that has a local interface but accesses data on a local or remote server. The application distributes the work between the client and the server, depending on the strengths of the client and server products. Client/server systems are often efficient because they minimize network traffic, and because each portion of the application can be optimized for its particular function.


code page

A character set that a computer uses to interpret and display data properly. Code pages usually correspond to different platforms and languages and are used in international applications.


column

A location within a database table that stores a particular type of data (for example, the FirstName column in the Employees table of the Northwind sample Microsoft Access database or Northwind sample Microsoft Access project). It is also the visual representation of a field in a datasheet, and in a Microsoft Access database, the query design grid or the filter design grid. In a datasheet, a column is a vertical stack showing the value of a field in every record. In the query and filter design grids in an Access database, a column is a vertical stack of information, such as the field name and the sort order, about each of the fields included in the query or filter. Individual columns have their own specifications as to data type and maximum length. These are called column (or field) properties.


constraint

Restriction placed upon the value that can be entered into a column or a row. For example, values in the Age column cannot be less than zero (0) or greater than 110.


database diagram

A graphical representation of any portion of a database schema. A database diagram can be either a whole or partial picture of the structure of a database; it includes objects for tables, the columns they contain, and the relationships between the tables.


database object
database objects

In a Microsoft Access database, the types of database objects available are tables, queries, forms, reports, macros, and modules.

For a Microsoft Access project connected to a SQL Server database, the database objects are tables (including indexes, triggers, keys, constraints, defaults, rules, and user-defined data types), views, stored procedures, and database diagrams. The Access project objects are forms, reports, macros, and modules.

From both Access databases and Access projects, you can also create data access page objects, which are stored as separate files outside the Access database or Access project file.


data-definition query

An SQL-specific query that contains Data Definition Language (DDL) statements. These statements allow you to create or alter objects in the database.


DBCS (Double-Byte Character Set)

A character set that uses one or two bytes to represent a character, allowing more than 256 characters to be represented. DBCS character sets are typically used for languages that use ideographic writing systems, such as Japanese, Korean, and Chinese.


default

Database object that enables the database to insert a value into a column if the user does not explicitly enter one.


delete query

A query (SQL statement) that removes rows matching the criteria you specify from one or more tables.


equijoin

A join in which rows from two tables are combined and added to the result set when there are equal values in the joined columns. By default, the inner and outer join types in the Query Designer are equijoins.


escape character

A character used to indicate that another character in an expression is meant literally and not as an operator. For example, in SQL the percent sign (%) is used as a wildcard character to search for any number of characters. However, if you want to search for a string such as 10% (10 percent), you cannot specify "10%" alone as a search string, because the search results will include all instances of 10 followed by any number of characters. By specifying an escape character, you can flag instances where you literally mean the percent sign. In this example, you use the number sign (#) as an escape character in the search string "10#%" to find only the instances of 10%.


expression

Any combination of operators, constants, literal values, functions, and names of fields (columns), controls, and properties that evaluates to a single value. You can use expressions as settings for many properties and action arguments; to define calculated controls in forms, reports, and data access pages; to set criteria (search conditions) or define calculated fields in queries; and to set conditions in macros. In a Microsoft Access project, you can use expressions to define check constraints.

You also use expressions in Microsoft Visual Basic.


field

An element of a table that contains a specific item of information, such as last name. A field is represented by a column or cell in a datasheet. On a form, report, or data access page, you can use a control, such as a text box, to display data from a field. In some databases, such as Microsoft SQL Server, "column" is used instead of "field."


fill factor

An option that specifies how full the database should make each index page. The amount of empty space on an index page is important because when an index page fills up, the system must take time to split it to make room for new rows. Use a fill factor of zero (0) to accept the database default.


filter

A set of criteria applied to data in order to show a subset of the data or to sort the data. In Microsoft Access, you can use a variety of ways to filter records, such as Filter By Selection and Filter By Form.


foreign key

One or more table fields (columns) that refer to the primary key field or fields in another table. A foreign key indicates how the tables are related — the data in the foreign key and primary key fields must match, though the field names do not have to be the same. For example, a Products table might contain the foreign key SupplierNumber, which relates to the primary key SupplierID in a Suppliers table.

A foreign key can be Null; if a foreign key consists of more than one field and any of those fields is Null, all the fields must be Null.


full outer join

A type of outer join in which all rows in all joined tables are included, whether they are matched or not. For example, a full outer join between the Titles and Publishers tables shows all titles and all publishers, even those that have no match. In contrast, a left outer join includes all the rows from the table on the left side of the LEFT JOIN operation — a right outer join includes all the rows from the table on the right side of the RIGHT JOIN operation — in the query's SQL statement, and only the matching rows from the other table.


global default

A default that is defined for a specific database and is shared by columns in different tables.


index

A feature that speeds up searching and sorting in a table based on key values and can enforce uniqueness on the rows in a table. The primary key of a table is automatically indexed. Some fields can't be indexed because of their data type.


inner join

A join in which records from two tables are combined and added to a query's results only if the values of the joined fields meet a specified condition. For example, when designing a query, the default join between tables is an inner join that selects records from both tables only if the values of the joined fields are equal.


input source

Any table, view, or database diagram used as an information source for a query.


Insert query

A query (SQL statement) that copies specific columns and rows from one table to another or to the same table.


Insert Values query

A query (SQL statement) that creates a new row and inserts values into specified columns.


join

An association between a field in one table or query and a field of the same data type in another table or query. A join tells Microsoft Access how data is related.

When you add tables to a query, and those tables already have a defined relationship, Access automatically creates an inner join that selects records from both tables when the values in the joined fields are equal. Even if relationships weren't previously defined, Access automatically creates an inner join between fields that have the same names and data types if one of the fields is a primary key. You can also create joins manually. Access allows you to create inner joins, outer joins, and self-joins.


join condition

A comparison clause that specifies how tables are related by their join fields. The most common join condition is equivalence (an equijoin), in which the values of the join fields must be the same. For example, Access can join the Titles and Publishers tables by finding values that match in their respective Pub_ID columns. You can use any comparison operator as part of a join condition.


join operator

A comparison operator in a join condition; the join operator determines how the two sides of the condition are evaluated and which records are returned. The most common comparison is equivalence, which uses the equal sign (=).


junction table

A table that has associations with two other tables and is used indirectly as an association between those two tables. Also called linking table. Use a junction table to create a many-to-many relationship between two tables when one record in either table can relate to many records in the other table.


key

A column used to identify a record, often used as the index column for a table.


left outer join

An outer join in which all the records from the left side of the LEFT JOIN operation in the query's SQL statement are added to the query's results, even if there are no matching values in the joined field from the table on the right. Records from the table on the right are combined with those from the table on the left only when there are matching values in the joined fields.

A left outer join is indicated by a join line arrow (Microsoft Access database) or key symbol (Microsoft Access project) pointing from left to right.


linking table

A table that has associations with two other tables and is used indirectly as an association between those two tables. Also called junction table. This is not the same as a linked table in a Microsoft Access database; a linked table is stored in a file outside the open database, from which Microsoft Access can access records.


locale

The set of information that corresponds to a specific language and country. A locale indicates specific settings such as decimal separators, date and time formats, and character sorting order.


make table query
make-table query

A query (SQL statement) that creates a new table and then creates records (rows) in it by copying records from an existing table.


many-to-many relationship

An association between two tables in which one record in either table can relate to many records in the other table. To establish a many-to-many relationship, you need to create a third (junction) table and add the primary key fields from each of the other two tables to this table. For example, if you have a Products table and an Orders table, an order can include more than one product, and a product can be included in more than one order. You must create a junction table that has a one-to-many relationship with the Products table and a one-to-many relationship with the Orders table.


object

Objects seen in a Microsoft Access database:

•	tables, queries, forms, reports, macros, and modules

•	objects that are defined by the system, such as the MSysObjects table

Objects seen in a Microsoft Access project:

•	objects stored in the Access project file: forms, reports, macros, and modules

•	objects stored in the Microsoft SQL Server database: tables, table properties (such as indexes, triggers, keys, constraints, defaults, rules, and user-defined data types), views, stored procedures, and database diagrams

•	objects defined by the system, such as the sysindexes table

Objects seen in both Access databases and Access projects:

•	data access pages, which are shortcuts (displayed in the Database window) to corresponding HTML files stored in the file system

•	information from another application, such as a chart (graph) or a drawing


one-to-many relationship

An association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of many records in the related table.

An example is the relationship between a Customers table and an Orders table, in which each customer can have many orders, but each order is related to only one customer.


one-to-one relationship

An association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of one and only one record in the related table.

This type of relationship is unusual. An example is the relationship between an Employees table and a Mailboxes table used to store information about employees' e-mail addresses. The tables have a one-to-one relationship because each employee has only one mailbox, and each mailbox is assigned to only one employee.


outer join

A join in which each matching record from two tables is combined into one record in the query's results. When a record from the table that's contributing all of its records can't be matched with a record from the other table, the record still appears in the results of the query, view, or stored procedure; however, the cells that had no matching record in the other table are empty. You can create three variations of an outer join to specify the unmatched rows to be included: left outer joins and right outer joins are in Microsoft Access databases and Microsoft Access projects; full outer joins are only in Access projects.


parameter

A value given to a variable. In a stored procedure, a parameter acts as a placeholder that can be filled in when the stored procedure is run. Parameters allow you to use the same stored procedure many times, each time with different values.

For example, you can create a stored procedure with a parameter for a last name, and then, when you run the stored procedure, have it prompt you for the last name to find. Parameters can be used for any literal value, and, in some databases, for column references as well.


primary key

One or more fields (columns) whose value or values uniquely identify each record in a table. A primary key cannot allow Null values and must always have a unique index. A primary key is used to relate a table to foreign keys in other tables.


property

A named attribute of a control, field, or object that you set to define one of the object's characteristics (such as size, color, or screen location) or an aspect of its behavior (such as whether it is hidden).


property pages

Properties in a tabbed dialog box; with these properties, you can set the characteristics of tables, relationships, indexes, constraints, and keys. Each object in a database diagram has a set of properties that determine the definition of that database object. The tabs in the property pages show only the properties specific to the selected object. If multiple objects are selected, the property pages show the properties of the first object you selected. For forms, reports, and data access pages, you set properties in a property sheet. The Microsoft Office Web Component controls on a data access page have their own property toolbox.


query

A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form, report, or data access page.

In a Microsoft Access database (.mdb), you can create a query, which is stored as a separate object and listed in the Database window. Or you can create a query as an SQL statement in the RecordSource property of a form, report, or a section of a data access page. An SQL statement is not listed in the Database window; it's stored in a form or report in an Access database, or in a data access page outside the Access database.

In a Microsoft Access project (.adp), you can create a query as a view or stored procedure, which is listed as a separate object in the Database window. Or you can create a query as an SQL statement in the RecordSource property of a form, report, or a section of a data access page. Views and stored procedures are stored in the Microsoft SQL Server database, not in the Access project. SQL statements are stored in a form or report in the Access project, or in a data access page outside the Access project.


record

A collection of data about a person, a place, an event, or some other item. A record is represented as a row in Datasheet view of a table, query, or form.


referential integrity

Rules that you follow to preserve the defined relationships between tables when you enter or delete records. If you enforce referential integrity, Microsoft Access prevents you from adding records to a related table when there is no associated record in the primary table, changing values in the primary table that would result in orphan records in a related table, and deleting records from the primary table when there are matching related records in a related table.


reflexive relationship

A relationship between a column or combination of columns in a table and other columns in that same table. Reflexive relationships are used to compare rows within the same table. For example, you can create a reflexive relationship to find all publishers that are in the same city and have the same postal code. In queries, this is called a self-join.


relationship

An association established between common fields (columns) in two tables. A relationship can be one-to-one, one-to-many, or many-to-many.


result set

The set of records that results from running a query or applying a filter. In some cases, you can update the data in the underlying table or tables when you make changes to a result set.


right outer join

An outer join in which all the records from the right side of the RIGHT JOIN operation in the query's SQL statement are added to the query's results, even if there are no matching values in the joined field from the table on the left. Records from the table on the left are combined with those from the table on the right only when there are matching values in the joined fields.

A right outer join is indicated by a join line arrow (Microsoft Access database) or key symbol (Microsoft Access project) pointing from right to left.


row

In a table, a set of related columns of information that are treated as a unit and that describe a specific entity. A row is the logical equivalent of a record.


rule

A database object that is bound to a column or to a user-defined data type and that specifies what data can be entered in that column.


schema

A description of a database to the database management system (DBMS) generated by using the data definition language provided by the DBMS. A schema defines attributes of the database, such as tables, columns,  and properties.


search condition

A comparison clause used in a query to specify the rows to return or update. For example, you can use a search condition to specify that a query display only the authors who live in London. This is sometimes referred to as criteria.


select query

A query that asks a question about the data stored in your tables and returns a result set in the form of a datasheet — without changing the data. A select query can contain specifications for the fields (columns) to return, the records (rows) to select, the order to put the records in, and the way to group (summarize) information. After the result set is displayed, you can view and, in some cases, make changes to the data in the underlying tables.

In contrast to select queries, action queries such as delete queries do make changes to your data.


self-join

A join in which records from a table are combined with other records from the same table when there are matching values in the joined fields. For example, if you have an Employees table, you can create a self-join between the EmployeeID field in one instance of the Employees table and the ReportsTo field in another instance of the Employees table. You can then use this join to retrieve information about each employee's supervisorA self-join can be an inner join or an outer join. A self-join is also known as a reflexive relationship.


server

On a network, a computer that controls access to data.


SQL

Structured Query Language, a database query and programming language.


stored procedure

A precompiled collection of SQL statements and optional control-of-flow statements stored under a name and processed as a unit. Stored procedures are stored in an SQL database such as Microsoft SQL Server, usually on a server; can be run with one call from an application; and allow user-declared variables, conditional execution, and other powerful programming features.


subquery

An SQL SELECT statement inside another select or action query. You can use a subquery as an expression in the field (column) cell in the design grid for a query or to define criteria (search conditions) for a field (column). The result set of the embedded SELECT statement becomes part of the search condition for the main query. For example, the following query uses a subquery to find all suppliers in Sweden and then uses the results in a WHERE clause to find all products with the selected suppliers:

WHERE supplier_id IN
(SELECT supplier_id
FROM supplier
WHERE (country = 'Sweden'))


subset

A selection of tables — and the relationships between them — that is part of a larger database diagram. This selection can be copied to a new database diagram. This is called subsetting the diagram.


surrogate key

A unique identifier for a row within a database table. A surrogate (or candidate) key can be made up of one or more columns. Every table must have at least one surrogate key. If a table has only one surrogate key, it automatically becomes the primary key for the table. If a table has more than one surrogate key, one of them must be designated as the primary key. Any surrogate key that is not the primary key is called an alternate key.


table

The fundamental structure of a relational database management system. In Microsoft Access, a table is an object that stores data in records (rows) and fields (columns). The data is usually about a particular category of things, such as employees or orders.


transaction log

A storage area reserved by the database to keep track of transactions made to the database.


trigger

A special form of a stored procedure that is carried out automatically when data in a specified table is modified. Triggers are often created to enforce referential integrity or consistency among logically related data in different tables.


unenforced relationship

An association between tables that joins the primary key in one table to a foreign key in another table, and that doesn't check referential integrity during INSERT and UPDATE transactions. In a Microsoft Access project, an unenforced relationship is represented in a database diagram by a dashed line.


union query

A query that combines corresponding fields from two or more tables or queries into one field. It's the equivalent of appending one table to another.

For example, a union query of the Customers table and the Suppliers table returns a result set that contains all the specified records from both the Customers table and the Suppliers table. The result set isn't updatable.


unique constraint

A constraint that enforces entity integrity on a non-primary key. It ensures no duplicate values are entered in the columns on which the constraint is placed. NULL values are allowed as long as rows are unique in the table.


universal naming convention (UNC)

A naming convention for files that provides a machine-independent means of locating the file. A UNC name will usually include a reference to a shared folder and file accessible over a network rather than a folder and file specified by a drive letter and path. For example, the UNC name for a database named Northwind.mdb on a shared directory named Samples on a computer called MyWorkstation would be \\MyWorkstation\Samples\Northwind.mdb.

The UNC is particularly useful in Web-based applications because it allows you to reference data that is not necessarily stored on a particular Web server.


update query

An action query (SQL statement) that changes a set of records according to criteria (search conditions) you specify.


user-defined data type

A definition of the type of data a column can contain. It is created by the user and defined in terms of existing system data types. Rules and defaults can be bound to user-defined data types but not to system data types.


view
view (object)

A virtual table generated by a query whose definition is stored in the database. For example, a view might be defined as containing three out of five available columns in a table, in order to limit access to certain information. Views can be treated as tables for most database operations, including select queries. Any operations performed on views affect the data in the table or tables on which the view is based.


wildcard character

A character that represents one or more other characters. For example, in SQL you can use the percent sign (%) as a wildcard character to search for any number of characters, and can use it to search for parts of a word. In the following example, the search string will return all words of any length that begin with the letters Mac:

LIKE 'Mac%'


Formatting toolbar (form, report, data access page Design view)

A toolbar that is displayed beneath the Form, Report, or Page Design toolbars. It includes buttons to change characteristics of controls, including fonts, font sizes, font styles (bold, italic, and underlined), alignment, colors, borders, and special effects. By default, the Formatting toolbar is docked beneath the Form, Report, or Page Design toolbars, but you can drag it to create a floating toolbar.


navigation buttons <definition>
navigation buttons

The buttons in the lower-left corner of the Datasheet view and Form view windows. You click the buttons to move through the records as follows:

The navigation buttons are also available during previewing so that you can move through the pages of your document.


record number box <definition>
record number box

A small box that displays the current record number in the lower-left corner in Datasheet view and Form view. To move to a specific record, you can type the record number in the box, and press ENTER.


toolbar <definition>
toolbar

A bar that contains a set of buttons, menus, or other controls that you can click to carry out common menu commands.

Note   In Microsoft Access 97 and later versions, toolbars and menus have been combined into a single entity, called "toolbars" in the user interface and "command bars" in Visual Basic for Applications. Toolbars can be one of the following types: menu bar, toolbar, or pop-up menu (shortcut menus, drop-down menus, or submenus).


Code window

A window in the Visual Basic Editor in which you write, display, and edit Visual Basic code. You can open as many Code windows as you have modules.


Immediate window

A window in the Visual Basic Editor in which you can run individual lines of Visual Basic code, usually for the purpose of debugging. The Immediate window is a kind of scratch pad in which expressions are evaluated immediately.


JRO (Jet and Replication Objects)
Jet and Replication Objects (JRO)

A set of automation interfaces that allow you to perform actions specific to Microsoft Jet databases. Using Jet and Replication Objects, you can compact databases, refresh data from the cache, and create and maintain replicated databases.


Locals window

A window in the Visual Basic Editor which automatically displays all of the declared variables, and their values, in the current procedure. When the Locals window is visible, it is automatically updated every time you change from Run mode to Break mode, and every time you view a different procedure or function by using the Call Stack.


Microsoft Script Editor

Used to add text, edit HTML tags, and edit any Microsoft Visual Basic Scripting Edition (VBScript) code in a data access page. You can also view your data access page in the Script Editor as it would appear in a Web browser.


Visual Basic Editor

An environment in which you write new and edit existing Visual Basic for Applications code and procedures. The Visual Basic Editor contains a complete debugging toolset for finding syntax, run-time, and logic problems in your code.


Microsoft Visual Basic

The high-level, visual programming version of the Basic language developed by Microsoft for building Windows-based applications. You can add Visual Basic commands to forms, reports, and the controls that are placed on them, to perform specialized tasks.


Microsoft Visual Basic Scripting Edition (VBScript)

A subset of the Visual Basic for Applications programming language optimized for Web-related programming. You can use VBScript in data access pages and other HTML documents.


Watch window

A window in the Visual Basic Editor used for debugging Visual Basic procedures. You can specify the variables from the procedure you want to inspect, and the Watch window displays the value of the variable as the procedure runs.


alias <definition>
alias

Visual Basic for Applications: An alternate name that you give to an external procedure to avoid conflict with a Visual Basic keyword, public variable, constant, or a name not allowed by the Visual Basic naming conventions.

SQL: An alternative name for a table or field in expressions. Aliases are often used to shorten the table or field name for subsequent references in code, to prevent possible ambiguous references, or to provide a more descriptive name in query output.


Building Applications with Forms and Reports

Building Applications with Forms and Reports contains additional information about how to create an application in Microsoft Access, how to use ActiveX controls, and how to implement security in your Access applications. Building Applications with Forms and Reports also provides an introduction to Visual Basic, including working with variables, objects, and collections. Finally, you learn how to deliver the applications you build to users. Building Applications with Forms and Reports is available on the Microsoft web site at http://www.microsoft.com.


menu bar macro <definition>
menu bar macro

A macro containing AddMenu actions that you can use to create:

•	A custom menu bar for a form or report.

•	A custom shortcut menu for a form, report, or a control on a form or report.

•	A global menu bar.

•	A global shortcut menu.


Insert Procedure button (Visual Basic toolbar)
Procedure (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.


Object Browser button (Visual Basic toolbar)
Object Browser (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 the syntax of a selected method or property.


Continue button (Visual Basic toolbar)
Continue (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). Also, runs a selected procedure that has no arguments.


End Button End command (Run menu)
End (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 that you have changed before rerunning the procedures.


Reset command (Run menu)
Reset (Run menu)

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


Break Point button (Visual Basic toolbar)
Toggle Breakpoint (Debug menu)

Switches between setting and removing a breakpoint. Microsoft Access suspends code execution and enters break mode when it reaches a line of code that contains a breakpoint. Setting a breakpoint bolds and highlights the line.


Instant Watch button (Visual Basic toolbar)
Quick Watch (Debug menu)

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


Calls command (View menu)
Call Stack (View 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 and command only when the Code window is open and code execution is suspended.


Step Into command (Run menu)
Step Into (Debug menu)

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


Step Over button (Visual Basic toolbar)
Step Over (Debug menu)

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


Indent button (Visual Basic toolbar)
Indent (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 (Editor tab).


Outdent button (Visual Basic toolbar)
Outdent (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 Editor tab.


Procedure Definition command (View menu)
Definition (View menu)

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


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

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


Step Out (Debug menu)

Runs all lines of code and nested procedures in Break mode — beginning with the current executable statement — and then returns execution to the next executable statement in the preceding procedure of the call tree. Use to avoid stepping through each line of code in called procedures.


Hypertext Transfer Protocol (HTTP)

The behind-the-scenes Internet protocol that delivers information by way of the World Wide Web. The protocol makes it possible for a user to use a client program to enter a URL (or click a hyperlink) and view text, graphics, sound, and other digital information on a Web server.

URLs of files on Web servers begin with http://


Hypertext Transfer Protocol (HTTP)

The behind-the-scenes Internet protocol that delivers information by way of the World Wide Web. The protocol makes it possible for a user to use a client program to enter a URL (or click a hyperlink) and view text, graphics, sound, and other digital information on a Web server.

URLs of files on Web servers begin with http://


Joint Photographic Experts Group (JPEG)

A graphics file format supported by many World Wide Web browsers. JPEG was developed for compressing and storing photographic images, and is best used for graphics containing many colors, such as scanned photos. JPEG files, which have a .jpg extension in Windows, are compressed bitmaps.


Joint Photographic Experts Group (JPEG)

A graphics file format supported by many World Wide Web browsers. JPEG was developed for compressing and storing photographic images and is best used for graphics containing many colors, such as scanned photos. JPEG files, which have a .jpg extension in Windows, are compressed bitmaps.


Graphics Interchange Format (GIF)

A graphics file format that many World Wide Web browsers can display as inline graphics. GIF was developed specifically for transmitting images. It is best used for graphics with few colors, such as cartoons or line drawings. GIF files, which have a .gif extension in Windows, are compressed bitmaps.


Graphics Interchange Format (GIF)

A graphics file format that many World Wide Web browsers can display as inline graphics. GIF was developed specifically for transmitting images. It is best used for graphics with few colors, such as cartoons or line drawings. GIF files, which have a .gif extension in Windows, are compressed bitmaps.


DHTML
Dynamic HTML (DHTML)

A technology that extends Hypertext Markup Language (HTML) by adding an object model. Scripts and programs can use the object model to change styles and attributes of page elements (objects) and to replace existing elements (objects) with new ones. Dynamic HTML also extends HTML by adding multimedia and database access features.


publish <definition>
publish

The process of exporting datasheets, forms, or reports to static HTML or server-generated HTML, or creating data access pages, and then setting up these files and all related files as a World Wide Web application on a Web server such as Microsoft Internet Information Server or Microsoft Personal Web Server.


Promote button

Groups records on one field from a table or query. Use when you want to group records on a field that contains values shared by many records.


Group By Table button

Groups records on a table or a query. Use to group records when the data access page contains fields from two tables or queries that have a one-to-many relationship, and you want to group on the table or query on the "one" side of the relationship. When you use Group By Table to group records, Microsoft Access groups and sorts records using the table's primary key.


Demote button

Moves the controls in the selected group header and footer into the header and footer of the next lower group level.


Group Record Source

Specifies the expression or the name of the table, query, or recordset for the selected group level. Set by using the Promote, Group By Table, or Demote button on the toolbar.


CaptionSection property

Click Yes to add a caption section above the group header. This section is displayed only when the next-higher group level is expanded. You can't add bound controls to a caption section. Click No to delete a caption section and any controls it contains.


GroupHeader property

Adds a group header for a selected field or expression in a data access page so that you can label or summarize data in a group of records. You can click No in the GroupHeader property to delete the group header and any controls it contains.


GroupFooter property

Click Yes to add a group footer above the record navigation section for the selected group record source. You can add controls that calculate group totals in the group footer. You can't add a group footer to the lowest group level on a data access page. Click No to delete the group footer and any controls it contains.


RecordNavigationSection property

Use to display the record navigation control for the group level. A record navigation section for a group appears after the group header section if there is no footer for the group level, or after the footer if there is a footer for the group level. You can't place bound controls in a record navigation section.


ExpandedByDefault property

Click Yes to open the data access page with the records in the next lower group level displayed. Click No to open the page with the records in the next lower group level hidden. The page will load faster in Page view and in Microsoft Internet Explorer if the ExpandedByDefault property is set to No for the highest group level on the page.


DataPageSize property

Specifies how many records you want to display at a time on the data access page for each group level. If a group level doesn't have a record navigation section or a record navigation control, you must set DataPageSize to All in order to see all the records for that group level. To use a page for data entry, you can have only one group level, and you must set the DataPageSize property to 1 for that group level.


GroupOn property

Specifies how to group data in a field or expression by data type. For example, you can group a Date field by month. The property settings available depend on its data type. The default setting for all data types is Each Value.


GroupInterval property

Specifies an interval value to group records by. This interval differs depending on the data type and GroupOn property setting of the field or expression you're grouping on. For example, you can set the GroupInterval property to 1 if you want to group records by the first character of a Text field, such as ProductName.


Sorting And Grouping (View menu)

Displays the Sorting And Grouping dialog box, which shows all the sorting and grouping properties for the group levels on a data access page.


DefaultSort property

Type the name of the field or fields you want to sort on, separated by a comma. You can specify the sort order by following each name with a space and the keyword ASC or DESC. If you don't specify the sort order, Microsoft Access sorts in ascending order. If the control you want to sort on is bound to an expression, you must type the alias of the control as displayed in its ControlSource property.


GroupFilterControl property

Type the name of the list box or drop-down list box that will filter the records in this grouping level.


GroupFilterField property

Type the name of the field that contains the values you want to filter for. The field must be in the selected group record source.


Sorting and Grouping window (View, Sorting and Grouping)
Sorting And Grouping dialog box

Use to view and edit sorting and grouping fields, expressions, and properties for the current report or data access page.


Locates a folder on your computer or on the network that contains an HTML template file.


Enter the location of an HTML template file that includes HTML tags and tokens unique to Microsoft Access. These tokens indicate where to insert output and other information in either the static or server-generated HTML files. If you do not specify an HTML template file containing navigation tokens when you export a report, Microsoft Access provides a default navigation scheme.


Open Favorites

Displays the Favorites folder in the Look in box. The Favorites folder contains shortcuts to files, folders, and hyperlinks that you use often.


Open (Web toolbar)

Opens the Web page in your default Web browser.


Locates a replica on your computer or on the network.


Customize

Customizes toolbar buttons, menu commands, and shortcut key assignments.


COM Add-Ins

Inserts COM (Component Object Model) add-ins, which extends Access features by adding custom functions.


Select to track conflicts in a replica set based on an entire record. For example, suppose that a change is made to the name field in a record in a replica, and the address field in the same record is changed for another replica; when the replicas synchronize, one of the changes is lost because synchronization is based on a change being made to the entire record. A conflict occurs when the two replicas synchronize, even though the two changes were made to different fields.

Clear this check box to track conflicts at the column level. Changes to the same record in two different replicas cause a synchronization conflict only if the same column or field is changed.


Append To

Use to indicate the field you want to append to. Microsoft Access fills in matching field names by default. To enter or change field names, click the cell, and then select a field name.


Show Table list box (Relationships window, Relationships, Show Table)
Select a table or query in the list box, and then click Add. Click the Tables or Queries tabs to limit the list; or the Both tab to see a combined list.


Logon Password (Logon dialog box)
Type the logon password for the user displayed in the Username box above.


Current Type (Edit, Object, Convert)
Displays the type of object currently selected.


Activate As (Edit, Object, Convert)
Starts the current object's application as the object type selected in the Object Type box. Use to view the object with an alternative application server.


Convert To (Edit, Object, Convert)
Permanently converts the current object to the object type selected in the Object Type box. Use, for example, to convert to a later version of an object, such as converting from Microsoft Graph 97 to Graph 2000.


Object Type (Edit, Object, Convert)
Select the object type you want the current object converted to or activated as. The Current object type is displayed above in the Current Type label and the results of your selection is displayed below in the Result box.


Save Password (File, Get External Data, Link Tables, Files of type, ODBC Databases)
Select to save the password in the current database and not require users to enter it. Clear to require users to enter a password every time they open the table in each new session with Microsoft Access.


Tables List (File, Get External Data, Link Tables, Files of type, ODBC Databases)
Select one or more objects. If you are importing, you must click each object tab to display each object type. Use the buttons to the right to conveniently select all objects currently listed or cancel your current selection.


Select All (File, Get External Data, Link Tables, Files of type, ODBC Databases)
Selects all the objects currently listed.


Deselect All (File, Get External Data, Link Tables, Files of type, ODBC Databases)
Cancels the selection of objects currently listed so you can change your selections.


Type (View, Properties, Object Properties dialog box)
Displays the type of object currently selected (Table, Query, Form, Report, Page, Macro, or Module).


Description (View, Properties, Object Properties dialog box)
Displays the selected object's description listed in the Details view of the Database window. Use also to enter or modify the object's description.


Created (View, Properties, Object Properties dialog box)
Displays the date the selected object was created.


Modified (View, Properties, Object Properties dialog box)
Displays the date the selected object was last modified.


Owner (View, Properties, Object Properties dialog box)
Displays the owner of the object (the user who created it). In a Microsoft Access database, Microsoft Access uses this property to determine the object's user-level security permissions.


Hidden (View, Properties, Object Properties dialog box)
Select Hidden to remove the selected object from view in the Database window. Clear to display the selected, hidden object (which has a dimmed icon). For more information, refer to Microsoft Access Help.


Replicated (View, Properties, Object Properties dialog box)
In a regular or nonreplicated Microsoft Access database, this check box is cleared and shaded, indicating that the selected table or query is local and that you cannot modify this property.

In a database Design Master, this check box is selected if the selected table or query is replicated. Clear this check box to make the table or query local to the Design Master, and remove the selected object from all the replicas in the replica set. In either case, you still must synchronize your databases to remove the table or query from the replicas.

In a database replica, this check box is selected and shaded, indicating that the selected table or query is replicated and that you cannot modify this property.


Apply Default

Applies the default control style to the selected control(s). The default control style represents the properties a control has by default when you create it.


Convert OLE (Tools, Database Utilities, Convert)
Converts all static OLE objects in unbound object frames to image controls. Use when you don't need to edit the object and you want to improve performance.


Export <object> to (File, Save As/Export, Save As dialog box, To an External file or database, Choose a database, Export dialog box)
Enter a name for the object you want to create in the external database.


in <database name> (File, Save As/Export, Save As dialog Box, To an External file or database, Choose a database, Export dialog box)
Displays the name of the external database you are exporting the object to.


Export Tables Definition and Data (File, Save As/Export, Save As dialog Box, To an External file or database, Choose a database, Export dialog box)
Select to export both the table data and the table design information.


Export Tables Definition only (File, Save As/Export, Save As dialog Box, To an External file or database, Choose a database, Export dialog box)
Select to export just the table data, but not the table design information.


Logon Password (Logon dialog box)
Enter the user name you want to log on as.


Database objects (Select Location dialog box)
Click the tab for the type of object you want to create a hyperlink for, and then select the object from the list.


Hyperlink (Insert menu)

Inserts or modifies a hyperlink address or Uniform Resource Locator (URL). In datasheet and form view, the hyperlink address field must be selected.


Paste as Hyperlink (Edit menu)

Pastes the current contents of the clipboard (such as a Microsoft Word paragraph or Microsoft Excel spreadsheet) as a hyperlink address and creates a hyperlink jump to the destination.


Hyperlink Open

Jumps to the hyperlink address or Uniform Resource Locator (URL) and replaces the current Web page in your browser if it is already open.


Hyperlink Open in New Window

Jumps to the hyperlink address or Uniform Resource Locator (URL) and starts another instance of your browser if it is already open.


Hyperlink Copy Hyperlink

Copies the hyperlink address or Uniform Resource Locator (URL) to the clipboard. Use to conveniently make copies of the control or to paste the hyperlink address into another application or onto your desktop.


Hyperlink Add to Favorites

Adds the hyperlink address or Uniform Resource Locator (URL) to your Favorites folder (available from Microsoft Office applications and Microsoft Internet Explorer).


Hyperlink Edit Hyperlink

Displays the hyperlink address or Uniform Resource Locator (URL) so that you can modify or delete it.


Underline shortcuts (Tools, Options, View)
Select to underline a hyperlink address or Uniform Resource Locator (URL). Use, for example, to distinguish a hyperlink address from other data.


Already viewed color (Tools, Options, View)
Select a color to indicate that a hyperlink address has already been viewed since you opened the database.


Not Yet Viewed color (Tools, Options, View)
Select a color to indicate that a hyperlink address has not been viewed since you opened the database.


Provide Feedback with sound (Tools, General)
Select to accompany various tasks, such as alert notification and print completion, with sound. This option affects all Office products. You can customize sounds through the Sounds dialog box in the Control Panel. If you install a sound card after installing Office 2000, you must reinstall the .WAV files.


Synchronize with (Tools, Replication, Synchronize now, Synchronize Database <name> diaolog box)
Select from the list or type the path of the replica set member you want to synchronize with. (Only members of the replica set are listed.)


Make <Database Name> the Design Master (Tools, Replication, Synchronize now, Synchronize Database <name> dialog box)
Select to make the specified replica the new Design Master for the replica set (for example, to transfer control of the Design Master to another location). Selecting this option prevents you from making design changes in the current Design Master.


In the background with Synchronizer (Path Unknown, Untitled)
Select In the Background with Synchronizer to have the Synchronizer that manages the open replica set perform the synchronization as resources allow. Then select from the list of Synchronizers the Synchronizer that manages the replica set member with which you want to synchronize.

Note   The Synchronizer that manages the open replica set must be running in order for the synchronization to occur.


In the background with all synchronizers (Path Unknown, Untitled)
Select to synchronize all replicated databases managed by the Synchronizer as resources allow.


Format (Output To dialog box)
Select the format you want the object data to be exported as. The text format (.txt) exports the data in a grid or tabular format.


Output All (Output To dialog box)
Select to export all data regardless of what is currently selected in the object.


Output Selection (Output To dialog box)
Select to export just the selected data in the object. Microsoft Access exports all data if no data is selected in the object.


Tab Control (Toolbox)

Use to create a tabbed form with several pages (such as the employee form in Northwind) or tabbed dialog box (such as the Options dialog box on the Tools menu). You can copy or add other controls onto a tab control. Right-click on the Tab control in the design grid to modify the number of pages, the page order, the selected page's properties, and the selected tab control properties.


Page Order (Page Order dialog box)
Select a page, and then click the buttons on the right to re-sequence the page order.


Move Up (Page Order dialog box)
Moves the selected page up one in the page order sequence displayed to the left.


Move Down (Page Order dialog box)
Moves the selected page down one in the page order sequence displayed to the left.


OK button
Saves changes and closes the dialog box.


Close button
Saves changes and closes the dialog box.


Apply button
Saves changes and keeps the dialog box open. Use to conveniently try out different options and see the results before closing the dialog box.


Cancel button
Ignores changes and closes the dialog box.


Query Type button

Displays the types of queries you can create. Click the button if it displays the desired query type, or click the arrow next to the button, and then click the desired query type.


View button

Displays the available views for the current window. Click the button if it displays the desired view, or click the arrow next to the button, and then click the desired view.


Make MDE File (Tools menu)

Copies an unopened database (.mdb) to an MDE database (.mde). Use to create a compiled, compacted, and memory-efficient database application in which the VBA source code has been removed so users cannot modify it.


Make MDE button (Tools, Database Utilities, Make .MDE File, Database to Save as MDE)
Copies the selected database (.mdb) to an MDE database (.mde). An MDE database is a compiled, compacted, and memory-efficient database application in which users cannot see or modify VBA source code.


Insert Tab Control Page

Inserts a new page to the right of the existing pages on the tab control and places it first in the page order sequence.


Delete Page

Deletes the active page in the tab control and all controls on that page. Deleting the only page on a tab control also deletes the tab control.


Page Order

Resequences the order of pages in the tab control.


Change To Command Button (Format menu)

Changes the selected control (if it has a HyperlinkAddress or HyperlinkSubaddress property defined) to a command button, and copies any other common properties from the selected control to the command button.


Available Controls (Tools, ActiveX Controls, ActiveX Controls dialog box)
Select an ActiveX control to register or unregister. The current list of ActiveX controls are those that have been installed on your machine, some of which may not work with Microsoft Access.


Auto Update (Paste Link dialog box)
Select to automatically update the OLE object whenever the source file changes.


Link To: (Paste Link dialog box)
Identifies the location of the linked OLE object.


Source Name: (Paste Link dialog box)
Identifies the name of the application server for the OLE object.


Indexes (Select Unique Record Identifier dialog box)
Select one or more indexes to use with the linked table.


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.


Command Line Arguments (Tools, Options, Advanced)
Enter the value you want the Command function to return. This option provides the same functionality as the /Cmd command line option. For more information, refer to Microsoft Access Help.


Synchronize directly with Replica (Path Unknown, Untitled)
Select Directly with Replica to synchronize directly (Changes synchronize immediately) with a replicated database. Then select from the list of replica set members or type the path of the replicated database with which you want to synchronize with.


Not in Dictionary box (Tools, Spelling, Spelling dialog box)
Shows a possible error, such as a misspelled word, a duplicate word, or incorrect capitalization.


Change To box (Tools, Spelling, Spelling dialog box)
Shows a suggested word to replace the word that appears in the Not In Dictionary box. To accept the suggested replacement, click Change. To delete the word in the Not In Dictionary box, delete the text in the Change To box, and then click Delete.


Suggestions box (Tools, Spelling, Spelling dialog box)
Lists suggested replacement words when you click Suggest or if you selected the Always suggest replacements for misspelled words check box on the Spelling tab in the Options dialog box (Tools menu).


Add Words To (Tools, Spelling, Spelling dialog box)
Adds the word in the Not In Dictionary box to the selected custom dictionary.


Ignore `Description' Field box (Tools, Spelling, Spelling dialog box)
Causes the spelling checker to ignore the current datasheet column.


Ignore button (Tools, Spelling, Spelling dialog box)
Leaves the word in the Not In Dictionary box unchanged.


Ignore All button (Tools, Spelling, Spelling dialog box)
Leaves all instances of the word in the Not In Dictionary box unchanged.


Change button (Tools, Spelling, Spelling dialog box)
Replaces the word in the Not In Dictionary box with the word in the Change To box. If the Change To box is empty, the button name changes to Delete. Click Delete to remove the selected word.


Change All button (Tools, Spelling, Spelling dialog box)
Replaces all instances of the word in the Not In Dictionary box with the word in the Change To box. If the Change To box is empty, the button name changes to Delete All. Click Delete All to delete all instances of the word in the Not In Dictionary box from the item.


Add button (Tools, Spelling, Spelling dialog box)
Adds the word in the Not In Dictionary box to the custom dictionary selected in the Add Words To box.


Suggest button (Tools, Spelling, Spelling dialog box)
Lists alternatives for a misspelled word. Click the word you want to use.


Options button (Tools, Spelling, Spelling dialog box)
Specifies rules used to check spelling.


AutoCorrect button (Tools, Spelling, Spelling dialog box)
Adds a word to the AutoCorrect list so you can automatically correct the word as you type.


Undo Last button (Tools, Spelling, Spelling dialog box)
Reverses the last action made while checking spelling. Click the button more than once to undo actions in sequence starting with the most recent action.


Always Suggest (Tools, Spelling, Options button, Spell Options dialog box)
Select to automatically show suggested spellings in the Suggestions box.


From Main Dictionary Only (Tools, Spelling, Options button, Spell Options dialog box)
Select to only search the main dictionary. Clear to search the main dictionary and custom dictionaries.


Ignore Words in UPPERCASE (Tools, Spelling, Options button, Spell Options dialog box)
Select to ignore words in uppercase letters, such as acronyms.


Ignore Words with Numbers (Tools, Spelling, Options button, Spell Options dialog box)
Select to ignore words with numbers, such as part numbers.


Dictionary box (Tools, Spelling, Options button, Spell Options dialog box)
Select the dictionary you want to use as your main dictionary.


Control Location (Tools, ActiveX Controls)
Displays the complete file name of the selected control.


Selected Toolbar (View, Toolbars, Customize, Toolbars tab, Properties button, Toolbar Properties dialog box)
Select the toolbar, menu bar, or custom shortcut menu whose properties you want to define or modify.


Toolbar Properties group (View, Toolbars, Customize, Toolbars tab, Properties button, Toolbar Properties dialog box)
Use to customize the appearance and behavior of the toolbar, menu bar, or custom shortcut menu in the Selected Toolbar list box.


Toolbar Name (View, Toolbars, Customize, Toolbars tab, Properties button, Toolbar Properties dialog box)
Type the new name for the custom toolbar, menu bar, or shortcut menu.

Note   You cannot change the name of a built-in toolbar, menu bar, or shortcut menu.


Type (View, Toolbars, Customize, Toolbars tab, Properties button, Toolbar Properties dialog box)
Select from these three types:

•	Menu Bar presents drop-down menus of commands as text.

•	Toolbar presents commands as buttons.

•	Popup presents common commands as text on shortcut menus and drop-down menus.


Docking (View, Toolbars, Customize, Toolbars tab, Properties button, Toolbar Properties dialog box)
Select the desired docking behavior for the selected toolbar or menu bar: Allow Any allows vertical or horizontal docking, Can't Change prevents changing of the docking behavior, No Vertical disables vertical docking, and No Horizontal disables horizontal docking. For any setting other than Can't Change, make sure you also select the Allow Moving option below.


Show on Toolbars Menu (View, Toolbars, Customize, Toolbars tab, Properties button, Toolbar Properties dialog box)
Select to display the selected toolbar or custom menu bar on the Toolbars submenu (View menu).


Allow Customizing (View, Toolbars, Customize, Toolbars tab, Properties button, Toolbar Properties dialog box)
Select to allow changes to the appearance and behavior of the selected toolbar, menu bar, or custom shortcut menu through the Customize dialog box.


Allow Resizing (View, Toolbars, Customize, Toolbars tab, Properties button, Toolbar Properties dialog box)
Select to allow resizing of the selected toolbar or menu bar. You can only resize floating toolbars or menu bars; you cannot resize a docked toolbar.


Allow Moving (View, Toolbars, Customize, Toolbars tab, Properties button, Toolbar Properties dialog box)
Select to allow moving of the selected toolbar or menu bar between a floating or docked position.


Allow Showing/Hiding (View, Toolbars, Customize, Toolbars tab, Properties button, Toolbar Properties dialog box)
Select to allow the selected toolbar or menu bar to be shown or hidden through the Toolbars submenus (View menu), the Toolbars tab of the Customize dialog box, or the right-click menu on toolbars and menu bars.


Restore Defaults (View, Toolbars, Customize, Toolbars tab, Properties button, Toolbar Properties dialog box)
Restores the default settings of the selected toolbar or menu bar to its original state. Microsoft Access prompts you for verification before restoring the default settings. This option only applies to built-in toolbars and menu bars.


Selected Control (View, Toolbars, Customize, Right-click on a toolbar, Properties command, <Toolbar Name> Control Properties dialog box)
Select the toolbar, menu bar, or custom shortcut menu control whose properties you want to define or change.


Control Properties group (Toolbars, Customize, Right-click on a toolbar, Properties command, <Toolbar Name> Control Properties dialog box)
Use to define or modify the properties of the selected toolbar, menu bar, or custom shortcut menu control in the Selected Control list box.


Caption (View, Toolbars, Customize, Right-click on a toolbar, Properties command, <Toolbar Name> Control Properties dialog box)
Type the name for the selected control. You can type an ampersand (&) character in front of the letter to indicate the corresponding access key, such as Print… ALT+P.


Shortcut Text (View, Toolbars, Customize, Right-click on a toolbar, Properties command, <Toolbar Name> Control Properties dialog box)
Type the text displayed next to the menu command that indicates its shortcut key, such as CTRL+P, which is defined with the AutoKeys macro.


ToolTip (View, Toolbars, Customize, Right-click on a toolbar, Properties command, <Toolbar Name> Control Properties dialog box)
Type the name of the ToolTip to display when you rest the pointer on the selected control. If you leave this option blank, Microsoft Access uses the same text as the Caption property.


On Action (View, Toolbars, Customize, Right-click on a toolbar, Properties command, <Toolbar Name> Control Properties dialog box)
Select the name of a macro or Visual Basic Function procedure that runs when you use the selected control. When you specify a Function procedure,  you must use the syntax, =functionname().


Style (View, Toolbars, Customize, Right-click on a toolbar, Properties command, <Toolbar Name> Control Properties dialog box)
Select the style for the selected control: Default Style displays an image and caption on a menu command, and an image on a button; Text Only (Always) displays only a caption on a menu command and button; Text Only (in Menus) displays only a caption on a menu command and only an image on a button; and Image And Text displays an image and caption on both a menu command and button.


Help File (View, Toolbars, Customize, Right-click on a toolbar, Properties command, <Toolbar Name> Control Properties dialog box)
Type the name of the path and file name of the help file that contains the What's This Tip topic specified by the HelpContextID property. A What's This Tip is context-sensitive pop-up help displayed when you choose the What's This command from the Help menu and click on a menu command or button.


Help ContextID (View, Toolbars, Customize, Right-click on a toolbar, Properties command, <Toolbar Name> Control Properties dialog box)
Type the context ID of the What's This Tip topic contained in the file specified in the Help File property. A What's This Tip is context-sensitive pop-up help displayed when you choose the What's This command from the Help menu and click on a menu command or button.


Parameter (View, Toolbars, Customize, Right-click on a toolbar, Properties command, <Toolbar Name> Control Properties dialog box)
Type a string that your application can use (by reading the toolbar control's properties in a function) when it performs the command specified in the On Action property.


Tag (View, Toolbars, Customize, Right-click on a toolbar, Properties command, <Toolbar Name> Control Properties dialog box)
Type an optional string that can be used later in an event procedure. For more information, refer to Microsoft Access Help.


Begin a Group (View, Toolbars, Customize, Right-click on a toolbar, Properties command, <Toolbar Name> Control Properties dialog box)
Select to indicate the beginning of a group of controls. On a menu bar, a separator bar appears above the selected control. On a toolbar, a separator bar appears to the left of the selected control.


Add-ins Add-in Manager (Tools menu)

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).


Database Utilities Database Splitter (Tools menu)

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. Use, for example, to allow users to customize their own forms and reports, while maintaining a single data source on a network.


Database Utilities Linked Table Manager (Tools menu)

Displays or refreshes links to tables. Use, for example, to refresh links when the structure or location of a linked table has changed.


Database Utilities Switchboard Manager (Tools menu)

Creates, edits, and deletes switchboard forms for an application.


Save button (Null Window, Tools menu, Database Utilities,  Convert Database, Convert Database Into dialog box)
Converts the selected database.


Always Use Event Procedures (Tools, Options, Forms/Reports)
Select to go directly to the Module window and bypass the Choose Builder dialog box (which lists the Expression Builder, Macro Builder, and Code Builder)  when you click the builder button on a property sheet for any event.


Filter For
Filter For:

Type a value or expression in the text box to filter your data. If there is an applied filter, the value or expression is added to the existing filter criteria; otherwise, the value or expression replaces the current filter. Use to quickly filter your data without using Filter By Selection or Filter By Form.


Macro Create Menu from Macro (Tools menu)

Creates a new Microsoft Access 2000–style menu bar from a selected macro. For more information, refer to Microsoft Access Help.


Macro Create Toolbar from Macro (Tools menu)

Creates a new Microsoft Access 2000–style toolbar from a selected macro. For more information, refer to Microsoft Access Help.


Macro Create Shortcut Menu from Macro (Tools menu)

Creates a new Microsoft Access 2000–style shortcut menu from a selected macro. For more information, refer to Microsoft Access Help.


Class Module (Insert menu)

Inserts a class module that is not associated with a form or report into the current database and displays its Declaration section in the Module window.


Web toolbar

Displays or hides the Web Toolbar.


Back

Opens the previous file or item in the list of the last 25 files or items you jumped to.


Forward

Opens the next file or item in the list of the last 25 files or items you jumped to.


Stop Current Jump

Stops loading or reloading of current page or file.


Refresh Current Page

Updates the currently selected page by reloading it.


Start Page

Jumps to the first Web page displayed when you start your default Web browser.


Search the Web

Opens the search page defined by your Web browser so you can search for Web pages by entering words or phrases.


Show Only Web Toolbar

Hides all the currently visible toolbars except the Web toolbar. Click  [image]  again to show the hidden toolbars.


Display Text: (Right-click a Hyperlink Data Type, Hyperlink)
Display Text:

Enter the text you want displayed in the Hyperlink field. By default, Microsoft Access displays the Hyperlink address, which can be either a universal naming convention (UNC) path or Uniform Resource Locator (URL).


Web Page Preview (File menu)

Opens a data access page in Microsoft Internet Explorer 5 or later.


Print Relationships (File menu)

Creates a report that displays the relationships in a Microsoft Access database as they appear in the Relationships window.


Revert (File menu)

Discards any changes that you made to a form or report in Design view and reverts to the last saved version of the form or report.


Connection (File menu)

Redefines the connection information for a Microsoft Access project — for example, to switch from a test to a production database or from a primary to a secondary server.


Send To Mail Recipient (File menu)

Sends a data access page as the body of an e-mail message. Microsoft Access opens the page in Page Design view so that you can make changes to it, such as adding text or notes to the page for the mail recipient, before you send it. To send the output of a database object in e-mail, you need Microsoft Outlook, Microsoft Exchange, Microsoft Mail, or another electronic mail application that supports Messaging Application Programming Interface (MAPI).


Export (File menu)

Exports existing database objects to another database, Microsoft Access project, spreadsheet, or file format so that data or database objects can be used in another database, Access project, application, or program.


Page Properties (File menu)

Displays data access page properties so that you can view or modify them. You can set document properties (for example, title, subject, and author) for a page.


Duplicate (Edit menu)

Duplicates a text box or other control. Microsoft Access pastes the control just below the selected control. To create another evenly spaced control, click Duplicate again. Access places the control beneath the most recently pasted control, even if you moved that control.


Theme (Format menu)

Applies a new or different theme to a data access page, or removes a theme from a page. A theme is a set of unified design elements and color schemes for bullets, fonts, horizontal lines, background images, and other elements. You can also animate certain theme graphics and apply a background to your page.


Detect and Repair (Help menu)

Detects and repairs problems (for example, missing files and missing registry settings) associated with Microsoft Access 2000.


Group (Format menu)

Groups text boxes or other controls on a form or report. To create a group, you must select more than one control. You can organize related controls in a group, and then you can select the group instead of each individual control as you're arranging controls or assigning properties.


Ungroup (Format menu)

Ungroups text boxes or other controls in a group. You can ungroup controls only when a single group is selected. When you ungroup controls, the group rectangle is deleted and all controls are automatically selected.


Cancel Query button

Stops downloading data from the server to the Microsoft Access project. Use Cancel Query if the download operation is taking too long. The Maximum Record Limit button, located just to the right of Cancel Query, controls the number of records downloaded from the Microsoft SQL Server database.


Maximum Record Limit button

Controls the number of records downloaded from the Microsoft SQL Server database and cached in the Microsoft Access project. The default value is 10,000. If you set the number of records to a high limit or to no limit, it might take a long time to access the data. To set a new default value for all new forms and datasheets, click Options on the Tools menu, click the Advanced tab, and enter a new value in the Default max records box.


Online Collaboration Meet Now (Tools menu)

Opens Microsoft NetMeeting so that you can collaborate with other people in real time over an intranet or the Internet on a Microsoft Access database or Microsoft Access project.


Database Utilities Make ADE File (Tools menu)

Copies an unopened Microsoft Access project (.adp) to an ADE file. Use to create a compiled, memory-efficient database project in which the Visual Basic for Applications (VBA) source code has been removed so that users cannot modify the source code.


Replication Partial Replica Wizard (Tools menu)

Opens the Partial Replica Wizard so that you can create a partial replica. A partial replica contains only a subset of the records in a full replica, so you can synchronize a replica with only the data that you need, rather than with an entire database.


Database Utilities Upsizing Wizard (Tools menu)

Upsizes a Microsoft Access database to a new or existing Microsoft SQL Server version 6.5 or 7.0 database or a new Microsoft Access project by upsizing the data and data definitions and migrating database objects. If you are upsizing an Access database with a (VBA) password, you must first remove the password in order to use the Upsizing Wizard.


Macro Microsoft Script Editor (Tools menu)

Opens the Microsoft Script Editor. You can use the Script Editor to add Microsoft Visual Basic Scripting Edition (VBScript) or JScript to a data access page, view the script for your page, or view your Web page as it would appear in a Web browser.


Macro Visual Basic Editor (Tools menu)

Opens the Microsoft Visual Basic Editor (VBE) so that you can create and edit Visual Basic for Applications code in a Microsoft Access database or Microsoft Access project.


Database Utilities Backup (Tools menu)

Creates a backup of your Microsoft SQL Server database. To use this feature, you must install Microsoft Data Engine (MSDE) or SQL Server version 7.0 on your computer.


Database Utilities Restore (Tools menu)

Restores your Microsoft SQL Server database from a previous backup. To use this feature, you must install Microsoft Data Engine (MSDE) or SQL Server version 7.0 on your computer.


Database Utilities Drop SQL Database (Tools menu)

Deletes a Microsoft SQL Server database. To use this feature, you must install Microsoft Data Engine (MSDE) or SQL Server version 7.0 on your computer.


Close command (File menu)
Close (File menu)

Closes the current window.


Save As command (File menu)
Save As (File menu)

•	Saves a copy of a selected object in the current database under a different name or as a different object type, or both.

•	Converts a selected macro to a new Microsoft Visual Basic module.


Database Properties command (File menu)
Database Properties (File menu)

Displays database properties so you can view or modify them.


Mail It button (tool button well)
Send To Mail Recipient (as Attachment) (File menu)

Sends the output of a table, query, form, report, or module through your electronic mail program as an attachment. You can send all of an object's output or a selected portion of a datasheet in one of the following formats including: HTML (.html), MS-DOS text (.txt), Rich Text Format (.rtf), or Microsoft Excel (.xls).


Exit command (File menu)
Exit (File menu)

Quits your Microsoft Access session.


Unhide command (File menu) - Null menu bar
Unhide (Windows menu)

Displays hidden windows.


Can't Undo command (Edit menu)
Can't Undo (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 (Edit menu)

Removes the selected item.

In the Relationship window of a Microsoft Access database, deleting a relationship line deletes the relationship between the two tables. In query Design view of an Access database, 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.


Options command (Tools menu)
Options (Tools menu)

Customizes characteristics of the Microsoft Access environment, such as screen fonts and colors, keyboard actions, and viewing options.


Database Objects Pages (View menu)

Displays in the Database window a list of shortcuts to the data access pages in the current Microsoft Access database or Microsoft Access project.


Database Objects Diagrams (View menu)

Displays in the Database window a list of the database diagrams in the current Microsoft Access project.


Database Objects Stored Procedures (View menu)

Displays in the Database window a list of the stored procedures in the current Microsoft Access project.


Database Objects Views (View menu)

Displays in the Database window a list of the views in the current Microsoft Access project.


Arrange Icons command (Window menu)
Arrange Icons (Window menu)

Arranges all icons of minimized database objects into rows across the bottom of the Microsoft Access window.


Cascade command (Window menu)
Cascade (Window menu)

Arranges windows in Microsoft Access in an overlapping pattern so that the title bar of each window remains visible.


Forms command (View menu)
Database Objects Forms (View menu)

Displays in the Database window a list of forms in the current database.


Hide command (Window menu)
Hide (Window menu)

Hides the active window. The window remains open when hidden. To redisplay a hidden window, choose Unhide on the Window menu.


Macros command (View menu)
Database Objects Macros (View menu)

Displays in the Database window a list of the macros in the current database.


Modules command (View menu)
Database Objects Modules (View menu)

Displays in the Database window a list of the modules in the current database.


Queries command (View menu)
Database Objects Queries (View menu)

Displays in the Database window a list of the queries in the current database.


Reports command (View menu)
Database Objects Reports (View menu)

Displays in the Database window a list of the reports in the current database.


Tables command (View menu)
Database Objects Tables (View menu)

Displays in the Database window a list of the tables in the current database.


Tile Vertically command (Window menu)
Tile Vertically (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)
Tile Horizontally (Window menu)

Arranges windows in Microsoft Access as horizontal panes so that all windows are visible and don't overlap.


Toolbars command (View menu)
Toolbars (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)
Unhide (Window menu)

Displays hidden windows.


Auto Arrange subcommand (View menu, Arrange Icons command)
Arrange Icons Auto Arrange (View menu)

Turns Auto Arrange on and off. When on, icons in 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 off, icons are released from the grid—you can move them anywhere on the Database window.


By Created subcommand (View menu, Arrange Icons command)
Arrange Icons By Created (View menu)

Arranges object icons in the Database window by their creation date.


By Modified subcommand (View menu, Arrange Icons command)
Arrange Icons By Modified (View menu)

Arranges object icons in the Database window by their modification date.


By Name subcommand (View menu , Arrange Icons command)
Arrange Icons By Name (View menu)

Arranges object icons in the Database window alphabetically by name.


By Type subcommand (View menu, Arrange Icons command)
Arrange Icons By Type (View menu)

Arranges object icons in the Database window by type and then by name. For example, queries are grouped by such types as select, crosstab, and union, and then displayed alphabetically, first by type and then by name.


Change To Text Box subcommand (Format menu, Change To command)
Change To Text Box (Format menu)

Changes the selected control to a text box, and copies any common properties from the selected control to the text box.


Change To Label subcommand (Format menu, Change To command)
Change To Label (Format menu)

Changes the selected control to a label, and copies any common properties from the selected control to the label.


Change To List Box subcommand (Format menu, Change To command)
Change To List Box (Format menu)

Changes the selected control to a list box, and copies any common properties from the selected control to the list box.


Change To Combo Box subcommand (Format menu, Change To command)
Change To Combo Box (Format menu)

Changes the selected control to a combo box, and copies any common properties from the selected control to the combo box.


Change To Check Box subcommand (Format menu, Change To command)
Change To Check Box (Format menu)

Changes the selected control to a check box, and copies any common properties from the selected control to the check box.


Change To Toggle Button subcommand (Format menu, Change To command)
Change To Toggle Button (Format menu)

Changes the selected control to a toggle button, and copies any common properties from the selected control to the toggle button.


Change To Option Button subcommand (Format menu, Change To command)
Change To Option Button (Format menu)

Changes the selected control to an option button, and copies any common properties from the selected control to the option button.


Change To Image subcommand (Format menu, Change To command)
Change To Image (Format menu)

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.


Horizontal Spacing Decrease subcommand (Format menu, Horizontal Spacing command)
Horizontal Spacing Decrease (Format menu)

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.


Horizontal Spacing Increase subcommand (Format menu, Horizontal Spacing command)
Horizontal Spacing Increase (Format menu)

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.


Horizontal Spacing Make Equal subcommand (Format menu, Horizontal Spacing command)
Horizontal Spacing Make Equal (Format menu)

Equalizes the horizontal space between three or more selected controls.


Select Form/Report/Page command (Edit menu)
Select Form/Report/Page (Edit menu)

Selects the entire form, report, or data access page so that you can, for example, view or modify its properties. You can also select an entire form or report by clicking the form selector or report selector on the Ruler.


Size To Narrowest subcommand (Format menu, Size command)
Size To Narrowest (Format menu)

Sizes selected controls to the same width as the narrowest selected control.


Size To Shortest subcommand (Format menu, Size command)
Size To Shortest (Format menu)

Sizes selected controls to the same height as the shortest selected control.


Vertical Spacing Decrease subcommand (Format menu, Vertical Spacing command)
Vertical Spacing Decrease (Format menu)

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.


Vertical Spacing Increase subcommand (Format menu, Vertical Spacing command)
Vertical Spacing Increase (Format menu)

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.


Vertical Spacing Make Equal subcommand (Format menu, Vertical Spacing command)
Vertical Spacing Make Equal (Format menu)

Equalizes the vertical space between three or more selected controls.


Size To Tallest subcommand (Format menu, Size command)
Size To Tallest (Format menu)

Sizes selected controls to the same height as the tallest selected control.


Size To Widest subcommand (Format menu, Size command)
Size To Widest (Format menu)

Sizes selected controls to the same width as the widest selected control.


Toolbox command (View menu)
Toolbox (View menu)

Shows or hides the toolbox. Use the toolbox to create controls on a form, report, or data access page.


Delete Column command (Edit menu)
Delete Column (Edit menu)

In query Design view and the Advanced Filter/Sort window, 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 (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)
Join Properties (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).


Remove Table command (Query menu)
Remove Table (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)
SQL Specific Union (Query menu)

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)
SQL Specific Data Definition (Query menu)

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)
SQL Specific Pass-Through (Query menu)

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 SQL query syntax, see the documentation for the database server.


Parameters command (Query menu)
Parameters (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 (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.


Report Header/Footer command (ViewFormat menu)
Report Header/Footer (View menu)

Displays or removes report header and footer sections. Use the report header for introductions that contain, for example, text, pictures, and logos. Use the report footer for summaries that contain, for example, grand totals.


Print Preview command (File menu)
Print Preview (File menu)

Displays the active object, such as a table, form, or report, as it will appear when printed (except in the Macro window where it first displays the Documenter). You can zoom in or out of a page or see several pages at once.


Page Numbers command (Insert menu)
Page Number (Insert menu)

Inserts a page number expression in a text box control on a form, report, or data access page. You can specify format, position, alignment, and whether or not to display the page number on the first page.


Date aAnd Time command (Insert menu)
Date And Time (Insert menu)

Inserts a current date and time expression in a text box control on a form, report, or data access page. You can specify format and whether or not to display just the date or time.


Picture command (Insert menu)
Picture (Insert menu)

Inserts a picture into an image control on the form, report, or data access page. Use an image control for static pictures, such as a logo, and for fast access.


Insert Object command (Insert menu)
Insert Object (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 by using its associated application, double-click the object.


Zoom 200% subcommand (View menu)
Zoom 200% (View menu)

Zooms the page(s) by a factor of 200 percent and makes that the new zoom setting.


Zoom 150% subcommand (View menu)
Zoom 150% (View menu)

Zooms the page(s) by a factor of 150 percent and makes that the new zoom setting.


Zoom 100% subcommand (View menu)
Zoom 100% (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)
Zoom 75% (View menu)

Zooms the page(s) by a factor of 75 percent and makes that the new zoom setting.


Zoom 50% subcommand (View menu)
Zoom 50% (View menu)

Zooms the page(s) by a factor of 50 percent and makes that the new zoom setting.


Zoom 25% subcommand (View menu)
Zoom 25% (View menu)

Zooms the page(s) by a factor of 25 percent and makes that the new zoom setting.


Zoom 10% subcommand (View menu)
Zoom 10% (View menu)

Zooms the page(s) by a factor of 10 percent and makes that the new zoom setting.


Fit to Window subcommand (View menu)
Fit to Window (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)
Four Pages  (View menu)

Displays four full pages in Print Preview or Layout Preview.


Pages 8 subcommand (View menu)
Eight Pages (View menu)

Displays eight full pages in Print Preview or Layout Preview.


Pages 12 subcommand (View menu)
Twelve Pages  (View menu)

Displays twelve full pages in Print Preview or Layout Preview.


Clear Layout command (Edit menu)
Clear Layout (Edit menu)

Clears the Relationships window. Clearing the layout does not delete actual tables, queries, or relationships.


Remove Table command (Relationships menu)
Hide Table (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 (Relationships menu)

Displays settings for the selected relationship line so you can modify the relationship. You can also double-click the relationship line to display settings.


Select All command (Edit menu)
Select All (Edit menu)

Selects all field or column definitions in a table, controls in a form or report, or rows in a macro so that you can, for example, copy these items to a new object.


Test Validation Rules (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/Field command (Insert menu)
Lookup Column/Field (Insert menu)

Creates a lookup field (column) for the selected data type. A lookup field looks up values from another table (such as a shipper from the Shippers table) and stores the reference to the values in the main table (such as the Shipper ID in the Orders table).


Paste Special command (Edit menu)
Paste Special (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)
Paste Append (Edit menu)

Adds records from the Clipboard to the end of the active form or datasheet. In a Microsoft Access database, 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)
Select Record (Edit menu)

Selects the current record in a form or datasheet so that you can, for example, copy the record to another table.


Select All Records command (Edit menu)
Select All Records (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 (Edit menu)

Updates, modifies, copies, reconnects, or breaks the link of the selected object.


Datasheet command (Format menu)
Datasheet (Format menu)

Turns horizontal and vertical gridlines on and off, changes the cell, gridline color, border, and line styles, and changes the cell effect (such as sunken or raised).


Rename Column command (Format menu)
Rename Column (Format menu)

Renames 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 Columns (Format menu)

Hides the selected datasheet columns from view. 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)
Unfreeze All Columns (Format menu)

Unfreezes all frozen columns in a datasheet. When you unfreeze columns, they remain in the same order they were in when frozen.


Advanced Filter/Sort command (Records menu)
Filter Advanced Filter/Sort (Records/Filter menu)

Displays the Advanced Filter/Sort window so you can create a filter to apply to the datasheet or form.


Refresh command (Records menu)
Refresh (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, refer to Microsoft Access Help.


Data Entry command (Records menu)
Data Entry (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 Remove Filter/Sort from the Records menu.


Autocorrect command (Tools menu)
AutoCorrect (Tools menu)

Customizes the settings used to automatically correct text as you type, and creates and modifies the list of words to correct as you type.


Merge It button Merge It subcommand (Tools menu, OfficeLinks command)
OfficeLinks Merge It with MS Word (Tools menu)

Starts the Microsoft Word Mail Merge Wizard, which merges Microsoft Access data with a 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 (Tools menu)

Starts the Table Analyzer Wizard, which analyzes a table, and if necessary, splits it into related tables to create a more efficient table design.


Analyze Performance button (Database toolbar) Performance subcommand (Tools menu, Analysis command)
Analyze Performance (Tools menu)

Starts the Performance Analyzer, which analyzes the performance of your database and its objects.


Documenter button (Database toolbar)Documenter subcommand (Tools menu, Analysis command)
Analyze Documenter (Tools menu)

Starts the Documenter, which provides detailed descriptions of one or more database objects.


Database Password subcommand (Tools menu, Protection command)
Security Set Database Password (Tools menu)

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)
Security User And Group Permissions (Tools menu)

Displays, assigns, and removes user and group account permissions for the current database and its objects. Also, displays, assigns, and changes ownership of database objects.


User and Group Accounts subcommand (Tools menu, Security command)
Security User And Group Accounts (Tools menu)

Displays, prints, adds, removes, and changes user and group accounts. Also, changes the password of the default user account, Admin.


User-Level Security Wizard subcommand (Tools menu, Security command)
Security User-Level Security Wizard (Tools menu)

Starts the User-Level Security Wizard, which creates a new, secured copy of the current database.


Startup command (Tools menu)
Startup (Tools menu)

Controls and customizes various database startup properties and actions, such as application title and icon, and which startup form or data access page to display.


Custom Controls command (Tools menu)
ActiveX Controls (Tools menu)

Registers or unregisters ActiveX controls in the Windows registration database (which is used for tracking information about applications, such as file name and path). Registration determines whether or not ActiveX controls are available for use.


Select and then click a font from the list if you need dual -font support to display all of your data. For example, if your data consists of both English-language characters and characters of an Asian language, the substitution font is used to display characters not supported by the default font.


•	Select Single-click open to select a database object by resting the pointer on it, and open an object by clicking it.

•	Select Double-click open to select a database object by clicking it, and open an object by double-clicking it.


Select if you want Microsoft Access to store the information it needs to correct naming errors, but not to make corrections right away. If you select the Perform name AutoCorrect check box at another time, Access will use the stored information in each object to repair any errors.


Select if you want Microsoft Access to repair naming errors as name changes are applied to the database.


Select if you want Microsoft Access to create a log of the changes it makes to the database when name errors are repaired. Access saves the log in a table called AutoCorrect Log.


Sets Web options for database objects. You can set the appearance of followed and unfollowed hyperlinks displayed in a table, query, form, report, or data access page. If a data access page is open in any view, you can also select how to organize your HTML files and encode your HTML documents.


Select to automatically compact and repair your database or compact your Microsoft Access project when you close the database. Your database or project will be compacted only if the size will be reduced by at least 256 kilobytes.


Select to make record-level locking the default for the current database. Clear to make page-level locking (which locks all records on the disk page) the default. If you select this check box, record-level locking becomes the default behavior for access to data through a form, a datasheet, and code that uses a recordset object to loop through records, but not through action queries, or through code that performs bulk operations by using SQL statements.


Enter a number to change the default number of records downloaded from a Microsoft SQL Server database and cached in a Microsoft Access project.


Select to display new object shortcuts in the Database window Object list. New object shortcuts are used to create new database objects — for example, Create report in design view and Create report by using wizard.


Select to see an icon displayed on the Windows taskbar for each open database object or window. To use this feature, you must install Microsoft Internet Explorer Active Desktop.


Show in Macro Design group (Tools, Options, Options dialog, View tab)
•	Select Names Column to display the Macro Name column for new macros.

•	Select Conditions Column to display the Condition Name column for new macros.


Default Colors group (Tools, Options, Options dialog, Datasheet tab)
Select a default color for the font, background, and gridlines of new datasheets.


Default Font group (Tools, Options, Options dialog, Datasheet tab)
Select Font, Font Weight, Font Size, Italic, or Underline to format text in new datasheets.


Default Gridlines Showing group (Tools, Options, Options dialog, Datasheet tab)
•	Select Horizontal to display horizontal gridlines by default.

•	Select Vertical to display vertical gridlines by default.


Default Column Width option (Tools, Options, Options dialog, Datasheet tab)
Type a measurement in inches or centimeters (depending on the system of measurement specified under Regional Settings in the Windows Control Panel) to change the default column width for new datasheets.


Default Cell Effect group (Tools, Options, Options dialog, Datasheet tab)
Select Flat, Raised, or Sunken to change the default appearance of cells for new datasheets.


Show Animations option (Tools, Options, Options dialog, Datasheet tab)
Select to turn on 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 Don't Move to keep the insertion point in the current field after you press ENTER.

•	Select Next Field to move the insertion point to the next field after you press ENTER.

•	Select Next Record to move the insertion point to the current field of the next record after you press ENTER.


Arrow Key Behavior group (Tools, Options, Options dialog, Keyboard tab)
•	Select Next Field to move the insertion point to the next or previous field after you press the RIGHT or LEFT ARROW key. Press F2 to move the insertion point within a field when you select Next Field.

•	Select Next Character to move the insertion point to the next or previous character after you press the RIGHT or LEFT ARROW key.


Behavior Entering Field group (Tools, Options, Options dialog, Keyboard tab)
Changes 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 to select the entire field when you enter it.

•	Select Go To Start Of Field to place the insertion point at the start of the field when you enter it.

•	Select Go To End Of Field to place the insertion point at the end of the field when you enter it.


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)
Defines selection behavior when you drag a rectangle to select controls on forms and reports.

•	Select Partially Enclosed to let the selection rectangle cover only part of a control or group of controls.

•	Select Fully Enclosed to require the selection rectangle to 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.


Select to display the most recently used files on the File menu. You can click a file name on this list to open it with the option settings it had the last time you opened it. The default number of files displayed is 4, but you can change this by selecting a number in the Recently used file list box.


Select Status Bar to display the status bar at the bottom of the Microsoft Access window.


Select Startup Dialog Box to display the dialog box that appears when Microsoft Access starts up.


Select Hidden Objects to display any object in the Database window with a property of Hidden as dimmed icons in the Database window.


Select System Objects to automatically display tables created by Microsoft Access when you create a new database or any system object as dimmed icons in the Database window.


Print Margins group (Tools, Options, Options dialog, General tab)
Type a measurement to change the default margins for datasheets and modules, new forms and reports, or data access pages. 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)
Type a folder name to change the default folder for storing new databases and files.


New Database Sort Order option (Tools, Options, Options dialog, General tab)
Select a language to change the default alphabetical sort order for new databases. The default is General. To reset the sort order for an existing database, select the language you want to use and then compact the database. For more information, refer to Microsoft Access Help.


Default Field Sizes group (Tools, Options, Options dialog, Tables/Queries tab)
Changes 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.

•	In the Number box, select the option you want for fields with a Number data type.


Default Field Type option (Tools, Options, Options dialog, Tables/Queries tab)
Select a data type to change the default data type of fields in new tables, or fields you add to existing tables.


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


Show Table Names option (Tools, Options, Options dialog, Tables/Queries tab)
Select to show table names in the query design grid. Use 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.


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 and 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.


Default Find/Replace Behavior group (Tools, Options, Options dialog, Edit/Find tab)
Sets the default behavior of Microsoft Access Find/Replace operations.

•	Select Fast Search to search the current field and match the whole field.

•	Select General Search to search all fields and match any part of the field.

•	Select Start Of Field Search to search the current field and match the beginning character(s) of the field.


Show list of values in group (Tools, Options, Options dialog, Edit/Find tab)
Controls 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 Record Changes to display a confirmation message when you change a record.

•	Select Document Deletions to display a confirmation message when you delete a database object.

•	Select Action Queries to display a confirmation message when you run an action query (Microsoft Access database only).


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)
Controls the default record-locking behavior in a multiuser environment.

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

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

•	Select Edited Record to lock only the record you're editing.


DDE Operations group (Tools, Options, Options dialog, Advanced tab)
•	Select Ignore DDE Requests to ignore DDE requests from other applications.

•	Select Enable DDE Refresh to enable updating DDE links at the interval specified in the Refresh Interval box.


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


Default Open Mode group (Tools, Options, Options dialog, Advanced tab)
•	Select Shared to open an existing database for shared access, by default.

•	Select Exclusive to open an existing database for exclusive access, by default.


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


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


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


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


Controls whether the drop-down lists in fields in the Filter By Form window retrieve and display unique values from each field in the local snapshot of records on the client. If the list of values takes too long to display, clear this check box. When this check box is cleared, the drop-down lists don't retrieve any values for the fields; the lists only display Is Null or Is Not Null.


Controls whether the drop-down lists in fields in the Server Filter By Form window retrieve and display unique values from each field from the records at the server. If the list of values takes too long to display, clear this check box. When this check box is cleared, the drop-down lists don't retrieve any values for the fields; the lists only display Is Null or Is Not Null.


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


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


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


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


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


Halt button (Macro single step dialog box)
Stops running the macro and closes the dialog box.


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


Add (Query, Add Table, Add Table dialog box)
Adds the selected table or query.


Make New Table (Query, Make Table, Make Table dialog box)
•	Type the table name, and then select Current Database to append the query results to the current database or to make a new table in the current database.

•	Type the table name, select Another Database, and then type the file name of the database to append to a table in another database or make a new table in another database. If the database is a non-Microsoft Access database, use the following format: file name database name, for example, "C:\Data\Sales" "Paradox".


Append To (Query, Append, Append dialog box)
•	Type the table name, and then select Current Database to append the query results to the current database.

•	Type the table name, select Another Database, and then type the file name of the database to append to a table in another database. If the database is a non-Microsoft Access database, use the following format: "file name" "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).

•	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)
Select a query from the list to load it from the active filter.

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)
Type the name of the object.


Column Width (Format, Column Width, Column Width dialog box)
Type the number of field characters displayed to set the column width. 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)
Sets the column as the default width (approximately one screen inch).


BestFit (Format, Column Width, Column Width dialog box)
Sets 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.


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


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


Object Type (Insert, Object, Insert Object dialog box, Report Design View)
Select the object type you want to insert on the form or report.


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

Select to insert a link to the file into the form or report. Changes to the file are reflected in the form or report.


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


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


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)
•	Select Current Icon, and then select an icon in the icon list to keep the current icon.

•	Select Default to use the default icon defined for the OLE object.

•	Select From File, and then type a file name to create a new icon from an existing file. Or click Browse, select a file containing an icon, click OK, and then select an icon in the icon list, (which displays one or more icons in that file).


Label (Insert, Object, Insert Object dialog box, Change Icon dialog box, Report Design View)
Type the new label to associate with the icon.


Custom Control (Insert, Custom Control, Insert OLE Controls dialog box, Report Design View)
Select an ActiveX control to insert.


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

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


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

•	Select Bottom of Page [Footer] to place the page number at the bottom of the form or report page.


Alignment (Insert, Page Numbers, Page Numbers dialog box, Report Design view)
Select Left, Center, or Right to align the page number on the left side, center, or right side of the page.

For duplex printing, select Inside to print odd page numbers on the left side of the page and even page numbers on the right, or select Outside to print even pages number on the left side of the page and odd page numbers on the right.


Show Number on First Page (Insert, Page Numbers, Page Numbers dialog box, Report Design view)
Select to show the page number on the first page.


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


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


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


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, 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, and then select the desired field name.


Enforce Referential Integrity (Relationships, Edit Relationships, Relationships dialog box)
Referential integrity is a system of rules that Microsoft Access uses to ensure that relationships between records in related tables are valid and that you don’t accidentally delete or change related data. Select this check box to enforce referential integrity for this relationship only if all of the following apply: the matching field from the primary table is a primary key or has a unique index, the related fields have the same data type, and both tables are stored in the same Access database.

Clear this check box to allow changes to related tables that would break referential integrity rules.


Cascade Update Related Fields (Relationships, Edit Relationships, Relationships dialog box)
Select Enforce Referential Integrity, and then select Cascade Update Related Fields 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 clear 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.


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

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


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."


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


Match Case (Edit menu, Find command, find dialog box, Module Design view)
Finds only text that has the same pattern of uppercase and lowercase letters as the text you specified in the Find What box. Clear this check box to find text regardless of case.


Find What (Edit menu, Find command, Find dialog box, Module Design view)
Enter the information you want to search for. In a Microsoft Access database, use a question mark (?) to match any single character or use an asterisk (*) to match any string of characters. For example, sm?th finds "smith" and "smyth"; *east finds "Northeast", "Southeast", and "East".

In a Microsoft Access project, use an underscore (_) to match any single character or use a percent sign (%) to match any string of characters. For example, sm_th finds "smith" and "smyth"; %east finds "Northeast", "Southeast", and "East".


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)
Select to embed an object previously copied from another application into the current form, report, or datasheet.


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, refer to Microsoft Access Help.


Paste Link (Edit menu, Paste Special command, Paste Special dialog box, Datasheet view)
Select to link and display the object you previously copied from another application into the current form, report, or datasheet. 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)
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)
Select one of the match types: Any Part Of Field ("berg" finds Bergen and Heidelberg), Match Whole Field ("London" finds London, but not Londonderry), or Start Of Field ("berg" finds Bergen, but not Heidelberg).


Search Fields as Formatted (Edit menu, Find, Find dialog box, Datasheet view)
Select 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). Searching this way is usually slowest. Clear to find data based on its value.


Current Field (Edit menu, Find, Find dialog box, Search In group, Datasheet view)
Select a field to search through all records in the current field only. This is usually quicker, especially if the field is indexed. Or, select the datasheet or form to search through all fields in all records.


Link Group (Edit menu, OLE/DDE Links command, Links dialog box, Datasheet view)
Select either OLE links or DDE links to display the desired link group in the Links list box.


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 file name 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.

•	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)
Updates the link selected in the Links list box. 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)
Edits the selected file using the object application.


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


Break Link (Edit menu, OLE/DDE Links command, Links dialog box, Datasheet view)
Breaks the link selected in the Links list box. 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)
Select Horizontal to display horizontal gridlines. Select Vertical to display vertical gridlines. These options also apply to the printed datasheet.


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)
Select a color to change the gridline color.


Background color (Format menu, Cells command, Cells dialog box, Datasheet view)
Select a color to change the background color.


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


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


Column (Format menu, Unhide Columns, Unhide Column dialog box, Datasheet view)
Select the corresponding check box to display a column.


Password (Tools menu, Security command, Set Database Password subcommand, Set Database Password dialog box)
Type the database password. For more information, refer to Microsoft Access Help.


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
Select a user or group's name to display or modify its permissions.


Object Name (Tools menu, Security command, User and Group Permissions subcommand, User and Group Permissions dialog box)
Select an object name to display or modify its permissions.


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


Object Type (Tools menu, Security command, User and Group Permissions subcommand, User and Group Permissions dialog box)
Select a database object type to display a list of them in the Object list box.


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, refer to Microsoft Access Help.


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
Select to indicate the object whose ownership you want to change.


New Owner (Tools menu, Security command, User and Group Permissions subcommand, User and Group Permissions dialog box)
Select to choose new owner.


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


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


User Name (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
Select a user name to display and modify it. Or, type a user name to enter a new name.


New (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
Click to add a new user or group, and then enter your personal ID.


Name (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
Select a user name to display and modify it. Or, type a user name to enter a new name.


Personal ID (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
Type your personal ID (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)
Deletes the current user or group displayed in the Name box.


Clear Password (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
Clears the password of the user displayed in the Name box. 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)
•	Select a group from the Available Groups list box and click Add to add the current user (displayed in the Name box) to a group.

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


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


Group Name (Tools menu, Security command, User and Group Accounts subcommand, User and Group Accounts dialog box)
Select a group to display it. Select a group and then click Delete, to delete it. Type a new group name, and then click New to add it.


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.


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


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


Application Icon Builder (Tools menu, Startup command, Startup dialog box, Datasheet view)
Locates a bitmap (.bmp) or icon (.ico) file.


Menu Bar (Tools menu, Startup command, Startup dialog box, Datasheet view)
Select a menu bar from the list to display your own menu bar as the default menu bar for the current database.


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


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


Display Form (Tools menu, Startup command, Startup dialog box, Datasheet view)
Select a form or data access page to display it when you open the database.


Display Database Window (Tools menu, Startup command, Startup dialog box, Datasheet view)
Select to display the Database window when you open the database. Clear to prevent the Database window from displaying when you open the database.


Display Status Bar (Tools menu, Startup command, Startup dialog box, Datasheet view)
Select to display the status bar.


Allow Default Command Bars (Tools menu, Startup command, Startup dialog box, Datasheet view)
Select to view and use the Microsoft Access default toolbars.


Allow Command Bar Changes (Tools menu, Startup command, Startup dialog box, Datasheet view)
Select to allow toolbar changes. Clear to lock toolbars (which disables the right mouse button, the Close button on toolbars, and the Toolbars command on the View menu).


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


Use Access Special Keys (Tools menu, Startup command, Startup dialog box, Datasheet view)
Select to allow use of special keys. For more information, refer to Microsoft Access Help.


Macro Name (Tools menu, Macro command, Macro dialog box, Datasheet view)
Select a macro to run it. Microsoft Access lists macros in a macro group, using the format, group.macro (for example, Invoice.Tax).


Register (Tools menu, ActiveX Controls command, ActiveX Controls dialog box, Datasheet view)
Registers a control by locating the file containing the control (.ocx). Microsoft Access will update the list of available controls.


Unregister (Tools menu, ActiveX Controls command, ActiveX Controls dialog box, Datasheet view)
Unregisters the selected control in the Available Controls list box.


Pages

Displays all the shortcuts to data access pages in the current Microsoft Access database or Microsoft Access project. Use the buttons on the Database window toolbar to open or modify the selected page or to create a new page.


Views

Displays all views in the current Microsoft Access project. Use the buttons on the Database window toolbar to open or modify the selected view or to create a new view.


Database Diagrams

Displays all database diagrams in the current Microsoft Access project. Use the buttons on the Database window toolbar to modify the selected database diagram or to create a new database diagram.


Stored Procedures

Displays all stored procedures in the current Microsoft Access project. Use the buttons on the Database window toolbar to run or modify the selected stored procedure or to create a new stored procedure.


Favorites

A built-in group to which you can add shortcuts to database objects.


Database window

Displays all objects in the current Microsoft Access database or Microsoft Access project. Click an object type in the Objects bar (such as Tables) to display all objects of that type. Use the buttons on the Database window toolbar to perform tasks, such as modifying database objects or creating new ones.


Field List (Relationships window)
Field List

Use to define a relationship between two tables by dragging a field from one table or query to another table or query. The table's primary key field is displayed as bold.


Forms tab (Database window)
Forms

Displays all forms in the current Microsoft Access database or Microsoft Access project. Use the buttons on the Database window toolbar to open or modify the selected form, or create a new form.


Macros tab (Database window)
Macros

Displays all macros in the current Microsoft Access database or Microsoft Access project. Use the buttons on the Database window toolbar to run the selected macro, edit the selected macro, or create a new macro.


Modules tab (Database window)
Modules

Displays all modules in the current Microsoft Access database or Microsoft Access project. Use the buttons on the Database window toolbar to edit the selected module or create a new module.


New button (Database window)
New

Creates a database object. Before clicking this button, in the Objects bar click the type of database object you want to create.


Queries tab (Database window)
Queries

Displays all queries in the current Microsoft Access database. Use the buttons on the Database window toolbar to open or modify the selected query, or create a new query.


Reports tab (Database window)
Reports

Displays all reports in the current Microsoft Access database or Microsoft Access project. Use the buttons on the Database window toolbar to preview how the selected report will look when printed, modify the selected report, or create a new report.


Run button (Database window)
Run

Runs the selected macro, or stored procedure in a Microsoft Access project.


Tables tab (Database window)
Tables

Displays all tables in the current Microsoft Access database or Microsoft Access project. Use the buttons on the Database window toolbar to open or modify the selected table or to create a new table.


Rename Group

Renames a group in the Database window.


Delete Group

Deletes a group in the Database window.


New Group

Creates a new group in the Database window. A group consists of shortcuts to the database objects that belong to it; adding an object to a group does not move that object. You can add different types of database objects to a group, and when you click the Groups bar and then click the icon for your group, all the shortcuts that you have added to the group appear in the Object list.


Add to Group New Group

Creates a new group that you can add database objects to.


Form Design view

Use to create or modify a form. By default, the window displays only the detail section. To display other sections of a form, click Page Header/Footer or Form Header/Footer on the View menu.


Form view

Use to enter, change, and view data one or more whole records at a time. Unlike Datasheet view, in Form view you can display pictures, other OLE objects, command buttons, and other controls.


Detail section

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


Form Footer

Displays, for example, instructions for using the form, command buttons, or unbound controls to accept input. A form footer appears at full height, so the controls in the section appear on the screen at all times. A form footer displays at the bottom of a form in Form view and at the end of a printout. It doesn’t appear in Datasheet view.


Form Header

Displays, for example, a title for the form, instructions for using it, or command buttons that open related forms or carry out other tasks. A form header appears at full height, so the controls in the section appear on the screen at all times. A form header displays at the top of a form in Form view and at the beginning of a printout. It doesn’t appear in Datasheet view.


Page Footer

Displays 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

Displays 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

Use to display and modify the properties of tables, queries, forms, reports, and data access pages. In table and query Design views, you can also display and modify the properties of individual fields. In Form view, and in form, report, and page Design views, you can also display and modify the properties of sections and controls.


Macro window (Macro, Design)
Macro window

Use to create and modify a macro.


Macro Name column (Macro window)
Macro Name column

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


Condition column (Macro window)
Condition column

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


Action column (Macro window)
Action column

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


Comment column (Macro window)
Comment column

Use 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 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.


Query Design view

Use 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 to add fields or columns to the active query or filter by dragging the field from the field list to a column in the design grid.


Join Line (Query Design view)
Join line

Relates 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

Resizes or selects 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

Adds a field to the results of the active query or filter. To add a field, click the cell in the design grid, and then select from the list of fields.


Table row (Query Design view)
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 or filter. To hide or display the Table row, click the Table Names command on the View menu.


Totals row (Query Design view)
Total row

Groups data in the active query or performs summary calculations, such as averages and counts. To hide or display the Total row, click the Totals command on the View menu.


Crosstab row (Query Design view)
Crosstab row

Creates 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.


Update To row (Query Design view)
Update To row

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


Delete row (Query Design view)
Delete row

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


Sort row (Query Design view)
Sort row

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


Show row (Query Design view)
Show check box

Displays or hides a column in the results of the active query or filter. If you hide a column, you can still use it to specify criteria.


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

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


Filter By Form window

Indicates 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 to filter records. Click the Look for tab, if not already selected, and then enter the values you want in one or more fields.


Or tab (Filter By Form window)
Or tab

Use to filter records by alternate values. You must first enter a value in a field on the Look for tab to enable the Or tab. Then, click the Or tab, and enter the alternate values you want the filtered records to contain in one or more fields.


SQL view (Query window)
SQL view

Displays, creates, or modifies a query using Structured Query Language (SQL). Changes in the SQL view are reflected in the query Design view and vice versa.

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


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 to position controls and determine the size of form or report sections. To display or hide the rulers, click Ruler on the View menu.


Detail section (Report Design window)
Detail section

Use to contain the main body of the report. To place controls in the detail section, use the field list or the toolbox. To hide 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, click Sorting and Grouping on the View menu, select a field or type an expression, and set the Group Header 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, click Sorting and Grouping on the View menu, select a field or type an expression, and set the Group Footer 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 hide 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 hide 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 hide 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 hide the report header, set its Height property to 0.


Print Preview window
Print/Layout Preview window

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

In Layout Preview, displays the report approximately as it will appear when printed, 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 uses only sample data and ignores criteria and joins in any underlying query.


Design view (Table window)
Table Design view

Creates and modifies the structure of a table.


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

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


Relationships window

Displays and edits existing relationships, or defines new ones between tables and queries.


Relationship Line (Relationships window)
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.


Open command (Database Window, Object names)
Open

Displays the selected table's, query's, or view’s Datasheet view, the selected form's default view (either Datasheet or Form), or a selected data access page or other HTML file in Page view.


Design  command (Database Window, Object names)
Design

Displays the selected object in Design view.


Preview  command (Database Window, Object names)
Preview

Displays the selected report in Print Preview.


Run  command (Database Window, Object names)
Run

Runs the selected macro in a Microsoft Access database or a Microsoft Access project, or a stored procedure in an Access project.


Print  command (Database Window, Object names)
Print

Prints the selected form, report, datasheet, or data access page immediately without displaying the Print dialog box.


Filter Excluding Selection  command (Datasheet title bar)
Filter Excluding Selection (Records/Filter menu)

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, point to Filter on the Records menu, and then click Filter Excluding Selection.


Pages Layout subcommand (Pages command, Print Preview)
Multiple Pages

Displays a matrix of full pages in Print Preview or Layout Preview. For example, 2x3 displays pages in 2 rows of 3 columns. Click and drag the grid to increase or decrease the size of the matrix.


Zoom  command (Table Design)
Zoom

Displays the Zoom window so you can easily view and edit long text fields.


Sets new objects to display in a left-to-right direction familiar to English and European language users. For example, displays the first field in a table starting in the leftmost column and adds new fields to the right of the column, and places the record number box and navigation buttons in table Datasheet view in the lower-left corner of the table.


Sets new objects to display in a right-to-left direction familiar to Middle Eastern language users. For example, displays the first field in a table starting in the rightmost column and adds new fields to the left of the column, and places the record number box and navigation buttons in table Datasheet view in the lower-right corner.


Sets insertion point movement to progress within bidirectional text according to the direction of the language encountered. For example, when using the arrow keys to move through Arabic and then English text in the same sentence, the insertion point moves in a right-to-left direction through the Arabic text and then starts at the leftmost character of the English word and continues its movement in a left-to-right direction.


Sets insertion point movement to progress within bidirectional text by moving to the next visually adjacent character. For example, when using the arrow keys to move from right to left through Arabic and then English text in the same sentence, the insertion point moves in a right-to-left direction through the Arabic text and then continues at the rightmost character of the English word and progresses in a right-to-left direction.


Sets the General alignment setting to align displayed characters consistent with the user interface language in effect. For example, when the user interface language is a left-to-right language (such as English), characters will be aligned left.


Sets the General alignment setting to align displayed text according to the direction of the first language-specific character. For example, if the first strong character (not a numeral or special character) is in English, text will be aligned left.


Sets the underlying date reference for a database to be based on the Islamic lunar calendar. If not selected, the calendar is Gregorian. It is recommended that the type of database calendar should be chosen when a database is first created and then never changed.


Field List (View menu)

Displays the Field List so that you can drag a field, a table, or a query from the list to the page to create controls that are automatically bound to a record source. The Database tab of the Field List displays all the tables, queries, and other record sources in the database. The Page tab of the Field List displays all the fields, expressions, and group record sources in the current page's data definition.


Page View (View menu)

Switches from the current view to Page view of the active data access page. You can use the page just as you would in Microsoft Internet Explorer 5 or later, while still working in Microsoft Access.


Design View (View menu)

Switches from the current view to Design view of the active data access page.


Movie from File (Insert menu)

Inserts a movie on a data access page. Microsoft Access creates a movie control and plays the movie in the control.


Unbound Section (Insert menu)

Inserts an unbound section into the body of a data access page or an HTML document. You can add an unbound section only if there is no section on the page. After you add controls bound to fields in tables, queries, or views to the section, you can add grouping levels. By default, any text boxes or other controls you place in the section are positioned absolutely.


Office Chart (Insert menu)

Starts the Microsoft Office Chart Wizard so that you can insert a two-dimensional chart on a data access page. You can display database data in a chart to analyze trends, patterns, and comparisons. When the data in the database changes, the chart will update automatically. If the chart is linked to a PivotTable list or spreadsheet on the page, the chart will change when you change the PivotTable list or spreadsheet.


Office PivotTable (Insert menu)

Inserts a Microsoft Office PivotTable list on a data access page. A PivotTable list displays data in a row-and-column format that you can reorganize to analyze the data in different ways. A PivotTable list is intended to display data only; you can't edit any values in a PivotTable list.


Office Spreadsheet (Insert menu)

Inserts a Microsoft Office Spreadsheet on a data access page. You can enter raw data, reference a control on the page to display its data or the result of a calculation on its data, or import data from a Web page or text file. You can also add formulas, apply filters, and perform additional spreadsheet operations.


Select All (Edit menu)

Selects all the objects on a data access page. For example, you can use Select All with Delete to delete all the objects on a page at one time.


Select Page (Edit menu)

Selects the data access page. For example, use this to display the page's property sheet.


Background Sound (Format menu)

Adds a background sound to a data access page. The sound plays when you view the page in Page view.


Background Picture (Format menu)

Adds a background picture, or watermark, to a data access page.


Decrease Indent

Indents the selected text to the previous tab stop on a data access page.


Increase Indent

Indents the selected text to the next tab stop on a data access page.


Numbering

Adds numbers to or removes numbers from selected text on a data access page.


Bullets

Adds bullets to or removes bullets from selected text on a data access page.


Code button (Database toolbar)
Code (View menu)

Opens the Visual Basic Editor and displays the code behind a selected form or report in the Code window.


Copy button (Database toolbar)
Copy (Edit menu)

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


Cut button (Database toolbar)
Cut (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.


Details button (Database toolbar)
Details (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 (Database toolbar)

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; double-click to copy to several controls, and then press ESC when finished.


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

Lists database objects by using large icons for the selected object type.


List button (Database toolbar)
List (View menu)

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


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

Creates a Microsoft Access database, data access page, or Access project.


New Object button (Database toolbar)
New Object (Database toolbar)

Creates a database object. Select AutoForm, AutoReport, or AutoPage to create a basic form, report, or data access page. Choose an object type (such as Form or Table) to create the object yourself.


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

Opens an existing Microsoft Access database, Access project, or other file type.


Paste button (Database toolbar)
Paste (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 (File menu)

Prints a database object. Displays the Print dialog box first so that you can change printer settings and properties.

In the Macro window, displays the Documenter so that you can choose to print one or more report sections. Then, it prints the macro report to the default printer.


Save button (Database toolbar)
Save (File menu)

Saves the layout of a datasheet; design of a table, query, view, stored procedure, SQL statement, form, report, or data access page; or structure and content of a macro.


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

Lists database objects by using small icons for the selected object type.


Spellcheck button (Database toolbar)
Spelling (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 (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 (Tools menu)

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


Properties button (Database toolbar)
Properties (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.


Font

Changes the typeface in a label text box in a database diagram. The default font is Tahoma, the default font style is Regular, and the default size is 16 points.


New Table (Diagram menu)

Creates a new table in the database diagram in Column Properties view. The table is created in the database when you save the table or the diagram.


New Label (Diagram menu)

Inserts a blank text box in the database diagram. You can use this command for notes describing the diagram and its objects — for example, headings, descriptions of the tables and their contents, or any other information you want to place in the diagram.


Add Related Tables (Diagram menu)

Adds related tables to the database diagram for tables with existing foreign keys.


Show Relationship Labels (Diagram menu)

Displays all relationship line labels in a database diagram.


Modify Custom View (Diagram menu)

Lets you determine exactly what columns you want to see when viewing tables in Custom view in a database diagram. After you make selections in the Column Selection dialog box, right-click the table you want to see in Custom view, and then click Custom View on the shortcut menu.


View Page Breaks (Diagram menu)

Displays page breaks that show how the database diagram will be broken into pages when it is printed.


Recalculate Page Breaks (Diagram menu)

Changes the page breaks in the database diagram if you've added or rearranged objects.


Layout Selection (Diagram menu)

Rearranges the database diagram to best display all the tables and their relationships. This command is especially useful if you've moved the tables in the diagram or added new tables and you want to clean up the diagram's layout.


Autosize Selected Tables (Diagram menu)

Adjusts the selected table and the columns within the table to show all the information in the displayed columns.


Layout Diagram (Diagram menu)

Rearranges the database diagram to best display selected tables or tables and their relationships.


Custom View (View menu)

Displays only the columns you choose, giving you the flexibility to display only the information you want to see. Custom view is also useful for printing the database diagram because you can display more tables on one page, and won't normally see horizontal scroll bars on the tables.


Column Properties View (View menu)

Displays a grid of all table columns, column properties, and property settings in the database diagram. In Column Properties view, you can edit the column properties directly by typing in a cell or using the Cut, Copy, and Paste commands on the Edit menu. You can also move and delete entire column definitions. Column Properties view provides blank grid rows, so you can easily add new column definitions to your database table.


Column Names View (View menu)

Displays the names of all the columns in the table listed by name. In Column Names view, you can rename column names. When you add an existing table to a database diagram, the table is shown in this view.


Keys View (View menu)

Displays the names of all the columns in the table that either are primary keys, are foreign keys, or have unique constraints. In Keys view, you can rename columns.


Name Only (View menu)

Displays a table in its minimized state, and shows only the table name. Name Only view is useful when you're working with a large number of tables because you can see more of the tables in your database diagram at one time.


Show Table (View menu)

Displays the Show Table List, which lets you add a table to the database diagram by selecting a table in the Show Table List and then dragging the table into the database diagram.


Hide Table (View menu)

Hides the selected table in the database diagram. To select a table, click anywhere in the table.


Delete Table from Database

Deletes the selected table permanently from the database after you save the diagram. Deleting a table in a database diagram automatically removes any relationships to the table.


Delete Relationship from Database

Removes the relationship line from your database diagram and from every other diagram in which the relationship line appears. The relationship is deleted from the database when you save the diagram.


Zoom Selection (View menu)

Zooms the view to a selected object.


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

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


Back Color button (Formatting toolbar)
Fill/Back Color (Formatting toolbar)

Applies colors in a form, report, or data access page to: The background of the selected control(s), the background of a section that doesn't have its Picture property set to picture, or an entire datasheet.


Transparent button

Applies a clear background, line or border to the selected control(s).


Bold button (Formatting toolbar)
Bold (Formatting toolbar)

Makes text bold in the current datasheet or the selected control(s) in a form, report, or data access page. On a page, this also makes selected text bold in the body of the page.


Border Color button (Formatting toolbar)
Line/Border Color (Formatting toolbar)

Applies a color or makes transparent the line or border of the selected control(s) or datasheet. Select the color you want to apply, or click Transparent to apply a clear line or border.


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

Applies the narrowest line or border width to the selected control(s).


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

Applies a 1-point line or border width to the selected control(s).


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

Applies a 2-point line or border width to the selected control(s).


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

Applies a 3-point line or border width to the selected control(s).


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

Applies a 4-point line or border width to the selected control(s).


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

Applies a 5-point line or border width to the selected control(s).


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

Applies a 6-point line or border width to the selected control(s).


Bound Object Frame tool (Toolbox)
Bound Object Frame (Toolbox)

Use to display 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 is displayed on the form or report as you move from record to record.


Center button (Formatting toolbar)
Center (Formatting toolbar)

Centers text within the selected control(s). On a data access page, this also centers the text selected in the body of the page.


Combo Box tool (Toolbox)
Combo Box (Toolbox)

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.


Command Button (Toolbox)

Use to perform actions, such as finding a record, printing a record, or applying a form filter.


Control Wizards tool (Toolbox)
Control Wizards (Toolbox)

Turns control wizards on or off. Use control wizards to help you create a control, such as a list box or command button. In a form, additional wizards are available for a combo box, option group, subreport, and subform. And in a data access page, you can use a wizard to create a drop-down list box or a Microsoft Office chart. To use wizards to create a control, the Control Wizards button must be pressed in.

You cannot use any wizards in a stand-alone page, and you cannot use them when you point a page to a database other than the database currently open.


Field List button (Form Design toolbar)
Field List (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)

Changes the font size of all text in the current datasheet or the selected control(s) in a form, report, or data access page. On a page, this also changes the font size of selected text in the body of the page.


Font Name box (Formatting toolbar)
Font box (Formatting toolbar)

Changes the font of all text in the current datasheet or the selected control(s) in a form, report, or data access page. On a page, this also changes the font of selected text in the body of the page.


Fore Color button (Formatting toolbar)
Font/Fore Color (Formatting toolbar)

Applies color to the text on a datasheet or the text in the selected control(s) on a form, report, or data access page. On a page, this also applies color to the selected text in the body of the page.


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

Adds or removes a header and footer section. Use these sections, for example, to display titles, instructions, or command buttons. These sections appear at the top and bottom of the Form window and at the beginning and end of a printout, but don't appear in Datasheet view.


Italic button (Formatting toolbar)
Italic (Formatting toolbar)

Italicizes all text in the current datasheet or the selected control(s) in a form, report, or data access page. On a page, this also italicizes the selected text in the body of the page.


Label tool (Toolbox)
Label (Toolbox)

A control that displays descriptive text, such as a title, a caption, or instructions on a form, report, or data access page. Labels on forms and reports can contain hyperlinks, but hyperlinks in a report won't work when viewed in Microsoft Access; hyperlinks will work when you output the report to Microsoft Word, Microsoft Excel, or to HTML format. Access automatically attaches labels to the controls you create.


Align Left button (Formatting toolbar)
Align Left (Formatting toolbar)

Aligns text to the left within the selected control(s). On a data access page, this also aligns to the left the selected text in the body of the page.


Line tool (Toolbox)
Line (Toolbox)

Use on a form, report, or data access page to emphasize related or especially important information or to divide a form or page into different sections, for example.


List Box tool (Toolbox)
List Box (Toolbox)

Displays a scrollable list of values. When a form is open in Form view or when a data access page is open in Page view or Microsoft Internet Explorer, you can select from the list to enter a value into a new record or to change the value in an existing record.


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

Adds or removes a page header and footer section to a form or report. Use page headers to display titles or column headings, for example. Use page footers to display page numbers or dates, for example.


Underline button (Formatting toolbar)
Underline (Formatting toolbar)

Underlines all text in the current datasheet or the selected control(s) in a form, report, or data access page. On a page, this also underlines the selected text in the body of the page.


Option Button tool (Toolbox)
Option Button (Toolbox)

Use as a stand-alone control bound to a Yes/No field in a Microsoft Access database or a Bit column in a Microsoft Access project. The option button is an unbound control for accepting user input in a custom dialog box or in part of an option group.


Toggle Button tool (Toolbox)
Toggle Button (Toolbox)

Use as a stand-alone control bound to a Yes/No field in a Microsoft Access database or a Bit column in a Microsoft Access project. The toggle button is an unbound control for accepting user input in a custom dialog box or in part of an option group.


Check Box tool (Toolbox)
Check Box (Toolbox)

Use as a stand-alone control bound to a Yes/No field in a Microsoft Access database or a Bit column in a Microsoft Access project. The check box is an unbound control for accepting user input in a custom dialog box or in part of an option group.


Option Group tool (Toolbox)
Option Group (Toolbox)

Use along with 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 shipped by air, sea, or land. In a data access page, an option group can contain only option buttons.


Object Frame tool (Toolbox)
Unbound Object Frame (Toolbox)

Use to display 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.


Page Break tool (Toolbox)
Page Break (Toolbox)

Use to begin a new screen on a form, a new page on a printed form, or a new page of a report.


Image Frame tool (Toolbox)
Image (Toolbox)

Use 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 after you've added it to a form or report.


Rectangle tool (Toolbox)
Rectangle (Toolbox)

Use for graphic effects, such as grouping a set of related controls, or use for emphasizing important data on a form, report, or data access page.


Subform/Subreport tool (Toolbox)
Subform/Subreport (Toolbox)

Use to display data from more than one table on a form or report.


Text Box tool (Toolbox)
Text Box (Toolbox)

Use to display, enter, or edit data in the underlying record source of a form, report, or data access page, display the results of a calculation, or accept input from a user.


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

Aligns text to the right within the selected control(s). On a data access page, this also aligns to the right the selected text in the body of the page.


Select Objects tool (Toolbox)
Select Objects

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


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

Switches to the Form view of the current form.


Subform Datasheet command (View menu)
Subform Datasheet (View menu)

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


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

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 (Format menu)

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


Duplicate command (Edit menu)
Duplicate (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 Left (Format menu)

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 Right (Format menu)

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 (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 (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 (Format menu)

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 (Format menu)

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 (Format menu)

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


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

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


Ruler command (View menu)
Ruler (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 (Format menu)

Turns Snap To Grid on and off. When on, Microsoft Access aligns controls with points on the grid. When off, you can place controls anywhere on the form, report, or data access page.


Grid command (View menu)
Grid (View menu)

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


Macro Names button (Macro toolbar)
Macro Name (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 (View menu)

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.


Run command (Macro menu)
Run (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 (Run menu)

Switches the single step mode on or off. When single step mode is on, you can run the actions one by one.


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

Exports database objects as text to a Microsoft Notepad file from any view. For tables, queries, views, stored procedures, and forms, regardless of the current view, Microsoft Access exports the datasheet to Notepad. From Datasheet view, you can select a portion of the datasheet to export.


Design View button (Tool button well)
Design View (View menu)

Switches from the current view to the Design view of the active table, query, view, stored procedure, form, or report.


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

Switches from the current view to the Datasheet view for the active table, query, view, stored procedure, or form.


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

Saves the active form as a report. Use, 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)
Special Effect Flat

Applies a flat effect to the cells on a datasheet, or to the selected control or controls on a form, report, or data access page.


Raised button (Tool button well)
Special Effect Raised

Applies a raised effect to the cells on a datasheet, or to the selected control or controls on a form, report, or data access page. This effect overrides any settings for a control's BorderColor, BorderWidth, and BorderStyle properties.


Sunken button (Tool button well)
Special Effect Sunken

Applies a sunken effect to the cells on a datasheet, or to the selected control or controls on a form, report, or data access page. This effect overrides any settings for a control's BorderColor, BorderWidth, and BorderStyle properties.


Etched button (Tool button well)
Special Effect Etched

Applies an etched or "engraved" effect to the selected control. This effect overrides any settings for the control's BorderColor, BorderWidth, and BorderStyle properties.


Chiseled button (Tool button well)
Special Effect Chiseled

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)
Special Effect Shadowed

Applies a shadowed effect to the selected control.


Solid button (Tool button well)
Line Style Solid

Applies a solid border to the selected control.


Dashes button (Tool button well)
Line Style Dashes

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


Short Dashes button (Tool button well)
Line Style Short Dashes

Applies short dashes to the border of the selected control.


Dots button (Tool button well)
Line Style Dots

Applies a dotted border to the selected control.


Sparse Dots button (Tool button well)
Line Style Sparse Dots

Applies sparse dots to the border of the selected control.


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

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


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

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

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


SQL View button (Query Design toolbar)
SQL View (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).


Select command (File menu) or button (Query Design toolbar)
Select Query (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 Query (Query menu)

Makes the active query 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 (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.


Append command (File menu) or button (Query Design toolbar)
Append Query (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.


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

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


Delete command (File menu) or button (Query Design toolbar)
Delete Query (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.


Run command (Query Menu) or button (Query Design toolbar)
Run (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.


Totals comand (View menu) or button (Query Design toolbar)
Totals (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 (Query Design toolbar)

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


Close button (Filter toolbar)
Close button

Closes the active window. In the Filter By Form and Advanced Filter/Sort windows, it does not apply a filter to the current datasheet or form.


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

Clears the fields in the grid (Microsoft Access database only) or filter ( Access database or Microsoft Access project). Also, in Query Design view, clears any parameters in the Query Parameters dialog box (Access database only). 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 (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 (File menu)

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


Layout Preview buttonLayout Preview command (View menu)
Layout Preview (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 buttonSorting and Grouping command (View menu)
Sorting and Grouping (View menu)

Use to add, delete, and change the following: Fields or expressions to group on (reports only), sort order, and group properties such as headers and footers.


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

Displays one full page in Print Preview or Layout Preview.


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

Displays two full pages in Print Preview or Layout Preview.


Page Setup button (Print Preview toolbar)
Page Setup (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 box

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


Publish it with MS Word button (Print Preview toolbar)
OfficeLinks Publish It with MS Word (Tools menu)

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 file name 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)
OfficeLinks Analyze It with MS Excel (Tools menu)

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 file name 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 (Print/Layout Preview toolbar)

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.


Stored Procedure Design

Switches from Datasheet view to Design view.


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

Switches between setting and removing a primary key field, which is a unique identifier for each record in the table. Each table should include a field or set of fields that uniquely identify each record stored in the table.


Indexes button (Table Design toolbar)
Indexes (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)
Rows (Insert menu)

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

View or window	Type of row
Table Design view	Field or column
Query Design view   (Microsoft Access database only)	Criteria
Query Designer   (Microsoft Access project only)	Column (with optional criteria)
Advanced Filter/Sort window   (Microsoft Access database only)	Criteria
Macro window	Action
Database Diagram window   (Microsoft Access project only)	Column (selected table in Column Properties view or Custom view)


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

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


Build button (Table Design toolbar)
Build button (Design toolbars)

Displays a builder for the selected item or property. Microsoft Access enables this button only if a builder is available for a 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 (Relationships and 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.


Show Direct Relationships button (Relationships toolbar)
Show Direct (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.


Show All Relationships button (Relationships toolbar)
Show All (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

Displays the Database window, which lists all objects in the current Microsoft Access database or Microsoft Access project. Use, for example, to create, copy, or delete a database object, or to drag an object to a group or to the current window.


Page (Insert menu)

Creates a new data access page by using the Page Wizard, page Design view, or an existing Web page.


View (Insert menu)

Creates a new view in Design view.


Diagram (Insert menu)

Creates a new database diagram in Design view.


Stored Procedure (Insert menu)

Creates a new stored procedure in Design view.


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

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 (Records menu)

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 (Records/Filter menu)

Filters records by 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 (Records/Filter menu)

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


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

Searches for a string, such as an employee's last name in a datasheet or form.


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

Searches for a string, such as an employee's last name in a datasheet or form, and replaces it with another string.


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

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.


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

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 (Edit menu)

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


AutoForm command (Insert menu)
AutoForm (Insert menu)

Automatically creates a form based on the selected table, query, view, or stored procedure.


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

Automatically creates a report based on the selected table, query, view, or stored procedure.


New Table button (Table Datasheet Toolbar) Table command (Insert menu)
Table (Insert menu)

Creates 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)
Query (Insert menu)

Creates a new query using one of the query wizards or query Design view.


New Form button (Table Datasheet Toolbar) Form command (Insert menu)
Form (Insert menu)

Creates a new form using one of the form wizards or form Design view.


New Report button (Table Datasheet Toolbar) Report command (Insert menu)
Report (Insert menu)

Creates a new report using one of the report wizards or report Design view.


New Macro button (Table Datasheet Toolbar) Macro command (Insert menu)
Macro (Insert menu)

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


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

Saves changes to data in the current record.


Font button (Toolbar Well, Datasheet Group) Font command (Format menu)
Font (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 (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 (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)
Unhide Columns (Format menu)

Displays previously hidden columns.


Freeze Column button (Toolbar Well, Records Group) Freeze Column command (Format menu)
Freeze Columns (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)
Go To First (Edit menu)

Moves to the first record in the datasheet or form.


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

Moves to the last record in the datasheet or form.


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

Moves to the next record in the datasheet or form.


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

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.


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

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


View Design

Switches from Datasheet view to Design view.


Defines a relationship between two tables.


Replication Create Publication (Tools menu)

Starts the Create Publication Wizard so that you can enable a database for publication and select tables or stored procedures as articles to be published. You can specify what types of subscriptions are allowed, how the subscriptions are initially synchronized, and the format for published data. To use this feature, you must install Microsoft Data Engine (MSDE) or Microsoft SQL Server version 7.0 on your computer.


Replication Pull Subscription (Tools menu)

Starts the Pull Subscription Wizard so that you can create a pull subscription, in which the subscriber maintains a subscription by pulling, or requesting, a replication of a publication from a publisher. To use this feature, you must install Microsoft Data Engine (MSDE) or Microsoft SQL Server version 7.0 on your computer.


Replication Subscription Properties (Tools menu)

Modifies the properties related to a subscription (for example, the name of the subscription database in which the subscription will be created and the synchronization options) and provides visual feedback on the current status of a subscription. To use this feature, you must install Microsoft Data Engine (MSDE) or Microsoft SQL Server version 7.0 on your computer.


Replication Publisher Properties (Tools menu)

Provides a central location to review and modify the properties of a publication, including article definitions, vertical partitions, horizontal partitions, subscriptions, and the current status of a publication. You can also select a distribution database to be used by the publisher and select subscribers. To use this feature, you must install Microsoft Data Engine (MSDE) or Microsoft SQL Server version 7.0 on your computer.


Replication Push Subscription (Tools menu)

Starts the Push Subscription Wizard so that you can create a push subscription, in which the publisher pushes data changes to subscribers, eliminating the need to administer each subscriber separately. Push subscriptions are used to send changes to subscribers as soon as they occur, or they can be used on a scheduled basis. To use this feature, you must install Microsoft Data Engine (MSDE) or Microsoft SQL Server version 7.0 on your computer.


Fill

A report magnification that fills the Report Snapshot window in the following way: If the report is in portrait orientation, the report width or short side of the page fits the window; If the report is in landscape orientation, the height or short side of the page fits the window.


report snapshot

A file (.snp extension) that contains a high-fidelity copy of each page of a Microsoft Access report and that preserves the two-dimensional layout, graphics, and other embedded objects of the report.


Snapshot Viewer

A program that you can use to view, print, and mail a snapshot, such as a report snapshot. Snapshot Viewer version 9.0 consists of a stand-alone executable program, a Snapshot Viewer control (Snapview.ocx), and other related files. You can install Snapshot Viewer when you install or reinstall Microsoft Access 2000. By default, it is automatically installed by Microsoft Access 2000 the first time you create a report snapshot. You can also install Snapshot Viewer from the World Wide Web software download page located at the Microsoft Access Developer's Web site.


Snapshot Viewer control

An ActiveX control (Snapview.ocx) that you use to view a snapshot report from Microsoft Internet Explorer version 3.0 or later, or from any application that supports ActiveX controls, such as Microsoft Access or Microsoft Visual Basic.


SourceSafe Add Database to SourceSafe (Tools menu)

Adds a database file (and all the objects it contains) to source code control.


SourceSafe Get Latest Version (Tools menu)

Gets the last version of an object and places a read-only copy in your working folder.


SourceSafe Check Out (Tools menu)

Checks out an object to your working folder so you can work on it.


SourceSafe Check In (Tools menu)

Checks in an object to source code control, saving your changes.


SourceSafe Undo Check Out (Tools menu)

Returns an object to source code control and discards any changes since the object was last checked out.


SourceSafe Show History (Tools menu)

Shows the source code control history of an object or a database. Historical information includes creation, labeling, check-ins, shares, and branches.


SourceSafe Show Differences (Tools menu)

Shows the differences between the local database object in your working folder and the version of that object checked in to source code control.


SourceSafe Properties (Tools menu)

Shows properties of the selected object in a source code control project. To show properties for the entire source code control project, hold down the SHIFT key when clicking this command.


SourceSafe Add Objects to SourceSafe (Tools menu)

Adds one or more objects in a database to source code control.


SourceSafe Share Objects (Tools menu)

Shares an object in a database with another source code control project.


SourceSafe Create .MDB from SourceSafe Project (Tools menu)
SourceSafe Create Database from SourceSafe Project (Tools menu)

Creates a new database file using existing objects.


SourceSafe Run SourceSafe (Tools menu)

Runs the Microsoft Visual SourceSafe Explorer.


SourceSafe Refresh Object Status (Tools menu)

Updates your view of the information for all objects in a database file. For example, if someone has just checked out an object in the database, you can refresh your view to see that object's current status.


SourceSafe Options (Tools menu)

Changes the behavior of automatic source code control operations, such as Get, Check In, Add Files, and Delete.


Subdatasheet Expand All (Format menu)

Expands all subdatasheets in the datasheet or subdatasheet that currently has focus.


Subdatasheet Collapse All (Format menu)

Collapses all subdatasheets in the datasheet or subdatasheet that currently has focus.


Subdatasheet (Insert menu)

Inserts a subdatasheet in a table or query in a Microsoft Access database. In a subdatasheet, you can view and edit related or joined data in a table, query, form datasheet, or subform.


Subdatasheet Remove (Format menu)

Removes a subdatasheet from a table or query in a Microsoft Access database.