Rent A Coder Alert: If you are receiving an error that says: 'page not found', or 'system could not find the file specified' on this site, it is caused by a bug in your browser. Please click here to fix it. (To disable this alert, click here).

    How Software Gets Done  


(No Login on Secured Page)

Custom Software Buyers
Request new bids
Search Coders
My Account
 
My Buyer 'To Do' List
 
My bid requests
  My escrow account
 
My General Info
Verification
 
Help for Buyers
Articles for Buyers
FAQ for Buyers
Latest News
 

Custom Software Coders

Newest open work
Browse all work
Search all work
My Account
 
My Coder 'To Do' List
 
My bids
 
My General Info
  My credit account
 
Help for Coders
Articles for Coders
FAQ for Coders
Latest News
 

Affiliates

My account
 
My pipeline
 
My credit account
 
Help for Affiliates
Latest News
 
Newest Open Bid Requests.
Website Redesign
By kurtk on May 23
Max Bid: Open to fair suggestions


web page sports club
By mdelanders on May 23
Max Bid: Open to fair suggestions


Linux C programming (URGENT!!)
By AcidBurn on May 23
Max Bid: Open to fair suggestions


Logo, Splash, Screen Layout
By Kellog on May 23
Max Bid: $150


Content Management System
By dmillner on May 23
Max Bid: Open to fair suggestions


vb help
By innovate on May 23
Max Bid: Open to fair suggestions


Click here to put this ticker on your own site

Open Work Categories.
Database 
(154 open)
   Access 
(59 open)
   MySQL 
(75 open)
   Oracle 
(9 open)
   SQL Server 
(63 open)
   Other DB 
(22 open)
Documentation / Tech Writing 
(21 open)
Data Entry 
(20 open)
Game Development 
(21 open)
Graphics / Art / Music 
(66 open)
   Graphics 
(68 open)
     3d Animation 
(20 open)
   Art (Misc.) 
(24 open)
   Music 
(17 open)
   3d Modeling 
(17 open)
Language Specific 
(117 open)
   ASP 
(65 open)
   ASP .NET 
(17 open)
   C# 
(34 open)
   C++ / C 
(109 open)
   Carbon (Mac OS) 
(3 open)
   Cocoa / Obj-C 
(1 open)
   Cold Fusion 
(9 open)
   Delphi 
(35 open)
   Java 
(57 open)
   JSP 
(4 open)
   Perl 
(39 open)
   PHP 
(90 open)
   XML/XSL 
(24 open)
   Visual Basic 
(144 open)
   Visual Basic .Net 
(64 open)
   Other 
(55 open)
Misc 
(38 open)
   CAD 
(5 open)
MultiMedia 
(42 open)
Network 
(38 open)
   Network Design 
(10 open)
   Network Implementation 
(12 open)
Platforms 
(71 open)
   Windows 
(156 open)
     MS Exchange 
(3 open)
     MS Office 
(16 open)
     Other 
(13 open)
   Darwin 
(3 open)
   Internet Browser 
(42 open)
   Linux 
(56 open)
   UNIX 
(29 open)
   Hand Held/PDA Programming 
(12 open)
Requirements 
(11 open)
Security 
(33 open)
Testing / Quality Assurance 
(16 open)
Web 
(178 open)
   Page Design 
(93 open)
   Flash 
(64 open)
   Web Services 
(80 open)
   Web (Other) 
(100 open)
Training 
(11 open)
   Computer Based 
(14 open)
 
Other
 
Other Sites

Download the free Rent A Coder IE toolbar!
 
Show Bid Request

MS Access and SQL
Bid Request Id: 60450
Bookmark in my 'To Do' list
Posted by: Jennagrace (2 ratings)
(Software buyer rating 10)
Non-action Ratio: Very Good - 0.00%
Posted: Apr 29, 2003
8:09:12 PM EDT
Bidding Closes: May 1, 2003
8:12:24 PM EDT
Viewed (by coders): 321 times
Deadline: 5/4/2003
TIME EXPIRED
Phase:
100% of work was accepted by buyer. Coder account has been credited.
Max Accepted Bid: Bidding is closed
Project Type: Personal Project / Homework Help
Bidding Type: Open Auction
Categories: Windows, Database, SQL Server, MySQL, Access
Enter chat room for this bid request
(0 active users at May 23, 2003 8:17:06 PM EDT)

Description:
This project must be separated into four parts:
Part One
1. Create a Microsoft Access database that has two tables.
2. One table is employee information and contains the employee&'s social_security_number, name, address, telephone, email_address, job_title_code, hire_date and salary. Note: Do NOT use real employees and social security numbers.
3. The second table is job title information and contains job_title code, job_title, exempt or non-exempt status, minimum_salary and maximum_salary.
4. Enter 10 employees and five job titles.

Part 2

1. Using SQL, add 10 more employees to your database using SQL.
2. First, group employees by job code.
3. Then group employees by salary.
4. Then group employees by salary within job code.
5. Post the SQL statements and the results.

Part 3

Using SQL:
Group employees by salary within job titles that are grouped into exempt and non-exempt. Note: The words 'Group employees' indicate Employees (names) should be part of the result set.
Then use UNION to create a third table of employee names, job titles and salary. Print out SQL statements and the results.

Part 4

Using SQL:
1. Calculate the average salary for exempt employees and the average salary for non-exempt employees.
2. Post the SQL statements and the results.



Deliverables:
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Complete ownership and distribution copyrights to all work purchased.



Platform:
Windows 98/2000/XP

Must be 100% finished and received by buyer on:
May 4, 2003 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.


Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.
 
Bidding/Comments:
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests.

See all rejected bids (and all comments)
Name   Bid Amount 
 
Date   Coder Rating  
This bid was accepted by the buyer!
Randy McCleary
(96 ratings)
in Excelsior Springs, Missouri
United States
Bid id: 649,959
 
$20 (USD) Apr 29, 2003
11:25:01 PM EDT
 10
(Excellent)
   
Hey, this sounds like a simple project to complete for you. I'm very good at programming SQL and working with Access database. And would like to work with you again on this project. I can have this done for you, before you deadline so you can test it out and make any adjustments and also ask any questions that you may need to ask me.

Thanks,
Randy

 
 
 
 
  See 2 private reply(ies)
to/from Randy McCleary.
 




Quick Search
 

 Advanced Search
Newest Open Work
Latest News

 
Credentials


 

 
Rent A Coder upholds the rigorous business practices required to be both a BBB member and Square Trade vendor.
  • All customer issues addressed within 2 days
  • Openly disclosed pricing and return policies
  • Participation in mediation at buyer request
  • Superior selling track record
This site is verified through its parent company, Exhedra Solutions, Inc.
 

Rent A Coder Top Coders.


Securenext
Rated a 9.98 on 99 jobs 
Anuj Gakhar
Rated a 9.98 on 92 jobs 
Codman
Rated a 9.97 on 144 jobs 
Buddies
Rated a 9.82 on 76 jobs 
Andrei Remenchuk
Rated a 10 on 12 jobs 
Michael Sharp
Rated a 9.97 on 178 jobs 
RNA
Rated a 9.92 on 37 jobs 
markesh
Rated a 10 on 22 jobs 
teleCODERS
Rated a 9.93 on 67 jobs 
hernest
Rated a 10 on 109 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers
 
Other
Rent A Coder is PayPal verified through its parent company, Exhedra Solutions, Inc.

Created in partnership with:

 


Affiliate Sites



Latest News | About Us | Kudos | Feedback/Contact    Affiliates | Advertise    Privacy | Legal

Copyright © 2001, Exhedra Solutions, Inc. All rights reserved.
By using this site you agree to its Terms and Conditions.
"Rent A Coder" (tm), "Safe Project Escrow" (tm) and "How Software Gets Done" (tm)
are trademarks of Exhedra Solutions, Inc.