+
Your Office - Access Workshop 5: Homework Project 1 Managing Inventory at Cem’s Sporting Goods

Your Office - Access Workshop 5: Homework Project 1 Managing Inventory at Cem’s Sporting Goods

Rating:
Rating
(0)
Author: matthew stock
Description:

http://homework.plus/your-office-access-workshop-5-homework-project-1-managing-inventory-at-cems-sporting-goods/

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 nameda03ws05_grader_h1.accdb. Save the file with the namea03ws05SportingGoods_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. Enter Maurice Sporting Goods as the company name. Enter1910 Techny Road as the address. Enter Northbrook as the city. Enter il as the state. Enter 60065 as the ZIP code. Enter800-477-3474 as the phone number. Enter 847-715-1418 as the fax. Enter www.maurice.net as the URL. 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. Make the data in this field required.

(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial