|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
05-22-2004, 02:16 PM
|
#1 |
|
Member (5 bit)
Join Date: Nov 2002
Posts: 31
|
Ms access database ?
I want to build a database in msaccess for keeping inventory control. I'm kind of stuck because I can;t figure out how to do it.
I need it to be capable of feeding it with items and then come out with products. For example I want to sell PC's but want to keep track of all the components for the different models I assemble. Can anyone guide me in the right direction, I just need either a sample database like teh one I need or a place where I can get the info. thanks |
|
|
|
05-22-2004, 02:26 PM
|
#2 |
|
Member (14 bit)
Join Date: Mar 1999
Location: Christmas, Florida
Posts: 10,661
|
I am not saying this to be taken in the wrong way, but doing my best to help.
access is a program that has so many capicables and power that it is taught in college courses. the4 best thing you can do for your self would be to go the your favorite book store and get some trainning manuals on how to run it, I don't think it is going to be something you can learn over a week end. that is something I need to do also look for more post on your question from others that may be able to help you more. |
|
|
|
|
05-22-2004, 02:38 PM
|
#3 |
|
Certified Audio Nut
Join Date: Jul 2003
Location: Washington State
Posts: 7,214
 |
I have Access. It came with Office XP but I have never needed it. I have tried to figure some things out in it but I have never gotten anywhere.
__________________
"I'm not lying. I'm writing fiction with my mouth." - Homer Simpson My Miscelaneous Gallery ASUS P7P55D PRO / Intel Core i7 860 / 8GB Mushkin DDR3 1600 RAM / OCZ Vertex 2 120GB SSD / Seagate 1TB 7200.12 / Asus Radeon 5870 1GB / LG Super-Multi 22x SATA DVD-RW / Windows 7 Home Premium 64bit / Cable Modem / HT Omega Striker 7.1 Sound Card / FSP 700W PSU / Logitech MX1000 Wireless Laser Mouse / Asus 24" 16:9 LCD w/Webcam / Axiom Audiobyte 2.1 Speakers |
|
|
|
|
05-22-2004, 03:07 PM
|
#4 |
|
Member (10 bit)
Join Date: Jul 2002
Location: Trivandrum, India
Posts: 800
 |
MS Access comes with a variety of database templates that you can use. One of them is an Inventory Control Database that you can customize to your needs.
In MS Access XP, go to File>New to open the Task Pane and click on General Templates>Databases>Inventory Control to open the wizard, which will help you create your new database and fill in all the fields and info you want. In Access 2000 just click File>New to bring up the template selection window. Or you could click Start>New Office Document(In Windows XP, Start>All Programs>New Office Document)>Databases>Inventory Control. This should get you started. I am sure the many gurus on these forums can help you with further customization. Oh, and read the Access Help files. They are very informative. |
|
|
|
|
05-23-2004, 05:19 PM
|
#5 |
|
Member (5 bit)
Join Date: Nov 2002
Posts: 31
|
Thanks for your help,
I've desiigned different DB, but all pretty much the same. Basically the same stuff that goes in goes out. On this other one that i need to design, I will feed it parts and come out with products. And that's what i can;t figure out how to do. |
|
|
|
|
05-29-2004, 09:28 AM
|
#6 |
|
Member (5 bit)
Join Date: Nov 2002
Posts: 31
|
anyone?
|
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
