Data Entry for Excel

Dexel Form gives you data entry forms for Microsoft Excel without any programming. Form based data entry, extensive data validation, protection, multi user access and a host of other features make your Excel databases robust and easy to use. It works on both Windows and Mac and it’s free.

Features

data entry

  • Form-based creation, editing, deletion and filtering of records
  • Searchable drop down lists for lookup of data in related tables
  • Date picker for date fields
  • Multiline editing of long text fields such as postal addresses
  • Customisable help text for the form and for individual fields

multi user access

  • Easily share your workbook with colleagues via a network share
  • Multiple users can update the shared workbook at the same time
  • Dexel Form ensures that data validations are enforced even when multiple users are active

data validation

  • Ensure required fields are filled
  • Data type validation and formatting (numeric, date, time, interval)
  • Uniqueness of values (unique keys), or combinations of values (composite keys)
  • Verification of data against related tables (lookups and conditional lookups)
  • Foreign key mechanism to ensure the integrity of relationships between tables
  • Custom data validations using standard Excel formulae with structured addressing
  • Recognises the Data Validations you may have already defined in Excel

auto increment

  • Dexel Form can automatically assign a unique sequence number to each record

default values

  • Using Excel formulae you can define default values to be inserted into new records

data protection

  • Protect tables (either with or without a password) such that the table data can only be updated using Dexel Form, thereby ensuring that data validations are rigidly enforced.
  • Optionally limit the actions that a user can perform on data in a table (e.g. do not allow records to be deleted)
  • Define columns as “read only” (value cannot be changed by the user)
  • Define columns to be “write once” (value is set by the user when the record is created but cannot be changed thereafter)

audit

  • Create a complete audit trail of all changes made to the data in a table

data verification

  • Highlight errors in data imported from external sources
  • Clean data by removing trailing spaces
  • Consistent application of formulae

no real limits

  • Handles tables with up to 1,000 columns
  • Number of rows is limited only by Excel (over 1 million)

programmability

  • If you want to use Dexel Form to manage the data entry dialog for hidden sheets, you can write simple macros to do so.


One thought on “Data Entry for Excel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s