# Difference Between Table and Database

What is the difference between the Table which serves as a form to enter data into the Database, and the Database itself, or is there any? Every time I want to add to the Database, I have to open the LibreOffice App, then click on the icon which should open the Database, then click on Tables to get to the form to see previous records and enter more. Is there no way to open the Database directly and just start adding records without going through all this? I should really only have to look at the Table when I want to Edit the Table itself--not the Database! Thanks!

edit retag close merge delete

Sort by » oldest newest most voted

Hello,

First let's start with Base. Base is a front end to a database. It provides tools to more easily deal with the actual database. You can create Forms which allow Table entries.

The Database itself contains the actual data - Tables. LO Base ships with a default database - HSQLDB embedded. Embedded means the data is contained in the .odb and can have corruption problems with larger amounts of data.

You need to open Base to access anything. However, you should have a Form created for your data entry. What it sounds as if you are doing is going to the Table view & entering data there. It's OK to do but not the easiest way. It's easy to create a form based upon a table. From the Form section, in the Tasks area, click on Use Wizard to Create Form... and select the Table or Query to base the form upon. Clicking Next will step through the rest of the design.

more

Thanks. Do I have to set the design as I enter each field in the Form or can I create the whole Form and then edit parts of it to look and act as I wish?

( 2018-03-09 05:26:22 +0100 )edit

There are multiple methods of how an entry form looks and works. This can be done with the Wizard or you can create from a blank canvas. The Wizard allows individual fields, a table control (similar to the Table view) and more. Again, perusing the documentation & trying the Wizard (you can always delete an unwanted Form) is the best way to start. Forms can be modified at any point - even after using for months. There is a great deal more to Base if you dig into it. Look at the docs.

( 2018-03-09 06:07:12 +0100 )edit

BTW - worth mentioning. Typically, you can double click on an .odb file & it should open up in Base. If not (unusual) your system is not set to associate .odb files with Base. This will save the extra steps you seem to be taking.

( 2018-03-09 06:56:35 +0100 )edit

Once I get the information in a Form which works for me, can I not only delete the unwanted Form but remove the information from the Table and leave the Table as just a template, or would removing the information remove it from the Form as well? Thanks.

( 2018-03-09 15:44:41 +0100 )edit

The Form is just a mechanism to display/enter information. The information typically comes from a Table or Query. So, deleting a Form simply deletes the Form.

Deleting information from a Table just deletes data. Deleting all data in the Table still leaves the Table structure in the database ready for more data to be entered.

( 2018-03-09 15:51:12 +0100 )edit

So which is the real Database, the Form or the Table? I want to enter data in the real thing and not the doppelgänger. I also have formatting questions regarding how to make the information appear onscreen the way I want. Thanks.

( 2018-03-12 05:08:29 +0100 )edit

@CoriSCapnSkip This question was already answered - "The Database itself contains the actual data - Tables." Also, "The Form is just a mechanism to display/enter information." So you enter data in a Form which is actually putting the data in a table.

You obviously have not looked at any of the documentation in answer link. 99% of database entry is done through Forms.

( 2018-03-12 12:20:15 +0100 )edit

This forum is designed to ask a question and get an answer. The original question has been answered. If you have other questions ie: formatting (which is typically done in forms), please ask as new question.

( 2018-03-12 12:34:10 +0100 )edit

So which is the real Database, the Form or the Table? I want to enter data in the real thing and not the doppelgänger. I also have some formatting questions. Thanks.

more