Reports in Ashton College Database (Report name-Client Payment details:rptClient

Client number -Name -Amount paid -Current Due
BS27 -Blant and sons-21,876.00-892.50
CP27-Calder plastics-8,725.00-0.00
CE16-Center services-26,512.00-2,672.00
EU28-Elba's Furniture-4,256.00-1,202.00
FL93-Fairland Lawn-21,625.00-0.00
FI28-Farrow-idsen-8,287.50-925.50
HN83-Hurley national-0.00-0.00
MC28-Morgan-Alyssa-24,761.00-1,572.00
PS82-PRIM staffing-11,682.25-2,827.50
TE26-Telton-Edwards-8,521.50-0.00

Queries in Ashton College Database

Client names with Trainer number 48 in ascending order:

Blant and Sons
Calder Plastics
Center Services
Elba's Furniture
Fairland Lawn
Farrow-Idsen
Hurlet National
Morgan-Alyssa
PRIM Staffing
Telton-Edwards

Structure of Client table, Structure of Trainer table

Structure of Client table

• Client Number (Text)
• Name (Text)
• Address (Text)
• City (Text)
• State (Text)
• Zip Code (Text)
• Amount Paid (Currency)
• Current Due (Currency)
• Trainer Number (Text)

Structure of Trainer table

• Trainer Number (Text)
• Last Name (Text)
• First Name (Text)
• Address (Text)
• City (Text)
• State (Text)
• Zip Code (Text)
• Hourly Rate (Currency)
• YTD Earnings (Currency)

Structure of Airline Passenger

• Passenger ID
• Surname
• Firstname
• Contact
• Emergency contact number
• Passport ID
• Birth of date
• Family
• Country
• Nationality
• Age
• Address