What is best

hannah-123

New member
Local time
Yesterday, 17:10
Joined
Nov 6, 2014
Messages
2
I am using Access 2013 and have basic knowledge.

I'm looking to create a data base to record the sale of our services.

Basically we will be sending parcels for people. I want a data base where I can store the information about who is sending the parcel and where they are sending it to, and be able to generate a confirmation slip/receipt that will be given to the customer.

It will contain all information about the customer and the receiver, it will state the type of service the item was sent on, and also provide the tracking number.

Any help will be much appreciated.
 
I made a sample database that you can modify to fit your needs here: http://www.patrickcool.me/OP/OP.html

edit: I saw you specified 2013, my example is 2010 and might require additional tweaking.
 
Question is, any recommendation as to what tables, forms etc. i should be creating
 
Question is, any recommendation as to what tables, forms etc. i should be creating

So your table would have a Person_Sending_Parcel field, a Sending_To(or more like a customer ID that relates to another table with the customer information) field, Confirmation field (so you can print a slip receipt based on that field), Service_Type field...

When you said "provide a tracking number",
Do you make a tracking number? where does the tracking number come from?

There are a lot of different ways to do what you want to do. I would just start by coming up with field names based on the information you want to see.
 

Users who are viewing this thread

Back
Top Bottom