Details of this Paper

create_and_save_a_new_blank_database_called_inventory

Description

solution


Question

;;Create and save a new blank database called Inventory.accdb;as shown in. Then, use the following steps to work;with your database;? Create the table ?Inventory? in Design View with the;following data fields;1. Item Number (auto-generated) (Figure 2);2. Item Name (such as computer or washing machine);3. Item Category (such as Appliances or Electronics);4. Item Manufacturer;5. Item Model Number;6. Item Serial Number;7. Purchase Date;8. Purchase Price;9. Merchant ID;10. Online/Mail Order (Yes/No);11. Credit Card Purchase (Yes/No);12. Warranty Type (store, manufacturer, both);13. Warranty Length;14. Repair (Yes/No);15. Repair Date;16. Comments;? Set the Item Number field as the primary key;? Create a new form using the Form Wizard. The form is;based upon the Inventory table, titled ?Inventory.? Use;all the fields from the Inventory table. The form should;possess the Columnar layout.;? Input the inventory information listed at the end of this;booklet into your database. Use the current year for;dates marked 20XX.;? Create the table ?Merchants? with the following data;fields;1. Merchant ID;2. Merchant Name;3. Merchant Address;4. Merchant City;5. Merchant State;6. Merchant ZIP;7. Merchant E-Mail;8. Merchant URL;9. Merchant Phone;10. Merchant Fax;? Set the Merchant ID field as the primary key.;? Create a new form using the Form Wizard and based;upon the Merchants table, titled ?Merchants.? Use all;the fields from the Merchants table. The form should;possess the Columnar layout.;? Input the merchant information listed at the end of this;booklet into your database.;After you?ve entered all the information into your database;tables, save the Inventory.accdb;Create a simple query on the Inventory table (Figure 4). The;query should include data entries only for items that have;been repaired. Include the following fields;1. Item Number;2. Item Name;3. Item Category;4. Item Manufacturer;5. Purchase Date;6. Warranty Type;7. Warranty Length;8. Repair;9. Repair Date;10. Comments;The data within the query should be sorted alphabetically by;Item Category. Save the query as Repaired Items.;Based on the data contained in the query Repaired Items;create a report with the Report Wizard using all the fields from;the query. No grouping levels are required in this report. Sort;in ascending order by Item Name (Figure 5). The report;should have the following format;? Columnar layout;? Portrait orientation;Title the report Repaired Items List. Make sure all of the;fields show clearly in the report, including the field titles.;After you?ve completed the simple query and report, resave;the Inventory.accdb;Create a multiple-table query on the Inventory and Merchants;tables. To create this query, you must establish a relationship;between the two tables (Figure 6). The common field between;the tables is Merchant ID. Both fields should be set to text in;their respective tables. Now you may begin to build your;query. Include the following fields from the Inventory table;1. Item Name;2. Item Category;3. Item Manufacturer;4. Purchase Date;Include the following fields from the Merchants table;1. Merchant Name;2. Merchant Address;3. Merchant City;4. Merchant State;5. Merchant ZIP;The data within the query should be sorted alphabetically by;Merchant Name. Set the criteria cell for the Item Category;field to search for ?Appliances.? Save the query as Appliance;Store Purchases.;Based on the data contained in the Appliance Store;Purchases query, create a report with the Report Wizard;using the following fields from the query (Figure 7);1. Item Name;2. Item Category;3. Item Manufacturer;4. Purchase Date;5. Merchant Name;6. Merchant Address;7. Merchant City;8. Merchant State;9. Merchant ZIP;View the data by Merchants. No grouping levels are required;in this report. Sort detail records in ascending order by;Purchase Date. Format the report as follows;? Stepped;? Landscape orientation;Title the report Appliance Store Purchases List. Make sure all;the fields show clearly in the report, including the field titles;After you?ve completed the multiple-table query and report;resave the Inventory.accdb;Use the information listed below to create the Inventory database.;Item Number 1;Item Name: VCR;Item Category: Electronics;Item Manufacturer: Super;Item Model Number: VCR2000;Item Serial Number: 1001001001;Purchase Date: 02/01/20XX;Purchase Price: $199.95;Merchant ID: 1;Online/Mail Order: No;Credit Card Purchase: Yes;Warranty Type: Manufacturer;Warranty Length: 60 days parts/labor;Repair: No;Repair Date: (none);Comments: (none);Item Number: 2;Item Name: Television;Item Category: Electronics;Item Manufacturer: Telecom;Item Model Number: TV100;Item Serial Number: 001001001;Purchase Date: 02/14/20XX;Purchase Price: $299.95;Merchant ID: 1;Online/Mail Order: No;Credit Card Purchase: Yes;Warranty Type: Manufacturer;Warranty Length: 90 days parts/labor;Repair: Yes;Repair Date: 09/01/20XX;Comments: Remove candy from;Controls;Item Number: 3;Item Name: Personal Computer;Item Category: Computers;Item Manufacturer: Deluxe;Item Model Number: PC1000;Item Serial Number: 100200100;Purchase Date: 02/01/20XX;Purchase Price: $1,299.95;Merchant ID: 6;Online/Mail Order: Yes;Credit Card Purchase: Yes;Warranty Type: Manufacturer;Warranty Length: 1 year parts/labor/tech;support;Repair: No;Repair Date: (none);Comments: (none);Item Number: 4

 

Paper#71859 | Written in 18-Jul-2015

Price : $57
SiteLock