Order Number |
636738393092 |
Type of Project |
ESSAY |
Writer Level |
PHD VERIFIED |
Format |
APA |
Academic Sources |
10 |
Page Count |
3-12 PAGES |
The purpose of this project is to create a home inventory database that can be referred to in
case of damage, theft, or natural disaster. You’ll assume the role of homeowner, who over time
has acquired many valuable assets. You would like to more easily manage purchase history,
product serial and model numbers, warranties, and appraisal information. For this project, you
must create an Access database with forms, queries, and reports that you’ll store off site in case
of emergency.
Note: If you have more than 10 attachments, you’ll need to WinZip all of the project’s
associated files along with all documentation using the WinZip software program.
Instructions
Create a Database
1. Start Access and create a Blank database, naming it “Inventory.”
2. On the Home tab, select View and then go to Design.
3. When prompted, name the new table “Inventory.”
4. In Design view, change the field name ‘ID’ to ‘Item ID’ and verify that it’s data type
AutoNumber and has been selected as the primary key.
5. In Design view, add the remaining fields and corresponding data types:
Field Name Data Type Description Item Name Short Text Category Short Text Appliances, Electronics, Jewelry,
Other Manufacturer Short Text Model Short Text Serial Number Short Text Purchase Date Date/Time (Short Date) Purchase Price Currency Merchant ID Number Online Purchase Yes/No Credit Card Purchase Yes/No Warranty Type Short Text Store, Manufacturer, Other Warranty Length Short Text Repair Yes/No Repair Date Date/Time (Short Date) Comments Short Text
6. Save and then close the Inventory table.
7. Create a second table in Design view. Name the table “Merchants.”
8. Add the following fields and corresponding data types. Be sure Merchant ID is the
primary key:
Field Name Data Type Description Merchant ID AutoNumber Merchant Name Short Text Address Short Text City Short Text State Short Text Zip Short Text Email Hyperlink Website Hyperlink Telephone Short Text (Phone number input
mask).
Fax Short Text
9. Save and then close the Merchants table.
10. Create a relationship by linking the Merchant ID in the Inventory table to the Merchant
ID in the Merchants table. Be sure to enforce referential integrity.
Create Forms and Populate the Database
11. Create a Merchants form.
12. Create an Inventory form, with the purchase price as $0.00.
13. Use the Merchants form to populate the appropriate sections in the Merchants table
with the records listed below.
Merchant Records Merchant ID 1 Merchant Name Electronics Mart Address 65 Resister Ave. City Blankston State PA Zip 18454 Email emart@blanknet.com Website www.emart.com Telephone (570) 555-1111 Fax (570) 555-1112 Merchant ID 2 Merchant Name Appliances Inc. Address 2020 Mechanics Road City Blankston
mailto:emart@blanknet.com
State PA Zip 18454 Email n/a Website n/a Telephone (570) 555-1234 Fax (none) Merchant ID 3 Merchant Name Stuff Mart Address 721 Frengburg St. City Shopville State NY Zip 10022 Email custserv@stuffmart.com Website www.stuffmart.com Telephone (212) 555-5432 Fax n/a Merchant ID 4 Merchant Name Phones and More Address 21 Framer Circle City Klossville State PA Zip 19019 Email callus@phonesandmore.com Website www.phonesandmore.com Telephone (612) 555-9876 Fax n/a Merchant ID 5 Merchant Name Jewelry Warehouse Address 24 Karat Street City Platoid State NY Zip 00050 Email info@jewelware.com Website www.jewelware.com Telephone (609) 555-3344 Fax (609) 555-3345 Merchant ID 6 Merchant Name Crazy John’s Computers Address 456 Enterprise St. City Wynnsville State CO Zip 18888 Email crazy@merchandizing.net Website www.merchandizing.net/crazy Telephone (301) 555-9080 Fax n/a Merchant ID 7 Merchant Name Collector’s Emporium Address 256 Antiques Ave.
mailto:custserv@stuffmart.com
mailto:callus@phonesandmore.com
mailto:info@jewelware.com
mailto:crazy@merchandizing.net
City Oldensurg State PA Zip 18999 Email findit@collectibles.net Website www.collectibles.net Telephone (570) 555-1608 Fax (570) 555-1609
14. Use the Inventory form to populate the appropriate sections in the Inventory table with
the records listed below.
Inventory Records Item ID 1 Item Name GameBox Category Electronics Manufacturer Super Model GB928 Serial Number R729-382 Purchase Date 2/1/2020 Purchase Price $599.00 Merchant ID 1 Online Purchase No Credit Card Purchase Yes Warranty Type Manufacturer Warranty Length 2 years, parts only Repair No Repair Date (none) Comments packaged with one free game control Item ID 2 Item Name Smart TV Category Electronics Manufacturer Super Model 4200 Serial Number 1930456 Purchase Date 2/20/2020 Purchase Price $499.00 Merchant ID 1 Online Purchase No Credit Card Purchase Yes Warranty Type Manufacturer Warranty Length 90 days, parts only Repair No Repair Date (none) Comments (none) Item ID 3 Item Name Laptop Category Electronics Manufacturer Deluxe Model SuperFast Serial Number 879603-109-345
mailto:findit@collectibles.net
Purchase Date 2/27/2020 Purchase Price $899.00 Merchant ID 3 Online Purchase No Credit Card Purchase Yes Warranty Type Manufacturer Warranty Length 1 year, parts and labor Repair Yes Repair Date 6/1/2020 Comments keyboard replaced Item ID 4 Item Name Bluetooth Headset Category Electronics Manufacturer Wireless Model BT54910 Serial Number 345-896-000 Purchase Date 2/22/2020 Purchase Price $99.00 Merchant ID 4 Online Purchase Yes Credit Card Purchase Yes Warranty Type Manufacturer Warranty Length 12 months, parts only Repair No Repair Date (none) Comments (none) Item ID 5
Item Name Ink Jet Printer
Category Electronics
Manufacturer Pro
Model U750
Serial Number 555639870
Purchase Date 1/15/2020
Purchase Price $49.00
Merchant ID 6
Online Purchase Yes
Credit Card Purchase Yes
Warranty Type Manufacturer
Warranty Length 90 days, parts and tech support
Repair No
Repair Date (none)
Comments (none)
Item ID 6
Item Name Refrigerator
Category Appliances
Manufacturer Wonderlux
Model Ice Age 2000
Serial Number 2567590
Purchase Date 4/5/2020
Purchase Price $999.00
Merchant ID 2
Online Purchase No
Credit Card Purchase Yes
Warranty Type Manufacturer/store
Warranty Length 2 years, parts and labor/5 years, refrigeration parts
RUBRIC | |||
Excellent Quality
95-100%
|
Introduction
45-41 points The context and relevance of the issue, as well as a clear description of the study aim, are presented. The history of searches is discussed. |
Literature Support
91-84 points The context and relevance of the issue, as well as a clear description of the study aim, are presented. The history of searches is discussed. |
Methodology
58-53 points With titles for each slide as well as bulleted sections to group relevant information as required, the content is well-organized. Excellent use of typeface, color, images, effects, and so on to improve readability and presenting content. The minimum length criterion of 10 slides/pages is reached. |
Average Score
50-85% |
40-38 points
More depth/information is required for the context and importance, otherwise the study detail will be unclear. There is no search history information supplied. |
83-76 points
There is a review of important theoretical literature, however there is limited integration of research into problem-related ideas. The review is just partly focused and arranged. There is research that both supports and opposes. A summary of the material given is provided. The conclusion may or may not include a biblical integration. |
52-49 points
The content is somewhat ordered, but there is no discernible organization. The use of typeface, color, graphics, effects, and so on may sometimes distract from the presenting substance. It is possible that the length criteria will not be reached. |
Poor Quality
0-45% |
37-1 points
The context and/or importance are lacking. There is no search history information supplied. |
75-1 points
There has been an examination of relevant theoretical literature, but still no research concerning problem-related concepts has been synthesized. The review is just somewhat focused and organized. The provided overview of content does not include any supporting or opposing research. The conclusion has no scriptural references. |
48-1 points
There is no logical or apparent organizational structure. There is no discernible logical sequence. The use of typeface, color, graphics, effects, and so on often detracts from the presenting substance. It is possible that the length criteria will not be reached. |
Place the Order Here: https://standardwriter.com/orders/ordernow / https://standardwriter.com/