Database

Discuss the database features

Database

Postby Randyz » Thu Jan 18, 2018 3:55 am

Hello all thanks for having me.
I use open office for my customers information in my Auto Repair shop. What I would like to do is set up a database that when customers come in or repeat customers come back, I want to have blocks for name , address, phone, type of vehicle, vin #, email. And when repeat customers come back I would like to have all their visits and work under the same name or vehicle in the same place. Can I do any of these things?
OpenOffice 3.1 on Windows Vist
Randyz
 
Posts: 1
Joined: Thu Jan 18, 2018 3:49 am

Re: Database

Postby RusselB » Thu Jan 18, 2018 5:42 am

First off: Welcome to the Open Office Help Forum
As to your query, all of what you have specified is possible using a database, and I'm glad to see that you recognize a database is the right aspect of Open Office to use.
Many people start off using Calc, which is a spreadsheet, rather than a proper database.
If you don't have any experience with database structure, then you are in for a steep learning curve, but I feel it will be worthwhile.
I am still in the process of learning how to write/work with databases, so I won't actually be of much technical use.
That said, I would like to suggest you look at some of the database tutorials located here
There are also some YouTube videos that I found by searching Google for the term "Open Office Base Tutorials"

You'll probably get more/better help by posting your queries in the Base section of the forum, which is located here
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4718
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Database

Postby UnklDonald418 » Thu Jan 18, 2018 6:02 pm

Look at this example
[Example] Business Cards
It includes a Rolodex form that may give you a jump start on your project
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.6 & LibreOffice 6.1.1.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 979
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA


Return to Base

Who is online

Users browsing this forum: No registered users and 4 guests