MS Access Database
The database is about 50% completed. I need someone to complete the database.
This is a membership database for a martial arts school to track students, monthly billing and belt ranking.
The main tables are:
Rank (belt level)
What I need are:
Form - Members
Alphabetize by memberâ€™s first name in combo box. Currently they are in the order of the Member ID.
Ability to add a photo for each record. The photo will be retrieved via a path in a folder on our hard drive, as opposed to Access storing the photos.
Adjust the Datasheet view of payments table so that column headings are readable.
Students are on different payment plans typically billed monthly or quarterly (Table = MemberTypes). Due Dates are on the anniversary of their sign-up date. For instance, if a student signs up July 6, 2007 their due date is the 6th of each month.
Create a table or field that will fill in the due date each month (or quarter) for each student.
Query - Billing
Create a query (or report) that allows me to print out a sheet at the beginning of each month showing Members Last / First Name and Due Date.
Create a query (or report) that allows me to see who has not paid and how many months they are late.
Each student tests for the next belt. Table = Rank shows belt level, time in # of months to get to that level and payment required for that rank.
Create a field that will determine testing month for each rank. For instance if a student joins in July, they will test September, November, January and so forth, determined by the field â€œMonth to Testâ€ in the Rank Table. Month to Test is a number based on how many months to get to that rank.
Query â€“ Rank
Create a query (or report) that allows me to:
Print out testing schedule per student. What month they will test and â€œRank Nameâ€
Print out a sheet at the beginning of each month showing Members Last / First Name of students scheduled to test that month, Rank Name and Cost to Test.