The assignment must be in Access or MDB format in a zip file.
Added by Rosa M.
Step 1
First, you need to create a database in Microsoft Access. Show more…
Show all steps
Your feedback will help us improve your experience
Ramesh Rajak and 84 other Macroeconomics educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Excel contains ____ tools not available in access.
Haricharan G.
2. Create a database named "school.mdb" and perform the following tasks: a. Create a table named "student info" having following table structure. Field Name | Data type | Description Class | Number | Section | Text | Roll no | Number | Name | Text | 40 characters long Status | Look up wizard | Two value: "senior", "junior" Photo | OLE object | Photos of students DOB | Date/time | Date of birth of students Remarks | Memo | b. Fill at least 5 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. e. Prepare a form of above query "senior". f. Prepare a report of all the fields of above table.
Madhur L.
Recommended Textbooks
Principles of Economics
Macroeconomics
Economics
Watch the video solution with this free unlock.
EMAIL
PASSWORD