Topics Search

DVD Rental Database

DVD Rental Database
Views: 116
I am a student and in need of some serious help. For our Coursework we were told that we needed to create a database for a company of our choosing. I did some research and decided to pick a DVD rental shop as I thought this would be a good idea at the time. Now its come the time to actualy start making the thing and I am in serious trouble.i have no idea how to use access.i have tried going through all the tutorials but they confuse me more!

all I have so far is 4 tables.customers.DVD's.rentals.and Suppliers.i need to know how to create a input form so I can add new customers but when I try to create a form and then go to pick out the feilds.there is no fields to choose from
Sponsored Links:

Similar posts...

 

If ID is in table show....

If ID is in table show.... Icon
I have a DVD Rental Database, and what I want to do is on the DVDs Form (Where all DVD details are entered) I want it show whether the DVD is in stock or if it is currently rented out. I presume I would have to say to the program something like this.

In Stock?(CheckBox) = Yes If DVD ID is in Rental Table Else No
 

DVD Rental Update Stock

DVD Rental Update Stock Icon
FAIRLY new to all this.
I'm having a little trouble figuring out how to update the stock levels for items in my stock table. It is a DVD Rental Database, so of course I need stock to be subtracted and added back on.

I already have a query for the amount of stock for each item, however, this only shows how much stock is in the 'AmountStock' column of my stock table (the original amount of stock).

I have a form also linked to my Rental Table, which works fine.
Just can't figure out how to make a query for updating stock each time a film is borrowed and returned!
 

Printing a letter in a form

Printing a letter in a form Icon
For a project, I am making a database for a DVD Rental Store, on this form I would like a button to print a letter that I have in word but for each different guests so it prints them a letter confirming there registration and include account numbers which will be different everytime
 

"Rewrite" an application without affecting old calculations

"Rewrite" an application without affecting old calculations Icon
Rewriting an application database file.

I created an application (1 file accde includes tables) that keeps track of the works of a rental shop.
It consist of tables where different data is stored and it has forms where a user can input data then
it has queries that calculate rental prices and finally it has reports that print invoices.
It works well.

But

The rental shop wants to change the way they calculate the prices. I can easily change the queries to make new calculations but it creates a problem.
The new queries will change the old invoices by recalculating them. And that should not happen.

1,Keep the old application for historical purposes and use the new version for the new jobs.
That looks the easiest.

2, Save all the old data in the database and stop recalculating them. There is a problem with this because it would save calculated data in the database.

3, Create complex queries that checks data and recalculate old data with the old method and new | data with the new calculations. It looks a bit time consuming task.
 

Price to automatically display when other data is selected.

Price to automatically display when other data is  selected. Icon
On a form, I want a price to automatically display when I select an item.

For example.

In a combo box, I would have a selection of camera gear that would incur a rental fee based on their rental type (Weekly Hire, Weekend hire, Overnight hire etc).

Instead of having a user select both the camera gear and then select the rental type and price in another combo box . how can I have it so that when the user selects the camera item, it will automatically display the rental fee
 

Normalisation and Relationships problem

Normalisation and Relationships problem Icon
I'm very new to Access databases and I'm trying to set up a system for a DVD rental shop. At the moment I have my tables set up as in the attached screenshot, but I've been told that this is not normalised and won't work properly.

Apparently I need to add another table. I'm also not sure what type of relationships I should have.
 

Check out an item for multiple dates in the Lending Library template?

Check out an item for multiple dates in the Lending Library template? Icon
I am trying to use Access 2007 in order to keep track of inventory for a small rental program for my school. The program is perfect because it can track inventory, who has it, if it is overdue or not, etc.

My only problem is that when I check out an item for say a date 2 weeks away from when I am booking the item it lists the item as not available. Therefore if someone wants to rent the item for the upcoming weekend, and have it returned before the next people have it checked out, I can not put it in the system.

If anyone knows how to check out an item for multiple dates and not have it come up as unavailable until theactual rental date,
 

Modifying Lending database

Modifying Lending database Icon
I would like to modify the Lending Library database for a friend who runs a costume hire shop. She needs to have Date Hired, Date Returned, Cost for Hiring and Stock Level included in the rental.

It need not be too complicated eg no need for manufacturer or supplier. I have to be honest my knowledge of Access is not brilliant.
 

How to check out an item for multiple dates in the Lending Library template?

How to check out an item for multiple dates in the Lending Library template? Icon
I am trying to use Access 2007 in order to keep track of inventory for a small rental program for my school. The program is perfect because it can track inventory, who has it, if it is overdue or not, etc. My only problem is that when I check out an item for say a date 2 weeks away from when I am booking the item it lists the item as not available. Therefore if someone wants to rent the item for the upcoming weekend, and have it returned before the next people have it checked out, I can not put it in the system. This is very frustrating because this is my only issue with the program and I am hoping it is something I can accomplish. If anyone knows how to check out an item for multiple dates and not have it come up as unavailable until the actual rental date, you're help would be greatly appreciated.
Thanks so much to all who respond.
 

Automatically Calculate Days Between & Overdue Query

Automatically Calculate Days Between & Overdue Query Icon
On my Rental form I have a date out and date in date, the date out is the day the dvd will be rent out, and the date in is the date due back, how can I get a text box to automatically calculate the different between the two, so it says number of days: 3 or whatever, badly explained I know. After this I will need to create a query to show overdue DVDs, how would I go about doing this, so the query needs to be "Show Rentals that date in is less than current date
 
Sponsored Links: