%3CLINGO-SUB%20id%3D%22lingo-sub-1325711%22%20slang%3D%22en-US%22%3EFeast%20your%20Eyes%20on%20our%20Access%20Query%20Improvements!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1325711%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EOne%20of%20Access%E2%80%99s%20most%20powerful%20capabilities%20is%20querying%2C%20which%26nbsp%3Bpulls%20information%26nbsp%3Bfrom%20many%20tables%20to%20assemble%26nbsp%3Band%20connect%20data%20points%26nbsp%3Bthat%26nbsp%3Bcan%20then%20be%20arranged%20into%20a%20form%20or%20report.%20Several%20Access%20customers%20have%20successfully%20leveraged%20queries%20to%20generate%20better%20insights%20and%20make%20mission-critical%20business%20decisions.%20They%20have%20also%20learned%20quite%20a%20bit%20more%20about%20its%20deeper%20technical%20functionalities%26nbsp%3Bover%20time%2C%20including%20its%20ability%20to%26nbsp%3Bperform%20calculations%2C%26nbsp%3Bautomate%20data%20management%20tasks%2C%26nbsp%3Bor%20add%2C%20change%2C%20and%20delete%20data%20from%20an%20existing%26nbsp%3Bdatabase.%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EBecause%20of%20its%20significance%20in%20creating%20successful%20Access%20applications%2C%26nbsp%3Bthe%20Access%20team%20is%20proud%20to%20announce%20the%20following%20enhancements%20to%20the%20Querying%20user%20experience.%3C%2FSPAN%3E%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3E%3CSTRONG%3EFind%20and%20replace%20dialogue%20in%20SQL%20View%20%E2%80%93%20%3C%2FSTRONG%3Eyou%20can%20now%20search%20for%20and%20replace%20SQL%20text!%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ebo_Quansah_0-1587487000385.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F185633iF56AD5EA40E249F9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Ebo_Quansah_0-1587487000385.png%22%20alt%3D%22Ebo_Quansah_0-1587487000385.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%20start%3D%222%22%3E%0A%3CLI%3E%3CSTRONG%3EMouse%20Wheel%20scroll%20in%20relationship%20window%20%E2%80%93%20%3C%2FSTRONG%3Eyou%20can%20now%20scroll%20vertically%20and%20horizontally%20(SHIFT%20%2B%20Scroll)%20in%20your%20relationship%20window%20as%20well%20as%20in%20SQL%20view%20with%20your%20mouse%20wheel.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%20start%3D%223%22%3E%0A%3CLI%3E%3CSTRONG%3ERight-clicking%20a%20table%20to%20design%20and%20size%20it%20and%20open%20in%20design%20view%20%E2%80%93%20%3C%2FSTRONG%3Ewe%20have%20implemented%20additional%20right%20click%20options%2C%20including%20the%20ability%20to%20open%20the%20table%20in%20design%20view%2C%20and%20to%20automatically%20size%20the%20table%20based%20on%20its%20corresponding%20text.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ebo_Quansah_1-1587487000395.jpeg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F185635iFDC5D75FC877D35D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Ebo_Quansah_1-1587487000395.jpeg%22%20alt%3D%22Ebo_Quansah_1-1587487000395.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%20start%3D%224%22%3E%0A%3CLI%3E%3CSTRONG%3EAuto-size%20tables%20by%20double%20clicking%20its%20edge%20%E2%80%93%20%3C%2FSTRONG%3Eyou%20can%20also%20auto-size%20your%20table%20by%20double%20clicking%20its%20edge.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3COL%3E%0A%3COL%3E%0A%3COL%3E%0A%3CLI%3EDouble%20click%20right%20edge%20to%20auto-size%20horizontally.%3C%2FLI%3E%0A%3CLI%3EDouble%20click%20bottom%20edge%20to%20auto-size%20vertically.%3C%2FLI%3E%0A%3CLI%3EDouble%20click%20bottom%20right%20corner%20to%20auto-size%20both%20horizontally%20%2B%20vertically.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3C%2FOL%3E%0A%3C%2FOL%3E%0A%3COL%20start%3D%225%22%3E%0A%3CLI%3E%3CSTRONG%3EMultiple%20table%20select%20in%20the%20Relationships%20window%20%E2%80%93%20%3C%2FSTRONG%3Eyou%20can%20now%20select%20multiple%20tables%20at%20once%20and%20perform%20various%20actions%20on%20them%20in%20a%20relationship%20window.%20Selected%20tables%20are%20highlighted%20in%20red%2C%20as%20shown%20below.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ebo_Quansah_2-1587487000402.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F185634iAD63F7BEBD5B9BAF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Ebo_Quansah_2-1587487000402.png%22%20alt%3D%22Ebo_Quansah_2-1587487000402.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20is%20just%20our%20first%20phase%20of%20query%20improvements%2C%20as%20we%20already%20have%20many%20more%20in%20scope%20for%20the%20future.%20Therefore%20we%20would%20love%20to%20receive%20your%20feedback.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20always%20appreciate%20hearing%20from%20you%2C%20and%20we%20look%20forward%20to%20receiving%20your%20responses.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1325711%22%20slang%3D%22en-US%22%3E%3CP%3ECheck%20out%20the%20developments%20we%20have%20made%20to%20the%20Access%20querying%20experience.%3C%2FP%3E%0A%3CDIV%20id%3D%22lia-teaserTinyMceEditorEbo_Quansah_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Query%20Picture.png%22%20style%3D%22width%3A%20600px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F185744i844B69074A410D0E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Query%20Picture.png%22%20alt%3D%22Query%20Picture.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%20id%3D%22lia-teaserTinyMceEditorEbo_Quansah_1%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1325711%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1336338%22%20slang%3D%22en-US%22%3ERe%3A%20Feast%20your%20Eyes%20on%20our%20Access%20Query%20Improvements!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1336338%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20select%20multiple%20tables%20in%20Relationship%20View%2C%20will%20you%20be%20able%20to%20%22align%20top%22%2C%20%22align%20left%22%2C%20etc%3F%26nbsp%3B%20%26nbsp%3BDo%20these%20features%20carry%20over%20to%20the%20Query%20Designer%20table%20layout%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1350468%22%20slang%3D%22en-US%22%3ERe%3A%20Feast%20your%20Eyes%20on%20our%20Access%20Query%20Improvements!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1350468%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385722%22%20target%3D%22_blank%22%3E%40BenSacherich%3C%2FA%3E%2C%20Thanks%20for%20your%20questions%3B%3C%2FP%3E%0A%3CP%3E1.%20Upon%20selecting%20multiple%20tables%20in%20Relationship%20view%2C%20you%20can%20manually%20move%20them%20to%20align%20in%20the%20format%20of%20your%20choosing.%20You%20can%20also%20%22size%20to%20fit%22%20all%20selected%20tables%20at%20once%20if%20you%20wish%3B%20however%20there%20is%20currently%20not%20a%20feature%20to%20automatically%20align%20all%20tables%20across%20the%20top%2Fbottom%20of%20screen%20or%20at%20the%20left%2Fright%20columns.%20This%20is%20a%20great%20recommendation%20that%20the%20Access%20team%20will%20take%20into%20consideration%20when%20we%20plan%20our%20next%20round%20of%20query%20improvements.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E2.%20Yes%2C%20improvements%20%232-5%20are%20all%20available%20in%20the%20query%20designer%20layout.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1381413%22%20slang%3D%22en-US%22%3ERe%3A%20Feast%20your%20Eyes%20on%20our%20Access%20Query%20Improvements!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1381413%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20we%20please%20have%20an%20SQL%20editor%20with%20a%20decent%20size%20font%3F%20Or%20make%20it%20user%20customizable.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1383123%22%20slang%3D%22en-US%22%3ERe%3A%20Feast%20your%20Eyes%20on%20our%20Access%20Query%20Improvements!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1383123%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F664083%22%20target%3D%22_blank%22%3E%40Dplaut%3C%2FA%3E%26nbsp%3BYou%20can%20already%20change%20the%20font%20typeface%20and%20size%20in%20the%20Access%20Options.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-05-12_11-40-28_Access_SQL_Font.png%22%20style%3D%22width%3A%20624px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190983i9F287F9094D3C017%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222020-05-12_11-40-28_Access_SQL_Font.png%22%20alt%3D%222020-05-12_11-40-28_Access_SQL_Font.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-05-12_11-32-20_Access_Query_Font.png%22%20style%3D%22width%3A%20975px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190980i88CB96FA8BE55D33%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222020-05-12_11-32-20_Access_Query_Font.png%22%20alt%3D%222020-05-12_11-32-20_Access_Query_Font.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-05-12_11-32-10_Access_Query_Design.png%22%20style%3D%22width%3A%20975px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190981i413DE41E64CB3B71%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222020-05-12_11-32-10_Access_Query_Design.png%22%20alt%3D%222020-05-12_11-32-10_Access_Query_Design.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere's%20also%20an%20add-in%20you%20can%20get%20called%20the%20%3CSTRONG%3EAccess%20SQL%20Editor%3C%2FSTRONG%3E.%26nbsp%3B%20%26nbsp%3BMicrosoft%20should%20take%20note%20of%20this%20as%20a%20something%20developers%20would%20like%20to%20have%20built-in.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ffieldeffect.info%2Fwp%2Faccess-sql-editor-documentation%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ffieldeffect.info%2Fwp%2Faccess-sql-editor-documentation%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-05-12_11-44-33_Access_SQL_Editor.png%22%20style%3D%22width%3A%20975px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190986i54B592C91C2278CE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222020-05-12_11-44-33_Access_SQL_Editor.png%22%20alt%3D%222020-05-12_11-44-33_Access_SQL_Editor.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1400834%22%20slang%3D%22en-US%22%3ERe%3A%20Feast%20your%20Eyes%20on%20our%20Access%20Query%20Improvements!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1400834%22%20slang%3D%22en-US%22%3E%3CP%3EIt's%20brilliant%20to%20see%20some%20gains%20in%20Access%20at%20long%20last!%26nbsp%3B%3CBR%20%2F%3EI%20have%20such%20a%20long%20wish%20list%20for%20Access%2C%20but%20most%20are%20on%20User%20Voice.%20I%20assume%20this%20is%20your%20reference%3F%3C%2FP%3E%3CP%3EAnd%20just%20a%20recent%20one%2C%20how%20about%20adding%20Full%20Ribbon%20support%20via%20the%20Windows%20Name%20Space%3A%3C%2FP%3E%3CDIV%3Exmlns%3D%22%3CA%20href%3D%22http%3A%2F%2Fschemas.microsoft.com%2Fwinfx%2F2006%2Fxaml%2Fpresentation%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fschemas.microsoft.com%2Fwinfx%2F2006%2Fxaml%2Fpresentation%3C%2FA%3E%22%3CBR%20%2F%3E%26nbsp%3Bxmlns%3Ax%3D%22%3CA%20href%3D%22http%3A%2F%2Fschemas.microsoft.com%2Fwinfx%2F2006%2Fxaml%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fschemas.microsoft.com%2Fwinfx%2F2006%2Fxaml%3C%2FA%3E%22%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EThese%20add%20full%20support%20for%20auto%20sizing%20and%20a%20whole%20bunch%20more...%3C%2FDIV%3E%3CP%3EBrian.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1467696%22%20slang%3D%22en-US%22%3ERe%3A%20Feast%20your%20Eyes%20on%20our%20Access%20Query%20Improvements!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1467696%22%20slang%3D%22en-US%22%3E%3CP%3EHallelujah%20This%20is%20great%20%E2%80%93%20well%20done!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

One of Access’s most powerful capabilities is querying, which pulls information from many tables to assemble and connect data points that can then be arranged into a form or report. Several Access customers have successfully leveraged queries to generate better insights and make mission-critical business decisions. They have also learned quite a bit more about its deeper technical functionalities over time, including its ability to perform calculations, automate data management tasks, or add, change, and delete data from an existing database. 

 

Because of its significance in creating successful Access applications, the Access team is proud to announce the following enhancements to the Querying user experience.

  1. Find and replace dialogue in SQL View – you can now search for and replace SQL text!

Ebo_Quansah_0-1587487000385.png

 

  1. Mouse Wheel scroll in relationship window – you can now scroll vertically and horizontally (SHIFT + Scroll) in your relationship window as well as in SQL view with your mouse wheel.

 

  1. Right-clicking a table to design and size it and open in design view – we have implemented additional right click options, including the ability to open the table in design view, and to automatically size the table based on its corresponding text.

Ebo_Quansah_1-1587487000395.jpeg

 

  1. Auto-size tables by double clicking its edge – you can also auto-size your table by double clicking its edge.
      1. Double click right edge to auto-size horizontally.
      2. Double click bottom edge to auto-size vertically.
      3. Double click bottom right corner to auto-size both horizontally + vertically.
  1. Multiple table select in the Relationships window – you can now select multiple tables at once and perform various actions on them in a relationship window. Selected tables are highlighted in red, as shown below.

Ebo_Quansah_2-1587487000402.png

 

This is just our first phase of query improvements, as we already have many more in scope for the future. Therefore we would love to receive your feedback.

 

We always appreciate hearing from you, and we look forward to receiving your responses.

6 Comments
Senior Member

If you select multiple tables in Relationship View, will you be able to "align top", "align left", etc?   Do these features carry over to the Query Designer table layout?

Microsoft

@BenSacherich, Thanks for your questions;

1. Upon selecting multiple tables in Relationship view, you can manually move them to align in the format of your choosing. You can also "size to fit" all selected tables at once if you wish; however there is currently not a feature to automatically align all tables across the top/bottom of screen or at the left/right columns. This is a great recommendation that the Access team will take into consideration when we plan our next round of query improvements.

 

2. Yes, improvements #2-5 are all available in the query designer layout.

 

Frequent Visitor

Can we please have an SQL editor with a decent size font? Or make it user customizable.

Senior Member

@Dplaut You can already change the font typeface and size in the Access Options.   

 

2020-05-12_11-40-28_Access_SQL_Font.png2020-05-12_11-32-20_Access_Query_Font.png

2020-05-12_11-32-10_Access_Query_Design.png

 

There's also an add-in you can get called the Access SQL Editor.   Microsoft should take note of this as a something developers would like to have built-in.

https://fieldeffect.info/wp/access-sql-editor-documentation/

 

2020-05-12_11-44-33_Access_SQL_Editor.png

 

Occasional Visitor

It's brilliant to see some gains in Access at long last! 
I have such a long wish list for Access, but most are on User Voice. I assume this is your reference?

And just a recent one, how about adding Full Ribbon support via the Windows Name Space:

 
These add full support for auto sizing and a whole bunch more...

Brian.

Occasional Visitor

Hallelujah This is great – well done!