How to create a sales database in LibreOffice Base

This is a Base Database tutorial covering how to create a sales database part 1. The tutor starts off by creating three tables, customers, products, and sales. The tutor uses the relationship window to relate the tables. The tutor adds some sample data and creates a query followed by a report. Reports use LibreOffice Writer. The tutor then creates several forms and explains how they work. In the final part of the video the tutor uses all three tables in a query and generates a report grouping by customer. How to create a sales database in LibreOffice Base.
#base
#libreoffice

Courses are available through Microsoft Teams, Online and Face to face in the UK

Training Guide Books
Excel for New Managers
Very cheap E_books are here:

[libreofficetutorials]

Create a Base database part 1. Get started

[PatrickPhilipp-th]

Thank you for doing those Base tutorials. This is a great program with some kind of steep learning curve. LO Base does unfortunately not get the attention it deserves. This is a perfect database program with some rough edges however. Please keep doing these LO Base videos from time to time. I would be pleased to see a more complex Base tutorials with queries an even form design. I like to thank you again very much to do these videos. There are not many people around like you which are familiar with LO Base.

[isahilliogluu]

Thank you! Please consider scaling the UI bigger for your new tutorials. It is a little difficult to see the text and put stress to the eyes unless you watch this on a quite large screen.

[robintyson]

Thanks for that. Got stuck with entering the sales. You skipped over it and showed one 'that you had prepared beforehand' I think? If I try to enter the second of the sales in that table it gives an error - "Integrity constraint violation - no parent SYS-FK-62 table: Customers in statement." It doesn't allow me to enter any of the other fields.