DVD Rental Database

Views: 106

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

More topics

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.

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!

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

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

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.

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.

I have a simple query. The first field is MediaType and has 2 values (DVD or Bluray) taken from the Media Type table Of course the query gives me a list of all the DVD and Bluray the DB has. What im trying to achieve is to run the query based on a list (DVD or Bluray).

What i was able to achieve (by using [DVD or Bluray] in the criterai) is a dialog that lets you input manually DVD or Bluray. Of course if you mispelled you get nothing.I'd like to be able to select the possible values (DVD or bluray) from a list to avoid that and i dont care much for the dialog.

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

The following data model is designed to hold information relating to a personal DVD collection. For this scenario we need to define the following facts:
These facts define the requirements which the Database must meet and should be agreed between the Database User and the Database Designer prior to physical creation.