GO19_AC_CH01_GRADER_1E_HW – Kiosk Inventory 1.0

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

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

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

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.

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

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

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.

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

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.

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.

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.

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.

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

Layers in Cyberspace Worksheet

Complete the following as directed below. 

Format any references according to APA guidelines. 

1. Identify each of the layers of cyberspace. 

2. In 75- to 125-words each, define each of the layers of cyberspace. How do the various layers of cyberspace impact cybersecurity policy decisions?

3. In 175- to 350-words, explain how the layers that make up cyberspace interrelate. How do the layers of cyberspace interact to create a global network that we rely on daily for work, entertainment and  

 Write a project proposal on a disaster recovery plan that utilizes cloud services for data and system redundancy. The outline of the project will need to be a minimum of one page in length and include an introduction, scope/description, and a conclusion on what the project accomplishes. In addition, include any possible references up to this point.

Create a voice over power point slide presentation to discuss what  have you learned in this module. Make sure you cover the following  topics:

• insertion sort and selection sort algorithms
• exception handling techniques
• linear search and binary search
• Discuss binary search.

Assignment Expectations

• At least 15 slides (title page and reference page excluded from 15 slides)
• All topics covered in the presentation
• Clear voice over explanation

 What is an algorithm and what role does an algorithm serve in  programming?  Give examples of various algorithms. Discuss the main search and sort algorithms. Must provide a minimum of 200 words and references.

Cyber Security In Healthcare

Hi there, I attached the instructions down below. I don’t have enough time to finish this assignment. Thank you!

 List the assets you created for the Letter of Credit business scenario and desribe the purpose of each asset. (i.e. define the real world entity that each asset represents and why it is needed) 

Answer the the following questions in your own words. No copy and paste or citations,  

Questions

1- Describe the impact of Oss on the IT market.

2- Show your understanding of the commercial OSS market. How do red hat, oracle, oracle’s sun division and IBM make money via open source?

3- Visit Mozilla.org which open-source products does this organization develop? Investigate how development of these efforts is financed, how does this organization differ from the ones mentioned above?

4- What is the Linux foundation? Why is it necessary? Which firms are members? Underwriting foundation efforts?

5- List the reasons why Linux is installed on only a very small fraction of desktop computers. Are there particular categories of products or users who might see Linux as more appealing than conventional operating system? Do you think Linux ‘s share of the desktop market will increase? Why or why not?

6- How is Microsoft combating the threat of open-source software and other free tools that compete with it commercial products?

7- What is the dominant open-source database software? Which firm use the products? Why?

8- Which firm developed the leading OSS database effort changed in recent years? Who oversee the effort today? What questions does this raise for the office suite or desktop alternative. Why or why not 

9- How has stewardship of the leading OSS database efforts changed in recent years? Who oversees the effort today? What question does this raise for the product’s future? Although this book is updated regularly, current events continue to change after complication of this chapter. Investigate the current status of this effort – reaction of the developer community, reception of the product and be prepare to share your findings with class.

10- List some of the risk associated with using OSS. Give examples of firms that might pass on OSS software, and explain why. 

Exp19_Word_Ch03_Cap_Boston

Exp19 Word Ch03 Cap Boston

 Word Chapter 3 Capstone – Boston 

Project Description:

You work with Boston Travels, a tour company that promotes various travel opportunities in Boston. To assist in that promotion, you develop a flyer–designing and formatting attractive tables to describe tours. In addition, you include sponsor names on the flyer through a mail merge process.

Start   Word. Download and open the file named Exp19_Word_Ch03_CAP_Boston.docx. Grader has automatically added   your last name to the beginning of the filename.

Display nonprinting characters.   With the insertion point at the beginning of the document, press ENTER.   Return to the beginning of the document and insert a 3×2 table. Type Boston   Travels in the   first cell on the first row.

In the first cell of the second   row, insert Boston1.png. Change the   picture height to 1”. In the second cell of the second row, insert Boston2.png. Change the picture height   to 1”. In the third cell of the second row, insert Boston3.png and resize   it to 1”.

Click the Table Move handle to   select the table. AutoFit table contents. Merge all cells on the first row,   and apply Align Center alignment to the row. Change the font size of text in   row 1 to 22 pt.

Cell margins provide space   between a cell’s inside edges and the beginning of cell contents. By reducing   cell margins, you remove some of the extra space so that cell contents are   more nearly aligned at the edge of a cell. Because pictures are in this   table’s cells, a neater arrangement is shown when there is very little space   between them.
 

  Apply a table style of Grid Table 4 – Accent 2 (row 4, column 3 under Grid   Tables). Center the table horizontally on the page. Reduce left and right   cell margins to 0”.

Click the Table Move handle to   select the table. Select a border style of Double solid lines, ½ pt., Orange   Accent 2 (sixth column, first row under Theme Colors). Apply the border to   outside borders.

By converting existing text to a   table, you are able to use table design and layout tools, resulting in an   attractive and well-designed feature.
 

  Press ENTER after the last body paragraph (ending in fantastic pricing). Select text at the end of the document, from Back Bay/Fenway to 16.00. Whether you select the   paragraph mark following 16.00 is   irrelevant. Convert the text to a table, accepting all dialog box settings.

Insert a column before the first   column in the second table. Type Family Fun Tours in the first cell of the new column. Select the   first three cells in the new column and merge them. Type Patriot Tours in the second cell of the first   column (below the merged area). Select the second, third, and fourth cells in   the first column and merge them. Type JFK/Harvard Tours in the third cell of the first   column (below the Patriot Tours merged cell). Select the last three cells in   the first column and merge them.

Select the third column. Click   Split Cells and deselect Merge cells before split. Accept all other dialog   box settings. Change the width of the second column to 2”. Change the width   of the last two columns to 0.85”.

Insert a row above the first   row. Type Tour Package in the first cell of the new row. Type Attraction in the second cell on the same   row. Type Discounted Admission in the third cell on the same row.

Merge the last two cells on row   1. Apply Align Center alignment to row 1. Create a formula in the last cell   on row 2 that subtracts (0.4*admission price) from the admission price. The   admission price is shown in cell c2, so the formula should be =c2-(0.4*c2). The Number format should be   #,##0.00. Adjusting for each row, enter a discounted admission formula for   each attraction in the table.

Apply a table style of List   Table 4 – Accent 2 (row 4, column 3 under List Tables). Center the table   horizontally on the page. Apply Align Center alignment to all cells in column   1.

Changing font color is one way   to draw attention to an item of interest. In this case, you want readers to   recognize the substantial discount, shown in red.
 

  Select all numbers in the last column and change the font color to Red   (second column in Standard colors). Change the price of the Freedom Trail/Statehouse Tour from 15.00 to 16.00. Update the formula field in the same row to   reflect the new discount value. Check for any spelling or grammatical errors,   correcting any that are identified. Ignore any clarity or conciseness concerns.

Begin a mail merge, choosing   Letters and selecting Sponsors.xlsx as   the data source. Data is located on Sheet1$   of the data source. Edit the recipient list to sort by Sponsor in ascending order.

Replace [Sponsor] on the last line of the document with the merge field   of Sponsor. Ensure that the brackets are included in the text to be replaced.   Preview results and then finish the merge, editing individual documents and   merging all. Press CTRL+A to select all of the merged document and copy the   selection. Display Exp19_Word_Ch03_CAP_Boston,   move the insertion point to the end of the document (after the Sponsor name)   and insert a page break. Paste all copied text, resulting in a 9-page   document

Save and close Exp19_Word_Ch03_CAP_Boston. Close all other open documents   without saving. Submit Exp_Word_Ch03_CAP_Boston.docx   as directed.