Question

Please Read it all and carefully
In visual basic(vba)do the following program

Summary

INGE Industry, Inc. needs a program in which the date and temperature in Celsius degrees of an industry laboratory are recorded and stored in a sequential file. In addition, you can see the recorded data and convert the temperatures in the following units: Fahrenheit, Kelvin and Rankine. In addition, they want to see a linear graph that reflects how the temperature has fluctuated day by day, for decision making.

Specifications :

Part 1 - Authentication: Form (user form) to authenticate in the program.

1. The program can only be accessed by authorized persons. Create a sequential file that has the user names (username) and password (password) of the people who will have privilege to access the program.

2. Create a form (user form) and programming so that the user of the program can authenticate.

3. Read the sequential file of the authorized persons, containing the user names and password, and validate that the user who is trying to access and the password are valid.

4. If the user enters incorrect data, submit an error message.

5. The user has privileges to access the program, close the authentication screen and present a form of a Menu.


Part 2-Menu: Form with option buttons to access.

1. Include the following option buttons to access the respective forms.

a. Temperature Record
b. Temperature Graph

2. Include the Exit button to close the program.

3. When pressing a button of the forms, leave the Menu form open and access the form that the user selected.


Part 3 - Temperature Record: Way to read, add and order daily temperatures.

1. Include the following objects in the form.

a. A ListBox to display the data of the file containing the dates and temperatures.

b. Labels and TextBox's to add a date with its temperature in degrees Celsius.

c. Button to add the data.

d. Button to exit the form and return to the Menu.

2. Procedures

a. When opening the form (when activated):

a.1 Execute a subroutine that reads the file that contains the dates with the temperatures in degrees Celsius, Fahrenheit, Kelvins and Rankine. and move the data to a Record structure.

a.2 Execute a subroutine that moves the data from the Record structure to the ListBox.

b. When you press the button to add data, do the following.

b.1 Check if the user specified the date and temperature in Celsius degrees to add. If you did not specify any of the two data, submit an error message to the user.

b.2 Use functions to convert the temperature in degrees Celsius to Fahrenheit, Kelvins and Rankine.

b.3 Add the date and temperatures to the Record structure.

b.4 Execute a subroutine that orders the data of the structure by date.

b.5 Rewrite the sequential file with the data: Create the output file whose name will be the same as the one you read, and move the record structure to the file.

b.6 Execute the subroutine that moves the data from the Record structure to the ListBox to see it updated with the data that was added.

b.7 Clean the Textbox's.

c. Pressing the Exit button closes the program and returns to the Menu.

Part 4 - Temperature Graphs: Integrates the dates with their respective temperatures in degrees Celsius.

1. Include the following objects in the form.

a. Image where the linear graph will be displayed.

b. Button to close the form and return to the Menu.

2. When the form is activated (activated), the program will do the following.

a. Remove the contents of the cells of the spreadsheet where the dates and temperatures will be displayed through programming.

b. Read the sequential file that contains data on dates and temperatures, and only move each date with its respective temperature in degrees Celsius to the Excel spreadsheet.

HINT: When the work team executes this instruction the first time (when you are doing the programming tests), you will access the Excel spreadsheet to create a line graph that reads the data of date and temperatures that are in the worksheet. calculation to include them in the line graph. Modify the title of the graph so that it is consistent with the information that is presented in it. This step will be carried out by the team only once and will not erase the graph, so that from that moment on the graph can be updated with the data that is moved to the Excel spreadsheet.

c. When the previous step is executed (move the date and temperature data Celsius to the Excel spreadsheet), the graph will automatically be updated; this is done automatically without programming intervention.

d. Through programming, export the linear graph of the spreadsheet to an image file and present the image of the graph in the image object that is in the form.

3. Include the Exit button to close the program. Pressing the Exit button closes the program and returns to the Menu.

Answer 1