Sample Database for DVD Rental Store


Does anyone have a sort of template for a dvd rental database in Access?


Sponsored Links:



being a bit lazy on this sunny friday morning, I was wondering if anyone cld recommend a freely available sample database for customer management, just one that records customer details, any meetings , any notes regarding the customer etc.. not too complex with maybe a couple of reports included !

many tks if you can

rgds

from sunny dublin




hi ,
does anybody have coffee shop or resturant sample database ?!

for example something that gives menu's and then u select people orders and then calculate the prices and print a bill

thanks




Hi,

I'm in over my head with something I've been asked to do at work as my access skills are pretty basic.

I need a sample database containing PRODUCTS and SUPPLIERS, that lets you book IN stock received from the supplier (and adds to the stock level) and lets you book OUT stock issued to staff (and reduces the stock level)

I'll have a go at reorder levels, form design, stuff like that myself, but I'm having trouble with these very basic requirements.

Does anyone know of a sample database that I can download to learn some of this from?




Hi friends,

I'm very happy and happy since I've found this discussion forum.

Actually, our company need to me to develop one database using MS Access for catering business, I've navigate to the internet to search sample database for catering but until now I'm still not find.

Hopefully, all of you can give me sample database for catering business.

Best regards,




Hi:

Have found help in various posts while I build my database for DVD rentals for our small country store. Was going to start from scratch, but discovered the template for Lending Library and thought it would spare me some time and effort.

Have experience building Access Databases, but it's been a while and I'm a bit rusty...

Been playing around with the Lending Library template and making it my own. I changed the tables and the relationships, since I noticed every table in the template had the same Primary Key (ID). Not good design, huh?

Managed to make some progress and added additional reports, etc. My only REAL problem right now, (and this is inherit from the template), is this:

The Contact Details Form's subform named Current Lending, pulls up ALL movies lent to customers, regardless of who rented them. Obviously there is something wrong with the query, and it's not filtering the information for each customer. I'm sure it's missing adjoining fields.

The easiest way to rectify this, is for me to upload the DB and have someone take a look and attempt to fix this, instead of me banging my head against the wall.

I have backups, so I don't mind if someone modifies the db, then I can put some minor touches to complete this project.


Thanks in advance,
Marion Attached Files Alger Market Movie Rentals.zip (255.1 KB, 12 views) Last edited by RuralGuy; 01-20-2012 at 02:49 PM. Reason: Attached the zip file Reply With Quote 01-20-2012, 04:30 PM #2 aytee111 Expert Windows 7 32bit Access 2010 32bit Join Date Nov 2011 Posts 550 That is the way it has been designed. What would you like to change about it? All the tabs reference all the customers, not just the Current Lending one.




Hi!

I'm making a test database for DVD rentals. When A loan is made I have an update query that sets some fields in the DVD copy table. One of these fields needs to be set to the primary key of the loan made. This would be the last entry on the loans table. I don't have any idea what to put in the 'Update To' box in the query though.

Wrong code here, but this may help explain what I am trying to get:

	Code:
	Tables.Loans.LastLoan.Loan ID

Also heres an image of my query:


Help would be much appreciated. Thanks




Hello all,

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!

i really really really need some help here.

thanks foe reading

Jon




hi, i'm a newbie and really don't know much about ms access

for school i have to creating a access database and using Visual Basic to create the user interface for it, the main focus of the project is on the vb so the access can be very simple

i'm thinking of using dvd rental database idea but i need it to keep stock as well. I was just going to keep a stock list and have one colomn called 'In Stock' displaying either yes or no and then run a report to display which dvds are in stock and which are not, or thats the idea at least

i will be setting up an input form for dvd rentals to select the customer and the dvd, but i need the form to change the yes to a no in the above column to change the In Stock status

my question is how do i do this, or is there a better way of going about this


thanks in advance

ps i'm using access 2003




Making a back-end database for video Rental shop web-site where user can search Dvd by Catergory and ask to borrow it. All info must be stored in relevant database.

How many tables do i need
1 Customers (should this include Username and password)
2. Dvd's Title,artist, rating
3. Catergory Horror,comedy,action etc
4. Loan ( not sure what attributes to have)




Hi,
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!!

Any help would be MUCH appreciated.
Thanks,




Ok for a project i had to make a dvd rental database i basically done all the features except some of the queries iam finding hard to do please help!

First query i want to make the computer detect Memebrs not borrowing videos. How do i make it to search for a blank in the table coloum and then give the results the table is linked with releationships the field is basically a number ID.

Second one: How can i find memebrs borrowing more than two films. I cant type >2 as it thinks iam talking about memebr or video id higher than number 2. SOmeone give me some info please




Hello all,
I am learning Access and am continuing to learn more and more and love it! I have gotten so much help on this forum from reading the posts and asking questions, I really thank everyone for there help. Just when I think I am getting going, I stumble though.

I am trying to make a report with date parameters. I looked at the sample database and can't figure out how the start and end date is being filtered. It doesn't use a query, so I am not sure how it is working. Can someone explain this to me?

Thank you in advance.




I recently down loaded this sample database and tried to use it using Access 2007. I was not able to get the database to work. It would not allow me to click on the Browse button. I kept getting a debug error, and it highlighted the first line of code behind the button. I manage several databases for a department of 30 plus people and this tool would be extremely useful for me, if it would work in 2007. Here is the link to the sample database: http://www.access-programmers.co.uk/...d.php?t=155950 . Does anyone know what needs to be done to get it to work in 2007?




Hey All, I came across the sample database that Smig made and am having problems getting it to work. Modules are not my strong point for sure. He says You will need to set up some eMail details for this to work (they are all in the mdl_PublicDeclerations) This is were I get lost I can't seem to figure out how or where to put my info.

Option Compare Database

Public pbUserName As String
Public pbUserEmail As String
Public pbEMailAcountUserName As String
Public pbEMailAcountUserPassword As String
Public pbEMailAcountSMTPHost As String
Public pbEMailAcountSMTPPort As String
Public pbEMailAcountUseAuthentication As Boolean
Public pbEMailAcountPOP3Host As String
Public pbEMailAcountUsePopAuthentication As Boolean

Public pbYourEmail As String ' -- for errors only

And this is my info

pbUserName = "phxbombardier@gmail.com"
pbUserEmail = "phxbombardier@gmail.com"
pbEMailAcountUserName = "phxbombardier@gmail.com"
pbEMailAcountUserPassword = "*******"
pbEMailAcountSMTPHost = "smtp.gmail.com"
pbEMailAcountSMTPPort = "465"
bEMailAcountUseAuthentication = 1
pbEMailAcountPOP3Host = "pop.gmail.com"
bEMailAcountUsePopAuthentication

Any help on this would be greatly appreicated




Hello all,

I have been playing with the GetFiles.mdb, featured in the Sample Databases section, and have come accross two issues I cant seem to adress alone.

First off, I would like to add the file path to an existing table called 'Indexing', to a certain field called 'Filepath'. There is another field called 'Filename' that must line up with the field 'Filepath'.
Example Table:
|[Index0]|[Index1]|[Filename]|[Filepath]__________
| abcd | 1234 | image | //Server/batch/image.tif |

I Modified the code to work with this table and field, but... For some reason, When I change ".AddNew" to ".Edit" it will not update all the records, only the first record updates with the last file name.

How can I accomplish updating the field without adding the file path in a new record?
--------------------Code from GetFiles------------------------
Private Function GetFile()
'Please note this is done with the Microsoft DAO 3.6 Object Library
'Your system may not have this version! A References error may occure
'if your version is different or if you have not put a Reference to a DAO
'Object library of any kind in the database.

Dim vFile As String
Dim dbs As DAO.Database, rst As DAO.Recordset
Dim strFile

strFile = Dir(Me.txtPath)
vFile = txtPath & strFile

'This seemed to be needed to add the first record from the path - without it
'it did not bring the first file in but missed it every time.

'If you wish to bypass the combo box option you can use the following
'line of code. Note this line will allow for two file types. Remove
'Or Right(strFile, 3) = "wma" if you wish to use only one file type.
'If Right(vFile, 3) = "mp3" Or Right(vFile, 3) = "wma" Then
If Right(vFile, 3) = Me.cboFileType Then

'Open Recordset.
Set dbs = DBEngine.Workspaces(0).Databases(0)
Set rst = dbs.OpenRecordset("Indexing", dbOpenTable)
'add the Path (file location)
With rst
.Edit
!Filepath = vFile
.Update
End With

'Close the recordset
rst.Close
Set rst = Nothing

'Increment the progress bar
Me.pbrProgress.Visible = True
Me.pbrProgress.Value = 1
End If

'Brings in the remaining files.
Do Until strFile = ""
strFile = Dir
vFile = txtPath & strFile
'If you wish to bypass the combo box option you can use the following
'line of code. Note this line will allow for two file types. Remove
'Or Right(strFile, 3) = "wma" if you wish to use only one file type.
'If Right(vFile, 3) = "mp3" Or Right(vFile, 3) = "wma" Then
If Right(vFile, 3) = Me.cboFileType Then

'Open Recordset.
Set dbs = DBEngine.Workspaces(0).Databases(0)
Set rst = dbs.OpenRecordset("Indexing", dbOpenTable)

'add the Path (file location)
With rst
.Edit
!Filepath = vFile
.Update
End With
'Close the recordset
rst.Close
Set rst = Nothing

'Incrementing the progress bar until completed
If Me.pbrProgress = Me.pbrProgress.Max Then

'If completed then pop up the completion message
MsgBox "Import Complete " & Me.pbrProgress.Max + 1 & " Files Found."

'Hide the progress bar
Me.pbrProgress.Visible = False
Exit Function
End If

'Increment the progress bar in not completed
Me.pbrProgress.Value = Me.pbrProgress.Value + 1
End If
Loop
End Function
-----------------------------------------------------------------
If I dont make any sense, ask and I will clarify.
-Thanks for any input.




Hi need a bit of urgent help, I posted a sample database while looking for some help, which I need to remove, coudl anyone please help me to do this the db contains company data...many thanks Fi




Just an FYI for anyone who wants an incredible library of Access sample databases (courtesy of MVP Roger Carlson):
Roger's Access Library




Hello,

I am creating a database in Access 2010 for HR to store its records and information. This database will be loaded into SharePoint server 2010 with Enterprise features. I need several people to be able to open and write to the database simultaneously without any issues.

Does anyone have a good article that covers what I need to consider/do as far as "splitting" the database, write locks, etc?

I am not using the SharePoint Access services because the capabilities are limited. Just a regular database with multiple users.

Thanks,
Alex




Does anyone know of a Access database for tracking laboratory or clinical samples/specimens? There are stand-alone programs, but I prefer it in Access.

It would have to accommodate multiple storage locations (freezers, refrigerators), print barcodes and provide for instances where one biochemical sample is divided into multiple smaller portions for storage. It would also have to have a security component allowing multiple users to login with different levels of permission.

I've I heard of Laboratory Information Mangement systems. I guess this would be a Laboratory Inventory Management System.