access volume 1 grader project inventory suppliers. please need HELP ASAP . DUE IN 12 HOURS acap1_in

  

access volume 1 grader project inventory suppliers. please need HELP ASAP . DUE IN 12 HOURS
acap1_inventory.xlsx

acap1_suppliers.xlsx

Don't use plagiarized sources. Get Your Custom Essay on
access volume 1 grader project inventory suppliers. please need HELP ASAP . DUE IN 12 HOURS acap1_in
Just from $13/Page
Order Essay

go16_ac_vol1_grader_cap_as_instructions.docx

go16_ac_vol1_grader_cap_as_instructions.docx

acap1_inventory.xlsx

acap1_inventory.xlsx

Unformatted Attachment Preview

Item ID
765589
114564
778952
772569
117895
796895
156899
456983
465894
793256
732568
465899
146553
989655
795622
756897
732589
145622
480782
145689
114568
146689
446275
Item Name
Beach Water
Bite Rite
Cargo
Cargo Lights
Celerater
Down Full Parka
Elite Jazz
E-motion
Fleece Hoodie
Fundamental Woven Stretch
Granite Divide
Gripper Gloves
K Face
Men’s High Top
Pedal Fast
Ski Gloves
Super Nova
Tie Breaker
Trail Sandals
Ultra Bibs
Vented Explorer
Women’s Snow Pants
XXT Trainer
Retail Price
$49.95
$89.95
$56.45
$43.95
$115.95
$229.95
$99.98
$44.95
$135.95
$45.65
$168.35
$25.55
$179.95
$98.46
$215.95
$29.99
$110.95
$69.55
$49.95
$130.89
$34.78
$85.65
$95.75
Category
Shoes
Shoes
Shorts
Shorts
Shoes
Jackets
Shorts
Shorts
Jackets
Shorts
Jackets
Socks and Gloves
Jackets
Shoes
Shoes
Socks and Gloves
Shoes
Tops and Tees
Shoes
Shorts
Hats
Pants
Shoes
Sport
Fitness
Biking
Biking
Biking
Hiking
Hiking
Biking
Fitness
Biking
Fitness
Skiing
Skiing
Hiking
Hiking
Biking
Skiing
Fitness
Fitness
Hiking
Biking
Hiking
Skiing
Hiking
Supplier ID
SUPP-03
SUPP-11
SUPP-09
SUPP-01
SUPP-01
SUPP-10
SUPP-07
SUPP-05
SUPP-09
SUPP-04
SUPP-06
SUPP-06
SUPP-02
SUPP-08
SUPP-05
SUPP-07
SUPP-03
SUPP-03
SUPP-08
SUPP-10
SUPP-04
SUPP-06
SUPP-11
Item ID
106555
106556
Item Name Retail Price Category Sport
Snowboard
256.99 Equipment Skiing
Wool Socks
Skiing
12.59 Socks and Gloves
Supplier ID
SUPP-06
SUPP-04
Supplier ID
SUPP-01
SUPP-02
SUPP-03
SUPP-04
SUPP-05
SUPP-06
SUPP-07
SUPP-08
SUPP-09
SUPP-10
SUPP-11
Company
Biking Supplies Inc
Boots Galore
Fitness City
Gear City
Rick’s Sporting Shop
Ski Country
Snow Gear Fitters
Specialty Shoes
Sports Fitters
Tree Country Outfitters
Winter Sports Club
Email Address
orders@bikingsupplies.com
orders@bootsgalore.com
orders@fitnesscity.biz
orders@gearcity.org
rick@ricksports.com
orders@skicountry.biz
orders@sgfitters.biz
orders@specshoes.com
info@sportfitters.com
info@treecountry.biz
info@wintersportsclub.biz
Phone
(800) 555-3788
(541) 555-1170
(505) 555-8765
(206) 555-8499
(757) 555-7139
(866) 555-2877
(248) 555-1000
(800) 555-5874
(800) 555-4084
(800) 555-3694
(800) 555-6781
Fax Number
(800) 555-3649
(541) 555-1175
(505) 555-8766
(206) 555-1284
(757) 555-1075
(866) 555-2880
(248) 555-1002
(800) 555-1374
(800) 555-7541
(800) 555-7194
(800) 555-6788
Address
7849 Pebble Ln
333 Windy Pines Ave
4786 Open Greens Dr
13 W 32nd St
4568 Atlantic Ave
582 Colinas Dr
8629 Mandolin Way
382 Hialeah Way
164 Chapel Rd
2304 S Westhaven Dr
211 Mountain View Rd
City
Boulder
Mountain View
Santa Fe
Seattle
Virginia Beach
Los Angeles
Gooseneck
Honolulu
Dayton
West Haven Valley
Boulder
State
CO
OR
NM
WA
VA
CA
MI
HI
OH
UT
CO
Postal Code
80302
97701
87506
98107
23451
90014
48071
96821
45404
84119
80304
Grader – Instructions
Access 2016 Project
GO16_AC_VOL1_GRADER_CAP_AS – Inventory Supplies
Project Description:
In this project, you will apply skills you practiced from the Objectives in Access Chapters 1 through 3. You will create a
database for Frank Osei, Vice President of Finance, that contains inventory and supplier information. In addition, you will
create queries that answer specific questions relating to the inventory items and suppliers, forms for entering and updating
information, and reports.
Steps to Perform:
Step
Points
Possible
Instructions
1
Start Access. Download, open, and save the database named
go_acc_grader_capstone_Inventory_Suppliers.accdb .
0
2
Open the Cap1 Inventory table in Design View. Rename the ID field to Item ID and change
the Data Type to Short Text. Continue adding the following fields as Short Text except for
Retail Price, which should have a Currency Data Type:
7
Item Name
Retail Price
Category
Sport
Supplier ID
3
Switch to Datasheet view. Enter the following two records into Cap1 Inventory:
5
Item ID: 106555
Item Name: Snowboard
Retail Price: 256.99
Category: Equipment
Sport: Skiing
Supplier ID: SUPP-06
Item ID: 106556
Item Name: Wool Socks
Retail Price: 12.59
Category: Socks and Gloves
Sport: Skiing
Supplier ID: SUPP-04
4
Close the table. Append a copy of the records from the downloaded aCap1_Inventory
workbook to the Cap1 Inventory table. Accept all defaults in the wizard and do not save the
Import steps. Open the table, verify there are 25 records, and apply Best Fit to all fields. Save
and close the table.
4
5
Import the source data from the downloaded aCap1_Suppliers workbook into a new table in
the current database. In the wizard, click the First Row Contains Column Headings option and
set the primary key to Supplier ID. Name the table Cap1 Suppliers.
6
6
Open the Cap1 Suppliers table in Design view. Delete the Fax Number field and save the
table. Switch to Datasheet view and apply Best Fit to all of the fields. Save and close the
table.
4
7
On the Navigation Pane, group the objects by Tables and Related Views.
2
Created On: 07/05/2019
1
GO16_AC_VOL1_GRADER_CAP_AS – Inventory Supplies
Grader – Instructions
Access 2016 Project
Points
Possible
Step
Instructions
8
Create a relationship between t he two tables in the database using Supplier ID as the
common field. Enforce Referential Integrity and select both Cascade options. One supplier can
supply many inventory items.
6
9
Create a relationship report. Save the report with Relationships as the name. Close the
Relationships window.
4
10
Create a query in Design view, using your Cap1 Inventory table to answer the question What
is the item name (in alphabetical order), retail price, and category for the sport of hiking? Add
the fields in that order. Do not display the Sport field in the que ry results. Run the query, save
it as Cap1 Hiking Query, then close the query. Seven records match the criteria.
6
11
Create a copy of Cap1 Hiking Query named Cap1 Hiking and Biking Shoes Query.
Redesign the query design to answer the question What is the sport, item name, retail price,
and supplier ID for the category of shoes where the sport is hiking or biking? Arrange the
fields in the order in which they’re mentioned in the question. Sort the records first in
ascending order by Sport and then in ascending order by Item Name. Do not display the
Category field in the query results, but display the Sport field. Run and then close the query.
Six records match the criteria.
8
12
Create a query in Design view, using both tables to answer the question What is the category,
8
item name, company, and phone number for a category that begins with the letter S for the
sport of fitness? Add the fields in that order. Sort the records first in ascending order by the
Category field and then in ascending order by the Item Name field. Do not display the Sport in
the query results. Run the query, save it as Cap1 Fitness S Category Query, and then
close it. Four records match the criteria.
13
Create a query in Design view, using the Cap1 Inventory table to answer the question For the
supplier ID of SUPP-06, for each item name and retail price, what is the markup for each item
if marked up 10%, and what is the final price? Add the fields in that order. Name the first
6
calculated field Markup and name the second calculated field Final Price. Run the query
and apply Best Fit to all of the fields. All numeric fields should be formatted as Currency, 2
Decimal Places. Save the query as Cap1 SUPP-06 Markup Query and close it.
14
Use the Query Wizard to create a crosstab query using the Cap1 Inventory table. Set the
Category field as the row headings, and set the Sport field as the column headings. Count the
Item ID field, name the query Cap1 Crosstab Query, and then finish the query. Run the
query and apply Best Fit to all of the fields. Save and close the query.
7
15
Create a query in Design view using the Cap1 Inventory table that prompts you to enter the
Sport, and then answers the question What is the sport, category, item name, and retail price
7
for inventory items, sorted first in ascending order by category and then in ascending order by
the item name? Add the fields in that order. The query should prompt an individual to Enter
the Sport. Run the query and type hiking when prompted for the criteria. Seven records
match the criteria. Save the query as Cap1 Parameter Query and close it.
Created On: 07/05/2019
2
GO16_AC_VOL1_GRADER_CAP_AS – Inventory Supplies
Grader – Instructions
Step
16
Access 2016 Project
Points
Possible
Instructions
Based on the Cap1 Suppliers table, use the Form tool to create a form. Switch to Form view
and use the form to add a new record as follows:
7
Supplier ID: SUPP-12
Company: Beach Water Sports Inc
Email Address: info@watersports.biz
Phone: (305) 555-6543
Address: 14 South Beach Rd
City: Miami
State: FL
Postal Code: 33125
Use the Filter By Form tool to create a filter that displays records with a State of CO or FL.
After verifying that three records match this criteria, toggle the filter to display all 12 records.
Save the form as Cap1 Supplier Form and close it.
17
Based on your Cap1 Suppliers table, use the Report tool to create a new report. Delete the
following fields from the report: Supplier ID, Address, City, State, and Postal Code. Clear the
Report Footer. Apply the Facet theme to this object only. Sort the Compan y field in ascending
order. For the Phone field, change the Width property to 1.25. For the Company field, change
the Left property to 1 and then close the Property Sheet. Save the report as Cap1 Suppliers
Report and then close the report.
5
18
Use the Report Wizard to create a report based on the Cap1 Inventory table. Add the
following fields to the report: Category, Item Name, and Retail Price, in that order. Group by
the Category field. Sort in ascending order by the Item Name field. Find the Average of the
Retail Price field. Be sure that the Layout is Stepped and that the Orientation is Portrait. For
the report title, type Cap1 Avg Price by Category Report and then switch to Layout view.
Delete the controls that begin with Summary for ‘Category.’ Under Item Name, click any text
box control and set the Width property to 2.75. Select the Retail Price column, including the
two controls that display the # symbols. Set the Width property to 1 and set the Left property
to 6. Save and close the report.
8
19
Close all database objects. Close the database and then exit Access. Submit the database as
directed.
0
Total Points
Created On: 07/05/2019
3
100
GO16_AC_VOL1_GRADER_CAP_AS – Inventory Supplies
Grader – Instructions
Access 2016 Project
GO16_AC_VOL1_GRADER_CAP_AS – Inventory Supplies
Project Description:
In this project, you will apply skills you practiced from the Objectives in Access Chapters 1 through 3. You will create a
database for Frank Osei, Vice President of Finance, that contains inventory and supplier information. In addition, you will
create queries that answer specific questions relating to the inventory items and suppliers, forms for entering and updating
information, and reports.
Steps to Perform:
Step
Points
Possible
Instructions
1
Start Access. Download, open, and save the database named
go_acc_grader_capstone_Inventory_Suppliers.accdb.
0
2
Open the Cap1 Inventory table in Design View. Rename the ID field to Item ID and change
the Data Type to Short Text. Continue adding the following fields as Short Text except for
Retail Price, which should have a Currency Data Type:
7
Item Name
Retail Price
Category
Sport
Supplier ID
3
Switch to Datasheet view. Enter the following two records into Cap1 Inventory:
5
Item ID: 106555
Item Name: Snowboard
Retail Price: 256.99
Category: Equipment
Sport: Skiing
Supplier ID: SUPP-06
Item ID: 106556
Item Name: Wool Socks
Retail Price: 12.59
Category: Socks and Gloves
Sport: Skiing
Supplier ID: SUPP-04
4
Close the table. Append a copy of the records from the downloaded aCap1_Inventory
workbook to the Cap1 Inventory table. Accept all defaults in the wizard and do not save the
Import steps. Open the table, verify there are 25 records, and apply Best Fit to all fields. Save
and close the table.
4
5
Import the source data from the downloaded aCap1_Suppliers workbook into a new table in
the current database. In the wizard, click the First Row Contains Column Headings option and
set the primary key to Supplier ID. Name the table Cap1 Suppliers.
6
6
Open the Cap1 Suppliers table in Design view. Delete the Fax Number field and save the
table. Switch to Datasheet view and apply Best Fit to all of the fields. Save and close the
table.
4
7
On the Navigation Pane, group the objects by Tables and Related Views.
2
Created On: 07/05/2019
1
GO16_AC_VOL1_GRADER_CAP_AS – Inventory Supplies
Grader – Instructions
Access 2016 Project
Points
Possible
Step
Instructions
8
Create a relationship between the two tables in the database using Supplier ID as the
common field. Enforce Referential Integrity and select both Cascade options. One supplier can
supply many inventory items.
6
9
Create a relationship report. Save the report with Relationships as the name. Close the
Relationships window.
4
10
Create a query in Design view, using your Cap1 Inventory table to answer the question What
is the item name (in alphabetical order), retail price, and category for the sport of hiking? Add
the fields in that order. Do not display the Sport field in the query results. Run the query, save
it as Cap1 Hiking Query, then close the query. Seven records match the criteria.
6
11
Create a copy of Cap1 Hiking Query named Cap1 Hiking and Biking Shoes Query.
Redesign the query design to answer the question What is the sport, item name, retail price,
and supplier ID for the category of shoes where the sport is hiking or biking? Arrange the
fields in the order in which they’re mentioned in the question. Sort the records first in
ascending order by Sport and then in ascending order by Item Name. Do not display the
Category field in the query results, but display the Sport field. Run and then close the query.
Six records match the criteria.
8
12
Create a query in Design view, using both tables to answer the question What is the category,
8
item name, company, and phone number for a category that begins with the letter S for the
sport of fitness? Add the fields in that order. Sort the records first in ascending order by the
Category field and then in ascending order by the Item Name field. Do not display the Sport in
the query results. Run the query, save it as Cap1 Fitness S Category Query, and then
close it. Four records match the criteria.
13
Create a query in Design view, using the Cap1 Inventory table to answer the question For the
supplier ID of SUPP-06, for each item name and retail price, what is the markup for each item
if marked up 10%, and what is the final price? Add the fields in that order. Name the first
6
calculated field Markup and name the second calculated field Final Price. Run the query
and apply Best Fit to all of the fields. All numeric fields should be formatted as Currency, 2
Decimal Places. Save the query as Cap1 SUPP-06 Markup Query and close it.
14
Use the Query Wizard to create a crosstab query using the Cap1 Inventory table. Set the
Category field as the row headings, and set the Sport field as the column headings. Count the
Item ID field, name the query Cap1 Crosstab Query, and then finish the query. Run the
query and apply Best Fit to all of the fields. Save and close the query.
7
15
Create a query in Design view using the Cap1 Inventory table that prompts you to enter the
Sport, and then answers the question What is the sport, category, item name, and retail price
7
for inventory items, sorted first in ascending order by category and then in ascending order by
the item name? Add the fields in that order. The query should prompt an individual to Enter
the Sport. Run the query and type hiking when prompted for the criteria. Seven records
match the criteria. Save the query as Cap1 Parameter Query and close it.
Created On: 07/05/2019
2
GO16_AC_VOL1_GRADER_CAP_AS – Inventory Supplies
Grader – Instructions
Step
16
Access 2016 Project
Points
Possible
Instructions
Based on the Cap1 Suppliers table, use the Form tool to create a form. Switch to Form view
and use the form to add a new record as follows:
7
Supplier ID: SUPP-12
Company: Beach Water Sports Inc
Email Address: info@watersports.biz
Phone: (305) 555-6543
Address: 14 South Beach Rd
City: Miami
State: FL
Postal Code: 33125
Use the Filter By Form tool to create a filter that displays records with a State of CO or FL.
After verifying that three records match this criteria, toggle the filter to display all 12 records.
Save the form as Cap1 Supplier Form and close it.
17
Based on your Cap1 Suppliers table, use the Report tool to create a new report. Delete the
following fields from the report: Supplier ID, Address, City, State, and Postal Code. Clear the
Report Footer. Apply the Facet theme to this object only. Sort the Company field in ascending
order. For the Phone field, change the Width property to 1.25. For the Company field, change
the Left property to 1 and then close the Property Sheet. Save the report as Cap1 Suppliers
Report and then close the report.
5
18
Use the Report Wizard to create a report based on the Cap1 Inventory table. Add the
following fields to the report: Category, Item Name, and Retail Price, in that order. Group by
the Category field. Sort in ascending order by the Item Name field. Find the Average of the
Retail Price field. Be sure that the Layout is Stepped and that the Orientation is Portrait. For
the report title, type Cap1 Avg Price by Category Report and then switch to Layout view.
Delete the controls that begin with Summary for ‘Category.’ Under Item Name, click any text
box control and set the Width property to 2.75. Select the Retail Price column, including the
two controls that display the # symbols. Set the Width property to 1 and set the Left property
to 6. Save and close the report.
8
19
Close all database objects. Close the database and then exit Access. Submit the database as
directed.
0
Total Points
Created On: 07/05/2019
3
100
GO16_AC_VOL1_GRADER_CAP_AS – Inventory Supplies
Item ID
765589
114564
778952
772569
117895
796895
156899
456983
465894
793256
732568
465899
146553
989655
795622
756897
732589
145622
480782
145689
114568
146689
446275
Item Name
Beach Water
Bite Rite
Cargo
Cargo Lights
Celerater
Down Full Parka
Elite Jazz
E-motion
Fleece Hoodie
Fundamental Woven Stretch
Granite Divide
Gripper Gloves
K Face
Men’s High Top
Pedal Fast
Ski Gloves
Super Nova
Tie Breaker
Trail Sandals
Ultra Bibs
Vented Explorer
Women’s Snow Pants
XXT Trainer
Retail Price
$49.95
$89.95
$56.45
$43.95
$115.95
$229.95
$99.98
$44.95
$135.95
$45.65
$168.35
$25.55
$179.95
$98.46
$215.95
$29.99
$110.95
$69.55
$49.95
$130.89
$34.78
$85.65
$95.75
Category
Shoes
Shoes
Shorts
Shorts
Shoes
Jackets
Shorts
Shorts
Jackets
Shorts
Jackets
Socks and Gloves
Jackets
Shoes
Shoes
Socks and Gloves
Shoes
Tops and Tees
Shoes
Shorts
Hats
Pants
Shoes
Sport
Fitness
Biking
Biking
Biking
Hiking
Hiking
Biking
Fitness
Biking
Fitness
Skiing
Skiing
Hiking
Hiking
Biking
Skiing
Fitness
Fitness
Hiking
Biking
Hiking
Skiing
Hiking
Supplier ID
SUPP-03
SUPP-11
SUPP-09
SUPP-01
SUPP-01
SUPP-10
SUPP-07
SUPP-05
SUPP-09
SUPP-04
SUPP-06
SUPP-06
SUPP-02
SUPP-08
SUPP-05
SUPP-07
SUPP-03
SUPP-03
SUPP-08
SUPP-10
SUPP-04
SUPP-06
SUPP-11
Item ID
106555
106556
Item Name Retail Price Category Sport
Snowboard
256.99 Equipment Skiing
Wool Socks
Skiing
12.59 Socks and Gloves
Supplier ID
SUPP-06
SUPP-04
Item ID
765589
114564
778952
772569
117895
796895
156899
456983
465894
793256
732568
465899
146553
989655
795622
756897
732589
145622
480782
145689
114568
146689
446275
Item Name
Beach Water
Bite Rite
Cargo
Cargo Lights
Celerater
Down Full Parka
Elite Jazz
E-motion
Fleece Hoodie
Fundamental Woven Stretch
Granite Divide
Gripper Gloves
K Face
Men’s High Top
Pedal Fast
Ski Gloves
Super Nova
Tie Breaker
Trail Sandal …
Purchase answer to see full
attachment

  
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more