These ready-to-use features organize your data right away without any effort :
Multi-value cells are common to be used in an entry, such as the multiple goods items in an Invoice entry.
Formula can be used to confine the scope and displaying order of data in each of the list views.
List views for the Sales Order worksheet : All, Delivered & Outstanding Items.
Filter boxes created for the Sales Order worksheet : Order date range, Customer & Article.
Data in the list view (the top part) is summarized in the info pane (the bottom left).
Simply put cell names in a formatted Excel worksheet to create the document template, data are then exported to generate the output document.
Apart from saving your data in an organized manner, these features automate your data and streamline your works — all created simply with a single formula :
For an Invoice entry, the unique identifier is Invoice No, with part of it retrieved from ‘Invoice Date’.
Default identifier of a new worksheet.
Use current date as the default value of the date fields.
Default value is incremented by one to the upper row number.
Create a list of available Order No. as workflow entry selection in the Invoice worksheet.
Create a list of articles for entry in the Order worksheet.
“Description” and “Unit” pop out upon entry of “Article No”.
Entry of Order No. triggers multiple order items moved into the Invoice worksheet.
Display recent prices as the user is entering unit price of an item.
Can also create related info in List View.
Item quantity is checked against stock quantity, and a “warning” message is displayed.
When message type is “error”, the entry cannot proceed saving.
Formula steps are displayed on the screen when the formulas are processed.
These are the features that make your works more convenient :
BAU DB file opened in Ms Access. BAU DB bridges between Excel and Access to provide the benefits of both. That said, you can use all the features of BAU DB without installing Microsoft Access.
Data likes currency table can be stored in petty tables.
User Access Control
Update user access right of each worksheet. Note that this is a feature of BAU DB Pro.