Edit Button (Worksheet)

The Worksheet Edit button gives us a quick way of launching Microsoft Access's own Query Designer, ready to edit the SQL from the current Worksheet. Microsoft's Query Designer does after all have many strengths. It's relatively easy to add fields into a datasheet using this tools, and adapt queries in many other ways.

We'll walk through a basic example for those less familiar with the tool. Once we've typed a question into the Worksheet, like "When was each employee hired?", we get a response which displays the HireDate, EmployeeID and LastName of each Northwind staff member. We could include additional information in the display by clicking Edit. The Microsoft Access Query Designer presents us with a list of available fields, such as Title, Home Phone, etc. We select the ones we want to add by double-clicking. If we've made changes or additions in this way, closing the Query Designer now prompts us to confirm the changes. If we agree, Access ELF rewrites its Worksheet SQL based on your changes then runs the modified query.