Topics Search

DVD Rental Database

DVD Rental Database
Views: 109
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' 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:

More topics


If ID is in table show....

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

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

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

Price to automatically display when other data is selected.

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

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.

"Rewrite" an application without affecting old calculations

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.


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.

List in a query

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.

Dynamic total ItemInStock

I trying to make an inventory Db. and I'm stuck in something that I belived is quite easy but I can't solve it.

How can I make a dynamic total?

Here's the example.

When someone sales an item, it has to shown the quantity of that item has been reduce. The query shoud show something like this:

IDItem Description
SaleQty ItemInStock 256
DVD plug
45 256 DVD plug
44 256 DVD plug
43 256 DVD plug
40 256 DVD plug
39 256 DVD plug
38 256 DVD plug

Other thing is that I really want to learn, so if any can point some good book for learning it will most apreciated (I've already finnish the video course from

Automatically Calculate Days Between & Overdue Query

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

Data Model Example: DVD Collection Scenario

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.