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 coded. There should also be more SQL functions that should be made available to the user, like in Microsoft SQL.
Also, being unable to comment directly into the SQL code is something I am finding annoying because I would like to be able to explain to future users what certain pieces of SQL code are for. I would appreciate if you could implement these ideas in the next version of MS Office. Thanks!

Issue:
Access database in the current *.accdb format contains a client table & queries used as a data source in Word Mail Merge. The Access database is encrypted and password protected using the recommended encryption (default), but Word Mail Merge can't open the data source (using OLE DB Database Files or MS Access Database via ODBC (*.mdb.accdb)). Switching to the older encryption (legacy) bypasses the issue on costs of weaker encryption or using the deprecated MS Access Database via DDE (*.mdb,*.mde) but this causes Access to shut down after the Word document is closed (this DDE method is not recommend by Microsoft).

Impact:
Important, customer can bypass the issue selecting a lower encryption level (legacy) for the database to successfully execute mail merge but regarding the new challenges in data security Word should be able to use Mail Merge with the current version of Access and their recommended encryption level. Using lower encryption levels and deprecated procedures can cause security breaches.

"Microsoft Graph is the gateway to data and intelligence in Microsoft 365. Microsoft Graph provides a unified programmability model that you can use to take advantage of the tremendous amount of data in Office 365, Enterprise Mobility + Security, and Windows 10.
You can use the Microsoft Graph API to build apps for organizations and consumers that interact with the data of millions of users. With Microsoft Graph, you can connect to a wealth of resources, relationships, and intelligence, all through a single endpoint: https://graph.microsoft.com."

It seems that just about every language except VBA can be used to run this. Access is a database app and it would be great to be able to use it to collect data to feed into, say, Office 365 groups, users and so on.

Please create global methods to deactivate the CTRL+MINUS (delete the current record) and the CTRL+PLUS (add record) shortcut:
• Bug report: In some forms AllowDeletions is mysteriously set to true, even if the form has AllowDeletions = False set (this is only displayed correctly in debug mode). CTRL-Minus then deletes a record without question. Calling Me.AllowDeletions = False in the Form_Open event helps. Access option "Confirm Record Changes" was not set.
• In the AutoKeys macro sub-macros for ^{-} and ^{+} are not allowed (but {DEL}, ^{DEL}, ^{X} are possible).
• The Access option "Confirm Record Changes" is helpful, but does not prevent deletions, if the user clicks yes.
Unfortunately, in my Access (2013, German) there is no description available, what it actually does. Even (German) Access reference books often don't show more than a word by word translation.
Also, the English Access Option Names can only be found by searching the Internet. Please consider:
+ Changing the Option Name "Confirm Record Changes" to "Confirm Record Deletions".
+ Update the help pages for these options (e.g. docs.microsoft.com) with a concise description.
+ Write the original Option Names into the tooltip or the status bar for all options in translated versions of Access.

Please raise the allowed and supported password length to at least 20 characters (as in Access 2007).

For security reasons our company releases a new security guideline so that every relevant application has to use passwords at least 20 characters long.
This would mean several hundred password encrypted databases from various versions of access are no longer allowed to be used.

Technically it is possible to use a 20 character long password within a database (backwards compatibility). But this doesn't work with linked objects. The Connect-String in MSysObjects stays empty.
The use of more than 14 characters is not supported by Microsoft right now.

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 strategy of our OST to PST gadget bundle for Outlook OST to PST for working environment 2007 change then you'll have the capacity to exchange free demo adaptation of OST record to PST document gadget bundle for thirty Email. With the help of ravishing OST specialist program you'll decidedly recapture undecipherable OST go into clear condition. OST to PST extractor program swimmingly convert relocate OST to PST with exact organization. PST, EML, enhancing and markup dialect square measure offered distinctive amid which you will reestablish recouped OST document. "Motivate OST to PST Recovery bundle that profoundly filter out of reach and damage OST messages data then you'll have the capacity to spare OST email into working MS standpoint with another configuration like as:- EML/MSG/EMLX/HTML/TXT/DOC/MBOX and viewpoint profile. This bundle has also capacity to help OST record as:- five.0/5.5/2000/2003/2007/2010/2013 related 2016 moreover in light of the fact that it gives you a development decision to separate noteworthy size of recouped PST document upto 5GB.

Read more information and download free demo version here:- https://www.inspiredatacare.com/convert-ost-to-pst.html