Close Office Assistant ñ Use CTRL+INSERT+F4 to close the Office Assistant as you would in other Office applications.

Create Join ñ Use CTRL+SHIFT+J to create a join in the Query.

Design View Grid. This is accomplished by pressing the keystroke once on the Source field and then again on the Destination field. To clear the join setup process, press CTRL+INSERT+C after the first press of CTRL+SHIFT+J. This function only works in the Query Design View grid and is subject to the normal Access 2000/97/95 constraints.

Create Relationship ñ Use CTRL+SHIFT+C to create a relationship between the source and destination fields and tables. This is accomplished by pressing the keystroke once on the Source field in the Source table, and then again on the Destination field. To clear the relationship setup process, press CTRL+INSERT+C after the first press of CTRL+SHIFT+C. This function only works in the Relationships screen accessed from the Tools menu and is subject to the normal Access 2000/97/95 constraints.

Delete Relationship ñ Use CTRL+DELETE to delete a relationship between the source and destination. When in the Relationships screen, focus on the list box and the participating item of the relationship, and then press CTRL+DELETE to delete. You can confirm whether a field participates in a relationship by using the INSERT+UP ARROW (Say Line) keystroke.

Note: Caution should be used when deleting relationships. Using this keystroke will delete the first relationship in which the field participates. This means that if the field participates in more than one relationship and you intend to delete the second relationship, it is better to move to the other table and the field in that table which forms the other half of the second relationship (providing this field in the second table only participates in one relationship) and delete the relationship from this table. If the field making up the other half of the relationship also participates in more than one relationship, sighted assistance may be required unless you delete the first relationship, then the second, and then recreate the first.

Read Active Report ñ Use CTRL+SHIFT+R to read the active report.

Read Data Sheet Coordinates ñ Use INSERT+C when in a datasheet, this keystroke reads the location row and column number.

Read Form In Control Order ñ Use CTRL+SHIFT+F to read the active form and any sub-forms in control order. The order depends on how the form was designed. This keystroke also works in all wizard forms.

Rel And Join Clear Values ñ Use CTRL+INSERT+C clears the JAWS stored value for the source of a join or relationship. This is similar to frame Clear Values in Default.

Screen Sensitive Help ñ Use INSERT+F1 for help in most areas, including the wizard and design view screens. This keystroke will also give you valuable information about the field you are in when entering data into a table. The information includes the field name, data type, size in characters, ordinal position, total number of fields, and whether data in this field is required or optional. In verbosity levels higher than Beginner, this information is trimmed down, but still includes important information.

Select Form Control ñ Use CTRL+SHIFT+L to list all of the controls on the current form. You can also use this keystroke to select and focus on a control (provided the control can receive focus). If you select a sub-form control, then another list opens where you can select a sub-form control.

Select Tool Box Control ñ Use CTRL+SHIFT+B to select a toolbox control to place on a form or report in design view.

Speak Database Summary ñ Use CTRL+SHIFT+D to speak a summary of the open database, including the name and number of objects. Objects include tables, queries, modules, relationships, forms, and so on.

Speak Relationship ñ Use INSERT+UP ARROW (SAY LINE) to speak details about a relationship. This keystroke only works in the Relationships screen that is accessed from the Tools menu. For example, you can use this keystroke in the Relationships screen of the Northwind database that comes with Microsoft Access 2000/97/95 to provide the location of fields. For instance, if you press INSERT+UP ARROW when the Supplier ID field is selected in the supplier table, JAWS tells you that the Products table references this field. Similarly, if you press INSER+UP ARROW when the Product ID field in the Products table is selected, JAWS tells you that the Order Details table references the Product ID. Pressing INSERT+UP ARROW when the Product ID field is selected in the Order Details table causes JAWS to say that Product ID references the Product table. So, JAWS tells you both when a field references another table and when another table references it. If the verbosity is set to anything higher than Beginner, a trimmed down version of the same information is spoken, for example, the table name containing the selected field is left out ñ it is assumed that it is already known.

Speak Table Summary ñ Use CTRL+SHIFT+T to hear a summary of the table currently displayed, including the name, data type, size, and total number of fields.

Spell Check ñ Use INSERT+F7 to repeat spell checker information.

Toggle Label Search ñ Use INSERT+F8 to toggle Label Search ON/OFF.