Once you have successfully created a database connection.
Select File->New, choosing PHP from the Dynamic Page category, then select the Bindings panel and click the Plus sign to define a new Recordset.
Provide the Recordset a Name, and select your Connection from the pull-down menu. A full list of the tables in your database is now made available in the Table menu, and you can select the table you wish to use.
You can use advanced queries, including multi-table joins can be defined using the Advanced option.