Monthly Archives: June 2023

Write a three-page paper on the Brave Browser. Be sure to include a References page. The Title page and References page do not count as part of the three-page requirement for this assignment.

Exp19_Access_Ch06_Capstone – Northwind Traders Sales Analysis 1.0

Project Description:

Northwind Traders is a small international gourmet foods wholesaler. You will update the company’s database by increasing the price of all of the meat and poultry products. You will make a table for archiving older order information. You will also summarize quantities sold by category and identify customers who have no orders.

Start   Access. Open the downloaded Access file named Exp19_Access_Ch6_Cap_Northwind. Grader has automatically added   your last name to the beginning of the filename. Save the file to the   location where you are storing your files.

Using a select query, you will identify   all of the products with a category of meat or poultry, and then use an   update query to increase the prices of the products.
 

  Create a select query that includes the CategoryID from the Categories table   and the UnitPrice and ProductName fields from the Products table (in that   order). Run the query and note the CategoryID for Meat/Poultry.

Add the appropriate CategoryID   criterion to limit the query output to only Meat/Poultry. Convert the query   to an update query. Update the UnitPrice for Meat/Poultry only by increasing   it by 6 percent.

View   the query in Datasheet view prior to running it to make sure you are updating   the correct (four) records. Return to Design view and run the query. Save the   query as Update Meat/Poultry   Prices.   Close the query.

You will identify orders shipped   during the first half of the year and create a new table in which to store   them. You will then delete the orders from the current orders table.
 

  Create a select query that identifies all of the orders shipped Between 1/1/2020 and   3/31/2020. Include all fields from the Orders   table.

Convert   the select query to a make table query. Name the new table Orders Archive. Run the query. Save the query as Make Orders Archive Table. Close the query.

Make   a copy of the Make Orders Archive   Table query and save it as Append Orders Archive   Table.   Open the Append Orders Archive Table query   in Design view. Convert the make table query to an append query. The query   will append to the Orders Archive table.

Modify   the criteria to append orders shipped Between 4/1/2020   and 6/30/2020. Run the query, save it, and then   close it.

Open   the Orders Archive table in Design   view and set OrderID as the   primary key field. Switch to Datasheet view, then save and close the table.

Make a copy of the Append Orders Archive Table query and   save it as Delete Archived Orders. Open the Delete Archived Orders query in Design view. Convert the append   query to a delete query.

Modify the criteria to delete all   archived orders from the Orders table (six records). Run, save, and then   close the query.

You   want to determine how sales are performing with respect to each product   category. You will create a crosstab query that displays quantities by   category and salesperson.
 

  Open the Profit query in Design view and add the LastName field from the Employees table to the last column of the   design grid. Run, save, and close the query.

Use the query wizard to create a   crosstab query based on the Profit   query that sums the total Quantity by Ship Country (row heading) and CategoryName (column heading). Accept   the query name as Profit_Crosstab.

Modify the query to display CategoryName as the row heading field   and LastName as the column heading   field. Run, save, and close the query.

You will create a query to determine   which customers have no matching orders. The customers will be contacted to   determine if they would like to place an order.
 

  Create a query to find out if any of the customers have no current order   details. Add all of the fields from the Customers table to the results. Save   the query as Customers With No Orders. Run the query and close it.

Close   all database objects. Close the database and then exit Access. Submit the   database as directed.

People are using their mobile phone browsers more and more every day to find information about businesses, make product decisions and purchases, and even determine the quality of a business based on what they can find online.  Write a seven to 10 (7 – 10) page paper in which you: 

1. How to Choose a Mobile Web Development Option.
2. Research and discuss effective use of screen real estate.
3. Compare and contrast different mobile platforms (i.e. Android, iOS).
4. The tools of mobile interface design.
5. Discuss mobile information design.
6. Choosing mobile web options.

Your assignment must follow these formatting requirements:

• Use at least ten – twelve (10 – 12 ) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. 
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment.

Complete the following assignment in one MS word document:

Chapter 1 –discussion question #1 & exercise 15 (limit to one page of analysis for question 15)

Chapter 2 – discussion question #1 & exercises 4, 5, and 15(limit to one page of analysis for question 15) Question 4 is not a group assignment.  It is an individual assignment.

When submitting work, be sure to include an APA cover page and include at least two APA formatted references (and APA in-text citations) to support the work this week.

 Summarize what you have learned over the last 9 weeks. Has it changed your opinion about technology? Do you believe technology will continue to evolve? What businesses should concerned about being “phased” out due to new technology? 

Weekly Assignment/Discussions via Unicheck Week 06

Write a Python program to convert temperature from Celsius to Fahrenheit and Kelvins; from Fahrenheit to Celsius and Kelvins.

Document your program – to include your name, course, date written, and the formulas used in the conversions as COMMENTS at the top of your program.
Instruct the user on how to enter the data you are requesting.
 

You must use the IF, ELSE, ELIF statements or a combination of these statements.
 You must functions [at least three functions]  You must have error trapping routine(s)
 You must have an exit to you program

Identify and research the latest electronic technology security being used to provide the highest level of security possible. For example, you can research “wireless signals such as radio, laser, and microwave,” the project “imaging system for immersive surveillance current technologies,” or another new or emerging technology of your choice.

1. Find a resource–a scholarly article, security organization article/whitepaper, or web article. Give the article’s APA style reference information.
2. Summarize the article. Include all major points.
3. Explain how this technology can and is being used. What kind of location, organization, level of needed security, etc., would need this form of technology? Justify your choice.
4. Explain the advantages of using this new technology over the older technology options.

Be sure to use APA style in your assignment. Use your best grammar and punctuation. Expected length is 3 pages. 

need help with python

1.) What are the differences between a linked list and a stack?

2.) What are the differences between a stack and a queue?

3.) Explain exactly why a reference variable can’t be changed once it is set.

4.) Create a pointer to the start of the list called startPtr. (The list is empty!)

6.) Assume that the list pointed to by startPtr is maintained in alphabetical order. Provide the statements necessary to insert the following node properly: “Pritchard”, 66.5 (Note: you do not know what is in the list, only that it is maintained in alphabetical order.)

Use pointers previousPtr, currentPtr and newPtr to perform the insertions. Assume that newPtr points to the new node.

8.) Write a while loop that deletes all the nodes in the list and frees the memory associated with each node. Use pointer currentPtr and pointer tempPtr to walk along the list and free memory, respectively.

9.) Write the code to declare a structure “myNode” that holds an integer value and a next pointer.

10.) Assume you have a linked list of “myNode” structures and the pointer “head” points to the first node of the list. Write a function that takes the head pointer as a parameter and returns a pointer to the last node in the list.

11.) Assume you have a linked list of “myNode” structures and the pointer “head” points to the first node of the list. Write a function that takes the head pointer as a parameter and a second parameter which is the number to search for. The function returns a pointer to the node if the number is found and NULL if the number is not in the list.

12.) Assuming the following structure definition write a proper push function to save a number to a list used as a stack.

struct Node

{

int number;

struct Node *next;

};

13.) Assuming the previous structure definition from problem 12, write a proper remove function to remove a number from a list used as a queue.

Follow the directions to complete the lab manual 

Reflection Assignment

After completing the lab, answer the following questions: Please see : Netlab: Firewall Configuration Directions Document

1. Type your answers in an APA-formatted Word document. Cite all sources.