Loading
Home › General Help › I have an Access assignment that needs to be completed. I...
Status: Completed

I have an Access assignment that needs to be completed. It includes creating a new database through microsoft Access. This is not going to be a difficult task for someone who is familiar with Access.

Date Posted: 25/02/2013
Category: General
Due Date: 25/02/2013
Instruction
I have an Access assignment that needs to be completed. It includes creating a new database through microsoft Access. This is not going to be a difficult task for someone who is familiar with Access.
Tutor Uploads
No File uploaded yet.
Bidders
Homework_Nerd 13 years, 7 months ago
Rated 9.64 earned 198461.97 around 1228 assignments.
Hey there. I'd like to help you out with this assignment. Could you send me the instructions before I commit to it? Thanks
$40.00
  • Definitely. Are you familiar with Access? If you decide to commit to this would you be able to tell me an approximate of when it would be complete? I am pasting the instructions. The Unit 7 Project is the culminating project for our units on Microsoft Access 2010. Using Microsoft Access 2010, create a new database. Create a table named `Items` that will hold the fields needed to maintain a list of items carried in a grocery store. Required fields for this table include the following and you may add other fields if you wish: Item_ID (data type Text, 25 field size), Item_Name (Text, 50), Vendor_ID (text, 25), Store_Cost (currency), & Selling_Price (currency) You will add at least 10 records of your creation to populate this data. Make Item_ID the primary key. Use at least five different Vendor_ID values. Create a second table named `Vendors` that will hold the fields to maintain a vendor list. Required fields for this table include the following and you may add other fields if you wish: Vendor_ID (data type Text, 25 field size), Vendor_Name (Text, 50), Vendor_StreetAddress (Text, 50), Vendor_City (Text 50), Vendor_State (Text 2), Vendor_ZipCode (Text, 10 - set Input Mask to zip plus 4 showing the dash between zip and the 4. Each item in the Items table must have a corresponding vendor record in the Vendors table. You will add at least 10 records of your creation to populate this data. All values are fictional. Make Vendor_ID the primary key. Create a relationship between Vendor_ID of the Vendor table and the Vendor_ID of the Item table in which you enforce referential integrity. Create a third table named `Sales` to record line-by-line sales. Required fields for this table include the following and you may add other fields if you wish: Sales_ID (data type AutoNumber), Sale_Date (data type Date/Time set Format to Short Date), Item_ID (Text, 25), Quantity (data type Number) You will add at least 10 records of your creation to populate this data. All values are fictional. Make Sales_ID the primary key. Create a relationship between Item_ID of the Sales table and the Item_ID of the Item table and enforce referential integrity. Every sale must use an item from the Items table. Create a query named `Sales_Query` with all fields from the Sales table, add in the Selling_Price field from the Items table, and build a calculated field to multiple the quantity field from the Sales table by the Selling_Price field from the Items table Name this calculated field as Charge. Be sure your relationships and data are in place first. With the Sales_Query query highlighted in the Navigation Panel, click on the basic Report builder button to create an instant report. Change the report title to Sales Report and save the report as Sales_Report.
    User_624 | Feb 25, 2013, 03:59 AM
  • Hey there. Yes, familiar with access. It's not hard work, but it's a little time consuming. I've changed my bid, and I can deliver within 2-3 hours from now
    Homework_Nerd | Feb 25, 2013, 04:04 AM
  • I appreciate the offer but can not pay 40$. Thank you.
    User_624 | Feb 25, 2013, 04:07 AM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
ScholarPro 13 years, 7 months ago
Rated 9.98 earned 5625.81 around 69 assignments.
Hi, I can help you with your assignment. I am very familiar with Access, and created and developed several advanced databases for my work. As I am new in this site, I am trying to keep my bids as low as possible. Please let me know if I can help you
$25.00
  • These are the instructions for the assignment. Do you have an idea how long it would take you to complete it? The Unit 7 Project is the culminating project for our units on Microsoft Access 2010. Using Microsoft Access 2010, create a new database. Create a table named `Items` that will hold the fields needed to maintain a list of items carried in a grocery store. Required fields for this table include the following and you may add other fields if you wish: Item_ID (data type Text, 25 field size), Item_Name (Text, 50), Vendor_ID (text, 25), Store_Cost (currency), & Selling_Price (currency) You will add at least 10 records of your creation to populate this data. Make Item_ID the primary key. Use at least five different Vendor_ID values. Create a second table named `Vendors` that will hold the fields to maintain a vendor list. Required fields for this table include the following and you may add other fields if you wish: Vendor_ID (data type Text, 25 field size), Vendor_Name (Text, 50), Vendor_StreetAddress (Text, 50), Vendor_City (Text 50), Vendor_State (Text 2), Vendor_ZipCode (Text, 10 - set Input Mask to zip plus 4 showing the dash between zip and the 4. Each item in the Items table must have a corresponding vendor record in the Vendors table. You will add at least 10 records of your creation to populate this data. All values are fictional. Make Vendor_ID the primary key. Create a relationship between Vendor_ID of the Vendor table and the Vendor_ID of the Item table in which you enforce referential integrity. Create a third table named `Sales` to record line-by-line sales. Required fields for this table include the following and you may add other fields if you wish: Sales_ID (data type AutoNumber), Sale_Date (data type Date/Time set Format to Short Date), Item_ID (Text, 25), Quantity (data type Number) You will add at least 10 records of your creation to populate this data. All values are fictional. Make Sales_ID the primary key. Create a relationship between Item_ID of the Sales table and the Item_ID of the Item table and enforce referential integrity. Every sale must use an item from the Items table. Create a query named `Sales_Query` with all fields from the Sales table, add in the Selling_Price field from the Items table, and build a calculated field to multiple the quantity field from the Sales table by the Selling_Price field from the Items table Name this calculated field as Charge. Be sure your relationships and data are in place first. With the Sales_Query query highlighted in the Navigation Panel, click on the basic Report builder button to create an instant report. Change the report title to Sales Report and save the report as Sales_Report.
    User_624 | Feb 25, 2013, 05:08 AM
  • I can deliver it today within 2 hours max., but it would be better if you set the deadline.
    ScholarPro | Feb 25, 2013, 05:14 AM
  • If I could get it within three hours that would be perfect. I would like to accept the bid. Thank you.I will definitely leave you feedback as well. I have a rubric as well but can not attach it here. I think I can once I assign the assignment to you though.
    User_624 | Feb 25, 2013, 05:19 AM
  • I have already started creating the first table according to the instructions. I will send you within 3 hours max. then.. Thank you
    ScholarPro | Feb 25, 2013, 05:21 AM
  • Wonderful, thank you again. I added the rubric to the instructions.
    User_624 | Feb 25, 2013, 05:25 AM
  • Hi, I just completed your database, and checked the rubric once over again. It is 100% accurate, meeting the all requirements of the assignment as per the rubric you have sent. However, this website does not allow me to upload an Access file. Therefore, I need your email address in order you send you the file.
    ScholarPro | Feb 25, 2013, 06:39 AM
  • Just found another way to send you the file. Here's the link: https://dl.dropbox.com/u/78538175/kselli.accdb Best regards
    ScholarPro | Feb 25, 2013, 06:42 AM
  • Thank you, it looks good from what I can tell. I have submitted it and will release the funds as soon as I get feedback from my instructor. This should only take a couple of days.
    User_624 | Feb 25, 2013, 10:14 AM
  • I should admit that I find this way of working pretty unfair, but if you say so, let's do so. Please let me know when you get a feedback
    ScholarPro | Feb 26, 2013, 11:10 AM
  • I am not trying to be unfair. I have only used this service one other time and the work was only half way complete which caused me to fail the requirements for the assignment. Since I had to have a certain grade on that assignment I failed the class. I do not want any issues with it so I am trying to make sure it is correct before releasing funds. I appreciate your help and will go ahead and release the funds but I am not leaving feedback until I receive it back from my instructor. Again, I am not trying to be unfair. I am just being cautious.
    User_624 | Feb 26, 2013, 11:30 AM
  • Thanks for the reply. Totally understand.. The reason why I think so is that I am just confident with my work, as I cross checked versus the rubric. Again I understand your situation, and waiting for your positive feedback. You may release the funds afterwards..
    ScholarPro | Feb 26, 2013, 13:02 PM
  • Thank you for understanding. You have every reason to be confident in your work, you did great. I have left feedback and released the funds. Thank you again.
    User_624 | Jan 03, 2013, 10:07 AM
  • Just got it, no problem, thanks a lot :)
    ScholarPro | Jan 03, 2013, 10:11 AM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}