What do I use

Not sure where to post? Post here!

What do I use

Postby kset51 » Tue Jun 23, 2015 2:31 am

I have a watch repair shop and am looking for something that will allow me to make and use and print a customer take in form. I need to be able to import a photo of repair item, print a repair form for shop use, and repair ticket for customer. Do I make a template and import into database or do I do something else? I am not sure where to start.
Thanks
Open Office 3.2.0 on Windows XP
kset51
 
Posts: 2
Joined: Fri May 28, 2010 11:59 pm

Re: What do I use

Postby RusselB » Tue Jun 23, 2015 2:44 am

A database is where I would go with this, The only part that I'm not sure of is the ability to import a picture into a database.
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.
User avatar
RusselB
Moderator
 
Posts: 5410
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: What do I use

Postby MTP » Tue Jun 23, 2015 6:00 pm

If you want to be able to track your history, a database is the best option.

If you just want a one-time use form to print (and save, if needed, although then only the filename would be searchable - nothing like the thorough search and reporting capabilities of a database) then a spreadsheet template would suffice and would be much easier to set up.

Base can definitely handle photos, either embedded inside the database or with the database having a link to the file. If you're interested in the database route, a good place to start is by reading about "normalization". It's a kind of weird concept but necessary to set up tables, which is the first step in making a database. Once you have the tables, then you'll make a database form that stores information into and reads information from the tables - this form will be what you print out. The learning curve in Base is (unfortunately) pretty steep and you'll probably need to work through a few tutorials before starting your own project.
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
User avatar
MTP
Volunteer
 
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA


Return to Beginners

Who is online

Users browsing this forum: Google [Bot] and 3 guests