If you have a table open look down the tasks - one of them is "Filter Rows" click that and it will switch to a view where you can enter a filter. If its an actual query you want just click New on the toolbar.
It takes a bit of time to make the switch from DBSys.
If you have any suggestions for improvements to the design feel free to post to the suggestions newsgroup.