Free E-Books

You can move and resize the Field Lists anywhere in the top pane. Access saves the arrangement
when you save and close the query. Generally speaking, the Field Lists will appear in the same configuration
the next time you open the query.
Removing a table
There are times when you need to remove tables from a query. Any table can be removed from the
Query window. Use the mouse to select the table you want to remove in the top pane of the Query
window and press the Delete key. Or right-click on the Field List and choose Removed Table from
the shortcut menu.
When you delete a table, join lines to that table are deleted as well. When you delete a
table, there is no warning or confirmation dialog box. The table is simply removed from
the screen, along with any of the table??™s fields added to the QBE grid.
Adding more tables
You may decide to add more tables to a query or you may accidentally delete a table and need to
add it back. You accomplish this task by clicking on the Show Table button on the Query Setup
group in the Design ribbon.


Pages:
432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456