Click on Queries in the left pane and then click Create Query in Design View. A new window will open, prompting you to Add Tables or Query (Figure B). Figure B.

In Microsoft Access, fields can be added and removed from the list of available fields. Learn how to add or delete a Field in Design View in Access.

Effectively maintaining an Access database requires the regular removal of duplicate records. The Find Duplicates Query wizard handles this chore quickly and easily. When maintaining an Access ...

When you have to scroll to the right to view all of the data on a wide Access query or report, ... Highlight a table in the table list, click "Create" and double-click "Query Design." ...