Software database solution?

itsonlysmellz

Estimable
Feb 15, 2015
12
0
4,560
0
Im currently using Excel spreadsheets to keep track of shipments for a business but I would like something more compact, cleaner and easier to manage and something that wont become eventually unmanageable like which my spreadsheet is quickly heading towards.

The data I manage is basically categorized in either current shipments I have inbound to me and prior shipments which I have already received. Each shipment will hold information such as the senders details and the item contents which as you can image can take up from 8-20 cells vertically in Excel making for a really long, congested and hard to navigate spreadsheet. I'd like to solve this.

I uploaded a picture of a rough diagram I made of what I have envisioned for a cleaner database solution: http://i.imgur.com/VV5IR4B.jpg

I would like to have the ability to enter shipment information similar to a html submission form and have it populate a new shipment cell for me when I submit it. I'd also like the ability to expand and close cells to see the full description of a shipment, the ability to navigate shipments based on date, to query cells based on emails, name, etc and the ability to convert cells in the "current shipments" category to the "prior shipments" category.

If anyone has any suggestions for what may be a solution I would appreciate it.
 

USAFRet

Splendid
Moderator
This happens ALL THE TIME with Excel.
It starts out easy. Nice neat columns of fddata.

And then...your needs grow. Completely outstripping the functionality of Excel.

For a couple user situation, Access would work perfectly here. A real database.
However, it is a bit more complex than just rows and columns.

A few tables & queries would be needed.
Customers
Inventory
Orders

You could easily query to show Customer A has ordered Items 1, 4, 6. Items 4 & 6 have already shipped.

However, building this is easy to get wrong.
Even better however
, Access comes with some prebuilt templates.
This the Inventory Tracker template in Access 2013:


And may serve as is. Or can be customized to your specific needs.
 

USAFRet

Splendid
Moderator
This happens ALL THE TIME with Excel.
It starts out easy. Nice neat columns of fddata.

And then...your needs grow. Completely outstripping the functionality of Excel.

For a couple user situation, Access would work perfectly here. A real database.
However, it is a bit more complex than just rows and columns.

A few tables & queries would be needed.
Customers
Inventory
Orders

You could easily query to show Customer A has ordered Items 1, 4, 6. Items 4 & 6 have already shipped.

However, building this is easy to get wrong.
Even better however
, Access comes with some prebuilt templates.
This the Inventory Tracker template in Access 2013:


And may serve as is. Or can be customized to your specific needs.
 
Thread starter Similar threads Forum Replies Date
C Apps General Discussion 0
I Apps General Discussion 0
M Apps General Discussion 1
Johnny5 Apps General Discussion 2
kep55 Apps General Discussion 1
I Apps General Discussion 2
gabriel.leijonhufvud Apps General Discussion 6
M Apps General Discussion 5
W Apps General Discussion 1
D Apps General Discussion 3
D Apps General Discussion 3
C Apps General Discussion 1
P Apps General Discussion 1
I Apps General Discussion 5
kep55 Apps General Discussion 3
commissarmo Apps General Discussion 7
bakacide Apps General Discussion 2
X Apps General Discussion 2
L Apps General Discussion 6
neiroatopelcc Apps General Discussion 10

ASK THE COMMUNITY