The Source List shows all tables, queries, forms, reports and scripts in a database. It works very much like the Overview. At the bottom of the source list are up to four context sensitive buttons.
Items
The source list shows every item in the database. There are five headers corrisponding to the five different types of items.
Double clicking a header will, by default, create a new item of the type of that header (with the exception of queries). However, the source list can also be set to expand/collapse the header when it is double clicked or to do nothing. These settings are in the UI > Source List section of Preferences.
Double clicking an item under a header will open it. For tables, it will open in table data view. For queries it will open in table data view with the queries pane open. For forms it will open in form data view. For reports and scripts it will open in their respective editors. Holding alt down while opening a table or form will open it in design view.
Buttons
The source list has five buttons which are shown context sensitively based on selection. If nothing is selected, no buttons will be shown.
If a header is selected, the add button will be shown (with the exception of queries which has no plus button). If a table or form item is selected, the add, delete, design and edit buttons will be shown. If a query item is selected, the delete and design buttons will be shown. If a report is selected, the add, delete and edit buttons will be shown. If a script is selected, the add, delete, edit and run buttons will be shown. Below is a table of what buttons are shown and when:
| Button 1 | Button 2 | Button 3 | Button 4 | |
|---|---|---|---|---|
| Headers (ex queries) | Add | |||
| Query Header | ||||
| Table | Add | Delete | Design | Edit |
| Query | Delete | Edit | ||
| Form | Add | Delete | Design | Edit |
| Report | Add | Delete | Edit | |
| Script | Add | Delete | Edit | Run |
Misc
At the bottom left of the source list is a resize handle. Drag it to make the source list bigger or smaller.
Each header can be expanded or collapsed by pressing the triangle to the left of the header's title.
The source list can be set to only show small icons, or to only show headers. These settings are in the UI > Source List section of Preferences.