Microsoft Access queries are useful in showing specific raw data records in a specific order or grouping. Editing is limited for a query format, which comes from a larger database table containing records. For advanced formatting and a more presentable display, the reports function is a better choice. Editing an Access query, using the design view, allows you to insert blank columns and modify other design changes, however, you should realise how they will affect your table and other data associated with the database.
- Skill level:
Other People Are Reading
Open the Access database containing the query to which you wish to add a column. Select "File" and "Open" and highlight the file you wish to open and click "Open."
Open the query by double-clicking it from the navigation pane on the left side of your screen. The navigation pane will show all tables, queries, reports and forms within the Access database file.
Edit the query from the design view by selecting the "Home" tab and clicking "Design View" from the "View" group. Use the command in the "Query Set-up" group to insert a blank column into your Access query.
Rerun your query by clicking "Run" from the "Results" group with these updates. Save by selecting the "Save" icon from the quick access toolbar at the top left of your screen.
Add data directly to the new blank column in the query as you need. Changes you make to the query will also change automatically in the associated database table.
Tips and warnings
- Changes to data design is better accomplished in the database tables or reports. Queries are best for viewing records but not designed for advanced formatting, rather a display of raw data.
- Creating a new query using the wizard may be quicker than manually adding multiple design changes to an existing query.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for