Exp19_Access_Ch08_HOEAssessment – Real 1.0

 Exp19_Access_Ch08_HOEAssessment – Real 1.0

  

Project Description:

In this project, you will work with a database that tracks real estate agents and their property sales. You will add a hyperlink field that will store a link for each agent’s website. The HR department manager wants to store a photo for each agent as an attachment. You also export data from the database to three different formats. Finally, you import information from Excel, Access, and text files.

     

Start   Access. Open the downloaded Access file named Exp19_Access_Ch8_HOEAssessment_Real.accdb. 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.

 

You will add a hyperlink field   to the Agents table to store each agent’s website address.
 

  Create a new field in the Agents table after PerformanceReview named Website with the Hyperlink data type.   Save the table.

 

Switch to Datasheet view, add   the website https://juanrosario.biz to the first AgentID (record   1). Close the table.

 

You will add an attachment field   to the Agents table to store the employees’ performance reviews and photos.
 

  Create a new field in the Agents table after PerformanceReview named EmployeeFiles with the Attachment data type.   Save the table.

 

Switch to Datasheet view and add   the downloaded the picture file named Juan.jpg   to the EmployeeFiles field for the first AgentID (record 1).

 

Create a basic form based on the   Agents table; the form will open in Layout view. For the first AgentID   (record 1), click the picture to   display the Attachment toolbar. Click Manage   Attachments to display the Attachments dialog box and then click Cancel. Save the form as Agents.   Close the form and the table.

 

You want to determine current   sales for a specific agent. You will filter the Sales Report query to locate   records and export the records to Excel and Word. You will also export   records to create a report in PDF format.
 

  Open the Sales Report query. Use Filter by Selection to display records in   the LastName column where the value equals Yang. Export the filtered records to an Excel file. Save the file   as a08c1Yang_LastFirst. Do not save the export steps.

 

Hide the Sale Price field from the datasheet results in the Sales Report   query. Export the same filtered records to a Word file. Open the destination   file after the export operation is complete. In the document, press ENTER one time and add the title Hart   Commissions to   the file. Format the title as bold and center aligned. Save the file as a   Word document with the name a08c1Yang_LastFirst. Close the document and exit Word. Do not save the   export steps. Save and close the filtered Sales Report query.

 

Use Filter by Selection to   display records in the Properties table where the Beds value equals 4 (twelve records will display).   Export the records to a PDF document. Save the file as a08c1FourBeds_LastFirst. Close the PDF reader program.   Do not save the export steps. Save and close the filtered Properties table.

 

You will import a new Customers   table from Excel.
 

  Open the a08c1Customers.xlsx   workbook, examine the Customers worksheet, and then close the workbook.   Create a linked table in the database by importing the workbook named a08c1Customers.xlsx. Use the first row   of the Customers worksheet as column headings and accept all other default   options.

 

You will also import subdivision   records from an Access database.
 

  Open the a08c1SubDivisions.accdb   database, examine the SubDivision2 table, and then close the database. Create   a linked table in the database by importing the SubDivision2 table from the   database named a08c1SubDivisions.accdb.

 

You will import additional   subdivision records from a text file.
 

  Open the a08c1TextSub.txt text   file, examine the content, and then close the file. Create a table in the   database by importing the text file named a08c1TextSub.txt.   Use the first row of the file as field names, SubDivisionID as the primary   key, and name the table SubDivision Text. Accept all other default options.

 

Append the 5 records from   SubDivision2 and the 5 records from SubDivision Text to the SubDivision   table. Open the SubDivision table to view the appended records. Close the   SubDivision table.

 

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

C-programming, Bench-marking arrays and linked lists

 

Create a new file named linked_list_tests.c with a corresponding header file. This file should contain three functions:

  1. void linked_list_insert_sequential_start(int num_samples, int sample_size)
  2. void linked_list_insert_sequential_end(int num_samples, int sample_size)
  3. void linked_list_insert_random(int num_samples, int sample_size)

Sequential Insert

The first test should create a new sample of size sample_size. Similar to the testing functions used for arrays, you can simulate this using a void * object and allocating sample_size bytes to it. Insert the new pointer at the beginning of the linked list.

The second test will be almost identical to the first one you created, except you should add each sample to the end of the list. Since you are simulating a standard, singly-linked list, you should expect that this version will perform slower inserting at the beginning of the list.

Random Insert

The third and final test should insert the samples at a random position based on the current number of samples. Reference the random tests in array_tests.c to see how the random values are generated.

After implementing all three functions, include the header file in run_tests.c and create a function named void linked_list_tests(int num_samples, int sample_size). This function should call each individual test you created previously. Use array_tests as a reference to what this should look like.

Running the Tests

The provided Makefile will compile and run the tests automatically. If you implement the functions as requested correctly, this will also work for your new tests. Once you have implemented the new tests, run the test by calling make.

The output should clearly show which test is being performed followed by the time (in ms) that it took to execute the test. Feel free to model your benchmark function after the array tests already provided. If the tests run properly, you’re done!

TAM

 

  1. Define TAM and the components.
  2. Note how TAM is impacting educational settings.
  3. Give an overview of the case study presented and the findings.

 

  • 3 pages in length (not including title page or references)
  • APA guidelines must be followed.  The paper must include a cover page, an introduction, a body with fully developed content, and a conclusion.
  • A minimum of five peer-reviewed journal articles.

risk management plans

 Create a partial draft of the risk management plan. To do so, follow these steps:

  1. Research risk management plans.
  2. Create an outline for a basic risk management plan with anticipated section headings (as indicated in this numbered list). This plan will include a qualitative risk assessment, which is addressed later in the project.
  3. Write an introduction to the plan by explaining its purpose and importance.
  4. Define the scope and boundaries of the plan.
  5. Research and summarize compliance laws and regulations that pertain to the organization. Keep track of sources you use for citation purposes.
  6. Identify the key roles and responsibilities of individuals and departments within the organization as they pertain to risk management.
  7. Develop a proposed schedule for the risk management planning process.
  8. Create a draft risk management plan detailing the information above. Format the plan similar to a professional business report and cite any sources you used.

APA format

4 pages

Fixing Home Networks for Fun and Profit

1. Describe how you would fix the home network of your noisy neighbors.

Parameters: In 10 to 12 complete sentences, identify the CPU architecture, memory, and storage, and state why each item was selected. Please include a table indicating the cost of the items and their specifications.

Your next-door neighbors and their four kids play music at all hours of the night. When you knock on their door to complain, the mom explains that her kids play music when doing homework, but their network is so slow, the kids never finish. Knowing you’re taking classes in CIS, they ask you to help them get some sleep by speeding up their computers and network. Based on the following description, make a list of recommended upgrades you would perform. Make sure to recommend specific devices and describe how they will resolve the problem. Assume they do not trust wireless technology, so please do not base your recommendations on a wireless infrastructure.

The family has the following devices:

  • ZyXEL cable modem DOCSIS 3.0 (CDA30360)
  • TP-Link AC1750 smart WIFI router
  • 3 x D-Link 8 port 10/100 unmanaged metal desktop switch (DES-108)
  • 1 x Xbox one slim
  • 6 x Roku magically wired to the network
  • QNAP for movies and music videos
  • Vonage home phone service HT802-VD VoIP device
  • 4 x Echo Mini
  • All devices are connected using CAT3 cable
  • 5 Mac Mini (2018) with SSDs and 8 GB of memory

Parameters: Given a $500 budget, generate a quote of recommended upgrades for their network. Each item should be accompanied by a three-to-four-sentence description of why it needs to be upgraded.

Assignment 7.1 [95 points]

  

Assignment 7.1 [95 points]

This program will ask the user to answer a series of arithmetic problems and report on how the user performs. You will write this program in phases as specified below. Make sure that each phase works correctly and uses good style before progressing to the following phase.

Note that the purpose of this assignment is to give you lots of practice with parameter passing without making you write a huge program. For this reason I have provided a structure diagram at the end of this document. Make sure that you adhere to the structure diagram carefully.

Turn in only your final product.

Phase 1: Your main function for phase I must look exactly like this:

int main()

{

srand(time(0)); 

doOneSet();

}

You must write the function doOneSet which will, for now, write out 5 addition problems. All of the numbers printed should be between 0 and 100, inclusive. Here is a sample output for this phase:

45 + 21 =

0 + 100 = 

54 + 23 = 

4 + 19 =

18 + 92 =

The numbers that are produced for these problems must be generated randomly by the computer. The numbers in the sample output are given only as an example. Refer to lesson 7.3 for more information about generating random numbers.

Phase 2: Change your doOneSet function so that instead of just writing out the problems it also allows the user to enter an answer, and then tells the user whether the answer was correct or not. Do not change your main function. Here is the sample output for this phase (user input is indicated here by using bold font. It won’t be bold in your own output):

45 + 21 = 66

correct

0 + 100 = 100 

correct 

54 + 23 = 67

incorrect

4 + 19 = 13

incorrect

18 + 92 = 110

correct

Before you move on to phase 3, refer to the structure diagram at the end of this document and make sure that you have adhered to it for all of the functions indicated there for phase 2. This will probably mean dividing your doOneSet function up into functions, if you haven’t done it already.

Phase 3: Now you will change your doOneSet function so that it will work for either addition, subtraction, or multiplication. For the purposes of this assignment, a set of problems is defined to be a group of problems that are all of the same type (all addition, all subtraction, or all multiplication). After completing this phase your program will give 5 addition problems, 5 subtraction problems, and 5 multiplication problems, for a total of 15 problems. Your main function must look exactly like this:

personal Selling

You are provided with a scenario below.  As a group make a recommendation for the best approach for sales compensation plan based on what little information has been provided:

Scenario #2: The restrictions are being lifted and you now can have a dining room at 50% capacity.  The community is still reluctant to return to in restaurant dining.  You need to have both pickup orders and book the in restaurant service to capacity to meet your minimum margins.  You challenge your staff to come up with ideas and incentives to do so.  What is their plan?

using APA formatting and should include a cover page and reference page with a minimum of 3 resources used.  The cover page and resource page are not included in the page count. 

 please remember to use direct quotations if your citing from any academic souurces. Include the page number as well in the in text-citation. 

References Links:

https://www.lucidchart.com/blog/sales-compensation-plan