STOCK HANDLING
STOCK HANDLING
Can MS Access be used in handling logistic warehousing and distribution?
I want to handle the STOCK LIST and customer list, including delivery, repair and return list and so on.
But I don't have any other software like accounting or others, I only have MS Access and Excel.
I want to use MS Access in Logistic warehousing & Distribution.
Please help me!
Yes, Both MS Access & Excel can be used for those things.
I have even seen them used together.
Usually MS Access comes with "Templates" of databases that can be automatically set up and all you have to do is enter data. Click "NEW DATABASE" and Look through the template listing to see if one matches (or is very close to) what You would be needing. If it's not there You may have to have Access re-installed with the "FULL INSTALL" rather than the "Recommended".
Check out the "NORTHWIND.mdb" sample DB available free from the Microsoft Knowledge base (It's actually a sample of what You are asking about!). And I would recommend a quick course in MS Access development befor trying to make any changes to the Templates.
But Access and Excel both DO have limitations. Excel can not have more than 16K rows on any given spreadsheet, and both have a "FILE SIZE LIMIT" imposed by windows. For MS ACCESS the "File size limit" is 2 GB. Work-arounds for this usually involve good data management (like deleting/archiving old records) and LINKING several DBs to each other so EACH ONE can grow to 2 GB.
The size limitations usually only come into play for MAJOR applications (like coordinating a chain of warehouses).
Alternativley I know there are some FREE-WARE database programs available, but they are most likely not as flexible to use as MS Access, nor as well developed.
 |
Silicone Skin Case for Xbox360 Controller Black White Blue Red Green Pink Orange | US $.99 | 14m |
 |
50pcs Purple 9 stainless Steel Memory Wire Bracelet Bangle Jewelery cords NK14 | US $14.62 | 14m |
 |
20pcs Gold 1723cm Love Heart Organza Voile Wedding Favor Gift Bags Pouch XCE1 | US $7.88 | 15m |
 |
Takara BeyBlade Metal Fusion Fight B49 Angle Compass | US $1.39 | 15m |
 |
25 SATA Hard Drive Disk HDD External Case Enclosure Box USB 20 Laptop PC | US $.99 | 15m |
 |
Sega Dreamcast 6 Controller Extension Cable Retro Bit BLACK New 6 feet Cord | US $4.50 | 15m |
 |
HDMI Male to Male M M CABLE CORD 15M for PS3 Xbox 360 HDTV 13B | US $.99 | 15m |
 |
Bearing For HPI RS4 3 RS4 3 EVO RS4 3 TYPE SS RS4 3 18SS RS4 RALLY MT MT2 | US $6.50 | 15m |
 |
Super Audio Video SAV Cable Nintendo GameCube New GC Composite RCA S AV Cord | US $2.50 | 15m |
 |
2 X SNES Retro Duo Controller Pad Classic Style TTX Tech Grey Super Nintendo | US $5.50 | 15m |
 |
1997 2000 BMW E39 5 SERIES ALTEZZA RED CLEAR TAIL BREAK LIGHTS LEFT RIGHT | US $53.99 | 15m |
 |
NEW Black Carbon Fiber Hard Case Skin Clear Bumper Cover for Apple iPhone 4 4G | US $.01 | 15m |
 |
OEM MICRO Data Sync USB AC WALL HOME CHARGER FOR HTC HD7 Espresso HD2 EVO 4G | US $.99 | 15m |
 |
XBOX 360 Forza Motorsport 2 Front Console Faceplate Microsoft MS NEW | US $2.50 | 15m |
 |
THE SECRET LIFE OF THE AMERICAN TEENAGER TV SEASON 3 3 DVD SET NEW | US $9.99 | 15m |
 |
Solar Powered Jewelry Rotary Turntable Display Silver | US $.99 | 15m |
 |
Brown Crystal European Bead Fit Charm Bracelet 5pcs | US $.99 | 15m |
 |
2 WHITE CRYSTAL RED JASPER GEMS SILVER PLATED PENDANT | US $.99 | 15m |
 |
Sanrio HELLO KITTY Bow Monogram Car Front Window Windshield Sun Shade 70x130cm | US $9.99 | 15m |
 |
Fashion Useful Ring Sizer Mandrel Finger Sizing Stick Metal Size 1 15 | US $17.50 | 15m |
 |
ELEGANT FLOWER VINES CASE COVER SAMSUNG GALAXY S II EPIC TOUCH 4G ACCESSORY | US $7.95 | 15m |
 |
Brand New USB Camera Connection Adapter Kit for Apple ipad 1 ipad 2 | US $.99 | 15m |
 |
YUGIOH 500 CARDS PREMIUM LOT WITH HOLO RARES | US $24.95 | 15m |
 |
40x25mm Stainless Steel Abacus Pendant 1pc | US $5.99 | 15m |
 |
1x New Dark Blue Stylus Touch Pen For Nintendo DSi NDSi | US $.01 | 15m |
 |
16GB MICRO SD SDHC MEMORY CARD for camera cell phone tablets iPhone PC | US $12.50 | 15m |
 |
Round CPU Cooling Cooler Fan for Intel Core2 LGA775 E33681 001 4pin | US $.99 | 15m |
 |
MICHAEL BUBLE CAUGHT IN THE ACT CD DVD SET NEW | US $15.99 | 15m |
 |
GROWING PAINS TV COMPLETE SEASON 1 KIRK CAMERON 4 DVD SET NEW | US $14.99 | 15m |
 |
BM 11 Crystal Plastic LCD Screen Monitor Cover Protector for Camera Nikon D7000 | US $.99 | 15m |
 |
Fashion Casual Clubwear Crew Neck Long Sleeve Flower Shoulder Short Mini Dress | US $.99 | 15m |
 |
Hot selling Casual Clubwear Crew Neck Flower Shoulder Long Sleeve Mini Dress | US $.99 | 15m |
 |
BOB DYLAN SAVED NEW SEALED CD | US $3.99 | 15m |
 |
5x Flower Ceramics Porcelain Loose Spacer Charm European Bead Fit Bracelet PDD22 | US $.01 | 15m |
 |
Ultrasonic Bark Stop Dog Training Collar barking pet | US $.99 | 15m |
 |
12000K H7 Xenon HID Kit Low Beam Replacement Bulbs 2pc | US $13.50 | 15m |
 |
Universal USB Port 10 Plugs Charger Cable Kit Black for Mobile Phone iPhone iPad | US $.99 | 15m |
 |
New Women Korean Fashion Black Cotton DressFree Belt | US $21.60 | 15m |
 |
NEW Black LED Blinker Motorcycle Turn Signals Indicator Flash | US $15.26 | 15m |
 |
60X Pocket Microscope Jeweler Magnifier LED Loupe Eye mini coin Watch Loupe tiny | US $.99 | 15m |
 |
Bearing For TEAM LOSI MINI LST 1 2 RAMINATOR MINI MONSTER BAJA RAMMUNITION | US $7.50 | 15m |
 |
Bracelet White Quartz 10mm Round Beads stretch | US $.99 | 15m |
 |
2x Blue 125 31mm DE3175 DE3022 6 SMD 5050 LED Bulbs For Dome Light | US $10.95 | 16m |
 |
URIAH HEEP Best Of LP SEALED | US $12.99 | 16m |
 |
50pcs Royal Blue 18 Stainless Steel Memory Wire Necklace Chokers Cords NJ10 | US $14.63 | 16m |
 |
Rare 045Cts Stunnig Top Luster Quality Color Pinkish Natural Pezzottaite DSA4 | US $9.99 | 16m |
 |
Vintage 70s Black Glass Crystal Drop Bead Pierced Earrings | US $9.49 | 16m |
 |
Ford 00 04 Excursion 99 04 F250 F350 Crystal Chrome Tint Headlights LH RH Lamps | US $102.95 | 16m |
 |
28 Black Onyx White Jade Multi Gemstone Necklace | US $.78 | 16m |
 |
17X12X12MM 15 NATURAL TURQUOISE GEMSTONE NUGGET BEADS | US $1.25 | 16m |
 |
35lot of 9 baby jewel flower hair bow clips velshl ha09 | US $.68 | 16m |
 |
3 6 Mts Toddler Beanie baby Hat Crochet Handmade Photography Prop sinsel eti8 | US $.65 | 16m |
 |
M STYLE FLOOR MATS CARPETS 4PCS 05 2006 2011 BMW E90 3 SERIES 4D 4DR M3 BLACK | US $55.00 | 16m |
 |
BLACK HOUSING ALTEZZA TAIL LIGHTS REAR BRAKE LAMP 1997 2002 FORD EXPEDITION SUV | US $27.00 | 16m |
 |
NEW CHRISTIAN AUDIGIER Full Zip Hoodie with Dragon Foil and Print Sandshell L | US $69.00 | 16m |
 |
98 02 ACCORD ANGEL EYE HALO PROJECTOR HEADLIGHTS BLACK | US $89.09 | 16m |
 |
6 NEW SUPER 8 KODAK EKTACHROME 100D COLOR FRESH FILM | US $119.99 | 16m |
 |
3 6 Mts Toddler Beanie baby Hat Crochet Handmade Photography Prop foufqq eti8 | US $.65 | 16m |
 |
6 Pcs 47 Hair Bow Peony Flower Clip Headband Hat Wedding Party Bridal ffe yz6j | US $.59 | 16m |
 |
10 x daisy flower baby hair bows clip headband vmrbjp yz10 | US $.99 | 16m |