TOP: Asset Management"

After viewing this page, choose the Image Management link to see another method for managing assets.  There, you will see how all items are put into one Master Inventory record and then divided into sub-categories.

A User Designed Database To Control And Manage;

Assets, Clients, Employees, Parts, Projects,
Products, Sales, Real-Estate, Time, And Information.

Other Links:

inqVista's
Home Page


Project Management:
Project Fire Truck; Example


Image Management:
Stamp Collecting; Example


Information Management:
Phone, Address,
& Reports; Example


Records Management:
Motel; Reservations
& Records; Example


Human Resources:
Employee Management; Example


Time Management:
Calendar With Alarm; Example


Most Secure Database:
[Div] Option; Example


Printing a Receipt:
Reports Management; Example
splash
     screen.

A Free Trial Version is available.
Register on:
insVista's HOME Page,


inqVista gives you the ability to create an easy to use database that will keep track of information that relates to your assets.  These assets can include such items as coins, clients, inventory, records, Images, real-estate, and other such assets.

inqVista has many features and some of its best are that it is easy to setup, easy to modify, and it is easy to use.  These features are important because they save money by saving your time.  And, since your data management requirements may change from time to time, you do not not have to start over, installing and learning new software.

Many users have a need for more than one database.  Using inqVista means that you can keep track of many dissimilar types of information with the same software.

After typing a few key strokes you are now in command of a new database, on the same computer; a database that is ready to store information.


Consider that the computer used to program this website contains all of the other databases that are shown and linked to this web page.



The image presented below is inqVista's default Master Data Entry Form, ready for you to modify.  This is the first form that you will see for whatever type of database you intend to create.

As you can see near the top of this Master Data Entry Form, the name the user gave to this database.

You can name yours Phone Book, Clients, Inventory, Employee Records, Real-Estate, Patients, Student's Grades, or anything else you choose.

Each Master Record has a general note field attached, ready for data entry.  These note fields are populated with any saved notes when loading a record.

This is one of many note fields available for each record.
default
     master data entry screen showing clock, date and all available options for this entry form. These options include information, save,
     find/edit, delete, sort, reports, modify DB, div_options, get_icon and calendar options.


Choosing the [Modify DB] option while in the Master Data Entry Form, (above), opens the Modify Database Form shown below.


From the Modify DB Form you can do exactly what the options imply:
  • Add or Delete rows.
  • Change Row Names.
  • Change Data Type.
  • Move Rows.
You can use these features anytime you have a need to modify your database, even after using it for long periods of time.
modify
     database form for adding, changing data type, moving, saving, and changing row names and other available modifications.


The Modify Database Form, (above), is where you will customized your database.

While in the Modify Database Form, entering a row name into any entry field then choosing the [Save name changes] option, changes the row name.

Also, choosing the [Add a row] option will add a blank "Master" row to your Master Data Entry Form.

Below, a few Master Rows were added to the two original Master Rows.  All rows were named to show some of the names one may find in a customized database.


The user changed the Data Type of some of the rows.

The Data Type's of Image and Folder were used because both types open either an Image File or a Folder. The user knows that this is a real time saver because with a simple click, the image is open.

Or, a click and the Folder that contains other Files, Folders and computer programs are there.

Someone using your computer can go directly to a Folder or an Image File and have it opened automatically.


modify
     database form with two rows added and all four rows named.
From the Modify Database Form, (above), choosing the [Return] option closed the Modify Database Form and returns you to the Master Data Entry Form.

This is what you could see after returning to the Master Data Entry Form, entering record information, saving it, then using the [Find / Edit] option.

Choosing the [Find / Edit] option and picking one record from a list of saved records will load the entry fields with the record's information.  You may see something like what you see below.


"inqVista" will follow the path shown any entry field with the Data Type of Image or Folder.  In this case, a simple click on the light green [DIV] button, row 3, opens the intended Folder or File.

Loading the path into the entry field is accomplished simply by clearing the field then pressing the [Div] option. The file finder helps the user locate an image in the user's computer.  Once found and selected, inqVista will automatically load the path into the entry field.  A message will let you know that the path is saved.

Choosing the [Div] option button, located left of any entry field that has a path will open that item along and an additional window.  This window contains the Division Record Form where the user can store additional information about that item.  The Division Records Form is shown below the American Double Eagle Bullion Coin a few frames below.
modified
    database entry form with newly added rows, one showing the path to an image saved somewhere on the users hard drive. Also, notes
    entered into the Master Data Entry Field.


"inqVista" is the most secure database.
Your division records are as secure as you care to make them.

Statement
    telling the viewer that inqVista, is the most secure database.


Choosing the [Div] option button located to the left of Master Data Entry Row with a Data Type of Image, opens both the Image and the Subdivision Entry Form. Both are shown below.

In this Subdivision Form the user divided Master Data Entry Row 3, PHOTO, into 4 additional rows.

Opening a Subdivision Entry Form offers additional space for more specific information, including another Note Field.  And, from within this Division Record Form, you can Add, Name, and Delete rows to suite your needs.  The results of using these options are shown below.


You can subdivide any of the Master Data Entry Rows from the Master Data Entry Form, (above).

To divide a row, simply click on any of the light green or pink [Div] buttons found to the left of every Master Data Entry Field.

For this example, over time each row in this Subdivision Form was created and given a unique name. The user chose Purchase Date, Purchase Price, Pur. From, and Paid By. The data was added and saved when it was convenient.

You will also notice that at the end of each entry field there is a date field that loaded automatically with the user's current date. The user may change this entry as necessary.

This date is used by the [Report] option to find information saved in these Division Records.

The Master Data Entry Form is where you can find the [Report] option.

Each time the [Div] option is picked from the Master Data Entry Window, and from this particular row, then both the Image and the Subdivision Form will open, as you see on your right.

You can have more or less rows for each Subdivision Form and this depends on your needs.  You can Add, Delete, or Rename rows as your needs change.
Stored
     picture and Subdivision Form  opened using the [div] button found on the master data entry form.

Division form
     showing 4 additional rows, including notefield and stored image


From the Division Form, you can return to the Master Data Entry Form by choosing the [Close] option.

After closing the Division Records Entry Form, you return to the Master Data Entry Form.  You'll notice that the image is still open. This image will stay open until you close it or until you close the program.

You can open this image again and have two of the same images open.  Or, you can open other additional images if you care to.

Also, you can see that what was a light green button named [Div] has now changed to pink and is named [DATA].

"inqVista" changes the name and the color because each record is different.  This feature lets you know that this record has a divided row that contains data, and this divided row is relative only to this record.

Whereas another record may have information stored only in the first row, Coin_Name.  And, in that case, then for that record the [Div] button would also change to pink.

Consider having 100, 500, or 5000 records, each with information stored in different divided rows.  Trying to remember which record and which row had information would be difficult.

There are other ways to find information stored in the Division Records Database.  One way to search for and find data in the Division Records Database is to choose the [Reports] option.  You can see this option in the Master Data Entry Window on your right.

Choosing the [Reports] option opens the Reports Option Form.  From within that form you would choose the [Div_Search] option.

To get a better idea of how the [Div_Search] option works, go to the Human Resources: Employee Management; Example, (link), found here in this page.


stored
     picture stays open even after closing the division information window and returning to the master data entry window.


In the previous Master Data Entry Form the user chose the [Div] button that opened the Image you can see above.  The images of the The American Eagle Gold Bullion 1-oz. coin is still open.

The open Master Data Entry Form below was open again and the user populated the form with a listing of a Double Eagle, from 1933.

Master data
     entry form with newly added rows. One record is loaded into the entry fields to show an example of how the Data Type of Folder is
     used.



Above, looking closely at the Master Data Entry Form you can see a few subtle changes.

First, the name of this database was changed from COIN MANAGEMENT to COIN MANAGER; this is the same database, renamed.

Next, a few new records were added as demonstration examples for these web pages.

The following examples will show how the Data Type of Folder can keep track of your assets by putting information about those assets on your computer.

Looking at the Master Data Entry Form (above), you can see an entry field named MY_COLLECTION.  This entry field has a Data Type of Folder and is populated with the path to a file named inqVista.pnm.

Below, you can see the results of choosing the light green [Div] button adjacent to entry field 4), located in the Master Data Entry Form (above).

Here, row 1 is highlighted and it is the same path that is found in the Master Data Entry Field 4), (above).

This Folder View window, shows row 1), highlighted, and shows the path to a Folder named Coins. Coins is the Master Folder; the Folder that contains all of the coins that this collector owns.  You can read that this Master Folder contains 3 sub-folders.

Here again the same statement can be made; these Folder contains all of the coins that this collector owns.  This collector named the Sub-Folders as follows:
  • The first Sub-Folder in row 2), is named All Dollars.
  • The second Sub-Folder is in row 3), and is named All-Bullion-Coins.
  • The third Sub-Folder is in row 4), and is named All-Eagles.
This Folder View window also shows all of the folders and files in the sub-folders mentioned (above).  You can see the names of the sub-folders and all files in each of those sub-folders.

Looking at the Folder View window you can see a folder named, in square brackets, [All Dollars].  And, below it on line 6), you can see a File named Four_Dollar_Gold_1.png

To continue this example, the user chose to click on row 6) to open the Image "Four_Dollar_Gold_1.png".
Master
     data entry form with data type of Folder showing the results of choosing the Div option located in the master data entry form.


Above, the user chose to open, "6) Four_Dollar_Gold_1.png."   

Below are the results, just as the Image is displayed on this computer.

This image is the way my computer opened the file stored on this computer's Hard Drive.

This Folder View image is the second way to find an image stored somewhere on a users computer.
Opened
     Image showing two, four dollar gold coins that is opened after choosing a row from the Folder View that is also opened by inqVista's
     Div option.


From time to time you may want to compute the value of your assets.

Using inqVista, you determine which items to compute or count.

Below you will see a few ways to count and compute the value of items that you have entered into the Division Records Database, inside inqVista.

This user divided all assets into three classifications. In the above Folder View, you will see on Row 4, a folder named All-Eagles.  The images and explanation below will show how to count and compute the imaginary value of only those coins.

To start a computation you can choose the [Reports] option from the Master Data Entry Form, already opened above.\

The Master Data Entry Form, contains data.  However the form can be a blank, and with a simple click on the [Reports] option, the Reports Option Form, on the right, will open.
Image
     showing inqVista's options for searching, saving, and printing information saved in inqVista.


For our purposes here, to compute all assets found in one folder on this user's computer, this user will choose the [Div_Search] option from the Reports Option Form, (above).

Below the Division Records Search Form has opened after choosing the [Div_Search] option..

From the Reports Option Form, (above), the [Div_Search] option was chosen to open the Division Records Search Form shown on the right.

This form has almost all of the instructions displayed when it opens, just as you see here.

This search form, gives you a variety of options not found in other off the shelf databases.

For example, once this window opens, the user can simply choose the [Search] option.  Choosing the [Search] option from this default form, will collect all information stored in inqVista's Division Records Database.

But, for this example, this user only wants a total purchase Price of all items that are in the Division Records Database and are called Eagle.

You could search for Paint, Cameras, red bricks, part No. ae123 or anything else you think is necessary to find.

Find includes finding the object and any information that you relate to it.  That information may include count (how many) and value, (purchase price or selling price).
Image
     showing inqVista's options for searching, saving, and printing information saved in inqVista.


The method shown here, to count an compute Eagles is the same method that one would used to compute and count other items that a user may have saved into the Division Records Database.  These items include but are not limited to any person, place, or thing.

This next window will show how this user searched for all items that were classified as Eagle.

Rather than use the default entry shown above, this user decided to be a little more specific.

This search is more specific because for this search, the user simply typed Eagle=;, highlighted in yellow on your right.

The entry is simply a word, with an equal sign, and followed by a semicolon.  In this case the word is Eagle.  The Following pages will show the results and explain why this search works.
Image
     showing inqVista's options for searching, for information saved in Division Records. In this search, the user is searching specificaly
     for a rare 1933 Gold Double Eagle coin.


The next window shows the results after choosing the [Seach] option from the Division Records Search Form, (above).  And, after entering an item name follow by an equal sign and a semi colon.

This List box, on the right, shows the results after choosing [Search].

This investor has a only eight Gold Eagle coins but depending on the user, the results may be in the hundreds, or thousands, depending on the items searched for.

Assume for a minute that the search was for cases of 1/4" x 20 hex head machine screws, and, the results were 2187 cases.  Computing the results of the search is difficult.

In this form, the user can simply choose the [Compute] option and produce results as shown in the next page.
Image
     showing a listbox with the results of searching for a Gold Eagle coin. The results produced a listing of a rare 1933 Gold Double Eagle coin in the users collection.


In the Div Search Results Form, (above), you can see the [Update] option .  Choosing the [Update] option after first highlighting one or more items will remove the highlighted items from the form. Any action the user performs on this listbox, will not include the removed records.

The next window shows the results after choosing the [Compute] option from the Div Search Results listbox, (above).

This window on the right, shows the results after choosing the [Compute] option from the Div Search Results listbox, (above).

You can see that there are eight items returned and you can also see the value of each item.  You can see the description of each item, with a note appended, (cost).

This works because when the item was entered into the Division Records Entry Field, the user entered the data as follows:
"eagle=, 4751.00, quarter eagle cost"
Or,
"eagle = 4751.00, quarter eagle cost"

The reason the [Compute] option works is because a word is followed by an equal sign which is followed a number or amount. The 8th row description, "quarter eagle #3 cost", follows a comma after the amount, 4751.00.

The user could add a second row to the Div Record and add another word to search for.

For example the user could enter words such as Silver, Gold, Rare, Antique, Wanted. An equal sign could be added, or not. Adding an equal sign depends on the results that you desired.  Without an equal sigh, a user could not compute a total.  However, the results would be similar to the Div Search Results, those showing the eight Eagle coins, (above)

The beauty of inqVista is that you can return to any Division Records Form and make changes as you need to.
Image
     showing a listbox with the results of searching for Eagle coins. The results produced a listing of Gold Eagle Coins which included a
     rare 1933 Gold Double Eagle coin in the list.


Explaination of other features available such as creating more than one database on a user's computer.

Rev. 17-0110

E:Mail Webmaster
Asset Management:

Coin Collecting Example

Go to Top: Asset Management"
inqVista's Home Page
Project Management: See Project Fire Truck Example
Image Management: See Stamp Collecting: Example
Information Management: See Phone, Address, & Reports; Example
Records Management; See Motel; Reservations; & Records; Example
Human Resources: See Employee Management; Example
Time Management; See Calendar With Alarm; Example
Most Secure Database: See [Div] Option; Example
Printing a Receipt: See Reports Management