• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating a database in Excel for Monthly Expenses

Viswateja

New Member
Dear All,

I am quite a beginner to these Databases. I am residing in an apartment and I have to prepare a monthly expense report for each flat that is occupied. I wanted to store it as a database for my future reference too. I have prepared an excel file "HVRWA Accounts" which comprises of three sheets. First sheet is for the Summary of the total income and arrears, second sheet corresponds to the data entry of individual flats (which inturn reflects the final value in first sheet) and third sheet is to print the list of defaulters. I have given the detailed instructions in the second sheet i.e. "Monthly Particulars" for your perusal. I knew it will be relatively easier with the access tables but I am very naive at these concepts. I kindly request you to please help me in sorting out this issue. Appreciate your response.
 

Attachments

  • HVRWA Accounts .xlsx
    23 KB · Views: 8
Back
Top