BXL Tiny Database - Finally! Database features in Excel.
Originally published: 22/03/2021 08:18
Publication number: ELQ-13959-1
View all versions & Certificate
certified

BXL Tiny Database - Finally! Database features in Excel.

Finally, database features in Excel!

Description
Are you managing data in Excel?

Do you wish you had magical data entry forms that create themselves over your data, with your branding, full data validation, record search capability and more?
Do your records have dependencies like parent/child relationships, or order/order detail relationships, or Class/teacher/student relationships?
Do you wish Excel would automatically create a number your next order or your newest customer?
Do you wish Excel would prevent you from deleting a parent record when dependent children exists?
Has everyone told you to put that data into Microsoft Access but you just don't have the time to learn it, or the money to hire someone to create it for you?

Well someone has finally done it. Someone has added Access like features to Excel. Load Beyond Excel's Tiny Database and instantly, and I mean instantly, add data entry forms to any and all of your Excel tables.
Set your color theme in Excel and the entry forms take on your corporate branding (Works best with BXL Format add in!).
Data validation in your tables is enforced in entry forms.
Entry forms protect locked cells form changes.
We can restrict which tables allow additions, changes, and deletions.
Tiny Database can automatically create IDs for new orders, customers, products, etc.
Tiny Database can auto-sort tables to keep them in perfect order
We can link tables so
- When displaying a parent, we can also display its children
- We can prevent deleting parents when child records exist

Download user guide: https://www.dropbox.com/s/c95klkrzy654imj/BXL%20TDB.pdf?dl=0
Promotional video: https://youtu.be/Y7hMdIkBQuU
Demonstration video: https://youtu.be/I9e_V81C0z8

This Best Practice includes
1 User guide, 1 Excel Add-in (Windows version), 1 demonstration workbook

Acquire business license for $9.50

Add to cart

Add to bookmarks

Discuss

Further information

Manage data in Excel with Access like features.

WIndows only (sorry, no MAC support).
Fewer than 100,000 records in any one table
Single user.

Do not use on a MAC
Desktop Excel only.
Most PCs perform noticeably slower when managing more than 100,000 records in any one table
Not designed to support multiple users making simultaneous entries.

Reviews

  • Rate this Downloadable Best Practice

    Write a review

  • bbhatmaker(last updated: 07/04/2021 18:39)

keyboard_arrow_leftkeyboard_arrow_right

Any questions on BXL Tiny Database - Finally! Database Features In Excel.?

The user community and author are here to help. Go ahead!


5.0 / 5 (1 votes)

please wait...