Reference no: EM13869122
Access Assignment - BoarDome Database
Problem: BoarDome is in the business of producing skate, surf and snow boards. They run a small museum and gift shop, located in airports in cities where the extreme sports are big. The gift shop purchases products from vendors for products and merchandise with the company name on them. The director of the gift shop has asked you to create and update a database that employees can use. The database consists of two tables; The Product table contains information on items available for sale. The Vendor table contains information on the vendors.
Objectives of the Assignment:
Using Microsoft Access:
1. Create a new database in which to store all the objects related to the gift shop system data.
2. Create tables and an input form
3. Populate the tables using data supplied
4. Perform file maintenance to tables
5. Generate a report utilizing the data
Instructions: Perform the following tasks.
1. Create a new database called BoarDome Gift shop Database.
2. Create a Product Table using the structure shown below. Use the nameProduct for the table name and save it with a File name = Product - Your Name.
|
Field Name
|
Data Type
|
Field Size
|
Description
|
|
Product Id
|
Text
|
4
|
User Id Number, Primary key, Yes (No Duplicates)
|
|
Description
|
Text
|
25
|
Description of the Product
|
|
On Hand
|
Number
|
Long Integer
|
Number of Units On Hand
|
|
Cost
|
Currency
|
|
Cost of Product
|
|
Selling Price
|
Currency
|
|
Selling Price of Product
|
|
Vendor Code
|
Text
|
2
|
Code of Product Vendor, Yes (Duplicates OK)
|
3. Add the data shown below to the Product Table.
|
Product Id
|
Description
|
On Hand
|
Cost
|
Selling Price
|
Vendor Code
|
|
CH04
|
hoodies
|
11
|
$26.75
|
$28.90
|
WW
|
|
DI24
|
lanyards
|
14
|
$3.75
|
$4.95
|
MS
|
|
GL18
|
hats
|
2
|
$27.50
|
$29.95
|
MS
|
|
JG01
|
glasses
|
3
|
$5.40
|
$6.95
|
MS
|
|
PC03
|
mugs
|
5
|
$8.50
|
$10.95
|
WW
|
|
ST23
|
Stationery
|
8
|
$3.95
|
$5.00
|
AR
|
|
TD05
|
t-shirts
|
6
|
$13.75
|
$15.95
|
WW
|
|
WI10
|
shorts
|
10
|
$7.50
|
$9.95
|
MS
|
|
WL34
|
Can holders
|
15
|
$2.50
|
$2.95
|
AR
|
|
YO12
|
stickers
|
9
|
$1.60
|
$1.95
|
WW
|
4. Create a Vendor Table using the structure shown below. Use the nameVendor for the table and save it with a File name = Vendor - Your Name.
|
Field Name
|
Data Type
|
Field Size
|
Description
|
|
Vendor Code
|
Text
|
2
|
Vendor Code (Primary Key), Yes (No Duplicates)
|
|
Name
|
Text
|
20
|
Name of Vendor
|
|
Address
|
Text
|
15
|
Street Address
|
|
City
|
Text
|
15
|
City
|
|
State
|
Text
|
2
|
State (Two-Character Version)
|
|
Zip Code
|
Text
|
5
|
Zip Code (Five-Character Version)
|
|
Telephone Number
|
Text
|
20
|
Telephone Number (999-999-9999 Version
Note: Use the Phone NumberInput Mask format
|
5. Add the data shown below to the Vendor Table.
| Vendor Code |
Name |
Address |
City |
State |
Zip Code |
| AR |
Artisan's printer |
3540 Grand |
Hancock |
WI |
69780 |
| MS |
Tshirts 4less |
134 Union |
Delana |
SD |
41345 |
| WW |
glassworks |
655 Clive |
Great Falls |
WV |
34567 |
6. Create a form for the Product Table. Use AutoForm Wizard to create your form. Save the form as "Product - Your Name".
7. Use the form you created to add the following two new products to the Product Table.
|
Product Id
|
Description
|
On Hand
|
Cost
|
Selling Price
|
Vendor Code
|
|
CH08
|
Key Chains
|
12
|
$20.00
|
$25.00
|
AR
|
|
PS30
|
Posters
|
20
|
$3.50
|
$4.50
|
MS
|
8. Create a report. Report should contain the following elements: Product ID,Description, On Hand, and Cost.
· Use Report Wizard to create the report
· Sort Order for your records = On Hand (Descending Order)
· Layout = Tabular; Orientation = Portrait; Style = Concourse or any other style
· Title = Inventory Report - Your Name.
Output Requirements:
· Save to your folder on the your pdrive or hard drive:
1. Created database entitled, BoarDome Gift shop Database One.
2. Two created tables entitled, Product and Vendor
3. One created form entitled, Product
4. One created Report entitled, Inventory Report.
|
Discuss the causes of water shortages
: Discuss the causes of water shortages
|
|
Efforts to practice corporate social responsibility
: Is it ethical for companies to benefit from their efforts to practice corporate social responsibility? Why or why not? How can anyone be sure that CSR efforts aren’t just public relations ploys?
|
|
Explain the permitting system instituted by rcra
: Explain the permitting system instituted by RCRA
|
|
Company use licensing agreements to enter world markets
: How can a company use licensing agreements to enter world markets? What two fundamental product strategies do companies choose between when selling their products in the global marketplace?
|
|
Create a new database in which to store all the objects
: Problem: BoarDome is in the business of producing skate, surf and snow boards. They run a small museum and gift shop, located in airports in cities where the extreme sports are big. Create a new database in which to store all the objects r..
|
|
How the law of demand affected your purchase
: Think about a product that you have purchased recently (e.g. soda, diapers, takeout meals, milk, shoes, manicure/pedicure, video game, etc.). Explain how the law of demand affected your purchase. Give specific examples of how the determinants of dema..
|
|
Calculate gdp using the product approach
: Consider an economy with a corn producer, some consumers, and a government. In a given year, the corn producer grows 30 million bushels of corn ad the market price for corn is $5 per bushel. Calculate GDP using i) the product approach, ii) the expend..
|
|
Find simproniuss maximum willingness to pay for insurance
: If Sempronius’ utility function is v(x) = 5((x)^(1/2)) + 99, he has exactly the same certainty equivalent and risk premium as above, with utility function u(x) = (x)^(1/2). Calculate Sempronius’s risk premium for v(x) =(x)^(1/4). Suppose Sempronius c..
|
|
Declares all unpaid taxes to be delinquent and sends
: Declares all unpaid taxes to be delinquent and sends notices to delinquent taxpayers that they aowe a 4 percent penalty. Snake River accounting policy calls for accruing the penalty at the time taxes are declared delinquent.
|