does anyone know how to create a database for managing inventory? Microsoft templates don't help.?
405600
While what you want to do could be done with Access, programming Access to do it -- make the forms, the queries and reports needed -- is very difficult, if you don't have fairly advanced database / Access skills.\n\nAlso, you're going to want this product to have rock-solid support -- because once you start using it, you'll be tied to it, and if it fails, you'll need it fixed ASAP.\n\nAs a result, you're not going to find something like what you are asking for out there for free, and having it custom programmed is going to cost more than buying it off the shelf -- at least, if the programmer is worth his salt.\n\nInstead, you should look for an off-the-shelf solution.\n\nQuickbooks -- http://www.intuit.com -- is one option; it technically is bookkeeping software, but it has advanced inventory management features and can handle purchase orders / autodepleting inventory based on purchase orders.\n\nIt will cost several hundred dollars to purchase, but you will find, again, that even so, it's one of the more affordable solutions.\n\nShort of that, there are lots of other software packages out there; most will cost even more than Quickbooks.\n\nA final option might be to find a college student who is in a database administration or programming course, and see if he's be willing to build this for you on the cheap. But remember, you get what you pay for.
962957
Microsoft do have a Spreadsheet wizard. I have used it to get me going and it is brilliant. For further info go to www.microsoft.com
336563
The MSDE version of SQL doesn't come with an interface to create a database.  Without SQL Enterprise Manager you need to use MS Access and create a project (.adp extension in Access).  Using that process, Access runs through a setup where you specify the local instance of SQL Server ... and once it creates the SQL database, you can add tables and views through the MS Access interface.  Good luck!
1002503
I hate the darn things. I have one in my name and it's a real pain.\n\nApplications written in SQL have a real problem with them too and usually error out if you include one.\n\n\nOther than that it's just plain lazy.
293894
Since mysql, Oracle, DB2 and Microsoft all offer free versions of their databases I am not sure who would pay money for a database.  Try selling something else.
146218
I also use Microsoft Publisher.  It is an awesome program and has already made design templates that you can use or alter to fit your needs.  Good luck!
1164930
Go to enterprise, and click on the database in which you want and right click on stored procedures and create new...\nIs that what u want?
26037
In my opinion, look upto MySQL, it is the best database for your needs. Incase you have queries regarding its setup, you can lookup to the following professional forums where people discuss such problems :\n\n(1) http://forums.mysql.com/\n(2) http://forums.devshed.com/forumdisplay.php?forumid=4\n(3) http://www.ahfb2000.com/webmaster_help_desk/archive/index.php/f-47.html
793099
Works Database ? never heard it. its somekind like Microsoft Access?\n\nBut try to learn SQL. http://dev.mysql.com/doc/\nit's a powerfull language for database
1153856
You can't, you can only build a spreadsheet, or a single table database.  You can use Access to build DB's.\n\nIf you need tuturiols on how to create/manage a Access Database.  See the links below.
1127319
we used microsoft ACCESS here at work; this program is very powerful and will help you organize, see and print information on customers or other records in a variety of forms, this is useful if you have data that you'll be inputting yourself electronically\n\nif you have a lot of paper that you want to store electronically the way to go would be to get a high-speed, high quality scanner (these can be leased) and either buy a big file server or burn the stuff to CDs
1020946
That will not be a database program because no database is involved!\n\nWhat language is the answer to be coded in?\n\nHow will the data be organised?\nOne line per data item?  \nThis will need x reads per property.  Will also leave blank lines where items missing.\n\nOne line per property.  Will there be fixed size data items or will you have a seperator? The seperator cannot be used in the data item!
415743
Uh oh\n\ndont worry you didnt lose them look here:\n\nMy Documents &#92; USER_NAME &#92; Application Data&#92; Microsoft &#92; Template\n\nthats where the templates are. Getting them to MSO 2003 open them and save as a template \n\nDont sweat
855738
MS Excel has tons of great formulas.  Have you thought about using that.  Also, not sure what sort of database application you're using but formulas can usually be programmed into them.
643171
This forum will probably lack the comprehensive information you need.  The materials provided with the Access program can get you started, however I suggest visiting a book store for a "How TO" instructional book.\n\nDo a search for "Microsoft Access" on amazon.com as a starting point.\n\nOn the web, research these sites:\n\nAccess Database Design and Programming \nO'Reilly's Access Database Design and Programming offers Access users the knowledge needed to begin the transition to Access developers.\nhttp://databases.about.com/library/weekly/aapr051202.htm (About Databases)\nAccess Database Too Big! \nAccess Database Too Big!\nhttp://databases.about.com/b/a/222380.htm (About Databases)\nAccess Database Design and Programming \nO'Reilly's Access Database Design and Programming offers Access users the knowledge needed to begin the transition to Access developers.\nhttp://databases.about.com/library/weekly/aapr060902.htm (About Databases)\nNew...Access Database from Delphi - DB Course/Chapter 13 - Page 2/2 \nChapter thirteen of the free Delphi Database Course for beginners. How to create an MS Access database without the MS Access. How to create a table, add an index to an existing table, how to join two tables and set up referential integrity. No MS Acc\nhttp://delphi.about.com/od/database/l/aa072401b.htm (About Delphi Programming)\nNew...Access Database from Delphi - DB Course/Chapter 13 - Page 1/2 \nChapter thirteen of the free Delphi Database Course for beginners. How to create an MS Access database without the MS Access. How to create a table, add an index to an existing table, how to join two tables and set up referential integrity. No MS Acc\nhttp://delphi.about.com/od/database/l/aa072401a.htm (About Delphi Programming)\nBuilding an Access Database From the Ground Up \nIn this series of ten Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up.\nhttp://databases.about.com/od/buildinganaccessdatabase/index.htm (About Databases)\nMicrosoft Access Database Fundamentals \nMicrosoft Access Database Fundamentals \nhttp://databases.about.com/b/a/139756.htm (About Databases)\nMicrosoft Access Database Fundamentals \nMicrosoft Access Database Fundamentals\nhttp://databases.about.com/b/a/243511.htm (About Databases)\nBuilding an Access Database From the Ground Up \nIn this series of Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up.\nhttp://databases.about.com/cs/tutorials/a/widgetmenu.htm (About Databases)
1035740
If your trying to learn how to set up and administrate databases the best reference I have found is link below:\nhttp://www.microsoft.com/technet/prodtechnol/sql/2000/books/pkadmindefault.mspx\n\nIf your trying to learn how to connect VB to MS SQL Server datasets then you should refer to the MSDN site for examples.  This site has reference links to VB and MS SQL\nhttp://www.microsoft.com/msdn\n\nGood luck
258585
Hey Dhruba, This is a good question and is in fact the topic of several entire books.  I recommend "Database System Concepts" by A Silbershatz, H Korth, and S Sudarshan.  As for the step by step Ill try and outline a few basics.\n\nFirst you are going to want to plan out your databases data structures, or schemas, you can consider these as objects.  For example if you were makeing a bank account database you might have a customer object and an account object.  In these objects you have information (attributes), say for customer you might have their name and address, while in account their account number and balance.\n\nNow typically you would use some kind of relation diagram to represend these two object and how they are related.  The entity relationship (ER) model is a common example.  The relation for our example could be "depositor".  Note that there are several other relationships between these two example entities (like say "withdraws from") and for any system of normal magnitude you will have several entities and relations that are far more complex.\n\nOnce you have your entire table layed out you can use a relational language such as SQL to code your entities and their relations creating a database ready for manipulation by whatever various front end language you wish to use.  Since you only asked about modelling I will stop here.  This is extremely simplified but if you want more details on any part I hope now you can ask more specific questions.  Another option of course it to read the book I suggested above, it will most likely be available at a local library.  Hope this helps and good luck.