Results 1 to 7 of 7
  1. #1
    Kudo is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    4

    Thumbs up Invoice and Reciept System

    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

  2. #2
    bigroo's Avatar
    bigroo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jan 2012
    Location
    Austin, Texas
    Posts
    101

    Invoice and Reciept System

    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

  3. #3
    Kudo is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    4
    well bigroo let me try it out and see

  4. #4
    Kudo is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    4
    Well am using Access 2010
    i have tried to look through the templates available can't seem to locate the Expense Reports

  5. #5
    bigroo's Avatar
    bigroo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jan 2012
    Location
    Austin, Texas
    Posts
    101

    Invoice and Reciept System

    Hi Kudo,

    Here it is in 2007 format, you should be able to open it in 2010 I would think.

    Thanks

  6. #6
    Kudo is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    4
    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

  7. #7
    imintrouble is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    Missouri, where frownin's a sport
    Posts
    127
    Perhapse you might find one of these to your liking.

    http://office.microsoft.com/en-us/te...010142348.aspx

Please reply to this thread with any new information or opinions.

Similar Threads

  1. query for an invoice.
    By lakersfan34 in forum Access
    Replies: 7
    Last Post: 11-25-2011, 12:54 AM
  2. Creating an Invoice System / Report
    By duffy1807 in forum Database Design
    Replies: 9
    Last Post: 11-03-2011, 11:36 AM
  3. Replies: 2
    Last Post: 04-12-2011, 10:14 AM
  4. Add a 1.5% charge to invoice?
    By alx100 in forum Access
    Replies: 1
    Last Post: 03-16-2011, 03:18 PM
  5. Invoice
    By billyff in forum Access
    Replies: 3
    Last Post: 04-25-2009, 12:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums