Microsoft Access 97 Command Summary



Microsoft Access 97

Command Summary

[pic]

[pic]

Contents

Overview v

All Windows 7

File Menu 7

Tools Menu (Except the Module Window) 9

Window Menu 13

Help Menu 14

Database Window 15

Edit Menu 15

View Menu 16

Insert Menu 17

Relationships Window 18

Edit Menu 18

View Menu 18

Relationships Menu 18

Table Design View 19

Edit Menu 19

View Menu 20

Insert Menu 20

Datasheet and Form Browse View 21

Edit Menu 21

View Menu 23

Insert Menu 24

Format Menu 25

Records Menu 26

Query Design View 27

Edit Menu 27

View Menu 28

Insert Menu 28

Query Menu 29

Advanced Filter/Sort and Filter By Form Windows 30

Edit Menu 30

View Menu 30

Insert Menu 31

Filter Menu 31

Contents - continued

Form/Report Design View 32

Edit Menu 32

View Menu 33

Insert Menu 34

Format Menu 35

Print/Layout Preview 37

Edit Menu 37

View Menu 38

Macro Design View 39

Edit Menu 39

View Menu 39

Insert Menu 40

Run Menu 40

Module Window 41

Edit Menu 41

View Menu 43

Insert Menu 43

Debug Menu 44

Run Menu 45

Tools Menu 45

Object Browser 46

Toolbars 47

Formatting Toolbar (Datasheet) 47

Formatting Toolbar (Form/Report) 48

Toolbox 50

Web Toolbar 52

SourceSafe Toolbar 53

Standard Buttons 54

Additional Buttons 55

Unique Shortcut Menu Commands 57

Overview

The Microsoft Access 97 Command Summary includes the name of each command in Microsoft® Access 97, its corresponding button, if any, and a description of the command.

Menu Commands

Most but not all commands are available from the menus in each window or view. Four menus are common to all windows and they are listed first: File, Tools (except for the Module window), Window, and Help. The commands on each of these common menus are usually the same, but any exceptions are noted. Additional menu commands for each window or view are then listed. In this case, you will notice some duplication of commands (for example, the Undo command is listed in each Edit menu), but this was done to reflect the user interface.

Toolbars and Buttons

Many commands are only available on toolbars, and these are listed according to the standard toolbar they normally reside on, such as the Toolbox or the Web toolbar. Several buttons are available on many of the toolbars, and these are listed next. Finally, there are several additional buttons that are located on the Commands tab of the Customize dialog box (on the View menu, click Toolbars, and then click Customize), and these are listed by their category in the Categories list box.

Unique Shortcut Menu Commands

Most commands have corresponding shortcut menu commands. These are not included here since the shortcut menu command usually performs the same action as its corresponding menu command or button. However, there are several unique shortcut menu commands that have no corresponding menu command or button, and these are listed. If you want to see a complete list of shortcut menu commands in the product, select Customize from the Toolbars command on the View menu, click the Toolbars tab, and then click the check box to the left of Shortcut Menus at the bottom of the Toolbars list box.

[pic] Displaying Screen Tips

You can also view command summary information in the user interface by displaying a ScreenTip. To see a ScreenTip for a menu command or toolbar button, click What's This on the Help menu or press SHIFT+F1, and then click the element you want information about.

All Windows

|File Menu |

|[pic] |New Database… |Creates a new database. |

|[pic] |Open Database… |Opens an existing database. |

| |Get External Data [pic] | |

|[pic] |Import… |Copies data from a text file, spreadsheet, or database table into a Microsoft® Access 97 table. Also, |

| | |copies objects from another Microsoft Access database into the current database. |

|[pic] |Link Tables… |Links data from a table in another database to a Microsoft Access 97 table in the current database. |

| |Close |Closes the current window. If you have made changes to the design of a database object and not yet saved |

| | |it, Microsoft Access asks if you want to save it. |

|[pic] |Save |Saves the layout of a datasheet; design of a table, query, form, or report; or structure and content of a|

| | |macro or module. |

| |Save As/Export… |Saves a copy of a selected object in the current database under a different name. |

| | |Exports the output of a selected object to an external file (such as text or rich-text format) or to an |

| | |external database (such as Microsoft Access or Paradox). |

| | |Converts a selected macro to a new Visual Basic® module. |

|[pic] |Load From Query… |Displays a list of applicable queries you can use to load a query to filter the active table, form, or |

| |(Filter By Form and Advanced |query. |

| |Filter/Sort windows only) | |

|[pic] |Save As Query |Saves the active filter as a query, including the criteria and sort order. |

| |(Filter By Form and Advanced | |

| |Filter/Sort windows only) | |

| |Save As Text… |Saves the module and all its procedures to a text file. Use to archive modules, or transfer them to other|

| |(Module window only) |products or other Microsoft Access versions. |

| |Save As HTML |Starts the Publish to the Web wizard, which creates or modifies a Web publication. You can select any |

| | |combination of database objects for export to static (.html) or dynamic (.idc/.htx and .asp) formats, and|

| | |store various option settings in a Web publication profile. |

All Windows

|File Menu - continued |

|[pic] |Page Setup |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). |

|[pic] |Print Preview |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. |

|[pic] |Print… |Prints a form, report, table, query, or module. Displays the Print dialog box first so you can change |

| | |printer settings and properties. |

| | |In the Macro window, displays the Documenter, so you can choose to print one or more report sections. |

| | |Then, it prints the macro report to the default printer. |

|[pic] |Send… |Sends the output of a table, query, form, report, or module through your electronic mail program. You can|

| | |send all of an object's output or a selected portion of a datasheet in one of the following formats: |

| | |HTML, MS-DOS text, rich-text format, or Microsoft Excel. |

| |Database Properties |Displays database properties so you can view or modify them. |

| |1, 2, 3, 4 |Lists most recently used databases. To open a file from the list, click it. |

| |Exit |Ends your Microsoft Access session. If you have made changes to the design of a database object and not |

| | |yet saved them, Microsoft Access asks if you want to save them. |

All Windows

|Tools Menu (Except the Module Window) |

|[pic] |Spelling… |Checks the spelling of text entries in table, query, or form Datasheet view or selected text in a text |

| | |box in Form view. |

| |AutoCorrect… |Customizes the settings used to automatically correct text as you type, and creates and modifies the list|

| | |of words to correct as you type. |

| |OfficeLinks [pic] | |

|[pic] |Merge It with MS Word |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. |

|[pic] |Publish It with MS Word |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. |

|[pic] |Analyze It with MS Excel |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. |

|[pic] |Relationships… |Displays the Relationships window so you can view, edit, or define relationships between tables and |

| | |queries. |

| |Analyze [pic] | |

|[pic] |Table |Starts the Table Analyzer Wizard, which analyzes a table, and if necessary, splits it into related tables|

| | |to create a more efficient table design. |

|[pic] |Performance |Starts the Performance Analyzer, which analyzes the performance of your database and its objects. |

|[pic] |Documenter |Starts the Documenter, which provides detailed descriptions of one or more database objects. |

| |Database Utilities [pic] | |

| |Convert Database… |Converts a database of a prior version of Microsoft Access to a Microsoft Access 8.0 database. |

| |Compact Database |Rearranges how a fragmented database is stored on disk. Compacting a database often reduces its size and |

| | |improves its performance. |

| |Repair Database |Repairs a damaged database. The database may become damaged if, for example, there is a power outage or |

| | |your computer experiences a hardware problem while the database is in use. |

|[pic] |Make MDE File… |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. |

All Windows

|Tools Menu (Except the Module Window) - continued |

| |Security [pic] | |

| |Set Database Password… |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. |

|[pic] |User and Group Permissions… |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… |Displays, prints, adds, removes, and changes user and group accounts. Also, changes the password of the |

| | |default user account, Admin. |

| |User-Level Security Wizard… |Starts the User-Level Security Wizard, which creates a new, secured copy of the current database. |

| |Encrypt/Decrypt Database… |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. |

| |Replication [pic] | |

| |Synchronize Now… |Synchronizes the open replica or Design Master with another member in the replica set. |

|[pic] |Create Replica… |Creates a replica of the open database at a designated location. You can also create a replica by |

| | |dragging the database from the Database window to the Windows® Briefcase on the desktop. |

| |Resolve Conflicts… |Starts the Conflict Resolver, which displays the records that were in conflict during previous |

| | |synchronizations between the open replica or Design Master and other members in the replica set. |

| |Recover Design Master… |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. |

| |Startup… |Controls and customizes various database startup properties and actions, such as application title and |

| | |icon, and which startup form to display. |

All Windows

|Tools Menu (Except the Module Window) - continued |

| |Macro[pic] | |

| |(Database window, Form/Report Design | |

| |view only) | |

| |Run Macro… |Runs a macro. |

| |(Not a subcommand in many windows) | |

| |Convert Form's/Report's Macros To |Converts a macro to Visual Basic event procedures in the form or report module. |

| |Visual Basic | |

| |Create Menu from Macro |Creates a new Microsoft Access 97-style menu bar from a selected macro. |

| |(Database window only) | |

| |Create Toolbar from Macro |Creates a new Microsoft Access 97-style toolbar from a selected macro. |

| |(Database window only) | |

| |Create Shortcut Menu from Macro |Creates a new Microsoft Access 97-style shortcut menu from a selected macro. |

| |(Database window only) | |

| |SourceSafe [pic] | |

| |(Office Developer Environment only) | |

| |Create Database from SourceSafe |Creates a new database file using existing objects. |

| |Project | |

| |Add Database to SourceSafe |Adds a database file (and all the objects it contains) to source code control. |

|[pic] |Run SourceSafe |Runs the Microsoft Visual SourceSafe® Explorer. |

| |Options |Changes the behavior of automatic source code control operations, such as Get, Check In, Add Files, and |

| | |Delete. |

|[pic] |ActiveX Controls… |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. |

All Windows

|Tools Menu (Except the Module Window) - continued |

| |Add-Ins [pic] | |

| |Add-In Manager |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 Splitter |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. |

| |Linked Table manager |Displays or refreshes links to tables. Use, for example, to refresh links when the structure or location |

| | |of a linked table has changed. |

| |Switchboard Manager |Creates, edits, and deletes switchboard forms for an application. |

| |Options… |Customizes characteristics of the Microsoft Access environment, such as screen fonts and colors, keyboard|

| | |actions, and viewing options. |

All Windows

|Window Menu |

| |Split |Toggles between splitting the Module window into two panes and restoring the two panes to one window. To |

| |(Module window only) |size the panes, move the split bar vertically. In a split window, you cannot view procedures from |

| | |different modules. |

| |Tile Horizontally |Arranges windows in Microsoft Access as horizontal panes so that all windows are visible and don’t |

| | |overlap. |

| |Tile Vertically |Arranges windows in Microsoft Access as vertical panes so that all windows are visible and don’t overlap.|

| |Cascade |Arranges windows in Microsoft Access in an overlapping pattern so that the title bar of each window |

| | |remains visible. |

| |Arrange Icons |Arranges all icons of minimized database objects into rows across the bottom of the Microsoft Access |

| | |window. |

| |Hide |Hides the active window. The window remains open when hidden. To redisplay a hidden window, choose Unhide|

| | |on the Window menu. |

| |Unhide… |Displays hidden windows. |

| |Size To Fit Form |Adjusts the size of the Form view window (using the DefaultView property setting) to display only whole |

| |(Form Browse window only) |records. |

| |1, 2, 3...9 |Lists all visible windows. To bring a window to the front, click it. |

All Windows

|Help Menu |

|[pic] |Office Assistant |The Office Assistant provides Help topics and tips to help you accomplish your tasks. |

|[pic] |Contents and Index |Provides various entry points to Microsoft Access Help. You can display Help contents organized by |

| | |category, use an alphabetized index, or search for a specific topic. |

|[pic] |What’s This? |Displays a tip 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 [pic] in the dialog box's title bar and then click the |

| | |item you want help on. |

| |Microsoft on the Web[pic] | |

|[pic] |Free Stuff |Connects to a Microsoft page that provides free Microsoft Access information and software. |

|[pic] |Product News |Connects to the Microsoft Access general user home page. |

|[pic] |Developer Forum |Connects to the Microsoft Access developer home page. |

|[pic] |Frequently Asked Questions |Connects to the Microsoft technical support page that provides answers to frequently asked questions |

| | |about Microsoft Access. |

|[pic] |Online Support |Connects to the Microsoft Access technical support home page. |

|[pic] |Microsoft Office Home Page |Connects to the Microsoft Office home page. |

|[pic] |Send Feedback… |Connects to the Microsoft Office feedback page. |

|[pic] |Best of the Web |Connects to the Microsoft Internet Explorer page that lists a variety of interesting home pages on the |

| | |World Wide Web. |

|[pic] |Search the Web… |Connects to the Microsoft search page. |

|[pic] |Web Tutorial |Connects to a Microsoft Internet tutorial page. |

|[pic] |Microsoft Home Page |Connects to the Microsoft home page. |

| |About Microsoft Access |Provides information about Microsoft Access 97 and the operating system installed on your computer, and |

| | |instructions for contacting Microsoft Product Support Services. |

Database Window

|Edit Menu |

|[pic] |Undo |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. |

|[pic] |Cut |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. |

|[pic] |Copy |Copies the selected item (for example, a control or a record) to the Clipboard so you can insert it |

| | |elsewhere. |

|[pic] |Paste |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. |

| |Create Shortcut… |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. |

| |Delete |Removes the selected item permanently without placing it on the Clipboard. |

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

Database Window

|View Menu |

| |Database Objects[pic] | |

|[pic] |Tables |Displays in the Database window a list of the tables in the current database. |

|[pic] |Queries |Displays in the Database window a list of the queries in the current database. |

|[pic] |Forms |Displays in the Database window a list of forms in the current database. |

|[pic] |Reports |Displays in the Database window a list of the reports in the current database. |

|[pic] |Macros |Displays in the Database window a list of the macros in the current database. |

|[pic] |Modules |Displays in the Database window a list of the modules in the current database. |

|[pic] |Large Icons |Lists database objects by using large icons for the selected object type. |

|[pic] |Small Icons |Lists database objects by using small icons for the selected object type. |

|[pic] |List |Lists database objects by using small icons for the selected object type. Icons are alphabetized |

| | |vertically within the Database window. |

|[pic] |Details |Lists database objects for the selected object type and provides the following details: name, |

| | |description, last date modified, date created, type, and owner. |

| |Arrange Icons [pic] | |

|[pic] |By Name |Arranges object icons in the Database window alphabetically by name. |

|[pic] |By Type |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. |

|[pic] |By Created |Arranges object icons in the Database window by their creation date. |

|[pic] |By Modified |Arranges object icons in the Database window by their modification date. |

| |Auto Arrange |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. |

| |Line Up Icons |Aligns icons in the Database window with the nearest points on the underlying grid. |

|[pic] |Properties |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. |

|[pic] |Code |Displays the code behind a selected form or report in the Module window. |

| |Toolbars [pic] | |

| |Toolbar Name |Displays or hides toolbars. To display a toolbar, select the check box next to the toolbar name. To |

| | |hide a toolbar, clear the check box. |

| |Customize... |Customizes toolbar buttons, menu commands, and shortcut key assignments. |

Database Window

|Insert Menu |

|[pic] |Table |Creates a new table using the Table Wizard, table Datasheet view, table Design view, or Import/Link |

| | |Table. |

|[pic] |Query |Creates a new query using one of the query wizards or query Design view. |

|[pic] |Form |Creates a new form using one of the form wizards or form Design view. |

|[pic] |Report |Creates a new report using one of the report wizards or report Design view. |

|[pic] |Macro |Displays the Macro window so you can create a new macro. |

|[pic] |Module |Inserts a new module into the current database and displays its Declarations section in the Module |

| | |window. |

|[pic] |Class Module |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. |

|[pic] |AutoForm |Automatically creates a form based on the selected table or query. |

|[pic] |AutoReport |Automatically creates a report based on the selected table or query. |

Relationships Window

|Edit Menu |

|[pic] |Cut |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. |

|[pic] |Copy |Copies the selected item (for example, a control or a record) to the Clipboard so you can insert it |

| | |elsewhere. |

|[pic] |Paste |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. |

| |Delete |Removes the selected item permanently without placing it on the Clipboard. In the Relationship window, |

| | |deleting a relationship line deletes the relationship between the two tables. |

|[pic] |Clear Layout |Clears the Relationships window. Clearing the layout does not delete actual tables, queries, or |

| | |relationships. |

|View Menu |

| |Toolbars [pic] | |

| |Toolbar Name |Displays or hides toolbars. To display a toolbar, select the check box next to the toolbar name. To hide |

| | |a toolbar, clear the check box. |

| |Customize... |Customizes toolbar buttons, menu commands, and shortcut key assignments. |

|Relationships Menu |

|[pic] |Show Table… |Shows one or more tables or queries that you can add to the Relationships window or the active query in |

| | |query Design view. |

| |Hide Table |Hides the selected table or query in the Relationships window. To select a table or query, click anywhere|

| | |in its field list. |

| |Edit Relationships… |Displays settings for the selected relationship line so you can modify the relationship. You can also |

| | |double-click the relationship line to display settings. |

|[pic] |Show Direct |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. |

|[pic] |Show All |Displays in the Relationships window all the tables and queries that have relationships defined in the |

| | |current database (if they are not already displayed). |

Table Design View

|Edit Menu |

|[pic] |Undo |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. |

|[pic] |Cut |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. |

|[pic] |Copy |Copies the selected item (for example, a control or a record) to the Clipboard so you can insert it |

| | |elsewhere. |

|[pic] |Paste |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. |

| |Select All |Selects all field definitions in a table, controls in a form or report, or rows in a macro so you can, |

| | |for example, copy these items to a new object. |

| |Delete |Removes the selected item permanently without placing it on the Clipboard. |

|[pic] |Delete Rows |Deletes the selected row(s). To select a row, click the row selector [pic]. |

|[pic] |Primary Key |Toggles between setting and removing a primary key field, which is a unique identifier for each record in|

| | |the table. |

| |Test Validation Rules |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. |

Table Design View

|View Menu |

|[pic] |Design View |Switches from the current view to the Design view of the active table, query, form, or report. |

|[pic] |Datasheet View |Switches from the current view to the Datasheet view for the active table, query, or form. |

|[pic] |Properties |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. |

|[pic] |Indexes |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. |

| |Toolbars [pic] | |

| |Toolbar Name |Displays or hides toolbars. To display a toolbar, select the check box next to the toolbar name. To hide |

| | |a toolbar, clear the check box. |

| |Customize... |Customizes toolbar buttons, menu commands, and shortcut key assignments. |

|Insert Menu |

|[pic] |Rows |Creates a blank field row above the selected row. To select a row, click the row selector [pic]. |

| |Lookup Field… |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). |

Datasheet and Form Browse View

|Edit Menu |

|[pic] |Undo |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. |

|[pic] |Cut |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. |

|[pic] |Copy |Copies the selected item (for example, a control or a record) to the Clipboard so you can insert it |

| | |elsewhere. |

|[pic] |Paste |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. |

| |Paste Special… |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 as Hyperlink |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. |

| |Paste Append |Adds records from the Clipboard to the end of the active form or datasheet. Records that Microsoft Access|

| | |can't append (for example, due to validation errors) are placed in the Paste Errors table. |

| |Delete |Removes the selected item permanently without placing it on the Clipboard. |

| | |In the Relationship window, deleting a relationship line deletes the relationship between the two tables.|

| | |In query Design view, deleting a join line causes the query to return every combination of records |

| | |between the two tables, but does not delete the relationship, if any, between the two tables. |

|[pic] |Delete Record |Deletes the selected record or records from the form or datasheet. To select a record, click the record |

| | |selector [pic]. |

|[pic] |Delete Column |In table Datasheet view, permanently deletes the selected column. To select a column, click the field |

| |(Table Datasheet view only) |selector. |

| |Select Record |Selects the current record in a form or datasheet so you can, for example, copy it to another table. |

| |Select All Records |Selects all records in a form or datasheet so you can, for example, copy them to another table. |

|[pic] |Find… |Searches for a string, such as an employee's last name in a datasheet or form, or a Visual Basic keyword |

| | |in the Module window. |

|[pic] |Replace… |Searches for a string, such as an employee's last name in a datasheet or form, or a Visual Basic keyword |

| | |in the Module window, and replaces it with another string. |

Datasheet and Form Browse View

|Edit Menu - continued |

| |Go To [pic] | |

|[pic] |First |Moves to the first record in the datasheet or form. |

|[pic] |Last |Moves to the last record in the datasheet or form. |

|[pic] |Next |Moves to the next record in the datasheet or form. |

|[pic] |Previous |Moves to the previous record in the datasheet or form. |

|[pic] |New Record |Moves to the end of the form or datasheet so you can enter a new record. |

| |OLE/DDE Links |Updates, modifies, copies, reconnects, or breaks the link of the selected object. |

| |Object Type Object [pic] | |

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

| |Play |Plays the selected OLE object (such as a video clip). |

| |Run |Runs the selected OLE object (such as a sound object). |

| |Convert |Converts compatible OLE object types. |

| |Properties |Opens the property sheet for the selected OLE object. |

Datasheet and Form Browse View

|View Menu |

|[pic] |Design View |Switches from the current view to the Design view of the active table, query, form, or report. |

|[pic] |Form View |Switches to the Form view of the current form. |

| |(Form Browse/Form Datasheet only) | |

|[pic] |Datasheet View |Switches from the current view to the Datasheet view for the active table, query, or form. |

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

| |(Form Browse/Form Datasheet only) | |

| |Toolbars [pic] | |

| |Toolbar Name |Displays or hides toolbars. To display a toolbar, select the check box next to the toolbar name. To hide |

| | |a toolbar, clear the check box. |

| |Customize... |Customizes toolbar buttons, menu commands, and shortcut key assignments. |

| |Zoom [pic] | |

| |200% |Zooms the page(s) by a factor of 200 percent and makes that the new zoom setting. |

| |150% |Zooms the page(s) by a factor of 150 percent and makes that the new zoom setting. |

|[pic] |Zoom 100% |Displays the page(s) the same size as the printed page and makes that the new zoom setting. |

| |75% |Zooms the page(s) by a factor of 75 percent and makes that the new zoom setting. |

| |50% |Zooms the page(s) by a factor of 50 percent and makes that the new zoom setting. |

| |25% |Zooms the page(s) by a factor of 25 percent and makes that the new zoom setting. |

| |10% |Zooms the page(s) by a factor of 10 percent and makes that the new zoom setting. |

| |Pages [pic] | |

|[pic] |One Page |Displays one full page in Print Preview or Layout Preview. |

|[pic] |Two Pages |Displays two full pages in Print Preview or Layout Preview. |

| |Four Pages |Displays four full pages in Print Preview or Layout Preview. |

| |Eight Pages |Displays eight full pages in Print Preview or Layout Preview. |

| |Twelve Pages |Displays twelve full pages in Print Preview or Layout Preview. |

Datasheet and Form Browse View

|Insert Menu |

|[pic] |New Record |Moves to the end of the form or datasheet so you can enter a new record. |

|[pic] |Column |Inserts a new column to the left of the selected column or the column with the current insertion point. |

| |(Table Datasheet view only) | |

| |Lookup Column… |Creates a lookup field (column) for the selected data type. A lookup field looks up values from another |

| |(Table Datasheet view only) |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). |

| |Hyperlink Column |Inserts or modifies a hyperlink address or Uniform Resource Locator (URL), including the subaddress and |

| |(Table Datasheet view only) |the type of path (whether absolute or relative). In Datasheet and Form view, the hyperlink address field |

| | |must be selected. |

| |Object… |Inserts an OLE object into a bound or unbound object frame on a form or report or a selected OLE object |

| | |field in a datasheet. To edit the object using its associated application, double-click on the object. |

|[pic] |Hyperlink… |Inserts or modifies a hyperlink address or Uniform Resource Locator (URL), including the subaddress and |

| | |the type of path (whether absolute or relative). In Datasheet and Form view, the hyperlink address field |

| | |must be selected. |

Datasheet and Form Browse View

|Format Menu |

|[pic] |Font… |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. |

| |Cells… |Turns horizontal and vertical gridlines on and off, changes the cell and gridline color, and changes the |

| | |cell effect (such as sunken or raised). |

|[pic] |Row Height… |Changes the height of all rows in a datasheet. You can also resize rows by dragging the lower border of |

| | |the record selector. |

|[pic] |Column Width… |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. |

| |Rename Column |Renames the selected column. |

| |(Table Datasheet view only) |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 Column |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. |

| |Unhide Columns… |Displays previously hidden columns. |

|[pic] |Freeze Columns |Freezes the selected columns on the left side of the window to prevent them from scrolling off the |

| | |screen. |

| |Unfreeze All Columns |Unfreezes all frozen columns in a datasheet. When you unfreeze columns, they remain in the same order |

| | |they were in when frozen. |

Datasheet and Form Browse View

|Records Menu |

| |Filter [pic] | |

|[pic] |Filter By Form |Displays the Filter by Form window, which is a blank version of the active form or datasheet, so you can |

| | |filter data. |

|[pic] |Filter By Selection |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. |

| |Filter Excluding Selection |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. |

|[pic] |Advanced Filter/Sort… |Displays the Advanced Filter/Sort window so you can create a filter to apply to the datasheet or form. |

| |Sort [pic] | |

|[pic] |Sort Ascending |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. |

|[pic] |Sort Descending |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. |

|[pic] |Apply Filter/Sort |Applies a filter or sort in the active datasheet or form. |

|[pic] |Remove Filter/Sort |Removes a filter or sort in the active datasheet or form, if one is currently applied, and displays the |

| | |most current records. |

|[pic] |Save Record |Saves changes to data in the current record. |

| |Refresh |Updates records in the active form or datasheet with changes made to the data by others in a multiuser |

| | |environment. |

| |Data Entry |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. |

Query Design View

|Edit Menu |

|[pic] |Undo |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. |

|[pic] |Cut |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. |

|[pic] |Copy |Copies the selected item (for example, a control or a record) to the Clipboard so you can insert it |

| | |elsewhere. |

|[pic] |Paste |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. |

| |Delete |Removes the selected item permanently without placing it on the Clipboard. In query Design view, deleting|

| | |a join line causes the query to return every combination of records between the two tables, but does not |

| | |delete the relationship, if any, between the two tables. |

| |Delete Rows |Deletes the selected row(s). To select a row, click the row selector [pic]. |

|[pic] |Delete Columns |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. |

|[pic] |Clear Grid |Clears the fields in the grid or filter. Also, in Query Design view, clears any parameters in the Query |

| | |Parameters dialog box. Clearing fields in the grid does not delete them from the underlying table. |

Query Design View

|View Menu |

|[pic] |Design View |Switches from the current view to the Design view of the active table, query, form, or report. |

|[pic] |SQL View |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). |

|[pic] |Datasheet View |Switches from the current view to the Datasheet view for the active table, query, or form. |

|[pic] |Totals |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. |

|[pic] |Table Names |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.|

|[pic] |Properties |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. |

| |Join Properties |Changes the type of join between two tables for a selected join line. To select a join line, click the |

| | |join line (this makes the line bold). |

| |Toolbars [pic] | |

| |Toolbar Name |Displays or hides toolbars. To display a toolbar, select the check box next to the toolbar name. To hide |

| | |a toolbar, clear the check box. |

| |Customize... |Customizes toolbar buttons, menu commands, and shortcut key assignments. |

|Insert Menu |

|[pic] |Rows |Creates a blank criteria row above the selected row. To select a row, click the row selector [pic]. |

|[pic] |Columns |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. |

Query Design View

|Query Menu |

|[pic] |Run |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. |

|[pic] |Show Table… |Shows one or more tables or queries that you can add to the Relationships window or the active query in |

| | |query Design view. |

| |Remove Table |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. |

|[pic] |Select Query |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. |

|[pic] |Crosstab Query |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. |

|[pic] |Make-Table Query… |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. |

|[pic] |Update Query |Makes the active query an update query, which updates a group of records, such as increasing salaries by |

| | |5%. Because this command changes data, verify the results in Datasheet view before running it. |

|[pic] |Append Query… |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. |

|[pic] |Delete Query |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. |

| |SQL Specific [pic] | |

|[pic] |Union |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. |

|[pic] |Pass-Through |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. |

|[pic] |Data Definition |Displays the SQL window and makes the active query a data definition query, which creates or alters |

| | |tables in the current database. |

|[pic] |Parameters… |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. |

Advanced Filter/Sort and Filter By Form Windows

|Edit Menu |

|[pic] |Undo |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. |

|[pic] |Cut |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. |

|[pic] |Copy |Copies the selected item (for example, a control or a record) to the Clipboard so you can insert it |

| | |elsewhere. |

|[pic] |Paste |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. |

| |Delete |Removes the selected item permanently without placing it on the Clipboard. |

| |(Advanced Filter/Sort window only) | |

| |Delete Rows |Deletes the selected row(s). To select a row, click the row selector [pic]. |

| |(Advanced Filter/Sort window only) | |

|[pic] |Delete Columns |In the Advanced Filter/Sort window, deletes the selected column from the design grid, which in turn |

| |(Advanced Filter/Sort window only) |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. |

| |Delete Tab |Deletes the active Or tab or Look For tab so the values specified in it are no longer used as criteria to|

| |(Filter By Form window only) |filter records. |

|[pic] |Clear Grid |Clears the fields in the grid or filter. Also, in query Design view, clears any parameters in the Query |

| | |Parameters dialog box. Clearing fields in the grid does not delete them from the underlying table. |

|View Menu |

| |Toolbars [pic] | |

| |Toolbar Name |Displays or hides toolbars. To display a toolbar, select the check box next to the toolbar name. To hide |

| | |a toolbar, clear the check box. |

| |Customize... |Customizes toolbar buttons, menu commands, and shortcut key assignments. |

Advanced Filter/Sort and Filter By Form Windows

|Insert Menu |

|[pic] |Rows |Creates a blank criteria row above the selected row. To select a row, click the row selector [pic]. |

|[pic] |Columns |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. |

|Filter Menu |

|[pic] |Filter By Form |Displays the Filter By Form window, which is a blank version of the active form or datasheet, so you can |

| | |filter data. |

|[pic] |Filter By Selection |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. |

| |Filter Excluding Selection |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. |

|[pic] |Advanced Filter/Sort… |Displays the Advanced Filter/Sort window so you can create a filter to apply to the datasheet or form. |

Form/Report Design View

|Edit Menu |

|[pic] |Undo |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. |

|[pic] |Cut |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. |

|[pic] |Copy |Copies the selected item (for example, a control or a record) to the Clipboard so you can insert it |

| | |elsewhere. |

|[pic] |Paste |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. |

| |Paste Special… |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 as Hyperlink |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. |

|[pic] |Duplicate |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. |

| |Select All |Selects all field definitions in a table, controls in a form or report, or rows in a macro so you can, |

| | |for example, copy these items to a new object. |

| |Delete |Removes the selected item permanently without placing it on the Clipboard. |

| |Select Form/Report |Selects the entire form or report so you can, for example, view or modify its properties. When the Ruler |

| | |is displayed, you can also click the form selector or report selector to select the entire form or |

| | |report. |

| |OLE/DDE Links |Updates, modifies, copies, reconnects, or breaks the link of the selected object. |

Form/Report Design View

|View Menu |

|[pic] |Design View |Switches from the current view to the Design view of the active table, query, form, or report. |

|[pic] |Form View |Switches to the Form view of the current form. |

| |(Form view only) | |

|[pic] |Datasheet View |Switches from the current view to the Datasheet view for the active table, query, or form. |

| |(Form View only) | |

|[pic] |Layout Preview |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. |

|[pic] |Print Preview |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. |

|[pic] |Properties |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. |

|[pic] |Field List |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. |

|[pic] |Sorting And Grouping (Report Design |Adds, deletes, and changes the following: fields or expressions to group on, sort order, and group |

| |view only) |properties such as headers and footers. |

|[pic] |Tab Order… |Changes the order in which the insertion point moves through controls when you tab through a form. |

| |(Form Design view only) | |

|[pic] |Code |Displays the code behind a selected form or report in the Module window. |

|[pic] |Ruler |Shows or hides the rulers at the top and along the left side of a form or report in Design view. |

|[pic] |Grid |Shows or hides the grid. Use the grid to evenly size or align controls when you design a form or report. |

|[pic] |Toolbox |Shows or hides the toolbox. Use the toolbox to create controls on a form or report. |

|[pic] |Page Header/Footer |Adds or removes a page header and footer section to a form or report. Use page headers for example to |

| | |display titles or column headings. Use page footers, for example, to display page numbers or dates. |

|[pic] |Form Header/Footer |Adds or removes a header and footer section. Use these sections, for example, to display titles, |

| |(Form Design View only) |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. |

|[pic] |Report Header/Footer |Displays or removes report header and footer sections. Use the report header for introductions that |

| |(Report Design View only) |contain, for example, text, pictures, and logos. Use the report footer for summaries that contain, for |

| | |example, grand totals. |

| |Toolbars [pic] | |

| |Toolbar Name |Displays or hides toolbars. To display a toolbar, select the check box next to the toolbar name. To hide |

| | |a toolbar, clear the check box. |

| |Customize... |Customizes toolbar buttons, menu commands, and shortcut key assignments. |

Form/Report Design View

|Insert Menu |

|[pic] |Page Numbers… |Inserts a page number expression in a text box control on a form or report. You can specify format, |

| | |position, alignment, and whether or not to display the page number on the first page. |

| |Date and Time… |Inserts a current date and time expression in a text box control on a form or report. You can specify |

| | |format and whether or not to display just the date or time. |

|[pic] |Chart… |Displays Microsoft Access data in a chart on a form or report. To add a chart created with another |

| | |application, such as Microsoft Excel or Lotus 1-2-3, use the Unbound Object Frame tool or the Bound |

| | |Object Frame tool in the toolbox. |

| | |To create this control, click Chart on the File menu, and then click the form or report where you want |

| | |to place the control. Microsoft Access starts the Chart Wizard. |

| |Picture… |Inserts a picture into an image control on the form or report. Use an image control for static pictures, |

| | |such as a logo, and for fast access. |

| |Object… |Inserts an OLE object into a bound or unbound object frame on a form or report or a selected OLE object |

| | |field in a datasheet. To edit the object using its associated application, double-click on the object. |

|[pic] |ActiveX Control… |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. |

|[pic] |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. |

|[pic] |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 |

| |(Form Design View only) |order sequence. |

Form/Report Design View

|Format Menu |

|[pic] |AutoFormat… |Applies your choice of predefined formats to a form or report, such as the background picture and fonts |

| | |for controls. |

|[pic] |Set Control Defaults |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. |

| |Change To [pic] | |

|[pic] |Text Box |Changes the selected control to a text box, and copies any common properties from the selected control to|

| | |the text box. |

|[pic] |Label |Changes the selected control to a label, and copies any common properties from the selected control to |

| | |the label. |

|[pic] |List Box |Changes the selected control to a list box, and copies any common properties from the selected control to|

| | |the list box. |

|[pic] |Combo Box |Changes the selected control to a combo box, and copies any common properties from the selected control |

| | |to the combo box. |

|[pic] |Check Box |Changes the selected control to a check box, and copies any common properties from the selected control |

| | |to the check box. |

|[pic] |Toggle Button |Changes the selected control to a toggle button, and copies any common properties from the selected |

| | |control to the toggle button. |

|[pic] |Option Button |Changes the selected control to an option button, and copies any common properties from the selected |

| | |control to the option button. |

|[pic] |Image |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. |

|[pic] |Command Button |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. |

|[pic] |Snap To Grid |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 or report. |

| |Align [pic] | |

|[pic] |Left |Aligns the left edges of the selected controls with the left edge of the leftmost control in the |

| | |selection. |

|[pic] |Right |Aligns the right edges of the selected controls with the right edge of the rightmost control in the |

| | |selection. |

|[pic] |Top |Aligns the top edges of selected controls with the top edge of the topmost control in the selection. |

|[pic] |Bottom |Aligns the bottom edges of the selected controls with the bottom edge of the bottommost control in the |

| | |selection. |

|[pic] |To Grid |Aligns the top left corner of each selected control to the nearest point on the grid. |

Form/Report Design View

|Format Menu - continued |

| |Size [pic] | |

|[pic] |To Fit |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. |

|[pic] |To Grid |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 Tallest |Sizes selected controls to the same height as the tallest selected control. |

| |To Shortest |Sizes selected controls to the same height as the shortest selected control. |

| |To Widest |Sizes selected controls to the same width as the widest selected control. |

| |To Narrowest |Sizes selected controls to the same width as the narrowest selected control. |

| |Horizontal Spacing [pic] | |

|[pic] |Make Equal |Equalizes the horizontal space between three or more selected controls. |

|[pic] |Increase |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. |

|[pic] |Decrease |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. |

| |Vertical Spacing [pic] | |

|[pic] |Make Equal |Equalizes the vertical space between three or more selected controls. |

|[pic] |Increase |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. |

|[pic] |Decrease |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. |

|[pic] |Bring to Front |Moves the selected control to the top of a stack of overlapping controls. |

|[pic] |Send to Back |Moves the selected control to the bottom of a stack of overlapping controls. |

Print/Layout Preview

|Edit Menu |

|[pic] |Undo |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. |

|[pic] |Cut |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. |

|[pic] |Copy |Copies the selected item (for example, a control or a record) to the Clipboard so you can insert it |

| | |elsewhere. |

|[pic] |Paste |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/Layout Preview

|View Menu |

|[pic] |Design View |Switches from the current view to the Design view of the active table, query, form, or report. |

|[pic] |Layout Preview |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. |

|[pic] |Print Preview |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. |

| |Toolbars [pic] | |

| |Toolbar Name |Displays or hides toolbars. To display a toolbar, select the check box next to the toolbar name. To hide |

| | |a toolbar, clear the check box. |

| |Customize... |Customizes toolbar buttons, menu commands, and shortcut key assignments. |

| |Zoom [pic] | |

| |200% |Zooms the page(s) by a factor of 200 percent and makes that the new zoom setting. |

| |150% |Zooms the page(s) by a factor of 150 percent and makes that the new zoom setting. |

|[pic] |Zoom 100% |Displays the page(s) the same size as the printed page and makes that the new zoom setting. |

| |75% |Zooms the page(s) by a factor of 75 percent and makes that the new zoom setting. |

| |50% |Zooms the page(s) by a factor of 50 percent and makes that the new zoom setting. |

| |25% |Zooms the page(s) by a factor of 25 percent and makes that the new zoom setting. |

| |10% |Zooms the page(s) by a factor of 10 percent and makes that the new zoom setting. |

|[pic] |Fit to Window |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 [pic] | |

|[pic] |One Page |Displays one full page in Print Preview or Layout Preview. |

|[pic] |Two Pages |Displays two full pages in Print Preview or Layout Preview. |

| |Four Pages |Displays four full pages in Print Preview or Layout Preview. |

| |Eight Pages |Displays eight full pages in Print Preview or Layout Preview. |

| |Twelve Pages |Displays twelve full pages in Print Preview or Layout Preview. |

Macro Design View

|Edit Menu |

|[pic] |Undo |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. |

|[pic] |Cut |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. |

|[pic] |Copy |Copies the selected item (for example, a control or a record) to the Clipboard so you can insert it |

| | |elsewhere. |

|[pic] |Paste |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. |

| |Select All |Selects all field definitions in a table, controls in a form or report, or rows in a macro so you can, |

| | |for example, copy these items to a new object. |

| |Delete |Removes the selected item permanently without placing it on the Clipboard. |

|[pic] |Delete Rows |Deletes the selected row(s). To select a row, click the row selector [pic]. |

|View Menu |

|[pic] |Macro Names |Toggles between displaying and hiding the Macro Names column in the Macro window. Display the Macro Names|

| | |column when you define a macro group. |

|[pic] |Conditions |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. |

| |Toolbars [pic] | |

| |Toolbar Name |Displays or hides toolbars. To display a toolbar, select the check box next to the toolbar name. To hide |

| | |a toolbar, clear the check box. |

| |Customize... |Customizes toolbar buttons, menu commands, and shortcut key assignments. |

Macro Design View

|Insert Menu |

|[pic] |Rows |Creates a blank action row above the selected row. To select a row, click the row selector [pic]. |

|Run Menu |

|[pic] |Run |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. |

|[pic] |Single Step |Switches the single step mode on or off. When single step mode is on, you can run the actions one by one.|

Module Window

|Edit Menu |

|[pic] |Undo |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. |

|[pic] |Redo |Restores what you’ve undone with the Undo button or command. The command name changes to Redo Typing, |

| | |Cut, Delete, or Paste, depending on what you have undone. If an action can't be redone, the name of the |

| | |command changes to Can't Redo. |

|[pic] |Cut |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. |

|[pic] |Copy |Copies the selected item (for example, a control or a record) to the Clipboard so you can insert it |

| | |elsewhere. |

|[pic] |Paste |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. |

| |Delete |Removes the selected text from the Module window without placing it on the Clipboard. To reverse the most|

| | |recent delete operation, choose Undo Delete on the Edit menu. |

| |Select All |Selects all text in the Module window so you can, for example, cut or paste the text to the clipboard. |

|[pic] |Find… |Searches for a string, such as an employee's last name in a datasheet or form, or a Visual Basic keyword |

| | |in the Module window. |

|[pic] |Find Next |Finds the next occurrence of a string entered in the Find dialog box, such as an employee's last name in |

| | |a datasheet or form, or a Visual Basic keyword in the Module window. |

|[pic] |Replace… |Searches for a string, such as an employee's last name in a datasheet or form, or a Visual Basic keyword |

| | |in the Module window, and replaces it with another string. |

|[pic] |Indent |Shifts the selected code or the line at the insertion point four spaces to the right, by default. Use to |

| | |format and align blocks of code. To change the default shift, change the Tab Width option in the Options |

| | |dialog box's Module tab. |

|[pic] |Outdent |Shifts the selected code or the line at the insertion point four spaces to the left by default. Use to |

| | |format and align blocks of code. To change the default shift, change the Tab Width option in the Options |

| | |dialog box's Module tab. |

| |List Properties/Methods |Displays all properties and methods for the statement containing the insertion point. Use if you prefer |

| | |to explicitly (rather than automatically) build statements or to edit existing statements. |

| |List Constants |Displays all constants for the statement containing the insertion point. Use if you prefer to explicitly |

| | |(rather than automatically) build statements or to edit existing statements. |

| |Quick Info |Displays syntax information for the variable, constant, or procedure at the insertion point. Use if you |

| | |prefer to explicitly (rather than automatically) build statements or to edit existing statements. |

Module Window

|Edit Menu - continued |

| |Parameter Info |Displays all parameters for the statement containing the insertion point. Use if you prefer to explicitly|

| | |(rather than automatically) build statements or to edit existing statements. |

| |Complete Word |Completes the typing of a property, method, or constant word fragment. Displays all possible choices if |

| | |the word fragment is not unique. |

| |Bookmarks [pic] | |

|[pic] |Bookmark |Switches between adding or deleting a bookmark (displayed as a blue rectangle in the margin indicator |

| | |bar) at the current line of text in the Module window. Use bookmarks for designating important lines of |

| | |code in long modules. |

|[pic] |Next Bookmark |Advances the insertion pointer to the next bookmark, displayed as a blue rectangle in the margin |

| | |indicator bar of the Module window. If you are positioned at the last bookmark, the insertion pointer |

| | |goes to the first bookmark. |

|[pic] |Previous Bookmark |Moves the insertion pointer to the previous bookmark, displayed as a blue rectangle in the margin |

| | |indicator bar of the Module window. If you are positioned at the first bookmark, the insertion pointer |

| | |goes to the last bookmark. |

|[pic] |Clear All Bookmarks |Removes all bookmarks (displayed as blue rectangles) from the margin indicator bar in the Module window. |

| | |You cannot undo this operation. |

Module Window

|View Menu |

| |Definition |Displays the definition of the selected module or procedure in the Module window, (once you select the |

| | |module in the top list box and highlight it in the Classes box). |

| |Last Position |Returns to the last line position in the previous procedure that you were viewing in the Module window. |

|[pic] |Object Browser |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. |

|[pic] |Debug Window |Displays the Debug window so you can test and debug code. |

|[pic] |Call Stack… |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 Module window or the |

| | |Debug window is open and code execution is suspended. |

| |Toolbars [pic] | |

| |Toolbar Name |Displays or hides toolbars. To display a toolbar, select the check box next to the toolbar name. To hide |

| | |a toolbar, clear the check box. |

| |Customize... |Customizes toolbar buttons, menu commands, and shortcut key assignments. |

|Insert Menu |

|[pic] |Procedure… |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. |

|[pic] |Module |Inserts a new module into the current database and displays its Declarations section in the Module |

| | |window. |

|[pic] |Class Module |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. |

| |File… |Inserts code from a text file into the current module above the line containing the insertion point. |

Module Window

|Debug Menu |

|[pic] |Compile Loaded Modules |Compiles all procedures in open modules. Use to check for compile-time and syntax errors. |

| |Compile All Modules |Compiles all procedures in all modules in the current database, whether loaded or not. |

| |Compile and Save All Modules |Compiles and saves all modules in the database. If you change the project name, your database will no |

| | |longer be in a compiled state. You must close and reopen the database before you rerun the command |

| | |Compile And Save All Modules. |

|[pic] |Step Into |Runs one statement at a time, including statements within a called procedure. |

|[pic] |Step Over |Runs one statement at a time, treating a called procedure as one step. |

|[pic] |Step Out |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. |

|[pic] |Run to Cursor |Runs the procedure from the current executable statement to the selected line or insertion point (which |

| | |must be within the same procedure), and then re-enters break mode. Use to avoid unnecessarily stepping |

| | |through each line of code. |

|[pic] |Add Watch… |Creates a watch expression at the selected expression (such as a variable, property, or function call) in|

| | |the Module window so you can examine its values in the Watch pane of the Debug window. |

| |Edit Watch… |Modifies or deletes a watch expression at the selected expression (such as a variable, property, or |

| | |function call). |

|[pic] |Quick Watch… |Displays the value of a selected expression (such as a variable, property, or function call). Optionally,|

| | |you can add the expression to the Debug window's Watch pane to continue examining its value. |

|[pic] |Toggle Breakpoint |Toggles between setting and removing a breakpoint. Microsoft Access suspends code execution and enters |

| | |break mode when it reaches a line of code containing a breakpoint. Setting a breakpoint highlights the |

| | |line and makes it bold. |

|[pic] |Clear All Breakpoints |Removes all breakpoints in all procedures in all modules in the current database. |

|[pic] |Set Next Statement |Changes the run sequence of your code so that the statement at the insertion point is the next statement |

| | |to run. The statement to be run must be within the currently running procedure. Use when debugging to |

| | |rerun a statement or skip statements you don't want to run. |

|[pic] |Show Next Statement |Shows the next executable statement. Use when examining other statements during debugging so you can |

| | |return to your original place. |

Module Window

|Run Menu |

|[pic] |Go/Continue |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. |

|[pic] |End |Terminates execution of Visual Basic procedures and clears all private variables, but preserves all |

| | |public variables. Use to reinitialize procedures in a module you have changed before rerunning them. |

|[pic] |Reset |Terminates execution of Visual Basic procedures and clears all public and private variables. Use to |

| | |reinitialize all code in a module you have changed before rerunning it. |

|Tools Menu |

| |References… |Displays a list of available references from object libraries and databases. Use to make procedures in |

| | |other databases callable from the current database, or to resequence the order in which Microsoft Access |

| | |searches object libraries and databases to resolve references. |

|[pic] |ActiveX Controls… |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. |

| |Add-Ins [pic] | |

| |Add-In Manager |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 Splitter |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. |

| |Linked Table manager |Displays or refreshes links to tables. Use, for example, to refresh links when the structure or location |

| | |of a linked table has changed. |

| |Switchboard Manager |Creates, edits, and deletes switchboard forms for an application. |

| |Options… |Customizes characteristics of the Microsoft Access environment, such as screen fonts and colors, keyboard|

| | |actions, and viewing options. |

Module Window

|Object Browser |

|[pic] |Project/Library |Select the specific project or type library you want to work with in the Object |

| | |Browser, or to work with all available projects or type |

| | |libraries. |

|[pic] |Go Back |Returns to the previously selected class or object, if any. |

|[pic] |Go Forward |Advances to the next selected class or object, if any. |

|[pic] |Copy to Clipboard |Copies the selected string to the clipboard. |

|[pic] |View Definition |Displays the code behind a selected object, method, or property. |

|[pic] |Help |Displays help, if any, on a selected object, method, or property. |

|[pic] |Search Text |Enter the text you want to search for in the currently selected project or library. Use, |

| | |for example, to find ambiguous references. |

|[pic] |Search |Finds every occurrence of the text string entered in the Search Text box and displays the results in the Search |

| | |results pane. |

|[pic] |Show Search Results |Switches between hiding and showing the Search Results pane. |

Toolbars

|Formatting Toolbar (Datasheet) |

|[pic] |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. |

|[pic] |Font box |Changes the font of all text in the current datasheet or the selected control(s) in a form or report. |

|[pic] |Font Size box |Changes the font size of all text in the current datasheet or the selected control(s) in a form or |

| | |report. |

|[pic] |Bold |Makes text bold in the current datasheet or in the selected control(s) in a form or report. |

|[pic] |Italic |Makes all text italics in the current datasheet or in the selected control(s) in a form or report. |

|[pic] |Underline |Underlines all text in the current datasheet or the selected control(s) in a form or report. |

|[pic] |Fill/Back Color |Applies colors in a form or report 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. |

|[pic] |Font/Fore Color |Applies color to the text on a datasheet or the text in the selected control(s) on a form or report. |

|[pic] |Line/Border Color |Applies a color or makes transparent the line or border of the selected control(s). Select the color you |

| | |want to apply, or click Transparent to apply a clear line or border. |

|[pic] |Gridlines: Both |Shows both horizontal and vertical gridlines on a datasheet. |

|[pic] |Gridlines: Horizontal |Shows only horizontal gridlines on a datasheet. |

|[pic] |Gridlines: Vertical |Shows only vertical gridlines on a datasheet. |

|[pic] |Gridlines: Show No |Hides all gridlines on a datasheet. |

|[pic] |Special Effect: Flat |Applies a flat effect to the cells on a datasheet, or to the selected control or controls on a form or |

| | |report. |

|[pic] |Special Effect: Raised |Applies a raised effect to the cells on a datasheet, or to the selected control or controls on a form or |

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

| | |properties. |

|[pic] |Special Effect: Sunken |Applies a sunken effect to the cells on a datasheet, or to the selected control or controls on a form or |

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

| | |properties. |

Toolbars

|Formatting Toolbar (Form/Report) |

|[pic] |Object |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. |

|[pic] |Font box |Changes the font of all text in the current datasheet or the selected control(s) in a form or report. |

|[pic] |Font Size box |Changes the font size of all text in the current datasheet or the selected control(s) in a form or |

| | |report. |

|[pic] |Bold |Makes text bold in the current datasheet or in the selected control(s) in a form or report. |

|[pic] |Italic |Makes all text italics in the current datasheet or in the selected control(s) in a form or report. |

|[pic] |Underline |Underlines all text in the current datasheet or the selected control(s) in a form or report. |

|[pic] |Align Left |Aligns text to the left within the selected control(s). |

|[pic] |Center |Centers text within the selected control(s). |

|[pic] |Align Right |Aligns text to the right within the selected control(s). |

|[pic] |Fill/Back Color |Applies colors in a form or report 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. |

|[pic] |Font/Fore Color |Applies color to the text on a datasheet or the text in the selected control(s) on a form or report. |

|[pic] |Line/Border Color |Applies a color or makes transparent the line or border of the selected control(s). Select the color you |

| | |want to apply, or click Transparent to apply a clear line or border. |

|[pic] |Line/Border Width |Displays a variety of line widths. Click the width you want to apply to the border of the selected |

| | |control(s). |

|[pic] |Hairline Line/Border Width |Applies the narrowest line or border width to the selected control(s). |

|[pic] |1-pt. Line/Border Width |Applies a 1-point line or border width to the selected control(s). |

|[pic] |2-pt. Line/Border Width |Applies a 2-point line or border width to the selected control(s). |

|[pic] |3-pt. Line/Border Width |Applies a 3-point line or border width to the selected control(s). |

|[pic] |4-pt. Line/Border Width |Applies a 4-point line or border width to the selected control(s). |

|[pic] |5-pt. Line/Border Width |Applies a 5-point line or border width to the selected control(s). |

|[pic] |6-pt. Line/Border Width |Applies a 6-point line or border width to the selected control(s). |

Toolbars

|Formatting Toolbar (Form/Report) - continued |

|[pic] |Special Effect: Flat |Applies a flat effect to the cells on a datasheet, or to the selected control or controls on a form or |

| | |report. |

|[pic] |Special Effect: Raised |Applies a raised effect to the cells on a datasheet, or to the selected control or controls on a form or |

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

| | |properties. |

|[pic] |Special Effect: Sunken |Applies a sunken effect to the cells on a datasheet, or to the selected control or controls on a form or |

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

| | |properties. |

|[pic] |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. |

|[pic] |Special Effect: Shadowed |Applies a shadowed effect to the selected control. |

|[pic] |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. |

Toolbars

|Toolbox |

|[pic] |Select Objects |Use to select a control, section, or form. Click this tool to unlock a toolbox button that you've locked |

| | |down. |

|[pic] |Control Wizards |Turns control wizards on or off. Use control wizards to help you create a list box, combo box, option |

| | |group, command button, chart, subreport, or subform. To use wizards to create these controls, the Control|

| | |Wizards button must be pressed in. |

|[pic] |Label |A control that displays descriptive text, such as a title, a caption, or instructions on a form or |

| | |report. Microsoft Access automatically attaches labels to the controls you create. |

|[pic] |Text Box |Use to: Display, enter, or edit data in a form's or report's underlying record source, display the |

| | |results of a calculation, or accept input from a user. |

|[pic] |Option Group |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. |

|[pic] |Toggle Button |Use as a stand-alone control bound to a Yes/No field, an unbound control for accepting user input in a |

| | |custom dialog box, or part of an option group. |

|[pic] |Option Button |Use as a stand-alone control bound to a Yes/No field, an unbound control for accepting user input in a |

| | |custom dialog box, or part of an option group. |

|[pic] |Check Box |Use as a stand-alone control bound to a Yes/No field, an unbound control for accepting user input in a |

| | |custom dialog box, or part of an option group. |

|[pic] |Combo Box |Combines the features of a list box and a text box. You can type in the text box or select an entry in |

| | |the list box to add a value to an underlying field. |

|[pic] |List Box |Displays a scrollable list of values. In Form view, you can select from the list to enter a value into a |

| | |new record or to change the value in an existing record. |

|[pic] |Command Button |Use to perform actions, such as finding a record, printing a record, or applying a form filter. |

|[pic] |Image |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 once you've added it to a form or report. |

|[pic] |Unbound Object Frame |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. |

|[pic] |Bound Object Frame |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 displays|

| | |on the form or report as you move from record to record. |

Toolbars

|Toolbox - continued |

|[pic] |Page Break |Use to begin a new screen on a form, a new page on a printed form, or a new page of a report. |

|[pic] |Tab Control |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. |

|[pic] |Subform/Subreport |Use to display data from more than one table on a form or report. |

|[pic] |Line |Use on a form or report, for example, to emphasize related or especially important information. |

|[pic] |Rectangle |Use for graphic effects such as grouping a set of related controls on a form, or emphasizing important |

| | |data on a report. |

|[pic] |More Controls |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. |

Toolbars

|Web Toolbar |

|[pic] |Back |Opens the previous file or item in the list of the last 10 files or items you jumped to. |

|[pic] |Forward |Opens the next file or item in the list of the last 10 files or items you jumped to. |

|[pic] |Stop Current Jump |Stops loading or reloading of current page or file. |

|[pic] |Refresh Current Page |Updates the currently selected page by reloading it. |

|[pic] |Start Page |Jumps to the first Web page displayed when you start your default Web browser. |

|[pic] |Search the Web |Opens the search page defined by your Web browser so you can search for Web pages by entering words or |

| | |phrases. |

| |Favorites [pic] | |

|[pic] |Add To Favorites… |Creates a shortcut to the selected file, folder, or link, and then adds the shortcut to the Favorites |

| | |folder. The original file or folder doesn’t move. |

|[pic] |Open Favorites… |Opens the Favorites folder in the Look in box .The Favorites folder contains shortcuts to files, folders,|

| | |and hyperlinks you use often. |

|[pic] |Go [pic] |Provides a drop-down list of additional Web toolbar buttons. |

|[pic] |Open… |Opens the selected Hypertext link. |

| |Set Start Page… |Sets the start page, or home page, to the currently displayed file. This setting may apply to your Web |

| | |browser as well. |

| |Set Search Page… |Sets the search page to the currently displayed file. This setting may apply to your Web browser as well.|

| |Object |Opens the specified database object. |

|[pic] |Show Only Web Toolbar |Hides all the currently visible toolbars except the Web toolbar. Click [pic] again to show the hidden |

| | |toolbars. |

|[pic] |Address |Enter the Web address you want to go to, or click one you previously used on the list. |

Toolbars

|SourceSafe Toolbar |

|[pic] |Add Objects to SourceSafe |Adds one or more objects in a database to source code control. |

|[pic] |Get Latest Version |Gets the last version of an object and places a read-only copy in your working folder. |

|[pic] |Check Out |Checks out an object to your working folder so you can work on it. |

|[pic] |Check In |Checks in an object to source code control, saving your changes. |

|[pic] |Undo Check Out |Returns an object to source code control and discards any changes since the object was last checked out. |

|[pic] |Share Objects |Shares an object in a database with another source code control project. |

|[pic] |Show History |Shows the source code control history of an object or a database. Historical information includes |

| | |creation, labeling, check-ins, shares, and branches. |

|[pic] |Show Differences |Shows the differences between the local database object in your working folder and the version of that |

| | |object checked in to source code control. |

|[pic] |Run SourceSafe |Runs the Microsoft Visual SourceSafe Explorer. |

Standard Buttons

|General |

|[pic] |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. |

|[pic] |Database Window |Displays the Database window, which lists all objects in the current database. Use, for example, to drag |

| | |and drop objects from the Database window to the current window. |

|[pic] |Build button |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). |

|[pic] |New Object |Creates a new database object. Select AutoForm or AutoReport to create a basic form or report. Choose an |

| | |object type (such as New Form or New Table) to create the object yourself. |

|[pic] |Format Painter |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. |

|[pic] |Close Filter 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. |

|Print/Layout Preview Toolbar |

|[pic] |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. |

|[pic] |Zoom |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. |

|[pic] |Zoom button |Switches between the full page and zoom views. When the pointer is a magnifying glass, you can also click|

| | |on a portion of the full page view to zoom to that portion, and click again to return to the full page |

| | |view. |

|Query Design Toolbar |

|[pic] |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. |

|[pic] |Top Values box |Finds the top values in the active query based on a percentage of rows or a number of rows. To find the |

| | |top values, choose a percentage (such as 10%) or enter a number (such as 25). |

Additional Buttons

|File Category |

|[pic] |Output To Notepad |Exports database objects as text to a Microsoft Notepad file from any view. For tables, queries, 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. |

|Records Category |

| | | |

|[pic] |Apply Filter/Remove Filter |Applies or removes a filter in the active datasheet or form. |

|Form/Report Design Category |

|[pic] |Align General |Aligns text to the left and numbers to the right within the selected control. |

|[pic] |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. |

|Format Category |

|[pic] |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. |

|[pic] |Line/Border Style (Short Dashes) |Applies short dashes to the border of the selected control. |

|[pic] |Line/Border Style (Solid) |Applies a solid border to the selected control. |

|[pic] |Line/Border Style (Sparse Dots) |Applies sparse dots to the border of the selected control. |

|[pic] |Line/Border Style (Dots) |Applies a dotted border to the selected control. |

|[pic] |Line/Border Style (Dash-Dot) |Applies alternating dashes and dots to the border of the selected control. |

|[pic] |Line/Border Style (Dash-Dot-Dot) |Applies a style consisting of a dash alternating with two dots to the border of the selected control. |

|[pic] |Line/Border Style (Dashes) |Applies a dashed style to the border of the selected control. |

Additional Buttons

|Web Category |

|[pic] |Web toolbar |Displays or hides the Web Toolbar. |

|Source Control Category |

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

| | Refresh Object Status |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. |

Unique Shortcut Menu Commands

|Database Window |

|[pic] |Design |Displays the selected object in Design view. |

|[pic] |Open… |Displays the selected table's or query's Datasheet view, or the selected form's default view (either |

| | |Datasheet or Form). |

|[pic] |Print Preview |Displays the selected report in Print Preview. |

|[pic] |Run |Runs the selected macro. |

|[pic] |Print |Prints the selected form, report, table, query, or module immediately without displaying the Print dialog|

| | |box. |

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

|Datasheet/Form Browse Window |

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

|Debug Window |

| |Collapse Parent |Collapses the selected variable and associated list of variables to their parent variable in the |

| | |hierarchy. |

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

|Object Browser Window |

| |Find Whole Word Only |Switches the search behavior between restricting to a whole word (which usually limits the number of |

| | |matches) or including a partial word (which usually increases the number of matches). |

| |Show Hidden Members |Displays hidden members of a type library as dimmed entries in the Object Browser display. |

| |Help |Displays Help information, if available, for the selected class or member. You can also press F1. |

|Form Design Window Tab Control |

|[pic] |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. |

Unique Shortcut Menu Commands

|Hyperlink Field/Control |

| |Hyperlink [pic] | |

| |Open |Jumps to the hyperlink address or Uniform Resource Locator (URL) and replaces the current Web page in |

| | |Microsoft Internet Explorer if it is already open. |

| |Open in New Window |Jumps to the hyperlink address or Uniform Resource Locator (URL) and starts another instance of Microsoft|

| | |Internet Explorer if it is already open. |

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

|[pic] |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). |

| |Edit Hyperlink… |Displays the hyperlink address or Uniform Resource Locator (URL), including the subaddress and the type |

| | |of path (whether absolute or relative), so that you can modify it. |

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

|Miscellaneous |

| |Zoom… |Displays the Zoom window so you can easily view and edit long text fields. |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download