I have, for the last 20 years been using Microsoft Works Programme (W/Processor/Spreadsheet/Database). With the withdrawl of the brilliant 'flat' database they provided, I have been highly recommended Open Office Database. On the MS version, I used it in two ways - (a) With 'Lists' - where information was listed across the page - one below the other, and (b) in 'Form' View, where you could see the same information of each individual 'line' now displayed downwards on a single page.
Being new to Open Office,
(a) are these two functions available here?
(b) Is the term 'tables' the same as 'Form View' that I used previously?
(c) Can I still display and edit information on both as a list and as a form as before?
(d) Are there any other bits of terminology I need?
Any help would be appreciated. Remember, I am not an expert - just a user who wantS something simple!!!
Many thanks......
[Solved] Display data in 'list' or 'form' view
-
- Posts: 1
- Joined: Tue Mar 02, 2021 3:30 pm
[Solved] Display data in 'list' or 'form' view
Last edited by MrProgrammer on Tue Mar 09, 2021 5:08 pm, edited 3 times in total.
Reason: Moved from Beginners forum to Base; Tagged ✓ [Solved]
Reason: Moved from Beginners forum to Base; Tagged ✓ [Solved]
Martin Smith Open Office 4.0.1 Windows 7
Re: A new (uneducated) user....!
I cannot answer your questions but, as a newcomer, start with LibreOffice as AOO is on its last legs (and the LO documentation is much better). The LO Base documentation is here
This forum supports AOO and LO users. Base forums etc are here.
This forum supports AOO and LO users. Base forums etc are here.
LO 6.4.4.2, Windows 10 Home 64 bit
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
- MrProgrammer
- Moderator
- Posts: 4895
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Display data in 'list' or 'form' view
The Base Guide in the documentation link above will describe how to create a table (your 'List'), and a report (your 'Form'). Base also has something called a form, but it is for data entry, not for display. I suggest that you work through some of the examples in the Base Guide so you can experiment a bit first. Then you can create your own database.Martin Smith wrote:I used it in two ways - (a) With 'Lists' - where information was listed across the page - one below the other, and (b) in 'Form' View, where you could see the same information of each individual 'line' now displayed downwards on a single page.
New people often do not understand what Base is. It is a tool to access an external database from OpenOffice components like Writer, Calc, etc. It can create a database with File → New → Database → Create a new database. Then you can access it with Base. While is suitable for experimentation and "proof of concept" you should not use that database for your real data. You will want an external database for that. But you can leave that step for after you have tried the examples in the Base Guide.
[Tutorial] Splitting an "embedded HSQL database"
Open a new topic in this forum if you need assistance with the tutorial above.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).