Ivy's report- rptCLient

Client Payment Details

ClientNumber - Name - Current Due - Amount Paid
IB44 -Baik Ivy - $0.00 - $0.00
BS27 - Blant and Sons -$892.50 - $21,876.00
CP27 - Calder Plastics -$0.00 - $8,725.00
CE16 -Center Services -$2,672.00 - $26,512.00
EU28 - Elba's Furniture -$1,202.00 - $4,256.00
FL93 -Fairland Lawn -$0.00 -$21,625.00
FI28 -Farrow-Idsen -$925.50 -$8,287.50
HN83 -Hurley National -$0.00 -$0.00
MC28 -Morgan-Alyssa -$1,572.00 -$24,761.00
PS82 -PRIM Staffing -$2,827.50 -$11,682.25
TE26 -Telton-Edwards -$0.00 -$8,521.50

HW

Display all Client name whose trainer number
is "48"or Client name is "Morgan-Alyssa

SQL
Select tblclient .ClientNum,
tblClient.Name,tblClent.[Trainer Number]
FROM tblClient
WHERE(((tblClient.[Trainer
Number])="48"))OR
(((tblClient.Name)="Morgan-Alyssa"))
ORDER BY tblClent.Name;

hw

• CLIENT NUMBER-text
• Name-text
• ADDRESS-text
• City STATE -text
• Zip Code-text
• Amount Paid-number
• Current Due-text
• Trainer Number-number
  
  

creating additional tables

FIELD NAME DATA TYPE FIELD SIZE PRIMARY KEY DESCRIPTION
Trainer Number TEXT 2 YES Trainer Number (primary Key)
Last name TEXT 10 NO Last Name of Trainer
First Name TEXT 8 NO First Name of Trainer
Address TEXT 15 NO Street Address
City TEXT 15 NO City
State TEXT 2 NO State (Two-Character Version)
Zip Code TEXT 5 NO Zip Code (Five-Character version)
HOurly Rate Currency Hourly Rate of Trainer
YTD Earings Currency YTD EARnings of Trainer

home work

Field names Data Type

Passenger Number(PK) Auto number

Last name Text

First name Text

Phone number Text

Sex Text

address Text

Planning the structure of table Passanger

Field names Data Type
Passenger Number(PK) Autonumber
Lastname Text
Firstname Text

Planning the Studnets

Student Number(PK)
Student First name
Studnet Last name
Phone number
Address
E-mail
Sex

Y:\2008-2009\year9\Ivy Baik\Term2

C:\Documents and Settings\User\桌面\access

what is database?

collection

explain of a database?


How much is the land?
What is the coast of the land?
How big is the land?
Good land?
Size of the land?
Can I build a house there?
Some one live there?
What is the location?