Free E-Books

(You can??™t, however, have a table and a query with the
same name, because tables and queries occupy the same namespace in the database.)
Although simple names like Contacts and Orders are adequate, as a database grows in size and
complexity you may become confused about which object a particular name refers to. For instance,
later in this book, you??™ll read about manipulating database objects through code and macros.
When working with Visual Basic for Applications (VBA), the programming language built into
Access 2007, there must be no ambiguity or confusion between referenced objects. Having both a
form and a report named Contacts might be confusing to you or your code.
The simplest naming convention is to prefix object names with a three- or four-character string
indicating the type of object carrying the name. Using this convention, tables are prefixed with
tbl and queries with qry. The prefix for forms, reports, macros, and modules are frm, rpt, mcr,
and bas or mod, respectively.


Pages:
210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234