Access 2002 Programming by Example

Creating a List of Objects

The Name and Type fields are accessed by the TableOfTables query. They are the keys to setting up a query accessing database objects. The type of object list you want is determined by the Type field and, of course, the object you want is determined by the Name field. The Name field is also where the system objects are excluded by using a wildcard in the criterion. Reverse the changes you just made in Tools, Options, View and take the following steps to examine and run the query:

1.	Open the TableOfTables query in Design view.
2.	Click the drop-down box of the View button and switch to Design view. Notice the Name column criterion excludes the system tables by using Not Like MS* for criterion. Notice also that the ...