DB Vue allows users to easily edit data and search tables and fields in
Oracle and Access databases and to export data to Excel.
It is designed to save time and money, it is easy to use and
preserves user's options for the next time it runs.
Features and Benefits
- Compatible with Oracle and Access
databases.
- Edit the data in databases
- Add or delete rows of data in databases
- Filter tables by name
- Search for a field by name in all tables
- List all fields and their properties in each table
- Show tables by type
- Copy fields to Excel or to other applications
- Browse through the records of the tables
- Copy data to Excel or to other applications
- Export complete tables or selected columns from databases to Excel
- Settings are saved between sessions
Usage
-Start the application by browsing the
menu: All Programs, Office Optimum, DB Vue. -Enter the database information:
-For Oracle enter the data source name,
user ID and password in the Oracle tab then
click Browse.
-For Access click the
Select Access button to select an MDB file
in the Access tab. Enter the user ID and
password, if required by the database, then click the Browse
button.
All the available tables will be listed in
the Tables grid.
-You can use the Show option buttons to view only certain
types of tables.
-Filter the tables by entering a table
name or part of its name in the
Filter Table Name box. -Search for a column by name
in all tables by entering a column name
or part of its name in the Column Name
Search box
provided and clicking the Search button.
-Click the Browse
button again to refresh the list of tables.
-Double click a table name or its row
in the Tables grid to list all
columns and data in that table.
-The rows of data listed are limited by default in this application to 100 rows. You can
change this value in the Settings menu.
Increasing this value will reduce the
application response time.
-To copy any data from the grid select one or more cells or a complete row, then press Ctrl + C
keys.
-Sort data by clicking on the column header. Click again to sort in reverse order.
-To export data from the current table to Excel, first select columns you wish to export by double clicking column headers or leave all columns unselected to export them all. Then, click the Export to Excel button.
-To edit data in a cell, double click a cell in the data grid and add or
change its value, then click the Save
Changes button.
-To add a new row in the table enter
values in the last empty row, then click
the Save Changes button. The
values entered must be according to the
type of data required by the respective
columns. Incorrect data will not be
saved to the database.
-To delete rows select the row headers,
then click the Save Changes
button.
-For security reason the passwords are not saved between
sessions.
-Also, this application does alter the structure of any
database.
Home
AutoCAD Tools
