Discussion on:
View:
Show:
Are you familiar with all the techniques included in this list or were some of them a surprise? What other tricks come in handy when you're working in the Query Design windows?
SQL View and learning what I'm doing!
Learn SQL first, if you want to do professional development. Adhoc stuff by power users fine, that's what access was designed for in the first place and it's damn good at it.
Way way back when, I remember giving up trying to find the menu option for Select Distinct and going to SQL view, never bothered with query builder again.
I write better SQL than it does anyway.
Learn SQL first, if you want to do professional development. Adhoc stuff by power users fine, that's what access was designed for in the first place and it's damn good at it.
Way way back when, I remember giving up trying to find the menu option for Select Distinct and going to SQL view, never bothered with query builder again.
I write better SQL than it does anyway.
When building a query that will be used repeatedly with different source tables (e.g., a new table each month), it is often easier to base the query on a secondary query that is a simple select all query. By doing so you only need to change the secondary query's select statement in the SQL window and you never need to modify the primary query.
These tips can be applied to Access 97 that's a decade old! Anything newer that say Access 2007 uses?
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
