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:	304 Weeks Ago, 3 Days 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

realized the importance of using technology to manage

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

YO16_AC_CH06_GRADER_PS2_AS - Vegas Tours Souvenir Shop Database

Project Description:

The Vegas Tours Souvenir Shop is where Las Vegas bus tours start and end, seven days a week. The shop sells a variety of Vegas souvenirs to customers who take the tour and to those who simply want to purchase souvenirs. Management has been using an Access database to keep track of customers, products, and transactions. You have been given some sample sales data from February 2018. Management has asked you to create some queries to begin the process of analyzing the data that has been collected.

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 a03ch06_grader_a1_VegasTours.accdb. Save the file with the name a03ch06_grader_a1_VegasTours_LastFirst, replacing LastFirst with your name. Enable the content, if necessary.	0
2	Create a query based on the tblProduct table that will display the ProductID, ProductDescription, QuantityInStock, Cost, Size, and Color, in that order, for any product with shirt in the ProductDescription field.	10
3	Sort the results in Descending order by Cost. Only display the products with the top 25% of cost. Save the query as qryShirtInventory and then close the query.	7
4	Create a query using the tblCustomer table. Display CustomerID, FirstName, LastName, and a new calculated field named Coupon?, in that order. In the Coupon? field, use the IIf and Like functions to display No Coupon if the customer did not take the tour and Send 10% off next visit if the customer did take the tour.	12
5	Sort the results in Ascending order by LastName. Save the query as qryCouponList and then close the query.	5
6	Create a query based on the tblProduct table that will display the ProductID, ProductDescription, Category, QuantityInStock, Cost, Size, Color, and a new calculated field named Retail Price, in that order. In the Retail Price field, use the Round function to display the price that the store needs to sell its products. The retail price is two times the cost.	12
7	Format the retail price field as Currency. Save the query as qryRetailPrice and then close the query.	5
8	Create a query based on the tblCustomer table that will display the FirstName, LastName, Address, City, State, and ZipCode, in that order. In the LastName field, use a wildcard and the Like function to include customers whose last names begin with letters M through Z.	12
9	Sort the results in Ascending order by LastName. Save your query as qryMZCustomers and then close the query.	5
10	Create a query based on the tblCustomer and tblPurchase tables that will concatenate the member’s first and last names (separated by a space) followed by the date they made a purchase. Name the concatenated field Purchase Details. Use a comma to separate the full name and date, in that order. Save your query as qryPurchaseDetails and then close the query.	12
11	Create a query based on the tblPurchase and tblPurchaseLine tables that will display the PurchaseID, PurchaseDate, PurchaseLine, ProductID, and Quantity in that order to view all transactions that fall within a specific date range.	12
12	Add a parameter that allows you to enter a start and end date, using Enter start date and Enter end date as the prompts. Use 2/5/2018 as the start date and 2/8/2018 as the end date to test your query. Save your query as qryDateRange and then close the query.	8
13	Close all database objects. Close the database and then exit Access. Submit the database as directed.	0
	Total Points	100

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.