
And if you want to extract data permanently out of dBASE you can now do that too.

If you need to link to a system written in dBASE you now can, as if the table were stored in Access. This used to be in Access then went away, and now it’s back! The feature allows you to link to and import from dBASE (.dbf) files. Only time will tell if the new and improved version is better in practice…. In practice, the feature has not worked very well up to now. This is a great idea as it can be hard to remember where everything is. The Tell Me box is meant to help you find what you are looking for on the Ribbons. This is for storing very, very large numbers and in our experience is needed infrequently. This is a new field data type called “Large Number” which is compatible with the SQL Server “bigint” data type. You still need to know the name of the property you are looking for, but this is a huge help for those “blind spot” moments. This feature allows you to go to the “All” tab of the Property Sheet and then click a sort button (see image) to put the properties in alphabetical order. Sometimes you want to amend a property of something, but you just can’t remember where it’s listed and so end up searching for it for a long time.

This is a very useful feature for people like us designing systems using Microsoft Access. Watch this space as time goes on and our experience of the new version in practice grows. Here are the new features listed by Microsoft, ordered according to our experience of potential usefulness, though none of them are ground-breaking in our view. Benefits of using Microsoft Access 2019 (Standard or 365)Īccess 2019 is very similar to its 20 predecessors.
