[Solved] Advice on creating my first database

Discuss the database features

[Solved] Advice on creating my first database

Postby neiloneil » Sat Jul 07, 2018 12:31 pm

I want to create a working database , which I can use, edit, and learn from. Getting started is proving too difficult for me though. I have, over the years tried and given up multiple times. I have followed advice from youtube videos and form other sources, which seem to make sense , but it doesn't ever come together as I expect.
would somebody help me please? I need a form with the relevant tables to achieve the following columns as attributes which I can cross reference with each other.

id number, date, description, customer id, project , retailer id, price, invoice sent yes/no, paid yes/no.

Can you suggest a download link for a ready made database which I can edit to suit my needs please?
Last edited by Hagar Delest on Mon Jul 09, 2018 10:45 pm, edited 1 time in total.
Reason: tagged [Solved].
open office 4.1 on windows 10, 64 bit
neiloneil
 
Posts: 8
Joined: Fri Apr 27, 2018 1:27 pm

Re: advice on creating my first database

Postby Villeroy » Sat Jul 07, 2018 2:25 pm

Does not work like that. You need a little bit of theoretical knowledge, study some example databases, build some simple excercise databases on your own before you will be able to construct anything productive. "Intuition" will lead you to dysfunctional waste lands.

Resources: https://forum.openoffice.org/en/forum/v ... 17#p225017
Tutorials: https://forum.openoffice.org/en/forum/v ... m.php?f=83
Examples: https://forum.openoffice.org/en/forum/v ... .php?f=100

Base is not a database. It is a product to link various types of connectable databases with office documents.
Base comes with a very small and simple real database product called HyperSQL or HSQL. The databases produced by HSQL can be embedded in the Base documents. Any other type of database connection is linked to some tabular data source outside the Base document. In many cases a spreadsheet or text file is treated as a database so it serves as a simple source for a form letter.
In fact the "embedded HSQL" is a fake because it will be extracted when you start working with it and repackaged when you stop working with it. While working, it is just an external databsae like any other connection. This embedded HSQL is well suited for learning and exercising but not for productive purposes. However, it is fairly easy to turn it into a non-embedded, more secure version of a productutive database.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 25750
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Advice on creating my first database

Postby UnklDonald418 » Sat Jul 07, 2018 5:51 pm

I uploaded a simple database that demonstrates something similar to what I believe you are needing.
There are 3 tables; Customers, Retailers, Tbl_Main and 3 forms. CustomerEntryForm and RetailerEntryForm use table grids to add/display/edit records in the Customers and Retailers tables.
MainEntryForm is used to add/display/edit records in Tbl_Main. It has 2 listboxes that allow Customer and Retailer ID values to be selected from the appropriate tables.

Demo28_Statements.odb
(37.66 KiB) Downloaded 123 times
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.5 & LibreOffice 6.0.4.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 960
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Advice on creating my first database

Postby neiloneil » Sun Jul 08, 2018 2:37 am

this is brilliant, thank you very much.
open office 4.1 on windows 10, 64 bit
neiloneil
 
Posts: 8
Joined: Fri Apr 27, 2018 1:27 pm


Return to Base

Who is online

Users browsing this forum: No registered users and 6 guests