Færdiggjort

Homework issue

Start Access, and then open the FirmPays database located in the le4 folder of the ZIP file included. Open the query named " June 2". View the query in SQL, and answer the following questions:

1.

2. Which tables are used in the query?

3. Which fields are displayed in the query results

4. What type of join is used between the tables

5. What selection criteria are used?

Then write a query in SQL in the FirmPays database that fulfills the following parameters:

*

* Displays the AmtPaid, Firm#, DatePaid, and Payment#

* Selects firm number 1115 and DatePaid between 6-1 and 6-10

* Results should be ordered by payment date

<!-- -->

*

* Submit your answers to questions 1-4 and your SQL statement to your instructor via the drop box under Unit 4 Individual Project.

## Deliverables

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

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

This needs to run on Acess 2000 or 2003

Evner: Ingeniørarbejde, Microsoft Access, MySQL, PHP, Software Arkitektur, Software Testning

Se mere: what is selection criteria, the hire firm, named query, issue payment, selection criteria, engineering selection, acess, project instructor, software issue, law firm database project, sql questions answers, selection criteria statement, law firm access database, submit issue, write software firm, php join tables, sql query access database, access acess php, needs instructor, write view sql

Om arbejdsgiveren:
( 7 bedømmelser ) United States

Projekt ID: #3316224

Tildelt til:

TakeReal

See private message.

$7 USD på 1 dag
(1290 bedømmelser)
7.5

17 freelancere byder i gennemsnit $6 på dette job

Steel9561

See private message.

$3.4 USD på 1 dag
(197 bedømmelser)
6.7
webtechpk

See private message.

$7.65 USD på 1 dag
(189 bedømmelser)
6.1
sergruch

See private message.

$8.5 USD på 1 dag
(84 bedømmelser)
5.4
shahidriazonline

See private message.

$5.1 USD på 1 dag
(17 bedømmelser)
4.4
expertphpcodervw

See private message.

$4.25 USD på 1 dag
(10 bedømmelser)
3.7
nhasan

See private message.

$5.95 USD på 1 dag
(3 bedømmelser)
3.0
awaisfarid

See private message.

$8.5 USD på 1 dag
(7 bedømmelser)
3.2
vnicky

See private message.

$6.8 USD på 1 dag
(15 bedømmelser)
2.8
raojune

See private message.

$6.8 USD på 1 dag
(7 bedømmelser)
2.4
rodionmironov

See private message.

$3.4 USD på 1 dag
(3 bedømmelser)
2.2
esafesystems

See private message.

$8.5 USD på 1 dag
(6 bedømmelser)
1.7
mrabbaa

See private message.

$5.1 USD på 1 dag
(0 bedømmelser)
0.0
ippy

See private message.

$5.1 USD på 1 dag
(0 bedømmelser)
0.0
jeet232vw

See private message.

$5.1 USD på 1 dag
(0 bedømmelser)
0.0
quickshotvw

See private message.

$4.25 USD på 1 dag
(0 bedømmelser)
0.0
stealthcoder

See private message.

$5.95 USD på 1 dag
(0 bedømmelser)
0.0