Databases in Excel 2010 from a flexible input mask with assignment of data types to create and edit.

An Excel spreadsheet is basically a database

 

 

 

 

 

It is very easy to edit the worksheet.

Only if the editing scope extends to multiple columns and rows, is somewhat uncomfortable to navigate or to find you are looking for entries.

 

This is much easier to do from an input mask.

 

From the most entry forms, you can edit only specific worksheets, where a data type is assigned to each area and it does not change.

 

With the flexible input mask, you can edit all worksheets in Excel file.

It doesn't matter which column which data types to be registered (in the range of column B to column N).

From the flexible input mask, you can assign a data type to all 13 columns.

The program works with 4 types of data: text, number, date and time.

The allocation scheme for each worksheet is stored and automatically upon activation of the leaf.

The input mask contains no unnecessary controls, this is very compact, uncluttered and not very big, what allows to use this program in small notebooks.

 

Also a search mode has the flexible input mask.

In search mode, you can evaluate any active worksheet for different search terms, and it doesn't matter which column (from column B to column N) is the term you're looking for.