Edit

The Edit menu of a database window.

Copy

Copies the selected object to the clipboard.

Paste

Inserts an item from the clipboard. If you want, you can insert forms and reports, including subfolders, from one database file to another.

Paste Special

Inserts an item from the clipboard. If you want, you can insert forms and reports, including subfolders, from one database file to another.

Select All

Selects all entries, including subfolders, in the lower part of the database window.

Edit

Opens a window where you can edit the selected table, query, form, or report.

Delete

Deletes the selected table, query, form, or report.

Rename

Renames the selected object. Depending on the database, some names, characters, and name length might be invalid.

Open

Opens the selected object in the last saved state.

Create as View

Converts the selected query to a view. The original query remains in your database file and an additional view is generated on the database server. You must have write permission to add a view to a database.

Most databases use queries to filter or to sort database tables to display records on your computer. Views offer the same functionality as queries, but on the server side. If your database is on a server that supports views, you can use views to filter the records on the server to speed up the display time.

Form Wizard

Starts the Form Wizard for the selected table, query, or view.

Report Wizard

Starts the Report Wizard for the selected table, query, or view.

Database

Opens a submenu.

Properties

Opens the Database Properties dialog.

Connection Type

Opens the Connection Type Wizard.

Advanced Properties

Opens the Advanced Properties dialog.