Using AOO Base for Small Business Sales

Discuss the database features

Using AOO Base for Small Business Sales

Postby ADECKER » Fri May 18, 2012 2:48 pm

Hi, I am new to OO, Used Access a lot about 15 years ago.
I have looked for an example for a sales database but have been unable to find one.

I have several product/price tables and an employee table (they are also customers). Not sure if I need a special column for a Customer ID and not sure how to show the sales...

I'm sure I did at one time and it should come back to me...just need to see it.
Thanks
Amy Decker
(1st time poster) :?
18 May 2012
OPENOFFICE 3.4.0 ON WINDOWS XP PROFESSIONAL
ADECKER
 
Posts: 2
Joined: Thu May 17, 2012 5:13 pm

Re: Using ooBase for Small Business Sales

Postby Villeroy » Fri May 18, 2012 4:18 pm

No, it is completely impossible to use Base for small business sales. Databases are designed to do this but Base is not a database.
So set up your database according to your detailed and well thought requirements and then you may use Base as a link between your database and this office suite (and you may connect an Access document to it as well).
Calling File>New>Database and creating a new one simply because it is so easy and free of costs leads to no viable solution.
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: Using ooBase for Small Business Sales

Postby RoryOF » Fri May 18, 2012 4:25 pm

Don't reinvent the wheel! Before putting much effort into rolling your own system using Base and an underlying database engine, why not do an Internet search for "small business sales software freeware" (no quotes). Several likely candidates pop up; it might be easier to customise such a system than write one from scratch.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 27297
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Using AOO Base for Small Business Sales

Postby ADECKER » Mon May 21, 2012 2:19 pm

Thank you!
OPENOFFICE 3.4.0 ON WINDOWS XP PROFESSIONAL
ADECKER
 
Posts: 2
Joined: Thu May 17, 2012 5:13 pm


Return to Base

Who is online

Users browsing this forum: No registered users and 8 guests