Go19_ac_ch01_grader_1e_hw – kiosk inventory 1.0

  

caGO19_AC_CH01_GRADER_1E_HW – Kiosk Inventory 1.0

Project Description:

In this project, you will create database objects to track the inventory of items for sale in a kiosk located in a college snack bar. You will create a table and import data from Excel to create a second table. You will create a simple query, a form, and a report.

Steps to Perform:

   

Step

Instructions

Points Possible

 

1

Start Access. Open the file Student_Access_1E_Kiosk_Inventory.accdb   downloaded with this project. Create a new table in Datasheet view.

0

 

2

Beginning   in the second column of the table and using the specified data types, create   the following fields (in this order):
 

Item   (Short Text), Category   (Short Text), Campus   (Short Text), Storage   Location (Short Text), Price (Currency), Quantity in Stock (Number).

12

 

3

Change the data type of the ID   field to Short Text, rename the ID field to Item ID, and change the field   size to 10   Save the table as 1E Inventory.

4

 

4

Add the   following three records to the 1E Inventory table and then close the table.

  

Item ID

Item

Category

Campus

Storage Location

Price

Quantity in Stock

 

C-1

Chocolate Bar

Candy

Southeast

SE100A

.89

250

 

C-2

Lollipop

Candy

Southeast

SE100A

.5

500

 

T-1

T-shirt

Clothing

Southeast

SE100B

17.5

100

10.5

 

5

Append the records from the   downloaded Excel file a01E_Inventory.xlsx   to the 1E Inventory table and then open the table in Datasheet view (the   table has 17 records).

10

 

6

Switch to   Design view and delete the Campus field. For the Category field, enter a   description of Enter the category of the item and then change the field   size to 25.   Save the table.

8

 

7

Switch to Datasheet view, apply   Best Fit to all of the fields in the table, save the table, and then close   the table.

0

 

8

Import   the records from the downloaded Excel file a01E_Inventory_Storage.xlsx into the database as a new table   named 1E   Inventory Storage. Designate the first row as column headings and   the Category field as the primary key. Open the Inventory Storage table in   Datasheet view (the table has five records).

12

 

9

Switch to Design view. For the   Location Detail field, change the field size to 35, enter a description of Room and bin   number or alternate location of inventory item, and then save the   table.

4

 

10

Switch to   Datasheet view, apply Best Fit to all of the fields in the table, save the   table, and then close the table.

0

 

11

Based on your 1E Inventory   table, use the Query Wizard to create a simple query. Include only the three   fields that will answer the question, For   all items, what is the storage location and quantity in stock?. Keep the   default name of 1E Inventory Query, click Finish to   display the query results, and then close the query.

10

 

12

Based on   your 1E Inventory table, use the Form tool to create a form for the table.   Save the form as 1E Inventory Form, display the form in Form   view, and then close the form.

8.5

 

13

Based on your 1E Inventory   table, use the Report tool to create a report. Delete the Category and Price   fields from the report. Save the report as 1E Inventory Report.

13

 

14

Sort the   Item ID field in ascending order. Set the width of the Item ID field to 0.75   inch. Set the width of the Storage Location field to 1.5 inches. Delete the page   number from the report, save the report, and then close the report.

8

 

15

Save and close the database,   and then submit for grading.

0

  

Total Points

100

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
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