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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Enhance the SQL Editor

    Some features would be good to developers:
    1) Tabbed SQL Query Windows - allow user to create a query window without binding to a query object (like we do in SQL Server)

    2) Format the query field with highlighting, identation, colors and make possible to even resize the font size. .

    3) Allow intellisense to get [table].[field] list (in A2013 we have it in Query Designer but no in SQL mode)

    4) Split the window in SQL Query and result pane - and make it possible to see result in table or text format (like we have in SQL Server).…

    338 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    15 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →

    The Access team is adjusting our status for this request – we are planning to embed the Monaco Editor (support for SQL Editor improvements) into Access, to be released within the next semester (first half of 2021), which will provide capabilities such as syntax highlighting, IntelliSense, SQL comments, and more. We are excited to have this capability released by next year, and we appreciate the energy and enthusiasm on this feature request. We still have a long ways to go to improve our experience with SQL, so please stay tuned as we execute on this objective!

    Thanks,
    -Access Product Team

  2. 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

    57 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 →
  3. 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.

    34 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 →
  4. 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,…

    29 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 →
  5. 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…

    28 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 →
  6. 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 →
  7. Refresh tables/queries while in Query Design View

    Add a way to refresh the columns listed in tables and queries being shown in the graphical layout of the Query Design View. A right-click, hotkey, or ribbon button would be nice.

    This scenario takes place when you are designing a new query that is dependent on other tables and queries. As you are working in Design View, you realize you need to make a change to a dependent table/query such as adding or renaming a column. Without closing the current query, you go and update the dependent object and come back to the open query. Now you want to…

    13 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 →
  8. Use F5 to run a query

    When switching between SQL Management Studio and an Access front end I find myself pressing F5 to run the Access query as I've been working in the other window - would be good if F5 ran the query in Access as it does in SQLMS

    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 →
  9. 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.

    9 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 →
  10. Allow the use of tables in update queries without requiring them to be writeable

    When executing an update query with multiple tables, all tables are currently required to be writeable.

    Please allow us to use read-only tables and queries as a source of data for update queries, e.g.

    UPDATE MyWritableTable rw
    INNER JOIN MyReadOnlyTable ro ON ro.ID = rw.ID
    SET rw.Field1 = ro.Field1

    Since there are no write actions to MyReadOnlyTable, this query should not require it to be writable, but it does.

    The current behaviour is a common source of misunderstanding (I often see questions about it on Stack Overflow), and limits the ability to update/merge in data from read-only data sources.

    9 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. 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.

    9 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. kth Percentile function

    Create an function to calculate kth Percentile as in excel that can be used in queries to calculate percent of grouped values

    9 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 →
  13. Enhance Union-Query architecture that total field count more over 255

    Please re-design that a Union query of MS Access deal with more over 255 source fields totaly like 1024 or 65535 fields.

    8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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.

    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 →
  15. Access Query Designer - fix/enhance behavior of layout window

    When a query opens in MS Access designer, quite often the window (query designer form) needs to be re-sized to be larger. When I drag the bottom of the window down, PLEASE keep the results fields selected "portion" (sub-form) the same size! This will result in the top area being enlarged, which gives me more room to view the contents lists of the objects selected (most often they are tables).
    Wouldn't it be phenomenal if the table lists would also automatically extend vertically?
    I spend a lot of time resizing my query designer windows. (e.g. please automatically enlarge the top…

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  16. Please add OFFSET and FETCH to queries

    It doesn't need to be as complex as SQL Server, but pagination would be nice Something like:

    SELECT Customers.*
    FROM Customers
    ORDER BY Customers.Name
    OFFSET 20 FETCH 5;

    This would be so amazing.

    6 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 →
  17. Someone needs to be fired (really)

    The recent Access updates that broke the most simple update queries was bad. However, Microsoft's response was even worse. Rather than Microsoft fixing the very serious problem they created, they said we should change the way we update records in our applications. What moron thought that was an appropriate response? Like many other throughout the world, we have a production system with 400K lines of code and you want us to rewrite every update statement because you do not want to roll out a bug fix? Then, someone thought it was a good idea to wait 30 days to fix…

    6 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 →
  18. 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.

    6 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 →
  19. Right click DUPLICATE a table, query, etc

    Right click DUPLICATE a table, query, etc. Instead of Copy/paste.

    5 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 →
  20. Increase maximum database size to 4GB and increase maximum Query size past the current 1GB limit

    I have a 78 million record 2 field table that indexes both fields fine. When that table is 82 million records, neither field will index because of a query limit error. The 1 GB query limit must be interfering with the indexing of a table that would otherwise not violate the 2 GB limit?? Also, increase the size of the access database container to 4GB....not asking for SQL Server replacement, just something we can work with. MS upsized and oversized Excel years ago.

    5 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 3
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base