Video Rental

it's just thoughts, nothing you have to do. I think it would help a lot if you just put down the data you need and try to categorise it. Also determine the processes, like buying video for store, rent it out, keep it in stock, video return, payment, selling off old videos and all sorts of stuff that might go on and you want to register.

Based on that information it would be easier for us to give you ideas for the queires and forms.

From the design of your tables I can see you did think it over very well, but to get good info from the forum, you might want to put that info here.

I think I want Video store to rent out the videos and video return. Then, cutomer receipt where it shows the total payment including tax and any late fee occur and type of payment.

so you have videos, you have customers, customer rent videos, you have tax percentages (or all rates with tax included?), you have rental rates, you have late fees, you have payment methods and the receipt.

I'd still build a table rental type with rental days, rental rate and late fee and maybe even late fees in a different table if it depends on the number of days late and not on the type (like 1 day 1 dollar, 2 days 3 dollars one week 10 dollars or something like that)

so you need a form for adding new videos which you can base directly on the video table, with a combo box to add the rental type.

you need a form to add customers (based on the customer table)

you need a form for rentals, which you base on the rental table and a combobox to choose the customer, the video and the rental type (default value, the rental type of the video).

then you need a form for the receipt where the total sum is calculated for the customers (depend on when they pay, when they tke them or when they return them or once a week, you might need a checkbox on the rental table to check if it is paid) you need the customer id and then you can either look up in the rental table which ones are paid or you pick the rental ID's (no need for the video ID because they are in the rental record)

Then you probably want a report for your income and maybe a list of what videos are in store and more reports

Correction on #2.  Either Due date or RentalDays should be store in the table.  The reason is that the rental period may change.  If not stored then all transactions would reflect the new period, which may not be what you want.

Jim.

I think I more understand what I want. I want to be able to see customer history rental, input new customer, rental out and payment method including tax. Can somebody email me with a sample database please.
I need this ASAP project due this week. Please help

<<I need this ASAP project due this week. Please help>>

  Sounds like course work.

Jim.

I wish I had the time to make you a sample working database

I revised my table and this what I have now

CUSTOMER:
CustID
LastName
FirstName
Street
City
State
PhoneNum

RENTAL:
RentalID
MovieID
Rental Date
RentalPrice

VIDEO:
Movie ID
Title
Rating
Release Date
Rental Cost
Rental Days
Format

Payments
PaymentID
paymentmethods
paymentamount
CC#
CCexpdate

paymentmethod
paymentmethodID
creditcard-yes/no

VIDEO STORE:
customerID
Movie ID
RentalDate
paymenttype
totalcost
Total Cost

what do I need to do next for me to be able to see customer history rental, input new customer, rental out and payment method including tax

how can I calculate the late fee base on the number of days they rented and total amount of the rental

the customer history rental you can get from the table video store, with links to the other table to get names instead of ID's
I think a query or a report would be appropriate
Input new customer is a standard form based on the customer table
rental out you will need a yes/no field in video store I think where you can tick off if a video has been returned. Then all videos that haven't been ticked off are rented out at that moment.
the payment method I'm not sure what you mean
you can calculate the late fee if you have the due date and the rate per day for the late fee. The days it is late mulitplies by the rate per day will be your late fee

ok I think I get the customer history rental and new customer input. Now I am confuse on calculating the late fee automatically where when you input the return date will automatically change the amount of late fee. where do I create this, what table? and what i payment method: input for the cc, check, or cash and also can I create tax calculation after I choose the payment method and amount payment plus tax and will give me total amount? where should I create this?

the calculation can be performed in a form or query. Use the builder to get the right format for the field names.

If you enter the return date you can compare this with the rent date (function DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])) and see how many days it is late.

did you ever get your database working?

This question has been abandoned and needs to be finalized.
  You can accept an answer, split the points, or get a refund (information at http:/help.jsp#hs5)
  If you need a moderator to help you, post a question at Community Support (http:/Community_Support/)
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
kfalandays cleanup volunteer

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
  SPLIT between Poppekop(150) and JDettman(100)
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
stevbe, EE Cleanup Volunteer