Exp19_access_ch08_cap – performance 1.0 | Computer Science homework help

  

Exp19_Access_Ch08_Cap – Performance 1.0

  

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.

     

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

 

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.

 

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.

 

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

 

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

 

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

 

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

 

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

 

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

 

Add   the Location and Titles tables to the Relationships window. Join Location and   Employees by their common field, enforcing referential integrity. Join Titles   and Employees by their common field, enforcing referential integrity.

 

Open   the Performance query in Design view (right-click the query in the Navigation   Pane, and select Design View). Add the newly imported Titles table to the   query window. Drag and drop the Title field from the Titles table over the   Performance field in the query design grid so that it is placed to the left   of the Performance field. The query calculates raises for the employees based   on data in the Titles table.

 

Add   the Photo field from the Employees table to the last position in the query.   Run the query.

 

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. Employees   whose performance is good or excellent will receive a bonus. Run, save, and   then close the query.

 

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.

 

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 two   pages.

 

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

 

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.

 

Open   the Performance query in Design view. Add the newly imported Location table   to the query window. Drag and drop the Location field from the Location table   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.

 

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

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more