BXL Tiny Database - Finally! Database features in Excel.

Finally, database features in Excel!

by Craig Hatmaker
IT Executive and author of Ribbon Recipes: Beginner's Guide to Creating Excel Menus available on AmazonFollow 10

1 review301 views|Start the discussion!|Bookmark Add to cart - $9.50

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