Well, I will take a stab at this one:
1:Data from multiple tables. At the opening screen (Tables), click and drag the ,aster field from the master table to the corresponding field of the child tables. This established the master / Child relations. Click next and go to the Query page. Select the master table and the table info will appear in the field window. Click "Add Table" and call in the child tables. Select which filed you wish to use from the child tables. When you get to the editor the master fields and the chosen child fields will all be available in one place for you to work with.
2: The REPORT feature works well in cases where you ant a summary. Simply go the the first "Tables" page, select the table that you wish to use for your report and at the bottom click "Add Report" and click next. Choose which field you wish to be in the report and click next again. This page allows you to do groups and summaries for your report. When you get to the visual editor, you can rearrange the fields somewhat to customize how the report looks.
3: If you wish to edit a page using information from an existing talbe, there is a menu item at the top that lists all available fields. At the visual editor, simply place the curso where you want the field to appear, and go to the field list menu item and choose the field you want to add. If you want a field that does not yet exist, go back to the very first page (Tables), highlight the table that you wish to modify and right click on it. You can then choose MODIFY table, to add a field to it. When you do this, the new fiel will appear, but it will NOT be active, so you have to click it "Check mark will appear" by the field name. Do similarly at the query page and field list page, as needed for it to appear on the LIST, AD EDIT, SEARCH, etc. pages.
4: You may want to talk to someone about a better idea for security, but I would offer two suggestions. Fist, if the amount of data in the database is small, add an auto increment field (ID field) to the master table and a field in the child table to store the master ID number. Your first time through you will have to manually enter the master ID number in the child table and then link the tables to establish the relationships. Alrernately, if you have a lot of data in the tablers and don't want to do this, pick a common field in the master table and the child table (Like the person's name) and link them. There is a danger in this second solution, however. Say for example, you creat a master table and the child has a hundred entries. LAter you realize that you mispelled the name in the master table and change it. The link is not broken as there is no exact match in the child tables any longer. Also, if anyone mispells a new entry in a child entry, the link will not work. You can get around the second issue by using a drop down list box for entries on the child page, but it still does not guard against changes in the master table.
By the way, I amnot an expert on any of this myself, so I hope this has been helpful and not misleading.
Good luck
Arthur