Please help to respond to the below using the VBA Excel and the screenshot with information attached to create the excel. The file purchase 1.xlsx contains a small dataset on computer purchases. Write a program that creates a user-defined type called CustomerPurchase with an item (of the appropriate type) corresponding to each data column: Customer, Email, Cell, Date, Amount. The type definition should be defined at the beginning of the module. Write a sub called test to create an array purchase where each element of array is of type CustomerPurchase and fill this array with the data in the file. Finally, display the information about Sam Lafferty in a message box.

Please help with Java code. Create student class Name Id Marks Create array of 10 student and print all students

C# According to the following statement, __.Random rn = new Random(); Question 1 options: It declares a variable named rn that can be used to reference an object of the Random type. The new operator creates an object in memory and returns a reference to that object. The = operator assigns the reference that was returned from the new operator to the rn object. All of the above.

The above screen is used to browse the products table it uses the ProductDAO.java file, it calls the getProductByCriteria() function which should accept a parameter, this parameter should be the criteria that would be built from the two combo boxes and the text box, and queries the products table.The getProductByCriteria() function should return a list of Product objects that matches the criteria specified. Modify the function so that it accepts a string paramater consisting of the fields from the combo boxes and a price number from the text box separated by commas and use this string to modify the query in the function to return the desired result set. public List<Product> getProductByCriteria() //MAKE MODIFICATIONS TO THIS FUNCTION SO IT CAN TAKE PARAMETER(S) { if (openConnection()) { try{ List<Product> items = new ArrayList <> (); Product temp = null; String...

Assignment Submission Instructions:This is an individual assignment – no group submissions are allowed. Submit a script file that contains the SELECT statements by assigned date. The outline of the script file lists as follows:/* ******************************************************************************** * Name: YourNameGoesHere * * Class: CST 235 * * Section: * * Date: * * I have not received or given help on this assignment: YourName * ***********************************************************************************/USE RetailDB;####### Tasks: Write SQL Queries ######### -- Task 1 (Customer Information):-- List your SELECT statement below. Make sure the SQL script file can be run successfully in MySQL and show the outcome of the code on MySQL

the only data that should b epresented as numerical values are those that represent numbers. data that represent categories should never be presented as numerical values. TRUE or FALSE

Assignment Name JavaScript Concepts III Assignment Filename lastname-circleArea.html (replace lastname with your last name). area.js Assignment Description This assignment demonstrates the following concepts: JavaScript Functions Assignment Instructions Write a JavaScript program that calculates the area of a circle: Write a function that calculates the area of a circle given the radius. Formula: Math.PI * (radius * radius) Your program code should contain appropriately named variables. Use documentation to identify various components of your program. Call the function once and pass a radius value of 10.75 to it. Use the starter files and complete the logic to satisfy the instructions. To access the files, download and save the circleArea.zip folder attached to this assignment. Then unzip the compressed folder to reveal the included files: circleArea.html and area.js. Be sure that the two files are in the same folder. Then write your code in the area.js...

Write the code for the data type that is necessary to create a data type that will store a social security number of the format 999-99~9999. Don't use a simple character array, use a structure.

Declare an enumerated data type named Direction with enumerators for North, South, East, and West.

The accompanying Gradebook spreadsheet contains a partially completed spreadsheet model for computing and summarizing the grades for a class. Complete the spreadsheet model by entering and copying the formulas in the appropriate cells. Cell range H4:H17 should contain the course number grades using the grades from exams and homework assignments and the grade allocation in row 22. Cell range I4:I17 should contain the course letter grades based on the grading criteria in cell range K4:L8. Rows 19, 20, and 21 should contain the average, maximum, and minimum exam, homework, and course number grades. You should only enter each formula once and copy the formulas to other cells. Gradebook Student ID Exam 1 Exam 2 Exam 3 Homework 1 Homework 2 Homework 3 Course Number Grade Course Letter Grade Grading Criteria 000-01-5562 60 50 40 79 92.0 76 0 F 000-01-2667 80 71 70 84 81.0 90 60 D 000-01-7376 65 65 65 60 90.0 94 70 C 000-01-1986...

Microsoft Visual C# 7th edition. In Chapter 7, you modified the GreenvilleRevenue program to include a number of methods. Now, using your code from Chapter 7 Case Study 1, modify your program so every data entry statement uses a TryParse() method to ensure that each piece of data is the correct type. Any invalid user entries should generate an appropriate message that contains the word Invalid, and the user should be required to reenter the data. I am working in CENGAGE MINDTAP. Here is my code, but the TryParse is not working. I am not getting the point for TryParse. thanks using System; using static System.Console; using System.Globalization; class GreenvilleRevenue { static void Main() { int numLastYear; int numThisYear; double revenue; int fee = 25; const int MAX_CONTESTANTS = 30; string[] names = new string[MAX_CONTESTANTS]; char[] talents = new char[MAX_CONTESTANTS]; char[] talentCodes = { 'S', 'D', 'M', 'O' }; string[]...

When we use the Group-Object cmdlet, it will create this new property, which displays the number of objects in each grouping: Group of answer choices Number Count Entry Name

Employee Management System Write a python class named Employee that holds the following data about an employee in attributes: name, ID number, department, and job title. Once you have written the class, write a PYTHON program that creates three Employee objects to hold the following data: Name ID Number Department Job Title Susan Meyers 47899 Accounting Vice President Mark Jones 39119 IT Programmer Joy Rogers 81774 Manufacturing Engineer The program should store this data in the three objects, then display the data for each employee on the screen.Using the Employee class, create a program that stores Employee objects in a dictionary. Use the employee ID number as the key. The program should present a menu that lets the user perform the following actions: • Look up an employee in the dictionary• Add a new employee to the dictionary• Change an existing employee’s name, department, and job title in the dictionary• Delete an employee from the dictionary• Print all...