Contents

GETTING STARTED

Overview

Ordering Information

Order Form

License Agreement

System Requirements

Registration Instructions

COMMANDS

File Menu

Edit Menu

View Menu

Window Menu

Help Menu

HOW DO I?

Register the product

Add a Table

Drop a Table

Add column(s) to an existing table

Drop column(s) from an existing table

Add an Index

Drop an Index

Establish a foreign key relationship between tables

Remove a foreign key relationship

Create a Trigger

Drop a Trigger

Create a database

Drop a database

Create different views of the same database

Organize the database schema

Print the database schema


Overview

Visual Database Designer is the ultimate schema manipulation tool for the database administrator. It allows complete visual editing of A Pervasive.SQL 2000 database as well as detailed or summarized printing of the database schema. The majority of editing operations can be performed completely with the mouse.

A full data diagram is presented including all foreign key relationships. Tables can be organized on the display to produce the most meaningful view of the database. As tables are moved all relationship lines to the table move with it.

Establish a new foreign key relationship is as simple as dragging a line from one table to another. Deleting an existing foreign key is as easy as clicking on the foreign key line and pressing delete. All changes are reflected on the display immediately.

This program eliminates the requirements for any knowledge of SQL unless custom triggers or stored procedures are being created.


Ordering Information

Customer information is considered confidential and will not be shared or distributed to any third party.

All orders are subject to the Visual Database Designer License Agreement.

Internet Orders

Online delivery of registered copies of Visual Database Designer is available for credit card orders placed via the Internet using the Order link on the Visual Database Designer home page: http://millsoft.ca/products.htm.  The license key will be sent within 1 business day by email or postal mail. You can place orders for delivery by postal mail using the Internet order forms or as described below.

Check Orders

To order by check, send the order form and a check to Millenia Software. Payments must be in US dollars, or you can send international postal money orders in US dollars.  The product will be delivered as soon as the payment clears. Click here to view a ready-to-print Order Form.

Credit Card Orders

You can place secure credit card orders on the Internet using the Order link on the Visual Database Designer home page at http://millsoft.ca/products.htm.

You can also print the Order Form to place credit card orders by fax, e-mail, or postal mail.

Site licenses

A site license for Visual Database Designer entitles an organization to receive one copy of the distribution package and to duplicate the distribution disk for the specified number of copies. See the table below for site license pricing.

Pricing (US$)

Visual Database Designer Single Copy	$135 each

Visual Database Designer Site Licenses:

2 to 9 computers:	$120 each

10+ computers:	$105 each

Prices include all applicable taxes.

Add $5 for delivery by surface mail or $20 for express delivery (in North America).

Prices guaranteed through August, 2000.


Order Form
Visual Database Designer Order Form

To print this order form, select Print Topic from the File pull-down menu.

Check payments must be in US dollars or you can send international postal money orders in US dollars.

Order Methods:	Fax:	 604-669-4469	Mailing Address:	Millenia Software
Phone:	 604-729-6397 (x111)	200 – 1168 Hamilton Street
Email:	sales@millsoft.ca	Vancouver, BC, V6B 2S2
Canada

Customer information is considered confidential and will not be shared or distributed to any third party. All orders are subject to the Visual Database Designer License Agreement.  Prices are guaranteed through August, 2000 and.include all applicable taxes.

Visual Database Designer Single Copy	_____ at $135 each =	__________

Visual Database Designer Site Licenses:

2 to 9 computers: _____ at $120 each =	__________

Payment method:	10+ computers: _____ at $105 each =	__________

[   ] Check	Delivery method:

[   ] MasterCard	[   ]	Email (License key only) at $0 =	__________

[   ] VISA	[   ]	Email (full) at $0 =	__________

[   ] AMEX	[   ]	Surface mail (full) at $5 =	__________

[   ] Discover	[   ]	Express mail (full) at $20 =	__________

Total payment:	__________

Date:	__________________________________________________________

Credit Card #:	__________________________________________________________

Expiration Date:	__________________________________________________________

Name On Card:	__________________________________________________________

Signature:	__________________________________________________________

Name:	__________________________________________________________

Company:	__________________________________________________________

Shipping Address:	__________________________________________________________

__________________________________________________________

City, State, Zip:	__________________________________________________________

Country:	__________________________________________________________

Day Phone:	__________________________________________________________

E-Mail address:	__________________________________________________________

How did you hear
about Designer?	__________________________________________________________

Comments:


License Agreement

You should carefully read the following terms and conditions before using this software.  Unless you have a different license agreement signed by Millenia Software your use of this software indicates your acceptance of this license agreement and warranty.

Evaluation License

The evaluation (unregistered) version may be freely distributed and used as is. It is limited to opening a maximum of 5 database tables at a time. Any version allowing more than 5 tables to be opened is considered a registered version and must be purchased and used in accordance with the Registered Version license below.

No alterations of any kind is permitted to the software especially such alterations as may circumvent the built in restriction mechanisms in the evaluation version. Any such alterations constitute an immediate breach of this license agreement.

Registered Version

One registered copy of Visual Database Designer may either be used by a single person who uses the software personally on one or more computers, or installed on a single workstation used non-simultaneously by multiple people, but not both.

You may access the registered version of Visual Database Designer through a network, provided that you have obtained individual licenses for the software covering all workstations that will access the software through the network.  For instance, if 8 different workstations will access Visual Database Designer on the network, each workstation must have its own Visual Database Designer license, regardless of whether they use Visual Database Designer at different times or concurrently.

Governing Law

Visual Database Designer is protected by the copyright laws of Canada and the United States

and by international treaties. Therefore, you must comply with such laws and treaties in

your use of it. Any  unauthorized copy of the program made by you is subject to this

Agreement and will include Millenia's copyright, trade-mark and other proprietary notices.

You may not copy any materials accompanying Visual Database Designer without written

permission from Millenia Software.

Visual Database Designer Copyright © 1999 by Millenia Software. All rights reserved.

Ownership

Visual Database Designer is licensed software and the fees charged to license it do not constitute a transfer of ownership. Ownership of Visual Database Designer and its associated proprietary rights are retained by Millenia Software.

Disclaimer of Warranty

THIS SOFTWARE AND THE ACCOMPANYING FILES ARE SOLD "AS IS" AND WITHOUT WARRANTIES AS TO PERFORMANCE OR MERCHANTABILITY OR ANY OTHER WARRANTIES WHETHER EXPRESSED OR IMPLIED. Because of the various hardware and software environments into which Visual Database Designer may be put, NO WARRANTY OF FITNESS FOR A PARTICULAR PURPOSE IS OFFERED.

Good data processing procedure dictates that any program be thoroughly tested with non-critical data before relying on it.  The user must assume the entire risk of using the program.  ANY LIABILITY OF THE SELLER WILL BE LIMITED EXCLUSIVELY TO PRODUCT REPLACEMENT OR REFUND OF PURCHASE PRICE.


System Requirements

Version 1.0 of Visual Database Designer (the program) will run on Windows 95, Windows 98, Windows NT 4.0, and Windows 2000.

It provides visual database administration capability for Pervasive.SQL 2000 databases only and therefore requires that Pervasive.SQL 2000 be installed.

The program makes database queries through ODBC and therefore requires that ODBC datasources be installed for any databases you wish to access. This program will work with the Workstation, Workgroup, Server, and Novell versions of P.SQL 2000.


Registration Instructions

If you have not already downloaded the program do so now or install the version you received in the mail. Once you are satisfied that it is correctly installed and operating in the demo mode you are ready to begin the registration process.

If you have not yet received a license key follow the Ordering Instructions to order the product. Until the product is registered a splash screen is displayed and you will only be able to open a maximum of 5 tables.

Once you have ordered the product you will receive a license key. This is essentially a block of alphanumeric characters that identifies who you are and unlocks the full functionality of the program.

Select the Help About menu item or the help button [image] on the toolbar to bring up the About box.

Now press the Register button to bring up the registration dialog.

Paste the license key you were sent into the edit box using Ctrl+V and press OK. If everything has worked correctly your name will now appear in the About box and the Register button will have been replaced with a License button.

Congratulations , you have now unleashed the full power of Visual Database Designer!


File menu commands

The File menu offers the following commands:

New	Creates a new database layout/view.
Open	Opens an existing database view.
Close	Closes an opened view.
Save	Saves an opened document using the same file name.
Save As	Saves an opened document to a specified file name.
Print	Prints a document.
Print Preview	Displays the document on the screen as it would appear printed.
Print Setup	Selects a printer and printer connection.
MRU	Most recently used file list
Exit	Exits Visual Database Designer


File New command
New (File menu)

Use this command to create a new document in Visual Database Designer.  Visual Database Designer stores the visual database information including table window positioning and datasource information in a configuration file that has a default extension of .dbd.

The File New operation displays the ODBC connection dialog to allow a datasource to be specified.

Once a connection has been established the database tables are displayed in a tiled pattern. They can then be organized in any pattern that makes sense. The default starting view is Schema View.

The demodata sample appears as follows when first displayed:

You can open an existing document with the Open command.

Shortcuts

Toolbar:
Keys:	CTRL+N


File Open command
Open (File menu)

Opens a saved configuration (.dbd) file, reconnects to the datasource, and displays the saved view. Use this command to open an existing document in a new window.  You can open multiple documents at once.  Use the Window menu to switch among the multiple open documents.  See Window 1, 2, ... command.

The following options allow you to specify which file to open:

File Name

Type or select the filename you want to open.  This box lists files with the extension you select in the List Files of Type box.

List Files of Type

Visual Database Designer files normally have a type of dbd. If you have chosen to use a different type then select All Files here.

Drives

Select the drive in which Visual Database Designer stores the file that you want to open.

Directories

Select the directory in which Visual Database Designer stores the file that you want to open.

Network...

Choose this button to connect to a network location, assigning it a new drive letter.

You can create new documents with the New command.

Shortcuts

Toolbar:
Keys:	CTRL+O


File Close command
Close (File menu)

Closes an open view and displays a save confirmation prompt if any changes to the configuration have been made. Before closing an untitled document, Visual Database Designer displays the Save As dialog box and suggests that you name and save the document.

You can also close a document by using the Close icon on the document's window, as shown below:


File Save command
Save (File menu)

Saves the current configuration replacing the previous configuration if one existed. Use this command to save the active document to its current name and directory.  When you save a document for the first time, Visual Database Designer displays the Save As dialog box so you can name your document.  You can also change the name and directory of an existing document before you save it by choosing the Save As dialog.

Shortcuts

Toolbar:
Keys:	CTRL+S


File Save As command
Save As (File menu)

Use this command to save and name the active document.  Visual Database Designer displays the Save As dialog box so you can name your document.

To save a document with its existing name and directory, use the Save command.

The following options allow you to specify the name and location of the file you're about to save:

File Name

Type a new filename to save a document with a different name.  A filename can contain up to eight characters and an extension of up to three characters.  Visual Database Designer adds the extension you specify in the Save File As Type box.

Drives

Select the drive in which you want to store the document.

Directories

Select the directory in which you want to store the document.

Network...

Choose this button to connect to a network location, assigning it a new drive letter.


File Print command
Print (File menu)

Use this command to print a document. The full diagram is split across pages both horizontally and vertically if it does not fit on one page. The display can be zoomed prior to printing.

This command presents a Print dialog box. The following options allow you to specify how the document should be printed:

Printer

This is the active printer and printer connection.  Choose the Setup option to change the printer and printer connection.

Setup

Displays a Print Setup, so  you can select a printer and printer connection.

Print Range

Specify the pages you want to print:

All	Prints the entire document.
Selection	Prints the currently selected text.
Pages	Prints the range of pages you specify in the From and To boxes.
Copies

Specify the number of copies you want to print for the above page range.

Collate Copies

Prints copies in page number order, instead of separated multiple copies of each page.

Print Quality

Select the quality of the printing.  Generally, lower quality printing takes less time to produce.

Shortcuts

Toolbar:
Keys:	CTRL+P


File Print Preview command
Print Preview (File menu)

Use this command to display the active document as it would appear when printed.  When you choose this command, the main window will be replaced with a print preview window in which one or two pages will be displayed in their printed format.

The print preview toolbar offers you the following options:

Print

Bring up the print dialog box, to start a print job.

Next Page

Preview the next printed page.

Prev Page

Preview the previous printed page.

One Page / Two Page

Preview one or two printed pages at a time.

Zoom In

Take a closer look at the printed page.

Zoom Out

Take a larger look at the printed page.

Close

Return from print preview to the editing window.


File Print Setup command
Print Setup (File menu)

Use this command to select a printer, a printer connection as well as paper characteristics and orientation.

The following options allow you to select the destination printer and its connection.

Printer

Select the printer you want to use.  Choose the Default Printer; or choose the Specific Printer option and select one of the current installed printers shown in the box.  You install printers and configure ports using the Windows Control Panel.

Orientation

Choose Portrait or Landscape.

Paper Size

Select the size of paper that the document is to be printed on.

Paper Source

Some printers offer multiple trays for different paper sources.  Specify the tray here.

Options

Displays a dialog box where you can make additional choices about printing, specific to the type of printer you have selected.

Network...

Choose this button to connect to a network location, assigning it a new drive letter.


File Exit command
Exit command (File menu)

Use this command to end your Visual Database Designer session.  You can also use the Close command on the application Control menu.  Visual Database Designer prompts you to save documents with unsaved changes.

Shortcuts

Mouse:	Double-click the application's Control menu button.

Keys:	ALT+F4


File 1, 2, 3, 4 command
MRU (File menu)

Whenever a document is opened it is added to the Most Recently Used list at the bottom of the File menu.

Use the numbers and filenames listed at the bottom of this menu to open the last four documents you closed.  Choose the number that corresponds with the document you want to open.


Edit menu commands

The Edit menu offers the following commands:

Undo	Reverse previous editing operation.
Cut	Deletes data from the document and moves it to the clipboard.
Copy	Copies data from the document to the clipboard.
Paste	Pastes data from the clipboard into the document.
Create Table	Creates a new table
Add Column(s)	Adds one or more columns to a table
Create Index	Creates an index on the currently selected table
Create Foreign Key	Creates a foreign key relationship between two tables
Create Trigger	Creates a trigger on the selected table
Drop	Drops the selected item


Undo (Edit menu)

Use this command to reverse the last editing action, if possible.   The name of the command changes, depending on what the last action was.  The Undo command is disabled on the menu if you cannot reverse your last action.

Shortcuts

Toolbar:
Keys:	CTRL+Z or
ALT-BACKSPACE


Cut (Edit menu)

Use this command to remove the currently selected data from the document and put it on the clipboard.  This command is unavailable if there is no data currently selected.

Cutting data to the clipboard replaces the contents previously stored there.

Shortcuts

Toolbar:
Keys:	CTRL+X


Copy (Edit menu)

Use this command to copy selected data onto the clipboard.  This command is unavailable if there is no data currently selected.

Copying data to the clipboard replaces the contents previously stored there.

Shortcuts

Toolbar:
Keys:	CTRL+C


Paste (Edit menu)

Use this command to insert a copy of the clipboard contents at the insertion point.  This command is unavailable if the clipboard is empty.

Shortcuts

Toolbar:
Keys:	CTRL+V


Create Table (Edit menu)

New tables can be created with this function. Specify the name and column information here. When the table is initially created it will have no indexes associated with it. Use Create Index to add indexes as required.


Add Column(s) (Edit menu)

This operation allows one or more columns to be added to the end of an existing table.


Create Index (Edit menu)

Select a table and right-click to display the index dialog. This operation will create one index containing the specified segments. The sort column indicates whether the segment is to be sorted in ascending or descending order. The default is to sort in ascending order. Enter the index name and indicate whether the index will be unique, modifiable, or not null.

A segment's collating sequence is specified during column creation. All columns in the index, which use an alternate collating sequence, must use the same collating sequence. It is possible to mix columns that are case sensitive, case insensitive, and one alternate collating sequence in the same index.


Create Foreign Key (Edit menu)

To define a foreign key, select one or more columns in the referencing (foreign) table. Then click on the foreign table and drag the cursor to a unique key in the referenced (primary table). The foreign key dialog will be displayed indicating the key segments in each table. These can be adjusted prior to actual creation of the relationship.

Only unique indexes in the primary table can be referenced and this index must already exist. All segments of the primary key must match. The foreign key may have excess segments in its index and the index does not need to be unique. If an index in the foreign table does not exist for the specified segments then one will automatically be created.

Any indexes created by the new relationship will be displayed when the operation has been successfully completed.

If Delete Cascade is specified any foreign key rows referencing a primary will be automatically deleted when the primary key is deleted.

If Delete Update is specified an attempt to delete a primary key which has foreign rows referencing it will fail.

Only restrict mode is supported for Updates. This means that any attempt to update the key field in primary table rows that are referenced by a foreign table will fail.


Create Trigger (Edit menu)

This operation allows the creation of a table. It requires familiarity with SQL.

Specify a trigger name of up to 20 characters. Trigger names must be unique to the entire database.

Specify whether the trigger is to apply to Insert, Update, or Delete operations and whether it is to fire before or after the insert, update, or delete is applied to the database.

Multiple triggers may be assigned to the same Insert, Update, or Delete operation. To control the order in which they fire specify a number in the Firing Order item.

The Where box allows the rows which are affected by the trigger to be further restricted. If no where clause is specified then all rows being inserted, updated, or deleted will cause the trigger to be fired.

The Trigger Body contains the SQL statements which are to be executed when the trigger Is fired. Semi-colons should separate these.


Drop (Edit menu)

The drop command is context sensitive. Select an item to drop and press delete. A confirmation dialog will be displayed and once confirmed the selected item(s) will be dropped.

The following items can be dropped:

Table	Drop a table
Column	Drops one or more columns
Index	Drop an index
Foreign Key	Drop a foreign key relationship
Trigger	Drop a trigger


Drop Table

Dropping a table is as simple as clicking on it and pressing delete. A confirmation dialog is displayed to confirm the operation. Tables can not be deleted while they are involved in a foreign key relationship.


Drop Column

Select one or more columns and press delete to drop those columns. If a column which is used in an index is dropped the corresponding index will also be dropped. A dialog is displayed to allow a final confirmation of the deletion.


Drop Index

To drop an index, select the one you want to delete from a table and press Delete or right click and select Delete from the context menu. You will be prompted to confirm the deletion. When an index is selected its name and all it's segments are highlighted.


Drop Foreign Key

Click on the line that represents the foreign key you wish to delete. It will be highlighted. Press Delete and you will be asked to confirm the operation. Once the foreign key operation is complete the line will no longer be visible on the diagram.


Drop Trigger

To drop a trigger, select it in the table, and press delete.


View menu commands

The View menu offers the following commands:

Toolbar	Shows or hides the toolbar.
Status Bar	Shows or hides the status bar.
Schema	Displays tables, columns, indexes, and triggers
Table Diagram	Displays tables only
Attributes	Displays column and index attributes in addition to what is displayed in schema view


View Toolbar command
Toolbar (View menu)

Use the View Toolbar command to display and hide the Toolbar, which includes buttons for some of the most common commands in Visual Database Designer, such as File Open.  A check mark appears next to the menu item when the Toolbar is displayed.

The toolbar is initially displayed across the top of the application window, below the menu bar.  The toolbar provides quick mouse access to many tools used in Visual Database Designer. The toolbar can be docked to either the top, left, bottom, or right side of the frame window or can be undocked altogether. To change the toolbar’s dockstate grab the edge and drag the toolbar where you want it. The toolbar settings are saved across application sessions.

To hide or display the Toolbar, choose Toolbar from the View menu (ALT, V, T).

Click	To

Open a new document.

Open an existing document.  Visual Database Designer displays the Open dialog box, in which you can locate and open the desired file.

Save the active document or template with its current name.  If you have not named the document, Visual Database Designer displays the Save As dialog box.

Print the active document.

Remove selected data from the document and stores it on the clipboard.

Copy the selection to the clipboard.

Insert the contents of the clipboard at the insertion point.

Displays the About dialog.

Displays context sensitive help information.


View Status Bar Command
Status Bar (View menu)

Use this command to display and hide the Status Bar, which describes the action to be executed by the selected menu item or depressed toolbar button, and keyboard latch state. A check mark appears next to the menu item when the Status Bar is displayed.

The status bar is displayed at the bottom of the Visual Database Designer window.  To display or hide the status bar, use the Status Bar command in the View menu.

The left area of the status bar describes actions of menu items as you use the arrow keys to navigate through menus.  This area similarly shows messages that describe the actions of toolbar buttons as you depress them, before releasing them.  If after viewing the description of the toolbar button command you wish not to execute the command, then release the mouse button while the pointer is off the toolbar button.

The right areas of the status bar indicate which of the following keys are latched down:

Indicator	Description

CAP	The Caps Lock key is latched down.

NUM	The Num Lock key is latched down.

SCRL	The Scroll Lock key is latched down.


View

The view window displays the database schema and allows it to be altered.

There are 3 available view formats:

Schema	Displays tables, columns, indexes, and triggers
Table Diagram	Displays tables only
Attributes	Displays column and index attributes in addition to what is displayed in schema view

The default view format is Schema. Click on the View menu to alter the current view format.


Schema View (View menu)

In detailed view a table's column, indexes, and triggers are displayed.


Attribute View (View menu)

Attribute View takes the detailed view one step further and displays the attributes of each table object. This includes the datatypes and sizes for columns as well as the index flags for indexes.


Table Diagram (View menu)

This view displays simple boxes for each table, procedure, and view containing their names.


Window menu commands

The Window menu offers the following commands, which enable you to arrange multiple views of multiple documents in the application window:

Cascade	Arranges windows in an overlapped fashion.
Tile	Arranges windows in non-overlapped tiles.
Arrange Icons	Arranges icons of closed windows.
Go to Window	Goes to specified window in list of open documents


Cascade (Window menu)

Use this command to arrange multiple opened windows in an overlapped fashion.


Tile (Window menu)

Use this command to arrange multiple opened windows in a non-overlapped fashion.


Arrange Icons (Window menu)

Use this command to arrange the icons for minimized windows at the bottom of the main window.  If there is an open document window at the bottom of the main window, then some or all of the icons may not be visible because they will be underneath this document window.


Go to Window (Window menu)

Visual Database Designer displays a list of currently open document windows at the bottom of the Window menu.  A check mark appears in front of the document name of the active window.  Choose a document from this list to make its window active.


Help menu commands

The Help menu offers the following commands, which provide you assistance with this application:

Contents and Index	Offers you an index to topics on which you can get help.
What’s This?	Context sensitive help
Using Help	Instructions on how to use help
About	Displays the version number and registration information for the application.


Contents and Index (Help menu)

Use this command to display the opening screen of Help.  From the opening screen, you can

jump to step-by-step instructions for using Visual Database Designer and various types of reference information.

Once you open Help, you can click the Contents button whenever you want to return to the opening screen.


Help Using Help Command
What’s This? (Help menu)

Use the Context Help command to obtain help on some portion of Visual Database Designer.  When you choose the Toolbar's Context Help button, the mouse pointer will change to an arrow and question mark.  Then click somewhere in the Visual Database Designer window, such as another Toolbar button.  The Help topic will be shown for the item you clicked.

Shortcut

Keys:	SHIFT+F1


Using Help (Help menu)

Use this command for instructions about using Help.


About command (Help menu)

Use this command to display the copyright notice and version number of your copy of Visual Database Designer.


Title Bar

The title bar is located along the top of a window.  It contains the name of the application and document.

To move the window, drag the title bar.  Note: You can also move dialog boxes by dragging their title bars.

A title bar may contain the following elements:

Application Control-menu button

Document Control-menu button

Maximize button

Minimize button

Name of the application

Name of the document

Restore button


Scroll bars

Displayed at the right and bottom edges of the document window.  The scroll boxes inside the scroll bars indicate your vertical and horizontal location in the document.  You can use the mouse to scroll to other parts of the document.


Size command (System menu)

Use this command to display a four-headed arrow so you can size the active window with the arrow keys.

After the pointer changes to the four-headed arrow:

1.	Press one of the DIRECTION keys (left, right, up, or down arrow key) to move the pointer to the border you want to move.

2.	Press a DIRECTION key to move the border.

3.	Press ENTER when the window is the size you want.

Note:  This command is unavailable if you maximize the window.

Shortcut

Mouse:	Drag the size bars at the corners or edges of the window.


Move command (Control menu)

Use this command to display a four-headed arrow so you can move the active window or dialog box with the arrow keys.

Note:  This command is unavailable if you maximize the window.

Shortcut

Keys:	CTRL+F7


System Minimize Command
Minimize command (application Control menu)

Use this command to reduce the Visual Database Designer window to an icon.

Shortcut

Mouse:	Click the minimize icon [image] on the title bar.

Keys:	ALT+F9


Maximize command (System menu)

Use this command to enlarge the active window to fill the available space.

Shortcut

Mouse:	Click the maximize icon [image] on the title bar; or double-click the title bar.

Keys:	CTRL+F10 enlarges a document window.


Next Window command (document Control menu)

Use this command to switch to the next open document window.  Visual Database Designer determines which window is next according to the order in which you opened the windows.

Shortcut

Keys:	CTRL+F6


Previous Window command (document Control menu)

Use this command to switch to the previous open document window.  Visual Database Designer determines which window is previous according to the order in which you opened the windows.

Shortcut

Keys:	SHIFT+CTRL+F6


Close command (Control menus)

Use this command to close the active window or dialog box.

Double-clicking a Control-menu box is the same as choosing the Close command.

Note:  If you have multiple windows open for a single document, the Close command on the document Control menu closes only one window at a time.  You can close all windows at once with the Close command on the File menu.

Shortcuts

Keys: 	CTRL+F4 closes a document window


Restore command (Control menu)

Use this command to return the active window to its size and position before you chose the Maximize or Minimize command.


Switch to command (application Control menu)

Use this command to display a list of all open applications.  Use this "Task List" to switch to or close an application on the list.

Shortcut

Keys:	CTRL+ESC

Dialog Box Options

When you choose the Switch To command, you will be presented with a dialog box with the following options:

Task List

Select the application you want to switch to or close.

Switch To

Makes the selected application active.

End Task

Closes the selected application.

Cancel

Closes the Task List box.

Cascade

Arranges open applications so they overlap and you can see each title bar.  This option does not affect applications reduced to icons.

Tile

Arranges open applications into windows that do not overlap.  This option does not affect applications reduced to icons.

Arrange Icons

Arranges the icons of all minimized applications across the bottom of the screen.


Print Progress Dialog

The Printing dialog box is shown during the time that Visual Database Designer is sending output to the printer.  The page number indicates the progress of the printing.

To abort printing, choose Cancel.


Next Pane Command
Next Pane

Sets focus to the next table object or foreign key path.


Prev Pane Command
Prev Pane

Sets focus to the previous table object or foreign key path


No Help Available

No help is available for this area of the window.


No Help Available

No help is available for this message box.