Microsoft Access 2010 Bible

Part III: More-Advanced Access Techniques

650

FIGURE 18.13

The Object Designers tab of the Access Options dialog box

TABLE 18.1

Query Design Options

Option Purpose Default

Show Table Names Shows the Table row in the QBE pane when set to Yes. Yes

Output All Fields Shows all fields in the underlying tables or only the fields displayed in

the QBE pane.

No

Enable AutoJoin Uses common field names to perform an automatic join between

tables that have no relationships set to occur. The tables must have a

field with the same name and type of data and one of the fields must

be a primary key field.

Yes

Query Design Font Used to set the Font type (name of font) and the size of the font used

in queries.

Segoe 8

SQL Server Compatible Select this database to enable ANSI-92 SQL query mode so that you

can create and run queries using ANSI 92 SQL syntax. ANSI 92 is

compatible with Microsoft SQL Server. Existing queries may not run

correctly if you set this option after creating other queries.

No