Is MS Access enough to used as an inventory database/spreadsheet?

Question

I wanna coz I wud b needing something like an inventory database/spreadsheet! Wud MS Access be enough?
Coz I don't know how to make Access as a spreadsheet? Where I can used it to put deliveries & pull outs and update the values on a daily basis!

Well yes I have excel! Can the two be combined? Coz I want all the dbase of the products & then export it & edit all the data details of excel!

Answer 1

Access is a database engine. In order to get Access to do anything, you have to set it up to accept data, then regurgitate results in a form that is usable. Most Access databases are set up by professionals who do this for a living, although there are some smaller ones that are not set up by a pro.

If you want a spreadsheet then get a spreadsheet. If you don't have Excel, and don't wish to buy it, then the OpenOffice.org spreadsheet program works very well -- and it is FREE.

FREE.

Did I mention that OpenOffice.org has a spreadsheet, and a word processor, etc etc and that they work well, and they are free?

Answer 2

I have little experience with Microsoft Access, but I do know that the program comes with a "wizard" to guide you in creating a database. There is a learning curve to use it, so if you aren't familiar with databases it may take some time.

What is this project for? If it is a web-based database you are looking for, I recommend using MySQL with phpmyadmin software to administer it.

Answer 3

The database report is opened in different window. it may additionally take place no be counted if that's computer virus by using beginning database gadgets in layout mode by using application itself and not last them exact. with out seeing this technique can not wager right reason. thank you

Answer 4

Try one of the items listed under number 43:
http://www.databaseanswers.org/data_models/