Skip to content
FeatherEssaysFeatherEssays
FeatherEssays
Expert Essay and Academic Writing Services
1-343-433-433-444support@featheressays.com

our-guarantee

  • HOME
  • ABOUT US
  • OUR SERVICES
  • HOW IT WORKS
  • FAQ
  • TESTIMONIALS
  • ORDER A CUSTOM PAPER NOW
  • CONTACT US
  • HOME
  • ABOUT US
  • OUR SERVICES
  • HOW IT WORKS
  • FAQ
  • TESTIMONIALS
  • ORDER A CUSTOM PAPER NOW
  • CONTACT US
July 21, 2017UncategorizedBy classhelp24@gmail.com [email if you need fresh paper done]

NEED DONE BY 8PM EASTERN TIME.

Employee Performance

Project Description:

You have been asked to modify an Employees database that tracks employee data, company locations, and performance and bonus information. You will import a spreadsheet from Excel and a text file into the database. You will add a hyperlink field that will store a URL for each city where the company has a location. You will also add an Attachment field that will store employee photos. You will then use imported data to enhance a query in the database, create a report, and then export it to a PDF document.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Access. Open the downloaded Access database named exploring_a08_Grader_a1.accdb. Save the database as exploring_a08_Grader_a1_LastFirst.

0

2

Create a new table in the database by importing the downloaded workbook named a08c2Location.xlsx. Use the first row of the worksheet as column headings, set LocationID as the primary key, and import the table as Location. Accept all other default options. Do not save the import steps.

8

3

Create a table in the database by importing the downloaded text file named a08c2Titles.txt. Use the first row of the file as field names, TitleID as the primary key, and name the table Titles. Accept all other default options. Do not save the import steps.

8

4

In the Employees table, add an Attachment field named Photo as the last field.

8

5

Add the downloaded image file KFleming.jpg for EmployeeID 3 to the Employees table.

4

6

Add the downloaded image file PBrumbaugh.jpg for EmployeeID 17 to the table. Close the table.

4

7

In the Location table, add a Hyperlink field named CityInfo as the last field.

8

8

Add the URL http://en.wikipedia.org/wiki/Atlanta as the CityInfo value for Atlanta in the Location table.

4

9

Add the URL http://en.wikipedia.org/wiki/Pittsburgh as the CityInfo value for Pittsburgh. Close the table.

4

10

Open the Performance query in Design view (right-click the query in the Navigation Pane and then select Design View). Add the newly imported Titles table to the query window. Drag and drop the Title field over the Performance field in the query design grid so that it is in the third field position. The query will calculate the raises for the employees based on data in the Titles table.

8

11

Add the Photo field from the Employees table to the last position in the query. Run the query to view the new salaries, bonuses, and employees on probation for poor performance reviews.

8

12

Set the criteria in the query so that only employees on probation will display and then run the query. Note that these employees will receive no bonus. Modify the criteria to display employees who are not on probation. Run, save, and then close the query.

8

13

Create a simple report based on the Performance query. In Layout view, delete the Probation and PercentIncrease fields. Adjust the column widths so that they all fit within the page, but the data is still visible.

8

14

In Design view, move the page numbering control to the left so that its right edge is just inside the 7.5-inch mark on the horizontal ruler. Drag the right edge of the report to the left so that it is just inside the 8-inch mark on the ruler. View the report in Print Preview; the report should consist of five pages.

4

15

Modify the report title as Performance Reviews and delete the logo to the left of the title.

4

16

Save the report as Employees in Good Standing and close the report. Export the report as a PDF document using the same name and publish the report. Open the report in your reader program and close the report. Do not save the export steps.

4

17

Open the Performance query in Design view. Add the newly imported Location table to the query window. Drag and drop the Location field over the LastName field in the query design grid so that it is in the first field position. Sort the records by Location in ascending order. Run, save, and then close the query. Compact and repair the database.

8

18

Save the database. Close the database, and then exit Access. Submit the database as directed.

0

Total Points

100

Office 2013 ? myitlab:grader ? Instructions

Exploring Series Vol. 2

Employee Performance
Project Description:
You have been asked to modify an Employees database that tracks employee data, company
locations, and performance and bonus information. You will import a spreadsheet from Excel and a
text file into the database. You will add a hyperlink field that will store a URL for each city where the
company has a location. You will also add an Attachment field that will store employee photos. You
will then use imported data to enhance a query in the database, create a report, and then export it
to a PDF document.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step

Points
Possible

Instructions

1

Start Access. Open the downloaded Access database named
exploring_a08_Grader_a1.accdb. Save the database as
exploring_a08_Grader_a1_LastFirst.

0

2

Create a new table in the database by importing the downloaded workbook named
a08c2Location.xlsx. Use the first row of the worksheet as column headings, set
LocationID as the primary key, and import the table as Location. Accept all other
default options. Do not save the import steps.

8

3

Create a table in the database by importing the downloaded text file named
a08c2Titles.txt. Use the first row of the file as field names, TitleID as the primary
key, and name the table Titles. Accept all other default options. Do not save the
import steps.

8

4

In the Employees table, add an Attachment field named Photo as the last field.

8

5

Add the downloaded image file KFleming.jpg for EmployeeID 3 to the Employees
table.

4

6

Add the downloaded image file PBrumbaugh.jpg for EmployeeID 17 to the table.
Close the table.

4

7

In the Location table, add a Hyperlink field named CityInfo as the last field.

8

8

Add the URL http://en.wikipedia.org/wiki/Atlanta as the CityInfo value for
Atlanta in the Location table.

4

9

Add the URL http://en.wikipedia.org/wiki/Pittsburgh as the CityInfo value for
Pittsburgh. Close the table.

4

Updated: 12/30/2013

1

A_CH08_EXPV2_A1_Instructions.docx

Office 2013 ? myitlab:grader ? Instructions

Exploring Series Vol. 2

Step

Instructions

Points
Possible

10

Open the Performance query in Design view (right-click the query in the Navigation
Pane and then select Design View). Add the newly imported Titles table to the
query window. Drag and drop the Title field over the Performance field in the query
design grid so that it is in the third field position. The query will calculate the raises
for the employees based on data in the Titles table.

8

11

Add the Photo field from the Employees table to the last position in the query. Run
the query to view the new salaries, bonuses, and employees on probation for poor
performance reviews.

8

12

Set the criteria in the query so that only employees on probation will display and
then run the query. Note that these employees will receive no bonus. Modify the
criteria to display employees who are not on probation. Run, save, and then close
the query.

8

13

Create a simple report based on the Performance query. In Layout view, delete the
Probation and PercentIncrease fields. Adjust the column widths so that they all fit
within the page, but the data is still visible.

8

14

In Design view, move the page numbering control to the left so that its right edge
is just inside the 7.5-inch mark on the horizontal ruler. Drag the right edge of the
report to the left so that it is just inside the 8-inch mark on the ruler. View the
report in Print Preview; the report should consist of five pages.

4

15

Modify the report title as Performance Reviews and delete the logo to the left of
the title.

4

16

Save the report as Employees in Good Standing and close the report. Export
the report as a PDF document using the same name and publish the report. Open
the report in your reader program and close the report. Do not save the export
steps.

4

17

Open the Performance query in Design view. Add the newly imported Location
table to the query window. Drag and drop the Location field over the LastName
field in the query design grid so that it is in the first field position. Sort the records
by Location in ascending order. Run, save, and then close the query. Compact and
repair the database.

8

18

Save the database. Close the database, and then exit Access. Submit the database
as directed.

0

Total Points

Updated: 12/30/2013

2

100

A_CH08_EXPV2_A1_Instructions.docx

Request A Fresh Paper Done For You!You are guaranteed plagiarism free paper within 3-8 hrs
About the author

classhelp24@gmail.com [email if you need fresh paper done]

What are you looking for?
Visit
  • HOME
  • ABOUT US
  • OUR SERVICES
  • HOW IT WORKS
  • FAQ
  • TESTIMONIALS
  • ORDER A CUSTOM PAPER NOW
  • CONTACT US
Happy Client Quotes
  • When I made the decision to seek help from you guys, I didn’t know I was making a choice that would positively change my life forever. I am so much more confident with my ability to go to work and still be able to finish my research paper on time. The research you guys did for me was great and I was highly awarded for it. I mean, all along I was having difficulty managing my time. It was so hard to decide what I ought to give priority, work or research? Thanks to you guys I can now go to work without worrying too much about how great my research should be. I am still the same person, just to be sure, but with lot of skills and ability, courtesy of feather essay. I wish you guys were around 30 years ago when I started doing research while still in school. Great research paper, thanks feather essays.

    Scott Williams, Chicago
  • Feather essays is awesome, really. I can’t just say enough about how well their services are custom-made to meet students’ needs. I mean have been using other services from different websites with erratic degree of satisfaction, but this is way too perfect. I’m thankful their team understand all about essays requirement. I had an essay assignment due in two days so I had to seek for their help, at first I thought they wouldn’t be able to do it perfectly since it was the first time I was using their service. Well, I guess I was wrong. Another thing I also liked about feather essays is how they communicate with clients, so simple, they made me feel at ease even though I was under pressure. From my standpoint, their platform is very intuitive, and it’s pretty much dummy-proof. Thanks to you guys I passed, it’s really hard to recommend anything but feather essays for quality service.

    Joseph Levoh, Phoenix University
  • I mostly do silly mistakes in term papers and essays, and while going through the instructions I used to get stuck after a few steps. I must say I always get annoyed whenever this happened and I had started doubting if I will make it through college. I had lost confidence in myself, I felt uncomfortable and unmotivated in doing assignments. One day I was just going through the internet looking for help with my essay, I found out about feather essay. I was not really sure if they could help me, but considering my situation I decided to give it a try. To say the least, I’ve never regretted making the decision. They are amazing, they offer instant help on assignment and term papers, and whenever I come across any assignment with doubts, all I do is talk to them. They instantly help me with my essays and explain to me everything about it. Thanks to you guys, you help me save a lot of time and concentrate on other class work.

    Eleona Miller, New York City
  • I’d never sought out for help with my essays before, so I was a bit uncertain how to go about it. All this doubts disappeared as soon as I talked to feather essays. You guys took your time to comprehend what my short term and long term needs were, and perfectly lined up different options for me. Considering the fact that I needed a quick response and solution, the options you guys offered were so organized. I thought the steps involved could take up several weeks or days, but I was surprised when all it took was less than four hours. I guess as soon as the agreement was made, the worked started immediately. The way you delivered that essay showed me how top class service professional you guys are. For quick essays help, I recommend you guys. The best thing is that you understand when a client needs more time to think. Thanks to you guys.

    Laurette, Ohio
  • Quick Essay Help

    I’d never sought out for help with my essays before, so I was a bit uncertain how to go about it. All this doubts disappeared as soon as I talked to feather essays. You guys took your time to comprehend what my short term and long term needs were, and perfectly lined up different options for me. Considering the fact that I needed a quick response and solution, the options you guys offered were so organized. I thought the steps involved could take up several weeks or days, but I was surprised when all it took was less than four hours. I guess as soon as the agreement was made, the worked started immediately. The way you delivered that essay showed me how top class service professional you guys are. For quick essays help, I recommend you guys. The best thing is that you understand when a client needs more time to think. Thanks to you guys.

    Diana Ross, California
  • Unique service and quality work!!!Feather essays not only offer wonderful essays but also helped me pass with flying colors!! I could not also believe it. And what makes me love them more is how work is done instantly after ordering!!i will never worry about school essays anymore. Absolutely the best!

    Sasha Kelly, Cleveland
Recent Posts
  • Week 7 – Assignment: Integrate Waste Elimination Techniques into Training Development (10 Points)
    June 5, 2019
  • (Let professional handle your assignment. Get an A) Cloud Architectures Application
    June 25, 2018
  • (Let professional handle your assignment. Get an A) Cloud Architectures Application
    June 25, 2018
  • (Let professional handle your assignment. Get an A) Cloud Architectures Application
    June 25, 2018
  • (Let professional handle your assignment. Get an A) Cloud Architectures Application
    June 25, 2018
  • (Let professional handle your assignment. Get an A) Cloud Architectures Application
    June 25, 2018
  • HOME
  • ABOUT US
  • ORDER A CUSTOM PAPER NOW
  • FAQ
  • CONTACT US
  • TERMS & CONDITIONS
  • CHEAP AND AFFORDABLE PRICES
footer

Copyright © 2015 FeatherEssays