Make Expression Builder available from Visual Basic Editor, as it used to be in Access 97 and before.
Currently it can be opened only from query design view..

Create an enhanced table manager that allows users to specify data source (sql, access, txt etc), source table name, attached name, any passwords (encrypted or hidden) and primary keys so that the system will drop existing links and refresh as needed. You would need a couple of tables for data sources and data source tables but many developers have done this over the years and lots of examples that could be incorporated. This is used all the time.

Spent today trying to save pop up form windows size with popular or a dialogue but the windows kept reverting or opened off screen on a dual. Monitor Pc - and I can't tell whether if it persists whether will do properly on a single monitor PC

When the ribbons began being used, we lost the ability to display the toolbox vertically. Despite using the ribbon for several years now, I have not gotten faster at picking up the right tool quickly.

When the toolbox could be displayed vertically, I practically didn't even have to look at the tools, I knew where they were positionally.

It is much faster to design when the toolbox can be vertical.

thanks

When Browsing for Importing, Exporting, or whatever, it would be nice to be able to have an option to use the last directory used -- even if the database has been closed.

It is difficult to figure out which column of a query that properties are being set for. It would be nice to show the column name at the top of Property Sheet in a Query

thank you

Currently, if a database is opened through code, it requires gymnastics to avoid running startup stuff. It would be nice for Access to have EnableEvents like Excel does

thank you

Lots of system help forms (i.E. on Query the search table or the references form in VBA to search DLLs ) are far too small and the user cannot resizre them, why ? Just allow to pull them bigger would help

Instead of separate window where coding takes place outside of form design, have it as a window positionable beside or below the form design.

These buttons would work they way they do in other Office products.

Also, rename Align Left|Right|Top|Bottom for objects to include the word object. Align Left, for instance, is the tooltip for 2 very different things.

It would be nice if Intellisense/Builder would recognize Table/Query Aliases

There are lots of commands to choose for the QAT and finding what you want can take time. It would be nice to be able to filter the choices

Excel has an option to save and restore the workspace, which is very convenient for opening all the files and positioning them where they were before. With Access, of course, this would be objects in the current database instead of files.

Why not have an OpenArgs parameter like in docmd.openform ? Would enable to react in forms based on OpenArgs - especially helpful when you want to open a form on several places with different actions.

In Queries, it would be nice to be able to reference a value in a record relative to the current one.

For instance, many times it is required to get a difference in a changed value

When exporting, it would be nice to be able to choose how data in form/page headers/footers will be treated:

1. as displayed
2. only at top and bottom
3. do not include

especially for RTF and formats that will end up in Word

I add SaveAs to my QAT -- but it would be nice if it was there by default.

When Save As (for object) from the backstage or whatever it is being these days, does NOT show what you are looking at -- this makes naming difficult.

It would be nice to have an option to Close All but the active object ... Close All would be ok too!

In queries, when there are multiple records for criteria, it would be nice if we could specify to just get the first record matching a certain condition but show all records matching criteria for the query.

Example:
list of all last order dates for a customer