Note: In case if your problem statement is updated, please donot hesitate us and send it to us at [email protected] We would surely like to help you in this regard.
Unit 5 – Database Management Systems
Reading Assignment: Textbook Reading: Murach – Chs. 16 – 17
Assignment Type: Individual Project Deliverable Length: Zip Folder (contains Access Database)
Chris and Pat Aquino own a successful ISP (Internet Service Provider) and want to expand their business to host an Internet auction site. The auction site will let sellers offer items for sale, such as antiques, first-edition books, vintage dolls, coins, art, stamps, glass bottles, autographs, and sports memorabilia.
After a seller posts an item for sale, it is sold at the auction site by accepting bids from buyers. Before people can sell items and bid on items, they must register with the auction site. Each item will be listed by subcategory within a general category, making it easy for bidders to find items of interest to them. For example, the general category of antiques might consist of several subcategories, including ancient world, musical instruments, and general.
Chris and Pat have registered their Web site name of each, which stands for electronic Auction Collectibles Host. Now they need to create a database that keeps track of the registered people, the items for sale, and the bids received for those items by the Web site.
Chris and Pat Aquino want you to begin creation of a secure, yet user-friendly interface for the BuySell database. They ask you to create the layout for the BuySell database by completing the following:
Assignment Guidelines:
1. Start Access, and then open the BuySell database located in the LE5 folder extracted from the zip file in IP4.
2. Follow these steps below and as a guide for a switchboard form preparation.
• Click on the create tab and then create a separate macro for the for actions below.
• Open the table Subcategory
• Open the form Item
• Open the form Registrant
• Open the Report Projected Income Based on Minimum Bid report in the Print Preview
1. Create a new form and name it Background.
2. Set the background color for the form to a color of your choice.
3. Set the database password to password.
4. Set the startup options to hide the Database window, restrict menus, eliminate the built-in toolbars, and open the Background form whenever you open the BuySell database.
5. Test the database password and startup options
6. Exit Access.
7. Save the file under the name U5A1LastName.accdb and then zip the file.
Kindly submit only U5A1LastName.accdb file
* If you have any issues with the payment method, please let us know at [email protected] and that can be discussed and considered.
* Your paypal has to be pre-loaded in order to complete the purchase or otherwise please discuss it with us at [email protected].
* As soon as the payment is received through PayPal, download link of the solution will automatically be sent to the address used in Paypal.
* Please check your junk mails as the download link email might go there.
* All the contents are compressed in one zip folder.
* In case if you get stuck at any point during the payment process, please immediately contact us at [email protected] and we will fix it with you.
* We try our best to reach back to you on immediate basis. However, please expect to get a response within 8 hours from our side.
* Comments/Feedbacks are truely welcomed and there might be some incentives for you for the next lab/quiz/assignment.
* In case of any query, please donot hesitate to contact us at [email protected].
******************************************** Good Luck ***************************************************
Any personal information received will only be used to fill your order. We will not sell or redistribute your information to anyone.
We will try our best to resolve the issue and if still persists we can discuss for a refund in case its required.
Note: In case if your problem statement is updated, please donot hesitate us and send it to us at [email protected] We would surely like to help you in this regard.