News1 min ago
Database advice needed
9 Answers
Can anyone recommend a database similar to Microsoft Access? It is something I want to use for the Goods In dept at work, so I don't mind paying for it. We are currently using Microsoft Acees, but have had nothing but problems with it, and I would like to see if there are any alternatives.Basically, I want to set up a Goods In Template where everything that is typed into the document is automatically stored in some sort of summary spreadsheet, for example, If I receive 10 of part X from Customer Y, on date Z, the summary should show this. I want to be able to click on a particular line of the summary, and for the relevant document to open up.Also, all of our Goods Receipt Notifications need to be issued with a unique identification number, even if it was something simple like GRN1,GRN2,etc, and the software needs to automatically select the next GRN number.
Any advice would be most appreciated.
Any advice would be most appreciated.
Answers
1 to 9 of 9
Best Answer
No best answer has yet been selected by TEAK36. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
What problems are you having with Access? This is the most apt application to use for this I reckon. You could also use Excel, but Access would be my choice.
As for unique id number, in Access this is usually the AutoNumber field type. In SQL Server we use something called a GUID (Globally Unique IDentifier). You can also use these in Access apparently :
http://www.access-programmers.co.uk/forums/sho wthread.php?t=108630
AutoNumbers are easier to deal with though. And, as the name suggests, they automatically increment when a new record is created.
As for unique id number, in Access this is usually the AutoNumber field type. In SQL Server we use something called a GUID (Globally Unique IDentifier). You can also use these in Access apparently :
http://www.access-programmers.co.uk/forums/sho wthread.php?t=108630
AutoNumbers are easier to deal with though. And, as the name suggests, they automatically increment when a new record is created.
PS, if you want any help with the Access database, email me<a/>.
if you follow the following link, you might find it useful as i'm looking for a handy database myself and came across this, though i haven't done anything about it yet. Hope you find this useful and don't be put of from watching this just because you the title "you tube". https://www.youtube.com/watch?v=DOkT5gIil9I&mod e=related&search=
-- answer removed --
-- answer removed --
1 to 9 of 9
