Module 6: Upload your Completed Excel Worksheet and Access Database with Imported Data and Tables

By the end of this module you will submit your completed Excel worksheet with employee data and created chart. You will also need to submit your Access Database with imported Excel data and two tables containing employee personal information and workplace information.

Now that the information has been entered and formatted in Excel, import the data into Microsoft Access as ADP has requested. Arrange the data into two tables: Personal Information and Workplace Information. Important Note: The employees names (first and last) need to appear in both tables.

In a heat transfer course, we can derive the equation for the temperature distribution in a flat rectangular plate. in this example, we will look at a plate at steadystate with three sides being held at t1, and one side held at t2. the temperature for any location on the plate, t(x,y), can be calculated by where create a function (prob3_5) that will take inputs of vectors x and y in feet, scalar n, scalars l and w in feet and scalars t1 and t2 in degrees fahrenheit. it will output a matrix t which is the temperature of each x and y locations. t will have the number of columns equal to the number of elements in x and rows equal to the number of elements in y. though this can be done without loops (perhaps more efficiently), your program must use a nested loop.