DVD Rental Database

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:

Related 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.


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
SalesDate
IDSalesman
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 Lydia.com


"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.

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.


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.


DLookUp Formula
The first issue is with a DLookUp formula.

What I need is for it to say "[The DVD Title Text Box] = The DVD Title from the DVDs Table when the DVD ID = [The DVDs ID Text Box on Form]

I have a tried a variety of things and always get ?Error or ?Name this is what I have at the moment

=DLookUp("DVD Title","DVDs","[DVDs]![DVDID]=[DVDsID]")

Just to check, this is meant to go in the Control Source of the DVD Title Text Box on the form.


Check out an item for multiple dates in the Lending Library template?
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,


DVD Database Creation
I am rather new to this and am trying to create a simple database to track my DVD collection. I have seen many templates on the web but they are too elaborate for me. I dont care about including the actors and plots, just the title of the disk is all I want.

The trouble I am having is trying to decide how to structure the database. The information I am interested in is this:

Some movies have Sequels. Some Shows have Seasons with multiple disks (exa. Season 1 Disk 1). Very few of the shows have similar titles. I store my DVDs alphabetically by Title.

How can I structure my database so that it can track Sequels and Seasons, sorting the Report view with the Sequels and Season shows grouped and sequentially indexed together


How to check out an item for multiple dates in the Lending Library template?
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.


Modifying Lending database
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.


Database application designing for video store
To illustrate how to use Access in a commercial application we'll use a business that almost everyone is somewhat familiar with: the local video rental store.
Let's say that the store, Mike's Video, is going to open for business in a few weeks and the owner, Mike, wants to have a database application ready to go for opening day.


How to set up recurring payments in the Membership Database
I recently transferred our database of residents to access and now I need to set up monthly rental payments. I used the "Membership Database" template from Office.com. The payment due varies by room type and I've modified the Membership Types form to reflect this.

What I can't figure out how to do is set up a recurring payment that charges the residents theappropriate amount on the first of every month.

I haven't included a lot of detail in the note above because I'm not sure what is needed.


Stuck with relationships
I am creating a movie rental database in Access that will work in a similar way to Netflix or Lovefilm, where rentals are not charged by individual rentals, but as part of a subscription where a user can rent a certain amount of DVDs at once.

It's been a while since I've used Access and I'm not finding it that easy getting back into it. By the way, this database will be usedto power some ASP in a website (of which I have never done before, so I want to make sure it is correct before going any further!)

I have set up all the tables I want to create, but I am unsure of whether the relationships are set up correctly and whether I have done it in the most efficient way. I haven't yet entered data in the database, but I have a feeling that I have not set up the relationships correctly for the tables in the red box.

Can someone check my relationships for me and if there are some problems, I know if they're not right now, then it can have major implications!


Stuck with relationships
I am creating a movie rental database in Access that will work in a similar way to Netflix or Lovefilm, where rentals are not charged by individual rentals, but as part of a subscription where a user can rent a certain amount of DVDs at once.

It's been a while since I've used Access and I'm not finding it that easy getting back into it. By the way, this database will beused to power some ASP in a website (of which I have never done before, so I want to make sure it is correct before going any further!)

I have set up all the tables I want to create, but I am unsure of whether the relationships are set up correctly and whether I have done it in the most efficient way. I haven't yet entered data in the database, but I have a feeling that I have not set up the relationships correctly for the tables in the red box.

Can someone check my relationships for me and if thereare some problems, I know if they're not right now, then it can have major implications!


2010 and 2007 Access Queries, Forms & Reports
I'm putting together a church membership database. The Access version on the computer at church is 2007. The one I have at home is 2010. The design of the tables are finished, and the church secretary has already started inputting data, while I'm working on queries, forms and reports.

I know not to upload a copy of my trial table into what she's doing, but how can I copy and paste queries, forms and reports onto a DVD and upload them into her version? Access shows "save database" and "save object".

Are queries, forms and reports considered objects, or should I simply use copy and paste from a DVD? This is my first attempt at using MS Access.