Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started