Question: Create a database named school. m d b ? and perform the following tasks: a . Create a table named student info having following table
Create a database named "school. and perform the following tasks: a Create a table named "student info" having following table structure. tableField Name,Data type,DescriptionClassNumber,SectionText,Roll noNumber,NameText, characters longStatusLookup wizard,Two value: "Senior" "Junior"PhotoOLE object,Photos of studentsDOBDatetimeDate of birth of studentsRemarksmemo, b Fill at least records. c Prepare a query to display all records and Name should be in ascending order. d Prepare a query named "senior" to display records including fields name, class, sec roll no status, photo and value of "status" field must be senior. Create a database named "library.mdb and perform the following tasks: a Create a table named "Book" having following structure: tableField name,Field datatype,DescriptionBookidText,tablePrimary key. Book identificationnumberBnameText,Book nameWnameText,Writer's n
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
