Đang Thực Hiện

151351 Membership / Billing DB

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:

Members

Payments

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.

Billing

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.

Rank

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.

Kỹ năng: Bất kì công việc gì, Microsoft Access

Xem thêm: what month is january, the month of january, school ranking, school rank, rank school, rank of school, ranking school, month of january, member ranking, january is the month of, january is month, for the month of january, billing microsoft, microsoft access test, test plans, s+db, paid membership, martial , how to add a photo, db query, create membership, billing, belt, track payments due, access query table

Về Bên Thuê:
( 0 nhận xét ) Los Angeles,

Mã Dự Án: #1897531