My family has a small store that we manage. I require a software that can record and organize a customer's information (address, phone number.etc) and allow us to customize it like adding extra information like assigning special numbers (something like a store ID).
Also another feature that is a must have is a search feature that let's me go through the database by name, address or a special number i assigned to them.
This program has to be able to run on either Windows XP or Windows 7.
I'm not sure, but Quicken might do that
I'm looking something similar to M$ Contact Management Database, but one that allows me to search via any information. M$ Limits me to names and zip code.
I'm pretty sure Access is a database program. It's pretty basic too if I remember correctly and sounds like what you're looking for.
[editline]02:35PM[/editline]
If you're looking for free alternative to office, OpenOffice has a program called Base which is also a database program.
Give me 10 dorrah and I will do it.
No really this is really simple Access stuff.
If you don't no how to do this download the Northwind example from Microsoft
[URL]http://office.microsoft.com/en-us/templates/TC012289971033.aspx?CategoryID=CT100649391033[/URL]
It will teach you how everything works
[editline]11:20PM[/editline]
Infact that may be to complex for your needs.
Just google how to do basic queries in Access
I tried the Contacts Manager in Access. The thing wrong about it is you can't search up a contact via phone number, was wondering if theres a program that'll work by searching up anything (address, special number assigned to the person, address.etc)
Check out this: [url]http://www.openoffice.org/[/url]
The database software is good
[editline]06:31PM[/editline]
Its free and you can search by whatever you need too
[editline]06:32PM[/editline]
Damn you specter!:bang:
As mentioned twice already, openoffice probably is the best solution, as I doubt there's any larger freeware database softwares out there, without going advanced with mysql or a custom script.
[QUOTE=peterboi;20405684]I tried the Contacts Manager in Access. The thing wrong about it is you can't search up a contact via phone number, was wondering if theres a program that'll work by searching up anything (address, special number assigned to the person, address.etc)[/QUOTE]
You just need to make a customer information table and then make some queries for it. You can query anything
[url]http://www.act.com/[/url]
Thank me later. Or use Access. ACT is designed for what you're asking for and can do everything you've mentioned, but Access might be better if you need to keep Databases of other data as well.
Yeah, in access don't use the contacts feature, create a table and store customer data in that. You can give each one a unique ID (just set the field's validation to AutoNumber)
If you need help we're doing a project at school about databases right now, that is pretty much what you want (except it does DVD rentals, but it's basically the same thing), PM me or something.
[QUOTE=aero1444;20414875]
If you need help we're doing a project at school about databases right now, that is pretty much what you want (except it does DVD rentals, but it's basically the same thing),[/QUOTE]
We must be the same person
[img]http://imgkk.com/i/Agp7la.png[/img]
And I even chose a DVD shop aswell
Gonna give each a try if i need any help i'll post again.
[QUOTE=microsnakey;20414936]We must be the same person
*form*[/img]
And I even chose a DVD shop aswell[/QUOTE]
Hahah, awesome. Although ours is a bit different to that. I'll grab a screenshot for you to show you my awesome database
[URL=http://filesmelt.com/][IMG]http://filesmelt.com/dl/Access13.png[/IMG][/URL]
[URL=http://filesmelt.com/][IMG]http://filesmelt.com/dl/Access14.png[/IMG][/URL]
[URL=http://filesmelt.com/][IMG]http://filesmelt.com/dl/Access15.png[/IMG][/URL]
Some of those menus go to sub-menus, like the query one.
Also totally original name, John's Rentals is the greatest rental shop ever.
I have Professor Farnsworth and Clark Kent as my customers, and loads of film stars (who seem to have rented a lot of films they actually starred in :/)
Oh and when you click print etc. it brings up a box saying "are you sure you want to print the report?" because I have a huge pile of records/reports which I printed accidentally when I thought I was in design view
I use Filemaker Pro
not sure of free. if there's a trial try it out
I'd use Access. Once you got it all set up it would be pretty simple to operate. Plus i already have the software so no point going to get something else.
Sorry, you need to Log In to post a reply to this thread.
