This auction is ONLY for somebody who knows something about **airliners. ** You dont have to know too much, but perhaps you are an airplane fan - that is enough.
Enclosed is a zip file with an access database. You only need to worry about two tables:
AIRCRAFT
and
MODELS
Your job is to fill in the "AircraftID" field of table MODELS as well as you can by matching the aircraft of the aircraft table to the model of the models table.
Your job is to match them as closely as possible. NOT ALL AIRCRAFT IN THE AIRCRAFT TABLE WILL HAVE MATCHES in the models table, and maybe not all matches in the models table will have matches in the aircraft table.
some aircraft in the aircraft table will have MORE THAN ONE match in the models table.
It takes some aircraft knowledge to make a good "best guess" of which aircraft match. For example, modelID 9-15 (all 24, 24X, etc) correspond to Lear 24, which is AircraftID #705 (so you would put "705" next to all of those in the aircraft table).
It's like a game - see how many you can do.
If one absolutely does not have a match in the Aircraft table, put "0" As the aircraft Id.
If one might have a match, but you are not sure which one it might be, put "9999" as the aircraft ID.
you can use sites like [login to view URL] and boks to help you with this.
Thank you for your bids. There are approximately 1578 records that you need to do. Because many are "clustered", I suspect that this job will take about 2 or 3 hours.
Thanks,
Adrian
## Deliverables
mdb file with models table completed.
## Platform
mdb, etc.