Access 2010: How To Insert Rows / Columns In Query Design

Access 2010 offers almost every control on the ribbon which you might need to use while setting up query in query design mode. Many a time while writing conditions for setting up query in a required way, new rows and columns are to be added. This post covers how to add new rows and columns in a query design.


To insert rows/columns in query design, open the query in Design View and head over to Query Tools Design tab, under Query Setup group, click Insert Rows for adding a row or click Insert Columns for adding a column.

1083d1277899249-how-insert-rows-columns-query-design-1

Advertisement
  • Shakil

    Very nice information. But I am not getting query tool. would you please show me the way?