Records Management:

Motel Reservations &
Motel Management Example.

User Created Records Management Database:

For Motel Reservations,
Point Of Sale Receipts & Motel Management.

Other inqVista Links:

HOME Page,

Project Management:
Project Fire Truck: Example

Image Management:
Stamp Collecting: Example

Asset Management:
Coin Collecting; Example

Information Management:
Phone, Address,
& Reports; Example

Human Resources:
Employee Management; Example

Time Management;
Calendar With Alarm; Example

Most Secure Database:
[Div] Option: Example

Printing a Receipt:
Reports Management: Example
      opening splash screen.

For a Free Trial Version of inqVista
go to: inqVista's HOME Page.


The program that allows the user to design, add to, delete from, and make changes to the structure of the database for the life of the database.

Our mission is to design a program that gives any user that can read, and one that can find keys on a keyboard, the ability to design their own computerized storage system; one that will suit their needs for as long as they own it.

Unlike other software, inqVista lets you determine the name of each row.  Just this simple feature saves time because you decide what the name of a row should be.  You don't have to learn what someone else thought you want.  And, further, you can change your mind.  Yes, you can change and modify inqVista to suit you.  You can change the name of rows, add rows, delete rows, and even move rows whenever you think it is necessary.

"inqVista" has many features, but some of its most attractive are that it is easy to setup, easy to change, and easy to use.  These features are important because your requirements may change from time to time and you should not have to start over learning about and creating new databases.  Also training others to use a program that you designed is a lot easier and faster than having them read a manual or calling an 800 number.

Also, since many companies and individuals have a need for more than one database, using inqVista means that you can keep track of related or un-related information by creating two or three databases, on your computer.  For example, the creator of this MyMotel database may also create an inventory database which may include pictures of each room, including the furniture.

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

As you can see in the top, light green border of this Master Data Entry Screen, the user has named this database MY Motel.

You can name your database Clients, Inventory, Employees, Coin Collection, Reservations, or anything else you choose.  And, you can have more than one database, on your computer.

Each record's Master Data Entry Form has a note field attached, and labeled "Record Notes".  This is one of many note fields attached to each record, ready for adding information.
this image is the 
     default master data entry form.

Throughout "inqVista", if you choose an option, one that is not a valid for your database at that time, then you will get a friendly reminder giving you information on how to proceed.  In other words if you want to know what to do next, choose the option that seems to be the correct one.  If that choice is incorrect, a message box will open with information on how to proceed.

After you name a new database, then from the Master Data Entry Form, choose the [Modify DB] option.  This option opens the Modify Database Form, (below).

From the Modify Datadbase Form you can:
  • Change Row Names.
  • Add or Delete Rows.
  • Move Rows.
  • Change Row Data Type.
  • Use these features ANYTIME you have a need to make a change.
Default modify db 
     window used for adding rows, changing and saving row names, changing data type, moving a row, and other available options.

The Modify Database Form is where you will customized your database to suite your needs.  The options available for inqVista are the names on the buttons.

Whether the row has a name or not, entering the name that you want to use into any entry field and choosing the [Save name changes] option, changes the row name.

To the right you can see the results of simply typing LAST, FIRST, into the pink entry field. then choosing the [Save name changes] option.  Naming the light green row ROOM NO. is done in the same way.

You can use this form as is, if this is all you need.  Choosing the [Return] option sends you back to the Master Data Entry Form.

However, below, this form was modified again to suite the users needs.
default blank 
     modifyDB form showing new entries into the first and last rows.

Below, three additional Master Rows were added to the two original Master Rows. The additional rows were named to show some of the possible row names one could find in a customized database.

Also, notice that the Data Type, shown in the Modify Database Form below, has a default of "Text".  Later, changes are made to the Data Type of some of the fields to accommodate specific needs.

To continue, you would choose the [Add a row] option to add additional "Master Rows" to your Master Data Entry Form.

From this form, you can change the Data Type of the entry fields that you may want filled in.  For example, CHECKED IN or CHECKED OUT.

From here you can choose the [Change data type] option.
modifyDB window 
     showing additional rows added to the existing database.

Since I already have an idea as to what I want, I'm going to change the Data Type of two of these entry fields to Date.  Choosing the Data Type of Date can help you in a number of ways.

First, it will force every user to enter a date in the format that you choose.  There are good reasons for using a specific format, however, exceptions can be made when necessary.  We will explore these exceptions with screen shots from inqVista, that follow.

Next, you can sort your database by date, the date that was entered when making an entry into the Master Data Entry form.

Changes to the Data Type of your chosen rows, from Text to Date, are easily made. And, reversing these changes, back to Text, or choosing any other option, is just as easy.

Choosing the [Change data type] option in the Modify Database Form, opens the gold. "Entry Field Row Number" form that you see on your right.

The user will enter a row number, then choose the [Continue] option.

After the gold, "Entry Field Row Number" form closes, a new form, the "Data Type Choice" window, (right), opens.  This new window shows the Data Types available for this row.
My Motel Data 
     type options window opened so the user can choose the data type for a specific row.

My Motel Data type 
      entries window opened so the user can choose the data type from a list of available types for that row.

Above, the user picked the option of [Date]. That choice opened one more window, (shown below), which offers a variety of Date Formats.

Here you can see the choices that you have after choosing the Data Type of Date.

This user chose the "YY-MMDD" Date format. 

This choice means that the user's entry into the Master Data Entry Form (below), will be 13-1216, which is December 16, 2013.
     modifyDB form shows the choices of Date formats available.

Below, this is what the Modify Database Form looks like after adding a row, (row 4), and changing the Data Type of a few rows.

On your right you see the results of changing the Data Type from Text to Date.

The user chose the Data Type of Date for two entry fields.  Using the data type of Date means that the database owner can compel the user to enter dates in the chosen format.

There are exceptions which we will show after returning to the Master Data Entry Form.  However, aside from the exceptions, if the user tries to enter any other format, a reminder message appears showing the correct format.

My_Motel modifyDB 
     form shows the results of changing the Data Type of a few rows.

Below, the Master Data Entry Form is ready for use.  Ready for use includes using the [Modify DB] option again, and whenever you think it is necessary.

inqVista is designed so that anyone that can read and find keys on a keyboard, can create a database to suite their needs.  inqVista is designed so that anyone that can read can use inqVista.

There are NO MANUALS, or TRAINING GUIDES.  Why?   Because, training consist of choosing options, clicking on [F keys], and [Buttons] just to see what happens.  inqVista will do either what the available options suggest or a message will open explaining how to proceed. Also, almost every form has an information option.  Choosing [Information] will give the user information about some of that form's options.

From the Modify Database Form, choosing the [Return] option, sends you back to the Master Data Entry Form, (below).

This Master Data Entry Screen, shows the results of making Data Type changes from "Text" to "Date".  It also shows what the form looks like after adding a few rows.

inqVista is ready for use.

And, inqVista is ready for you to modified again, if and when you think it necessary.
Finished making 
     changes, such as entering row names and changing data types in the Modify Database Form this image shows the Master Data Entry Form 

Below, the Master Data Entry Form had data entered into it and then saved.  After that the [Find / Edit] option was chosen and the first record of this database was picked.

The Master Data Entry Form was populated with the data you see below.

You can also see in the Master Data Entry Form header, the information that the MY MOTEL database contains 0001 ACTIVE Record.  For some users this information becomes important for a variety of reasons.  Each user has a different consideration for this information.

This Master Data Entry Form, is populated with the entries that the user made.

First, the user entered the data.

Next, the user chose the

Last, the user chose the
[Find / Edit]
option (shown below), and selected this record from the menu.

This MY MOTEL database was quickly populated by choosing this record.  Then after making a few changes to the selected record, such as changing the ROOM_NO, and changing the ROOM_TYPE/RATE, a new record was created and saved.

Because the user changed the last row, ROOM_NO, (green field), and saved it, a new record was created.

Changing either the pink, first entry field, or changing the last entry field, then saving, creates a new record.
The user chose 
      one record using the Find option. This choice populated the Master Data Entry Screen with data that was previously entered.

To add many records in a short time the user chose the same record and made a change to either the pink or green entry field, then saved the changes.

Changes to either the pink or green entry fields creates a new record after saving the changes.

This Find / Edit Window shows some of the Current Records contained in the MY MOTEL database.

Look at the list of records and you can see that the first, left column, contains the row number and the room number.

The second column has either a guest's name or ZZ-Vacant.

The user chose this method to display the availability of their rooms, and you can choose whatever suits you.

To get these results, first choose the [Sort Order] option, found in the Master Data Entry Form.

Next, enter the row number of the Entry Field from the Master Data Entry Form in the position that you want it display.

The next frame will show how to change the display of the entry fields in the [Find / Edit] form.
This window shows 
      the results of opening the Find / Edit option after the user entered 15 new records.

The user chose the [Sort Order] option from the Master Data Entry Form.  This choice opened the Sort Order Form as shown below.

This Sort Order Window is the place where you will make the decision of what column goes where.

In the List Box (above), the row data will appear in the column you want it to.  This window (right), also gives more information on how to use the option.

Above, the user chose a specific order for display.  The reason for this Sort Order was because of a need to find vacant rooms.  And, on your right, at the bottom of the page, you can see the Sort Order that the user entered.

However, the user did not enter all of the row numbers.  The user simply entered the first two row numbers.  You can enter one, two, or more row numbers, depending on the list view that you want.  inqVista will enter the rows that are left out. In other words, you can simply enter 6, 5 and inqVista takes it from there.

Let's suppose that a guest is checking out of MY MOTEL.  Then, I may consider changing the Sort Order to 1, 6, 4 and saving the change.
This window 
     shows the results of opening Sort Order option.

The Find / Edit Window (below), shows the result of simply changing the Sort Order Sequence.  The previous entry was 6, 5, and the new entry (not shown is 1, 6, 4.  The next frame shows what you should expect.

Choosing the [Find / Edit] option an opening this new window shows the same records as shown in the previous FIND / EDIT WINDOW.  However, the user changed the Sort Order.

This list of records shows that the 1st, left column, still contains the row number.  But this time the first column also contains the guest's name.

The 1st column may also contain ZZ-None.  This user decided to enter ZZ-None when the room is not occupied.  This ZZ-None entry was used because entries are listed alphabetically and this entry will always appear below all guests names.  You can see the top three entries are guests.

The 2nd column, contains the room number.

The 3rd column shows the ROOM_TYPE/RATE.

The ordered display, in this window, was produced by the user first clearing the previous entry then entering the row numbers, [1, 6, 4 ] into the Current sequence entry field.  You can see the results here.

      window shows the results of entering a new sort order, then opening the Find / Edit option.


The user is in control of the security of all Division Records so the security is as safe as the user wants to make it.

For examples of Division Records at work, check:
Image Management; Stamp Collecting (link) or
Project Management: Project Fire Truck (link), and other inqVista links..

image explaining the secure 
     division records.

Explaination of other features available for inqVista, including creating more than one database on a single user's computer.

Rev. 16-0128

Records Management:
Motel Management;

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