About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:

Accounting,Algebra See all

Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all

Teaching Since:	Jul 2017
Last Sign in:	305 Weeks Ago
Questions Answered:	15833
Tutorials Posted:	15827

Education

MBA,PHD, Juris Doctor
Strayer,Devery,Harvard University
Mar-1995 - Mar-2002

Experience

Manager Planning
WalMart
Mar-2001 - Feb-2009

Category > Computer Science Posted 08 Jan 2018 My Price 10.00

Cem’s Sporting Goods has been in business for over a decade

Can you help with this

YO16_AC_CH05_GRADER_PS2_AS - Managing Inventory at Cem’s Sporting Goods

Project Description:

Cem’s Sporting Goods has been in business for over a decade. Cem, the owner, has realized the importance of using technology to manage his inventory, and he has created a database to help him do so. Unfortunately, he does not know enough about database design to create tables that help control the way data is entered. Thus, he has only entered a small amount of data. You have been asked to modify the tables to ensure ease of use and functionality so he can begin using the database.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step	Instructions	Points Possible
1	Start Access. Open the downloaded Access file named a03ws05_grader_a1.accdb. Save the file with the name a03ws05SportingGoods_LastFirst replacing LastFirst with your name. Enable the content if necessary.	0
2	Open tblSupplier in Design view, and then make the following modifications. • SupplierID: Create a custom format so the supplier ID is displayed as ID-001, ID-002, and so on. • CompanyName: Change the caption to Company Name.	6
3	Make the following modifications to the tblSupplier table. • State: Create a custom format so the state name is displayed in uppercase. Change the field size to only allow two characters. • ZipCode: Create an input mask for ZipCode that appears in the format 15044-1234. Change the field size to only allow 10 characters. Change the caption to Zip Code.	6
4	Continue to make the following modifications to the tblSupplier table. • Phone: Create an input mask using the Phone format. The phone number should appear in the format (555) 555-1234. Access should store the symbols in the mask and use an underscore as a placeholder. Change the field size to only allow 14 characters. • Fax: Create an input mask using the Phone format. The fax number should appear in the format (555) 555-1234. Access should store the symbols in the mask and use an underscore as a placeholder. Change the field size to only allow 14 characters. • Add a new field named URL. Select Hyperlink as the data type, and then enter This is the website home page as the Description.	10
5	Save your changes and switch to Datasheet view. Enter the following record to ensure your field settings are correct. Company Name: Maurice Sporting Goods Address: 1910 Techny Road City: Northbrook State: il ZipCode: 60065 Phone: 8004773474 Fax: 8477151418 URL: www.maurice.net Close tblSupplier.	6
6	Make the following modifications to the tblInventory table. • ItemName: Change the caption to Item. • Supplier: Use the Lookup Wizard to create a lookup field that looks up the CompanyName in the tblSupplier table. Sort the company names in Ascending order. Keep the key column hidden. Enable Data Integrity and Restrict Delete.	10
7	Continue to make the following modifications to the tblInventory table. • QuantityOnHand: Add a validation rule that requires all data entries to be greater than or equal to zero. Enter the following if a user accidently enters a negative number: Values must be greater than or equal to zero. Please reenter the quantity on hand. Make the data in this field required. Change the caption to Qty on Hand. • Discontinued: Change the field to the Yes/No data type.	10
8	Switch to Datasheet view, and then enter the following data in record 1 to ensure your field settings are correct. • Supplier: DollarDays International, Inc. • QuantityOnHand: Change to –1 to see if the validation rule works. Change back to 2 once verified. • Discontinued: Yes	6
9	Filter the data using an advanced filter to display all items that have Qty on Hand greater than or equal to 3. Save the filter as a query named qry3orMore.	10
10	Make the following modifications to the tblOrder table. • TransID: Change the data type to AutoNumber. Create a custom format so the TransID is displayed as TID-A01, TID-A02, and so on. • Item: Create a lookup field that looks up the ItemName and Description in the tblInventory table. Sort the item names in Ascending order. Keep the key column hidden. Enable Data Integrity and restrict related records from being deleted.	10
11	Continue to make the following modifications to the tblOrder table. • TransactionType: Create a lookup field that looks up values that you enter. Enter the following options: Row 1: Check; Row 2: Credit; Row 3: Pay On Delivery. Limit selections to the list, and then do not permit multiple values to be selected. Change the caption to Transaction Type. • Quantity: Add 1 as the default value.	10
12	Continue to make the following modifications to the tblOrder table. • OrderDate: Change the caption to Order Date. Format the field as Medium Date. • Create a multiple-field index on the Item, Quantity, and OrderDate fields. Enter OrderDetails as the name. Sort Item, Quantity, and OrderDate in Ascending order. Select No for the Primary, Unique, and Ignore Nulls properties.	10
13	Save your changes and switch to Datasheet view. Enter the following record to ensure your field settings are correct: Item: Pro Racer Goggles Transaction Type: Check Quantity: Keep the default Order Date: 6/8/2018	6
14	Close all database objects. Close the database and then exit Access. Submit the database as directed.	0
	Total Points	100

Attachments:

1515413080-grader5.docx

Answers

SophiaPretty

(5)

Status NEW Posted 08 Jan 2018 11:01 AM My Price 10.00

----------- ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

Buy Answer

Hire Dedicated Virtual Team / Business Solution for SMEs.