• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Identifiers

An identifier usually is the name of an object; databases, tables, fields, queries, forms, and reports are objects in Access. Each object has a name that uniquely identifies that object. Sometimes, to identify a subobject, an identifier name consists of a family name (object class) separated from a given name (object name) by a bang symbol or a period (an identifier operator). The family name of the identifier comes first, followed by the separator and then the given name. SQL uses the period as an object separator. An example of an identifier in an SQL statement is as follows:

Customers.Address


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint