• Have the ins_id be the primary key, and ensure the lastname and firstname are not null. Assign ins_id as type INTEGER, country as type CHAR(2), and rest of the fields VARCHAR.
• Insert one row into the INSTRUCTOR table for the instructor Rav Ahuja. Values for the character fields require a singe quotation mark (') before and after each value.
• Insert two rows for instructors Raul Chong and Hima Vasudevan.
• On the Create tab, create 2 simple queries using the query wizard.
• Save the database file as Instructor, as Access 2002-2003 Database.
• Once completed, upload the database file out of Apporto by clicking on the File Upload cloud icon in the Apporto menu bar.
•  

Transcribed Image Text:

ins_id 1 2 3 lastname Ahuja Chong Vasudevan firstname Rav Raul Hima city Toronto Toronto Chicago country CA CA US ins_id 1 2 3 lastname Ahuja Chong Vasudevan firstname Rav Raul Hima city Toronto Toronto Chicago country CA CA US

Answer rating: 100% (QA)

Step 1 Create the Instructor Table In Microsoft Access you can create a new database and then create ... View the full answer