Hey guyz am still new to access
but i want to develop a system to track my invoices and reciepts using access 2010
how do implement the tables to represent
Hey guyz am still new to access
but i want to develop a system to track my invoices and reciepts using access 2010
how do implement the tables to represent
Hi Kudo,
Welcome!!
Have you looked at the database templates that come with Access to see if they will help you out or fit your needs?
There is one in access 2007 under Business called "Expense Reports"
Thanks
well bigroo let me try it out and see
Well am using Access 2010
i have tried to look through the templates available can't seem to locate the Expense Reports
Hi Kudo,
Here it is in 2007 format, you should be able to open it in 2010 I would think.
Thanks
Hey Bigroo
thanks for that
i have tried it out but its like it doesn't much my expectations
but however i have tried to sort out the tables am going to represent
here they are
ClientsTB(ID,Name,ContactPerson,Department,Adress, City,Email,Phone#)
ProfomasTB(ID,Date,ServiceTotal,Ptotal,Tax,Client, )
InvoiceTB(ID,Date,Invoice#,ServiceTotal,Invoice total,Tax,Client,)
RecieptTB(ID,Client,Date,Invoice#,Total)
just advise me accordingly
do i need a reciept table cause in the manual form they use a reciept
Perhapse you might find one of these to your liking.
http://office.microsoft.com/en-us/te...010142348.aspx