Navigate tables with these keyboard shortcuts
The most common method for moving around a table is to click the specific cell you want to go to. However, if the table contains many rows and columns across a page, you could spend a great deal of time scrolling.
Word provides a number of keyboard shortcuts for quickly moving around large tables. Here are some examples:
Ensure all cells are empty before deleting a column or row
Before deleting a row or column that appears to be empty, it's a good idea to check beyond the screen view to ensure that all the cells are really blank. While you can scroll to the end of a column or row, it can be much quicker to use keyboard shortcuts.
To check whether a row is empty, follow these steps:
To check whether a column is empty, follow these steps:
Omit records with duplicate field entries in a query
You can create a query that returns only those records that don't contain duplicate data in a field. For example, suppose you want to query the Orders database to determine the total number of households in New Jersey that placed orders last year.
Since the Orders database includes multiple records for each address, you want to set the query properties so it includes each household only once in the query results.
Follow these steps:
If the query output includes the address and name fields for each order, Access will include only those records with unique address fields in the output.