I am a newbie in excel i need help for creating a database for collection of fines in an organized manner, the tables are as follows:
District Names
district_id (primary key)
district_Name
contact_person
Book Number
Book_Number (primary key)
District_Name (from table district names)
Issue Date
Book Summary
Book_Number (from table Book Number)
Page_Number (1 to 50)
Fine Imposed
Bank Collection
Court Collection
I want to add a district first then book number and lastly the book summary which have fix 50 rows like this
Book Number:
District Issued:
Issue Date
page number Fine imposed Bank Court
1 100 100 0
2 200 0 200
3 etc
4
5
to
50
Thanks in advance