Desire Data Execute

[Eeshan]

Hi,

It is possible to execute desire data from a table which has All details, like below


and want to execute only Class 5 and ExamType Annual



If i select under Class only 5 and ExamType Annual

then it should execute like below table



under access.........




Thank You.....................

[offie]

So you want to make a table and run a simple query?

This is super easy, look into some tutorials.

Make a table:
Enter the information in the same way as the pictures, the grey cell is where you want to add the title, these are called fields

Make a query:
Create> Query Design
Double click on the table you just made
In the box that shows up in the gray space, click all the fields you want (in you case all of them)
In the white table below, set the criteria in the Criteria row
Enter 5 and press enter and it will automatically make it into "5", this is what you want
Do the same for anything you want to choose.

If you want to make user-friendly form, buttons and selections, it's not that hard but I'm not going to explain it. Look up how forms work, how to search with textboxes, check boxes and option buttons et cetera

[Eeshan]

Exactly I want to make it user friendly where i dont want to show Mastertable data and Security protection on Mastertable..

User can use only grey box and after execute data will extract as per the selection.

Plz help me ........

Thank you in Advance...............

[offie]

Seriously, this is very basic stuff, have you even tried to learn access?
Just look up simple video on how to make a search form.

Make the table, make the query, then make a form.

Form:
Create > Create blank form
Make either unbound text boxes or combo boxes, name them (in properties)
>> If you want to use combo boxes, I would make another table that has all of the possible selections, but only once, then make the combo lists from that separate table.
Go back into the query and change the Criteria to match what you just made
Ex: [Forms]![FormName]![Combo or text box name]
Drag and drop the query onto the form
Test it

[Eeshan]

i want to make it as app from where we can see only above menioned grey box and hidden master table...if it is possible in other way which is offline work plz suggest..

[offie]

What? Ya, when there is a form all you see is what is on a form when the form is opened, you can make it so that the form opens automatically when you open the file (File> Option> Current Database > Display Form).

What do you mean by offline? What is it that you want to do exactly? If you don't understand how access works, please take the time to learn.

When you say app, you just mean program right? Are you looking to share this somehow or something?

[offie]

Here. If you actually want to learn how to use access, try to recreate it.