GO19_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.


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


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).


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.


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


Item ID

Get Plagiarism-Free and Quality Papers Without Overpaying at Homeworkmavens.com

Solution preview:

Just in case you need an assignment done, hire us. Using our writing services will make your life easier because we deliver exceptional results. Use us to get an A!

We are the Best!


275 words per page

You essay will be 275 words per page. Tell your writer how many words you need, or the pages.

12 pt Times New Roman

Unless otherwise stated, we use 12pt Arial/Times New Roman as the font for your paper.

Double line spacing

Your essay will have double spaced text. View our sample essays.

Any citation style

APA, MLA, Chicago/Turabian, Harvard, our writers are experts at formatting.

We Accept

Secure Payment
Image 3

Subjects We Cover