rptClient

Name - Current Due - ClientNum - Amount Paid
Blant and Sons - $892.50 -BS27 - $21,876.00
-Calder Plastics - $0.00 - CP27 - $8,725.00
-Center Services - $2,672.00 -CE16 -$26,512.00

Queries in Ashton James College Database

List all Client Names with Trainer number 48 or the client name MORGAN-ALYSSA in ascending order .

Answer:
Which clients take their training form trainer number 48?
Telton-Edwards
Center services
Fairland Lawn
Calder plastic
Hurlet National

(SELECT tblClient.ClientNum, tblClient.Name, tblClient.[Trainer Number]FROM tblClientWHERE (((tblClient.[Trainer Number])="48"))ORDER BY tblClient.Name, tblClient.[Trainer Number] DESC;)
Arrange client name in descending order.
Telton-Edwards
PRIM Staffing
Morgan-Alyssa
Hurlet Nationa
Farrow-Idsen
Fairland Lawn
Elba's Furniture
Elba's Furniture
Center Services
Calder Plastics
Blant and Sons
(SELECT tblClient.ClientNum, tblClient.Name, tblClient.[Trainer Number]FROM tblClientORDER BY tblClient.Name DESC;)

if (window['tickAboveFold']) {window['tickAboveFold'](document.getElementById("latency-7146641217945988796")); }

structure of training table

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

Structure of Ashton James College

Ashton James College

Client Number - Text
Name - Text
Address - Text
City - Text
State - Text
Country - Text
Amount Paid - Currency
Current Due - Currency
Trainer Number - Text

Planning a structure

Planning a structure for Airline Booking System

-passenger number = Auto Number
-last name = Text
-first name = Text
-age = Number
-sex = Text
-nationality = Text
-phone number = Text
-passport number = Text
-address = Text
-Proffesion = Text

Database

What is database?

-A collection of data that is stored in a computer
-Can be easily used and added

Example of a database

-Stock Market

-Student Profile


Planning a database for a developer

ØIs there any plot available?
ØWhat is the price?
ØSize of the plot
ØShape of the plot
ØLocation
ØHas any other customer registered this plot, deposit ( $100 )
ØFacilities
ØType of property

Hello

Hello My name is Alex.
I am a student in kis. This blog is an educational blog. Specifically, this term we are going to discover the new learning experience through blogging in the information & communication technology class. ( Also known ICT)

I WELCOME EVERYONE~~