Feedback by UserVoice

Access (Desktop Application)

Welcome to the Access Desktop feedback forum! This is the place for users to send us suggestions and ideas on how to improve.
We have partnered with UserVoice, a third-party service and your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

I suggest you ...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Bug Report - The graphical problem on the screen in Query Design View mode.

    The problem is happening when is moving horizontal line between Show Table area and Field area, when is holding this line with mouse button.
    During the moving of the line is copying the content of the Query Field area on the desktop area and in Access working area.
    This problem is happening on new PCs / CPU Intel i5-i7-i8 / Processor Graphics Intel HD-630/640 / Windows 10 (1803/1809/1903).
    For better understanding the problem I can send a picture of screen. Please, give me an e-mail address.

    12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  2. When a query fails due to data type mismatch - tell us what field in the error message.

    When a query fails due to data type mismatch or some other field specific error - tell us what field in the error message.

    22 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  3. Upgrade Access SQL dialect to current ANSI standards

    MS Access's ACE SQL engine continues to run with a variant form of ANSI-89 with some ANSI-92 features while the rest of the relational database world has adopted more recent ANSI standards and at the very least fully comply to the universal, lowest common denominator standard accepted in the industry: ANSI-1992.

    Being a highly used, worldwide database for small to medium-sized shops and its popularity with the Office suite, enhancing Access's dialect to industry standards will add value to current and future users including the Microsoft brand. Even SQLite, a similar, very popular file-level database as open-source counterpart to Access,…

    11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  4. Increase the font size of queries shown in SQL view

    When you show a query in SQL view the font size is minute. There seems to be no way of enlarging it.

    8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  5. Fix Ukrainian locale issues

    Fix bug in Ukrainian locale of Access, when it translates also aggregate functions (for example, Count or Sum) in design view, which tends query to have syntax errors (functions are inserted into SQL query in Ukrainian, not in their original form).
    Same bug is for Like operator in design view of queries and expression builder of field rules.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  6. An option needed to ignore accents and Low-High letters in queries for local and linked tables. Also multilingual characters like ü,è,á,etc.

    An option needed to ignore accents and low-high letters in queries for local and linked tables. Also for multilingual characters like ü,è,á,etc.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  7. Better ways to Access Scanned Templates

    The only idea I got is hjow to make your purchased apps like Microsoft Office word and
    Publisher, Excel user Friendly as on Windows 10 your fighting all the way just to open something to edit , the bought programmes at least work well , cheers Brendon James

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  8. Allow Control-A to Select All in Query Design View

    In previous versions of Access, I could use Control-A to select all fields in a table within the query design view, then Control-Click on the certain field(s) to de-select. It is not always preferential to use the asterisk, particularly if you are doing something other than a delete query. This used to be supported, but looks like it went away after I upgraded to Office365. Thanks.

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  9. Allow Post it style notes to document queries when the QBE is open

    The best place to add notes to a query is when the QBE is open and you can see what's going on

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  10. Develop the SQL User Interface

    SQL is something that I find particularly useful when I am running a database. However, the SQL user interface is very poor in my opinion. It should be more something like the Visual Basic interface, where when you start typing in a formula, then it has a dropdown with all your options and when you select the function from the dropdown, it will show you how to build the formula. For me it becomes very time consuming to have to go online to figure out how the function is built. Also it would be great if it can be colour…

    24 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  11. Add an option to disable the 'Show Table' dialog when creating a new query

    It would be useful to be able to suppress the automatic display of the modal 'Show Table' dialog every time a new query is created.

    Currently I instinctively hit 'Esc' when creating a new query, knowing that this dialog will be displayed.

    I prefer to add tables/queries to my query by dragging them from the navigation bar.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  12. access 2016 crosstab

    Crosstables should never have been removed.
    It just doesn't make sense to have to export the data to Excel and if the data changes, we need to export again.
    Please bring it back

    55 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  13. Intellisense/Builder Improvements

    In Access I often use the criteria Intellisense/Builder to help me get the vba string to drill down to a deeply nested subform. But Intellisense/Builder gives up about 3 forms in. It would be nice to be able to drill down further with the help of this tool.
    I am by no means an expert at Access but over time have created several useful tools over the years, with the help of many Access experts on line. I created a very comprehensive vacation calendar used by over 200 people (tied to an sql back end) for my employer prior to…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  14. OST to PST Converter

    On the off chance that your Outlook OST record has turned out to be broken or unparented due to a few reasons like infection assault, Trojan disease, awful server, Low system property, document assemble activity disappointment, equipment crash or bundle disappointment and you wish to ask back your OST record because of your OST document is in this way fundamental to you, at that point don't freeze you'll have the capacity to endeavor our OST record to PST document gadget bundle furthermore as OST to PST for working environment 2007. In the event that you wish to investigate the work…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add Save As... back to the Query context menu

    In earlier version of Access, when you modified a query the context menu had the choices of “Save”, “Save As…” and “Close” in the context menu. Since the ribbon was introduced, the context menu only provides “Save” and “Close”, if you’ve made a change in the query and don’t want to over write the existing one, you have to go to the File | Save Object As route to get to the “Save As..” dialog box.

    20 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  16. Allow to enter criteria at the join level

    Left join categories c on c.id = p.catgoryId and p.price > 100

    This can be done in most SQL DBs, including SQL Server, but is not allowed in Access

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  17. idea for fix of a query that stops working

    When sorting a query, I've found that if after sorting I then rename the query, the query stops working. It works again if I undo sorting. It seems the query is trying to sort the data according to the earlier naming of the quwery, even after the query has been renamed.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  18. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  19. Action Query: List specific records/columns that violate index or validation

    When running an action query, if records will be 'excluded' due to index or validation, give clear info as to what records & columns are causing the issue.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  20. Seamless SQL Query engine

    It is really good to have (if not at the same level) basic MS SQL query syntax with Access. I see over the years it has never been updated.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1
  • Don't see your idea?

Access (Desktop Application)

Feedback and Knowledge Base