Meaning of symbols used in access

[JackG]

In each window (Table, Query, etc.) there is a symbol/icon infront of each
object . Where can I get a definition of what these symbols/icon mean. In
Table view you have two blue table and sometimes you have an arrow in front
of the table - I know this means the table is linked. What do all these type
of symbols mean in the other windows, there are many I have no clue. For
example, in Query what does a green + with an ! mean, what does a red X!
mean.

Knowing what these symbols mean would be very helpful but I have not found
any information in books or on-line. Also, what are they called -
icons/symbols?
Thanks,

Jack G.

 

[Ken Sheridan]

Jack:

The exclamation mark indicates its an 'action' query, i.e. changes data.
The green + sign is an 'Append' query (inserts rows into a table); the red
cross is a Delete query (deletes rows from a table). There's also a yellow
pencil (I think that's what it is) symbol, which indicates an Update query
(changes existing data); a table with radiating yellow lines at its top right
corner which indicates a 'Make Table' query (creates a new table from data in
an existing table; something which looks like a miniature spreadsheet which
indicates a 'Cross Tab' query, and linked rings which indicates a 'Union'
query.

I don't know that they have an official name or if there's a comprehensive
list of them anywhere. To identify a symbol all that's necessary s to open
it the object design view and see what it is.

Ken Sheridan
Stafford, England

 

[Arvin Meyer [MVP]]

A green + is an Append Query, a red X is a Delete query, an Exclamation
point and pencil is an Update Query, an Exclamation point and a datasheet
with highlight is a Make-Table query, a Crosstab query is a single
datasheet, a Data Definition Query is a green triangle and pencil.

Links to other databases show up in Tables as other symbols depending upon
which type of database it is.

 

[John Spencer]

If you display the TYPE column you will see the definition that matches the
"icon". Simply click the detail button in the database window to see that
information.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County