could someone help me

tawhid111

Registered User.
Local time
Today, 06:30
Joined
Aug 15, 2011
Messages
23
Help me plz |need immediate helpppp

could someone help me with access ? guys i am in need of some serious serious help i don't understand access at all im seriously stuck .. i have added the file link of what i ve done soo far this is my task im not sure how to finish this please help

[/CODE]EDIT UPDATED ATTACHMENT

changed the rental table/added relatiomships plz check and let me know and thank you guys
 

Attachments

Last edited:
Have you tried asking your professor for help or guidance on your homework assignment?
 
yes but the material he gave me was outdatrf i need to submit this asap and i need some major help plz help me out
 
So are you saying that you asked your professor for help, and then he gave you some outdated material?

A blanket "I need help" statement, in the same post with the word "assignment" typically implies that you are looking for someone to do your homework for you. That is a practice which is frowned upon in this forum.

If you have a specific question or questions to ask pertaining to certain area(s) where you need help, you should post those questions. In that event, it is more likely that you will find someone here receptive to your request who would be willing to help you.

Finally, you might want to consider converting your database to MDB format before uploading it here. You will reach a broader range of Users who have not yet upgraded to MS Access 2007.
 
i need help with it because i dont understand it if i did i wouldnr be asking right ? well maybe i didtnt ask properly so could someone kindly help me out ? i did the half the work already i just need someone to help me finish it since i dont understand access its my first time ever using it .:confused:
 
This is why you need to sit down with your professor and talk with him. Your professor should be able to give you the guidance you need to complete the assignment yourself.

"i did the half the work already i just need someone to help me finish it" is not a specific request that is likely to elicit a positive response. It sounds like you are asking someone to do your assignment for you and, as I said, that is frowned upon in this forum.

Do you have a question about a specific part of the assignment that you don't understand and with which you need help? Is it something to do with the Tables? Queries? Forms? The more explicit your questions, the more likely you are to receive help.
 
I was able to take a look at your database, and I have some general recommendations.
1. It is best not to use spaces or special characters (#,!,&,*) in your table or field names (you have some field names that have spaces)
2. It is best to have an autonumber primary key field in every table. The primary key uniquely identifies the record. You have that with the exception of the rental table.
3. Information in 1 table should not be repeated in another table with the exception of a foreign key field.

Looking at your database, your customer table looks OK with the exception of the spaces in the fieldnames, so you should take care of that.

In your media table, again remove the spaces in your field names. The other issue I see is with the media type field. If you look at your data, you repeat the same media type many times. This describes a one-to-many relationship: 1 media type to several media items. It would be better to put the media types in a separate table (1 record for each unique type) and then reference the key field in your media table.

So a table to hold the media types

tblMediaTypes
-pkMediaTypeID primary key, autonumber
-txtMediaType

From what I see you would have the following 4 records in the media type table:

pkMediaTypeID|txtMediaType
1|DVD
2|Blue Ray DVD
3|Game
4|VHS


Now you need to adjust your media table to reference the key field of the type table you just created. When you reference the primary key of 1 table in another, related table, we call the field a foreign key field. Since the autonumber datatype is just an incrementing long number integer field, the foreign key field must also be a long number integer field but it cannot be autonumber (you can have only 1 autonumber field in a table, and I would reserve that for the primary key of the table).

So we need to adjust the media table

Media
-MediaID primary key, autonumber
-MediaName (text field)
-fkMediaTypeID foreign key to tblMediaTypes, must be a long number integer datatype as explained above
-Description

Now, the main problem with your database is with the Rentals table. Here is some guidance on correcting the table (I do not want to do it for you since it is an assignment after all)

1. You need an primary key, autonumber field that uniquely identifies the rental (independent of the customer or media)
2. Do not have fields that contain information that is already in another table with the exception of the foreign key fields like I showed above.
3. no spaces or special characters in your table or field names


Now the key to setting up the rental table correctly depends on what your relationships are. Here are some questions to ask yourself?

1. Can a customer rent many media items?
2. Can a media item be rented by many customers over time?
 
ok i could correct those but could you help finish it i got til the end of this week im new to ms access or i wouldnt be stressed out with it i need like more time to learn access .theres soo many things i still dont understand just this once i m asking you guys to help me out !

for the customer question if doesnt have to be many times as long they can rent it once or i can show the records its good its a tough for an introduction to technology couse .. i didnt count on this :confused:
 
When you say "just this once i m asking you guys to help me out", do you mean, "help me understand how to do this" or do you mean "would you do this for me"?

jzwp22 has already given you some detailed guidance on your project; you should be able to use this information to complete the assignment yourself. If you are asking for someone else to finish your assignment for you, you've definitely come to the wrong place.
 
i mean by that is i will try my best to completing it and fixing whats being suggested and if i cant i want you guys to help finish it like i understand tthe part where he suggesting me to label the tables properly what i dont understand and having massive issues is how to generate the records etc ..
 
for the customer question if doesnt have to be many times as long they can rent it once or i can show the records its good its a tough for an introduction to technology couse .. i didnt count on this

I think that your professor is really after how you structure the rental table and whether you do it properly. It is the key to the assignment! As such, I will not do it for you, but I will give you this hint: look in your textbook or other sources you have for the course for the concept of "junction table" By the way, your professor gives you a big hint in the last paragraph of the text of the assignment you posted earlier!

After you do some research on that, try to come up with the correct table structure yourself. Keep in mind the hints I provided in my earlier post as well. Please post the table structure you come up with.
 
ok i tried to follow what jzwp22 said to fix and updated the attachment on the first post please let me know what do i do next ?
 
The Rental table does not look to be any different than before.

The customerID cannot be the autonumber, primary key of the rental table, but it can be a foreign key and you are still duplicating information in the rental table.
 
The Rental table does not look to be any different than before.

The customerID cannot be the autonumber, primary key of the rental table, but it can be a foreign key and you are still duplicating information in the rental table.
i made the change im not sure if i understood what you asked please have a look
 
Almost got it. You need to double check the data type of the customerID field in the rental table.

The next step is to create your relationships in the relationship window. I suggest you enforce referential integrity for all of your joins.

After that then you can create your forms. Typically you would base each form on a table. The junction table should be the subform. You would populate one of the foreign keys via a combo box while the other will bind to the main form.
 
Almost got it. You need to double check the data type of the customerID field in the rental table.

The next step is to create your relationships in the relationship window. I suggest you enforce referential integrity for all of your joins.

After that then you can create your forms. Typically you would base each form on a table. The junction table should be the subform. You would populate one of the foreign keys via a combo box while the other will bind to the main form.


ok i added relationship and used the form wizard to create forms is that what i am suppose to do ??
 
Yes, now you need to add some records via the forms to make sure that the tables populate properly.
 
Yes, now you need to add some records via the forms to make sure that the tables populate properly.

please help me with this part i dont know how to do this did i do the relationship correctly and please advice or help me fix it to make this a a decent work :)
 
Last edited:
Sorry, I did not realize that you had posted the updated database back on the first post. I do not always go back to the original post only the most recent, so if you could put the updated databases on your most current post as we move forward that would be best. Also, if others are following the post, they will see the progress of how the database changes with each new series of posts. It provides a better learning tool to everyone.

Regarding the relationships, you will need to enforce referential integrity. To do this, double click the join line and check the referential integrity box.

Regarding your forms, if you want to see what customer has rented which media items, it would be nice to see that within 1 view. To do this, you need a main form with a subform. It is generally easier to have the subform in datasheet view rather than single form view, that way you can readily see all the media items that each person has rented in one glance. I gave you a hint earlier about on which table the subform should be based. To create a form/subform, open the main form in design view, click on the form to be used as a subform and drag it into the main form. Since you set up your relationships, Access will automatically make the join between the main form and the subform. Remember that you will need a combo box in the subform so that you can select the particular media item being rented.
 

Users who are viewing this thread

Back
Top Bottom