how to create table?

Question

i want to create a daily expenss calculating s/w , what attribute should i take or anybody has alredy make a s/w plz help

Answer 1

It differs for all. You should note down your expences daily, And you can find the reoly within 5-7 days,

Answer 2

Hi,

You can create the "Daily Expenses" s/w using the following attributes in the table.

GroupId
GroupName
SubGroupId
SubGroupName
DateOfPurchase
Amount

This GroupId is Unique and Primary Key
Groupname is the name
Subgroup is dependent on GroupId.

This wil Work as:

GroupId --- 0001
GroupName---Food
SubGroupId---GroupID + ID
SubGroupName--Beverages/ Pespi/ Cola

This is a way , so that u can easily bifurcate the each and every product and the will help u create the Reporting as per group or Subgroup.

Hope U will find it best for you.

Answer 3

You haven't' mentioned if you would create the table in Access or Excel !
May be you would be easier to create an excel sheet specify Standard collection of Categories to put it in the first Column and then description,Date, Unit Price, Amount, Total price, all prices should be in the same Currency to be able to make totals.

for the Total price column you should create formula by writing "=" sign and then name or the cell (for unit price) * name of the cell (for Amount) ex =a1*b1 .
then you could drag the formula for the hole column of the total price

Good Luck

Answer 4

You can create it using Microsoft Excel or using some database application like MS Access or SQL Server or Oracle...

Answer 5

I think it is not a typical application. Just go for MS Excell it will solve you probelom very simply.