The First Rule of Microsoft Excel: Don’t Tell Anyone You’re Good at It

Re:The First Rule of Microsoft Excel: Don’t Tell Anyone You’... by Nullabillity on Friday October 05, 2018 @08:02PM (#18152705)

> People say "use a real database", fine, but where is the visual data entry?

Any visual DB client?

> Where are the easy adhoc reports?

Isn't that just queries? Then throw it into a view to "save".

> Where are the forms?

No idea what you're looking for here, but this sounds a lot like your first question.

[ Parent | on HN ]

Re:The First Rule of Microsoft Excel: Don’t Tell Anyone You’... by yawaramin on Friday October 05, 2018 @08:51PM (#18152850)

Ad-hoc reports are not just saved queries, they're saved queries + something like Word's mail merge feature so that you get a data-driven, print-quality document, like an invoice.

Forms are data entry views that save to the backing tables. Nowadays the most well-known forms are probably https://docs.google.com/forms/

[ Parent | on HN ]